for displaying concurrent programm name dynamically in a report
declare user parameter as p_conc_request_id
write the below commnds in triggers as
srw.user_exit('fnd srwinit') in before report trigger and
srw.user_exit('fnd srwexit') in after report trigger.
and take one place holder column in report level... so, now we r going to use this place holder column in one formaula column.
for that take one formula column and in that we want to write a piece of code which is shown below....
select fcp.user_concurrent_program_name
into :cp_conc_name(place holder column name)
from fnd_concurrent_requests fcr,
fnd_concurrent_programs_vl fcp
where fcr.concurrent_program_id=fcp.concurrent_program_id
and fcr.request_id =nvl(:p_conc_request_id,fcr.request_id);
and for request id we can
declare
in same in formula column
as
return(fnd_profile.value(':p_conc_request_id'));
declare user parameter as p_conc_request_id
write the below commnds in triggers as
srw.user_exit('fnd srwinit') in before report trigger and
srw.user_exit('fnd srwexit') in after report trigger.
and take one place holder column in report level... so, now we r going to use this place holder column in one formaula column.
for that take one formula column and in that we want to write a piece of code which is shown below....
select fcp.user_concurrent_program_name
into :cp_conc_name(place holder column name)
from fnd_concurrent_requests fcr,
fnd_concurrent_programs_vl fcp
where fcr.concurrent_program_id=fcp.concurrent_program_id
and fcr.request_id =nvl(:p_conc_request_id,fcr.request_id);
and for request id we can
declare
in same in formula column
as
return(fnd_profile.value(':p_conc_request_id'));
No comments:
Post a Comment