About add parameter
Hi
Is there any suggestion about below?
Requirement:
Display the program run time in the report .
In order to meet the requirement, I added a parameter 'p_run_time' from define window.
The value set is 'FND_STANDARD_DATE and selected 'current date'.
Then , I added below formula to capture the value of _p_run_time and want to display in the xml data.
function CF_RUN_DATEFormula return Char is
v_run_date varchar2(200);
begin
v_run_date := trunc(apps.fnd_date.canonical_to_date(:P_Current_date)) ;
return v_run_date;
exception
when others then
v_run_date := NULL;