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 375: select hsecs into l_end_time from v$timer;

371:
372: --clean up code
373: CLEAN_UP_CODE(l_request_id);
374:
375: select hsecs into l_end_time from v$timer;
376: write_log( 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
377: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Time taken for the header process 2 (sec):' ||(l_end_time - l_start_time)/100);
378: Return;
379: ELSE -- ( l_req_data IS NULL)

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

392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Parent: '||p_process_parent);
393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Threads: '||p_no_of_threads);
394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------------------------');
395:
396: select hsecs into l_start_time from v$timer;
397: write_log( 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
398:
399: FND_PROFILE.GET('QP_SOURCE_SYSTEM_CODE', l_source_system_code);
400: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY',l_pte_code);

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

3536: END IF;
3537:
3538: END LOOP;
3539:
3540: select hsecs into l_end_time from v$timer;
3541: write_log( 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
3542: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Time taken for the header process 1 (sec):' ||(l_end_time - l_start_time)/100);
3543:
3544: --Parents waits untill all the threads complete

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

3560: write_log( 'Request ID: '||l_request_id);
3561:
3562: -- Update PBH child lines with request id.
3563:
3564: select hsecs into l_start_time from v$timer;
3565: write_log( 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
3566:
3567: -- Bug 5208480(5208112,4188784) RAVI
3568: UPDATE qp_interface_list_lines qpil

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

4720: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Successfully Processed Pricing Attr: '||l_suc_pr_attr);
4721: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Errored Pricing Attr: '||l_err_pr_attr);
4722: ERRORS_TO_OUTPUT(l_request_id);
4723:
4724: select hsecs into l_end_time from v$timer;
4725: write_log( 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
4726: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Time taken for the line process (sec):' ||(l_end_time - l_start_time)/100);
4727:
4728: END IF;