DBA Data[Home] [Help]

APPS.FND_CP_OPP_CMD dependencies on FND_CONC_PP_ACTIONS

Line 50: from fnd_conc_pp_actions

46: begin
47:
48: select processor_id, completed
49: into cpid, complete
50: from fnd_conc_pp_actions
51: where concurrent_request_id = reqid
52: and action_type = 6
53: and sequence = 1;
54:

Line 60: update fnd_conc_pp_actions

56:
57: -- post-processor has not started yet, update the table with our id
58: -- so the post-processor will not pick it up.
59:
60: update fnd_conc_pp_actions
61: set processor_id = senderid
62: where concurrent_request_id = reqid;
63:
64: commit;

Line 113: from fnd_conc_pp_actions

109: begin
110:
111: select processor_id, completed
112: into cpid, complete
113: from fnd_conc_pp_actions
114: where concurrent_request_id = reqid
115: and action_type = 6
116: and sequence = 1;
117:

Line 121: update fnd_conc_pp_actions

117:
118: if cpid is null then
119: -- post-processor has not started yet, update the table with our id
120: -- so the post-processor will not pick it up.
121: update fnd_conc_pp_actions
122: set processor_id = senderid
123: where concurrent_request_id = reqid;
124:
125: update fnd_concurrent_requests