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:
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;
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:
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