TO get user submitted the report and run time with date:
In before parameter trigger
Define two variables:
xuser varchar2(30);
xrundate varchar2(30);
begin
select REQUESTOR,to_char(request_date,'DD-Mon-YY HH24:MI')|| 'Hrs' into xuser,xrundate from FND_CONC_REQ_SUMMARY_V where REQUEST_ID = :P_CONC_REQUEST_ID;
:cp_user := nvL(xuser,'');
:cp_rundate := xrundate;
end;
In before parameter trigger
Define two variables:
xuser varchar2(30);
xrundate varchar2(30);
begin
select REQUESTOR,to_char(request_date,'DD-Mon-YY HH24:MI')|| 'Hrs' into xuser,xrundate from FND_CONC_REQ_SUMMARY_V where REQUEST_ID = :P_CONC_REQUEST_ID;
:cp_user := nvL(xuser,'');
:cp_rundate := xrundate;
end;
No comments:
Post a Comment
Thanks for your comments submitted.,will review and Post soon! by admin.