DBA Data[Home] [Help]

APPS.MSC_ATP_PEG dependencies on V$TIMER

Line 2665: from v$timer;

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

Line 3232: from v$timer;

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

Line 3287: from v$timer;

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

Line 3373: from v$timer;

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

Line 3832: from v$timer;

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

Line 3926: from v$timer;

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

Line 3938: from v$timer;

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