APPS.FND_CP_OPP_CMD dependencies on FND_CONCURRENT_REQUESTS

Line 69: select 1 into dummy from fnd_concurrent_requests where request_id = reqid for update of pp_end_date, post_request_status nowait;

65:
66: -- also update the post-processing status of the request
67: -- this could possibly cause a deadlock if the manager running the request still has the lock
68: begin
69: select 1 into dummy from fnd_concurrent_requests where request_id = reqid for update of pp_end_date, post_request_status nowait;
70: update fnd_concurrent_requests
71: set pp_end_date = sysdate,
72: post_request_status = 'E'
73: where request_id = reqid;

Line 70: update fnd_concurrent_requests

66: -- also update the post-processing status of the request
67: -- this could possibly cause a deadlock if the manager running the request still has the lock
68: begin
69: select 1 into dummy from fnd_concurrent_requests where request_id = reqid for update of pp_end_date, post_request_status nowait;
70: update fnd_concurrent_requests
71: set pp_end_date = sysdate,
72: post_request_status = 'E'
73: where request_id = reqid;
74: commit;

Line 125: update fnd_concurrent_requests

121: update fnd_conc_pp_actions
122: set processor_id = senderid
123: where concurrent_request_id = reqid;
124:
125: update fnd_concurrent_requests
126: set pp_end_date = sysdate,
127: post_request_status = 'E'
128: where request_id = reqid;
129: else