APPS.FEM_MULTI_PROC_PKG dependencies on FND_CONCURRENT_REQUESTS

Line 1189: FROM fnd_concurrent_requests R,

1185: v_sql_cmd VARCHAR2(32766);
1186:
1187: CURSOR c_sub_req_id IS
1188: SELECT request_id
1189: FROM fnd_concurrent_requests R,
1190: fnd_concurrent_programs P
1191: WHERE parent_request_id = v_req_id
1192: AND R.concurrent_program_id = P.concurrent_program_id
1193: AND P.concurrent_program_name = c_mp_sub_prg

Line 1500: FROM fnd_concurrent_requests

1496: ----------------------------------
1497: DELETE FROM fem_mp_process_ctl_t T
1498: WHERE rule_id = p_rule_id
1499: AND (req_id IN (SELECT request_id
1500: FROM fnd_concurrent_requests
1501: WHERE phase_code = 'C')
1502: OR NOT EXISTS (SELECT 1 FROM fnd_concurrent_requests
1503: WHERE request_id = T.req_id));
1504:

Line 1502: OR NOT EXISTS (SELECT 1 FROM fnd_concurrent_requests

1498: WHERE rule_id = p_rule_id
1499: AND (req_id IN (SELECT request_id
1500: FROM fnd_concurrent_requests
1501: WHERE phase_code = 'C')
1502: OR NOT EXISTS (SELECT 1 FROM fnd_concurrent_requests
1503: WHERE request_id = T.req_id));
1504:
1505: DELETE FROM fem_mp_process_args_t T
1506: WHERE rule_id = p_rule_id

Line 1508: FROM fnd_concurrent_requests

1504:
1505: DELETE FROM fem_mp_process_args_t T
1506: WHERE rule_id = p_rule_id
1507: AND (req_id IN (SELECT request_id
1508: FROM fnd_concurrent_requests
1509: WHERE phase_code = 'C')
1510: OR NOT EXISTS (SELECT 1 FROM fnd_concurrent_requests
1511: WHERE request_id = T.req_id));
1512: COMMIT;

Line 1510: OR NOT EXISTS (SELECT 1 FROM fnd_concurrent_requests

1506: WHERE rule_id = p_rule_id
1507: AND (req_id IN (SELECT request_id
1508: FROM fnd_concurrent_requests
1509: WHERE phase_code = 'C')
1510: OR NOT EXISTS (SELECT 1 FROM fnd_concurrent_requests
1511: WHERE request_id = T.req_id));
1512: COMMIT;
1513:
1514: IF (v_slc_type > 0)