DBA Data[Home] [Help]

APPS.FUN_SEQ_BATCH dependencies on FND_CONCURRENT_REQUESTS

Line 1132: select distinct phase_code into l_phase_code from fnd_concurrent_requests

1128: begin
1129: --
1130: -- check if this is the parent request and all child request are completed.
1131: --
1132: select distinct phase_code into l_phase_code from fnd_concurrent_requests
1133: where parent_request_id= p_request_id;
1134: -- all childs completed
1135: if l_phase_code ='C' then
1136: delete from fun_seq_requests where request_id=p_request_id;