Monday, December 7, 2015

Date Parameter in Concurrent Programs



Use FND Value set FND_STANDARD_DATE



Procedure Code
PROCEDURE jkproc
   (errbuf out varchar2,retcode out varchar2,p_processing_date in varchar2)
   AS
v_date  date ;
   BEGIN
v_date:= fnd_date.canonical_to_date(p_processing_date);
END;

OR

Use
to_Date (substr(<date value>,1,10) ,'DD-MON-RRRR') 

No comments:

Post a Comment