APPS.FND_CP_OPP_REQ dependencies on FND_CONC_PP_ACTIONS

Line 54: -- Used by the OPP service to update the FND_CONC_PP_ACTIONS table

50:
51: --
52: -- update_actions_table
53: --
54: -- Used by the OPP service to update the FND_CONC_PP_ACTIONS table
55: -- The table is only updated if it has not been previously updated by another process
56: --
57: -- reqid - Concurrent request id
58: -- procid - Concurrent process id of the service. FND_CONC_PP_ACTIONS.PROCESSOR_ID will be updated

Line 58: -- procid - Concurrent process id of the service. FND_CONC_PP_ACTIONS.PROCESSOR_ID will be updated

54: -- Used by the OPP service to update the FND_CONC_PP_ACTIONS table
55: -- The table is only updated if it has not been previously updated by another process
56: --
57: -- reqid - Concurrent request id
58: -- procid - Concurrent process id of the service. FND_CONC_PP_ACTIONS.PROCESSOR_ID will be updated
59: -- with this value for all pp actions for this request
60: -- success - Y if the table was updated, N if the table has already been updated.
61: --
62: procedure update_actions_table(reqid in number, procid in number,

Line 69: from fnd_conc_pp_actions

65: cnt number;
66: begin
67: select count(*)
68: into cnt
69: from fnd_conc_pp_actions
70: where concurrent_request_id = reqid
71: and processor_id is not null;
72:
73: if cnt > 0 then

Line 79: update fnd_conc_pp_actions

75: return;
76: end if;
77:
78:
79: update fnd_conc_pp_actions
80: set processor_id = procid
81: where concurrent_request_id = reqid;
82:
83: success := 'Y';

Line 223: -- Updates fnd_conc_pp_actions, setting the processor_id for a request,

219: --
220: -- update_pp_action
221: --
222: -- Helper procedure for postprocess
223: -- Updates fnd_conc_pp_actions, setting the processor_id for a request,
224: -- so the post-processor will not pick it up and process it
225: --
226: procedure update_pp_action(reqid in number, cpid in number) is
227:

Line 231: update fnd_conc_pp_actions

227:
228: pragma autonomous_transaction;
229:
230: begin
231: update fnd_conc_pp_actions
232: set processor_id = cpid
233: where concurrent_request_id = reqid;
234:
235: commit;

Line 447: from fnd_conc_pp_actions

443: -- see if the postprocessor has started on it
444:
445: select processor_id
446: into pp_id
447: from fnd_conc_pp_actions
448: where concurrent_request_id = reqid
449: and action_type = 6
450: and sequence = 1;
451:

Line 555: select count(1) into action_type from fnd_conc_pp_actions

551:
552: -- Check if the request itself is a published request, if not then check
553: -- whether the parent request is a published request.
554:
555: select count(1) into action_type from fnd_conc_pp_actions
556: where concurrent_request_id=reqid and action_type=6;
557:
558: select count(1) into output_exists from fnd_conc_req_outputs
559: where concurrent_request_id = decode(action_type, 1, reqid, to_number(parent_req_id))

Line 617: from fnd_conc_pp_actions

613:
614: -- see if any publishing actions for this request
615: select count(*)
616: into cnt
617: from fnd_conc_pp_actions
618: where action_type = 6
619: and concurrent_request_id = cur_reqid;
620:
621: if cnt = 0 then