APPS.FND_CONCURRENT dependencies on FND_CP_SQL_REQUESTS

Line 2716: -- using the fnd_cp_sql_requests table.

2712: position number;
2713: begin
2714:
2715: -- Select all the information needed for this request from fnd_concurrent_requests,
2716: -- using the fnd_cp_sql_requests table.
2717: -- A row should have been inserted earlier in usdspid, containing the current request id,
2718: -- machine name, and process id.
2719: -- By joining these tables with v$session, we can pull out all the information we need,
2720: -- using only our own session id.

Line 2748: fnd_cp_sql_requests sr

2744: into session_id, userid, respid, respappid,
2745: secgrpid, siteid, loginid, cloginid,
2746: progappid, cprogid, creqid, cprireqid
2747: from fnd_concurrent_requests fcr,
2748: fnd_cp_sql_requests sr
2749: where fcr.phase_code = 'R'
2750: and fcr.status_code = 'R'
2751: and fcr.request_id = sr.request_id
2752: and sr.machine = lmachine

Line 2760: DELETE from fnd_cp_sql_requests where request_id = creqid;

2756: FND_GLOBAL.INITIALIZE(session_id, userid, respid, respappid, secgrpid, siteid, loginid,
2757: cloginid, progappid, cprogid, creqid, cprireqid);
2758:
2759: -- now delete the row, to avoid having to purge the table.
2760: DELETE from fnd_cp_sql_requests where request_id = creqid;
2761:
2762: exit;
2763: exception
2764: when no_data_found then