eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_ATP_PUB dependencies on MSC_REGIONS_TEMP

Line 2186: -- Delete records from MSC_REGIONS_TEMP before returning back to calling

2182: END LOOP; -- FOR j in 1..l_atp_rec.inventory_item_id.LAST LOOP
2183:
2184: IF NVL(g_atp_check, '@') = 'N' THEN
2185:
2186: -- Delete records from MSC_REGIONS_TEMP before returning back to calling
2187: -- application so as to clean up the table for another request within
2188: -- same session for Region Level Sourcing Support
2189:
2190: DELETE msc_regions_temp

Line 2190: DELETE msc_regions_temp

2186: -- Delete records from MSC_REGIONS_TEMP before returning back to calling
2187: -- application so as to clean up the table for another request within
2188: -- same session for Region Level Sourcing Support
2189:
2190: DELETE msc_regions_temp
2191: WHERE session_id = p_session_id;
2192:
2193: IF PG_DEBUG in ('Y', 'C') THEN
2194: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'Rows deleted from msc_regions_temp : '||sql%rowcount);

Line 2194: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'Rows deleted from msc_regions_temp : '||sql%rowcount);

2190: DELETE msc_regions_temp
2191: WHERE session_id = p_session_id;
2192:
2193: IF PG_DEBUG in ('Y', 'C') THEN
2194: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'Rows deleted from msc_regions_temp : '||sql%rowcount);
2195: END IF;
2196:
2197: --bug3940999 Delete temp records before exiting
2198: DELETE msc_atp_src_profile_temp

Line 2630: delete from msc_regions_temp where session_id = p_session_id;

2626: --Update_table which will be called across dblink instead of
2627: --making multiple update statements across dblink.
2628:
2629: --bug3520746 Delete temp records before exiting
2630: delete from msc_regions_temp where session_id = p_session_id;
2631:
2632: IF PG_DEBUG in ('Y', 'C') THEN
2633: msc_sch_wb.atp_debug('Rows deleted from msc_regions_temp:'|| sql%rowcount);
2634: END IF;

Line 2633: msc_sch_wb.atp_debug('Rows deleted from msc_regions_temp:'|| sql%rowcount);

2629: --bug3520746 Delete temp records before exiting
2630: delete from msc_regions_temp where session_id = p_session_id;
2631:
2632: IF PG_DEBUG in ('Y', 'C') THEN
2633: msc_sch_wb.atp_debug('Rows deleted from msc_regions_temp:'|| sql%rowcount);
2634: END IF;
2635:
2636: --bug3940999 Delete temp records before exiting
2637: delete from msc_atp_src_profile_temp where session_id = p_session_id;

Line 2701: delete from msc_regions_temp where session_id = p_session_id;

2697: END IF;
2698: END LOOP;
2699:
2700: --bug3520746 Delete temp records before exiting
2701: delete from msc_regions_temp where session_id = p_session_id;
2702: IF PG_DEBUG in ('Y', 'C') THEN
2703: msc_sch_wb.atp_debug('Rows deleted from msc_regions_temp:'|| sql%rowcount);
2704: END IF;
2705:

Line 2703: msc_sch_wb.atp_debug('Rows deleted from msc_regions_temp:'|| sql%rowcount);

2699:
2700: --bug3520746 Delete temp records before exiting
2701: delete from msc_regions_temp where session_id = p_session_id;
2702: IF PG_DEBUG in ('Y', 'C') THEN
2703: msc_sch_wb.atp_debug('Rows deleted from msc_regions_temp:'|| sql%rowcount);
2704: END IF;
2705:
2706: --bug3940999 Delete temp records before exiting
2707: delete from msc_atp_src_profile_temp where session_id = p_session_id;

Line 2754: delete from msc_regions_temp where session_id = p_session_id;

2750: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'Exception x_return_status : '||x_return_status);
2751: END IF;
2752:
2753: --bug3520746 Delete temp records before exiting
2754: delete from msc_regions_temp where session_id = p_session_id;
2755: IF PG_DEBUG in ('Y', 'C') THEN
2756: msc_sch_wb.atp_debug('Rows deleted from msc_regions_temp:'|| sql%rowcount);
2757: END IF;
2758:

Line 2756: msc_sch_wb.atp_debug('Rows deleted from msc_regions_temp:'|| sql%rowcount);

2752:
2753: --bug3520746 Delete temp records before exiting
2754: delete from msc_regions_temp where session_id = p_session_id;
2755: IF PG_DEBUG in ('Y', 'C') THEN
2756: msc_sch_wb.atp_debug('Rows deleted from msc_regions_temp:'|| sql%rowcount);
2757: END IF;
2758:
2759: --bug3940999 Delete temp records before exiting
2760: delete from msc_atp_src_profile_temp where session_id = p_session_id;