DBA Data[Home] [Help]

APPS.FUN_SEQ_BATCH dependencies on FND_CONCURRENT

Line 1131: select distinct phase_code into l_phase_code from fnd_concurrent_requests

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

Line 1156: l_result := fnd_concurrent.get_request_status(

1152: FOR i IN l_req_id_tbl.FIRST .. l_req_id_tbl.LAST LOOP
1153: --
1154: -- Check concurrent request status
1155: --
1156: l_result := fnd_concurrent.get_request_status(
1157: request_id => l_req_id_tbl(i),
1158: appl_shortname => NULL,
1159: program => NULL,
1160: phase => l_phase,