add

About Me

My photo
Oracle Apps - Techno Functional consultant

Thursday, July 24

Displaying concurrent programm name dynamically on a report

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'));

No comments: