APPS.FND_CONCURRENT dependencies on FND_CP_SQL_REQUESTS

Line 2607: -- using the fnd_cp_sql_requests table.

2603: position number;
2604: begin
2605:
2606: -- Select all the information needed for this request from fnd_concurrent_requests,
2607: -- using the fnd_cp_sql_requests table.
2608: -- A row should have been inserted earlier in usdspid, containing the current request id,
2609: -- machine name, and process id.
2610: -- By joining these tables with v$session, we can pull out all the information we need,
2611: -- using only our own session id.

Line 2639: fnd_cp_sql_requests sr

2635: into session_id, userid, respid, respappid,
2636: secgrpid, siteid, loginid, cloginid,
2637: progappid, cprogid, creqid, cprireqid
2638: from fnd_concurrent_requests fcr,
2639: fnd_cp_sql_requests sr
2640: where fcr.phase_code = 'R'
2641: and fcr.status_code = 'R'
2642: and fcr.request_id = sr.request_id
2643: and sr.machine = lmachine

Line 2651: DELETE from fnd_cp_sql_requests where request_id = creqid;

2647: FND_GLOBAL.INITIALIZE(session_id, userid, respid, respappid, secgrpid, siteid, loginid,
2648: cloginid, progappid, cprogid, creqid, cprireqid);
2649:
2650: -- now delete the row, to avoid having to purge the table.
2651: DELETE from fnd_cp_sql_requests where request_id = creqid;
2652:
2653: exit;
2654: exception
2655: when no_data_found then