APPS.MSC_ATP_PEG dependencies on V$TIMER

Line 2667: from v$timer;

2663: -- End Bug 3750638 -- FORALL loop
2664:
2665: select hsecs
2666: into l_timestamp
2667: from v$timer;
2668:
2669: -- Bug 3750638 Get the total number of records.
2670: n_row_count := SQL%ROWCOUNT;
2671:

Line 3234: from v$timer;

3230: OPEN config_items;
3231:
3232: select hsecs
3233: into l_timestamp
3234: from v$timer;
3235:
3236: IF PG_DEBUG in ('Y', 'C') THEN
3237: msc_util.msc_log('Gen_Atp_Pegging : After opening config_items ');
3238: msc_util.msc_log('Gen_Atp_Pegging : TIMESTAMP 1 ' || l_timestamp);

Line 3289: from v$timer;

3285:
3286:
3287: select hsecs
3288: into l_timestamp
3289: from v$timer;
3290:
3291: IF PG_DEBUG in ('Y', 'C') THEN
3292: msc_util.msc_log('Gen_Atp_Pegging : Stage 5 ' );
3293: msc_util.msc_log('Gen_Atp_Pegging : TIMESTAMP 3 ' || l_timestamp);

Line 3375: from v$timer;

3371:
3372:
3373: select hsecs
3374: into l_timestamp
3375: from v$timer;
3376:
3377: IF PG_DEBUG in ('Y', 'C') THEN
3378: msc_util.msc_log('Gen_Atp_Pegging : Stage 6 ' );
3379: msc_util.msc_log('Gen_Atp_Pegging : Rows Procesed ' || SQL%ROWCOUNT );

Line 3834: from v$timer;

3830: -- Obtain Simplified Pegging Information
3831: Create_Simple_Pegging (atp_peg_det, atp_peg_tab, l_return_status);
3832: select hsecs
3833: into l_timestamp
3834: from v$timer;
3835:
3836: IF PG_DEBUG in ('Y', 'C') THEN
3837: msc_util.msc_log('Gen_Atp_Pegging : Stage 8 After obtaining Simple Pegging ');
3838: msc_util.msc_log('Gen_Atp_Pegging : TIMESTAMP 5 ' || l_timestamp);

Line 3928: from v$timer;

3924: END LOOP; -- FOR i in 1..atp_peg_t
3925:
3926: select hsecs
3927: into l_timestamp
3928: from v$timer;
3929:
3930: IF PG_DEBUG in ('Y', 'C') THEN
3931: msc_util.msc_log('Gen_Atp_Pegging : Stage 9 After Calculating Reliefs ');
3932: msc_util.msc_log('Gen_Atp_Pegging : TIMESTAMP 6 ' || l_timestamp);

Line 3940: from v$timer;

3936: Generate_Resource_Pegging (atp_peg_tab, l_return_status);
3937:
3938: select hsecs
3939: into l_timestamp
3940: from v$timer;
3941:
3942: IF PG_DEBUG in ('Y', 'C') THEN
3943: msc_util.msc_log('Gen_Atp_Pegging : Stage 10 After Resource Pegging ');
3944: msc_util.msc_log('Gen_Atp_Pegging : TIMESTAMP 7 ' || l_timestamp);