Script to disable a Request Set in a Cloned APPS environment.
I clone our production environment daily through a scripted process.
How would I script to cancel a request set?
Please advise.
Below is what I currently use to cancel our Concurrent Requests:
begin
declare
ret boolean;
v_message varchar2(2000);
cursor req is
select r.request_id request_id,
r.requested_by requested_by,
r.responsibility_id responsibility_id,
r.responsibility_application_id responsibility_application_id
from fnd_concurrent_requests r,
fnd_concurrent_programs_vl cp
where r.concurrent_program_id = cp.concurrent_program_id
and r.program_application_id = cp.application_id
and cp.user_concurrent_program_name in ('