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 2215: -- Delete records from MSC_REGIONS_TEMP before returning back to calling

2211: END LOOP; -- FOR j in 1..l_atp_rec.inventory_item_id.LAST LOOP
2212:
2213: IF NVL(g_atp_check, '@') = 'N' THEN
2214:
2215: -- Delete records from MSC_REGIONS_TEMP before returning back to calling
2216: -- application so as to clean up the table for another request within
2217: -- same session for Region Level Sourcing Support
2218:
2219: DELETE msc_regions_temp

Line 2219: DELETE msc_regions_temp

2215: -- Delete records from MSC_REGIONS_TEMP before returning back to calling
2216: -- application so as to clean up the table for another request within
2217: -- same session for Region Level Sourcing Support
2218:
2219: DELETE msc_regions_temp
2220: WHERE session_id = p_session_id;
2221:
2222: IF PG_DEBUG in ('Y', 'C') THEN
2223: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'Rows deleted from msc_regions_temp : '||sql%rowcount);

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

2219: DELETE msc_regions_temp
2220: WHERE session_id = p_session_id;
2221:
2222: IF PG_DEBUG in ('Y', 'C') THEN
2223: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'Rows deleted from msc_regions_temp : '||sql%rowcount);
2224: END IF;
2225:
2226: --bug3940999 Delete temp records before exiting
2227: DELETE msc_atp_src_profile_temp

Line 2664: delete from msc_regions_temp where session_id = p_session_id;

2660: --Update_table which will be called across dblink instead of
2661: --making multiple update statements across dblink.
2662:
2663: --bug3520746 Delete temp records before exiting
2664: delete from msc_regions_temp where session_id = p_session_id;
2665:
2666: IF PG_DEBUG in ('Y', 'C') THEN
2667: msc_sch_wb.atp_debug('Rows deleted from msc_regions_temp:'|| sql%rowcount);
2668: END IF;

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

2663: --bug3520746 Delete temp records before exiting
2664: delete from msc_regions_temp where session_id = p_session_id;
2665:
2666: IF PG_DEBUG in ('Y', 'C') THEN
2667: msc_sch_wb.atp_debug('Rows deleted from msc_regions_temp:'|| sql%rowcount);
2668: END IF;
2669:
2670: --bug3940999 Delete temp records before exiting
2671: delete from msc_atp_src_profile_temp where session_id = p_session_id;

Line 2735: delete from msc_regions_temp where session_id = p_session_id;

2731: END IF;
2732: END LOOP;
2733:
2734: --bug3520746 Delete temp records before exiting
2735: delete from msc_regions_temp where session_id = p_session_id;
2736: IF PG_DEBUG in ('Y', 'C') THEN
2737: msc_sch_wb.atp_debug('Rows deleted from msc_regions_temp:'|| sql%rowcount);
2738: END IF;
2739:

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

2733:
2734: --bug3520746 Delete temp records before exiting
2735: delete from msc_regions_temp where session_id = p_session_id;
2736: IF PG_DEBUG in ('Y', 'C') THEN
2737: msc_sch_wb.atp_debug('Rows deleted from msc_regions_temp:'|| sql%rowcount);
2738: END IF;
2739:
2740: --bug3940999 Delete temp records before exiting
2741: delete from msc_atp_src_profile_temp where session_id = p_session_id;

Line 2788: delete from msc_regions_temp where session_id = p_session_id;

2784: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'Exception x_return_status : '||x_return_status);
2785: END IF;
2786:
2787: --bug3520746 Delete temp records before exiting
2788: delete from msc_regions_temp where session_id = p_session_id;
2789: IF PG_DEBUG in ('Y', 'C') THEN
2790: msc_sch_wb.atp_debug('Rows deleted from msc_regions_temp:'|| sql%rowcount);
2791: END IF;
2792:

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

2786:
2787: --bug3520746 Delete temp records before exiting
2788: delete from msc_regions_temp where session_id = p_session_id;
2789: IF PG_DEBUG in ('Y', 'C') THEN
2790: msc_sch_wb.atp_debug('Rows deleted from msc_regions_temp:'|| sql%rowcount);
2791: END IF;
2792:
2793: --bug3940999 Delete temp records before exiting
2794: delete from msc_atp_src_profile_temp where session_id = p_session_id;