145: into l_copies_buffer,
146: l_printer_buffer,
147: l_style_buffer,
148: l_save_result
149: from fnd_concurrent_requests
150: where request_id = to_number(c_req_id);
151:
152: if (l_save_result='Y') then
153: l_save_buffer:=true;
177: raise zero_req_id;
178: ELSE
179: --
180: if p_adv_flag = 'Y' then
181: update fnd_concurrent_requests
182: set output_file_type = 'XML'
183: where request_id = l_req_id;
184: end if;
185: --
184: end if;
185: --
186: COMMIT;
187: --
188: l_wait_outcome := FND_CONCURRENT.WAIT_FOR_REQUEST(
189: request_id => l_req_id,
190: interval => 30,
191: max_wait => 86400,
192: phase => l_phase,
195: dev_status => l_dev_status,
196: message => l_message);
197: --
198: -- IF (l_dev_phase = 'COMPLETE' and l_status = 'NORMAL') THEN
199: -- update fnd_concurrent_requests
200: -- set PARENT_REQUEST_ID = to_number(c_req_id)
201: -- where request_id = l_req_id;
202: -- ELSE
203: -- hr_utility.set_message(801, 'HR_51002_REPORT_CANT_SUBMITTED');