APPS.QP_BULK_LOADER_PUB dependencies on V$TIMER

Line 160: select hsecs into l_start_time from v$timer;

156: IF ( l_req_data IS NOT NULL)
157: THEN
158: write_log( 'Second call');
159:
160: select hsecs into l_start_time from v$timer;
161: write_log( 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
162:
163: l_req_data_counter:=to_number(l_req_data) + 1;
164:

Line 263: select hsecs into l_end_time from v$timer;

259:
260: --clean up code
261: CLEAN_UP_CODE(l_request_id);
262:
263: select hsecs into l_end_time from v$timer;
264: write_log( 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
265: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Time taken for the header process 2 (sec):' ||(l_end_time - l_start_time)/100);
266: Return;
267: ELSE -- ( l_req_data IS NULL)

Line 284: select hsecs into l_start_time from v$timer;

280: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Parent: '||p_process_parent);
281: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Threads: '||p_no_of_threads);
282: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------------------------');
283:
284: select hsecs into l_start_time from v$timer;
285: write_log( 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
286:
287: FND_PROFILE.GET('QP_SOURCE_SYSTEM_CODE', l_source_system_code);
288: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY',l_pte_code);

Line 3421: select hsecs into l_end_time from v$timer;

3417: END IF;
3418:
3419: END LOOP;
3420:
3421: select hsecs into l_end_time from v$timer;
3422: write_log( 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
3423: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Time taken for the header process 1 (sec):' ||(l_end_time - l_start_time)/100);
3424:
3425: --Parents waits untill all the threads complete

Line 3445: select hsecs into l_start_time from v$timer;

3441: write_log( 'Request ID: '||l_request_id);
3442:
3443: -- Update PBH child lines with request id.
3444:
3445: select hsecs into l_start_time from v$timer;
3446: write_log( 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
3447:
3448: -- Bug 5208480(5208112,4188784) RAVI
3449: UPDATE qp_interface_list_lines qpil

Line 4605: select hsecs into l_end_time from v$timer;

4601: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Successfully Processed Pricing Attr: '||l_suc_pr_attr);
4602: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Errored Pricing Attr: '||l_err_pr_attr);
4603: ERRORS_TO_OUTPUT(l_request_id);
4604:
4605: select hsecs into l_end_time from v$timer;
4606: write_log( 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
4607: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Time taken for the line process (sec):' ||(l_end_time - l_start_time)/100);
4608:
4609: END IF;