DBA Data[Home] [Help]

APPS.FUN_SEQ_BATCH dependencies on FND_CONCURRENT

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;

Line 1157: l_result := fnd_concurrent.get_request_status(

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