APPS.QP_PS_ATTR_GRP_PVT dependencies on V$TIMER

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

750: if l_req_data is not NULL then
751: remove_duplicate_patterns;
752: --- updation of used in pattern
753: --Added for PL/SQL Pattern Search
754: select hsecs into l_end_time from v$timer;
755: write_log( 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
756: IF p_list_header_id IS NULL THEN
757: update qp_pte_segments
758: set used_in_search ='Y'

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

866: /*DELETE qp_pattern_phases
867: where pattern_id IN (-2,-3)
868: AND pricing_phase_id=1;*/
869:
870: select hsecs into l_end_time from v$timer;
871: write_log( 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
872: write_log( 'Time taken for the Update process (sec):' ||(l_end_time - l_start_time)/100);
873: return;
874: end if;

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

872: write_log( 'Time taken for the Update process (sec):' ||(l_end_time - l_start_time)/100);
873: return;
874: end if;
875:
876: select hsecs into l_start_time from v$timer;
877: write_log( 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
878:
879: if p_list_header_id is null then
880: -- like upgrade, refresh everything related to patterns

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

945: l_count := l_count + 1;
946: exit when l_count > l_slab_count;
947: end loop;
948:
949: select hsecs into l_end_time from v$timer;
950: write_log( 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
951: write_log( 'Time taken for the header process (sec):' ||(l_end_time - l_start_time)/100);
952:
953: fnd_conc_global.set_req_globals(conc_status => 'PAUSED',

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

986: end if; -- if l_total_lines > 0
987: end if; -- if p_spawned_request = 'N'
988:
989: if p_spawned_request = 'Y' then
990: select hsecs into l_start_time from v$timer;
991: write_log( 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
992: if p_list_header_id is NOT null then
993: -- like upgrade, refresh everything related to patterns
994: -- IF g_qp_pattern_search <> 'M' THEN

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

1045: write_log('Child '||l_count);
1046: l_count := l_count + 1;
1047: exit when l_count > l_chunk_count;
1048: end loop;
1049: select hsecs into l_end_time from v$timer;
1050: write_log( 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
1051: write_log( 'Time taken for the line process (sec):' ||(l_end_time - l_start_time)/100);
1052: end if; -- if p_spawned_request = 'Y'
1053:

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

1052: end if; -- if p_spawned_request = 'Y'
1053:
1054: -- commit the changes done so far
1055: write_log( 'COMMIT in Pattern_Upgrade');
1056: select hsecs into l_start_time from v$timer;
1057: write_log( 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
1058: commit;
1059: select hsecs into l_end_time from v$timer;
1060: write_log( 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

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

1055: write_log( 'COMMIT in Pattern_Upgrade');
1056: select hsecs into l_start_time from v$timer;
1057: write_log( 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
1058: commit;
1059: select hsecs into l_end_time from v$timer;
1060: write_log( 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
1061: write_log( 'Time taken for the Commit process (sec):' ||(l_end_time - l_start_time)/100);
1062: err_buff := '';
1063: retcode := 0;