DBA Data[Home] [Help]

APPS.MSC_ATP_PVT dependencies on MSC_REGIONS_TEMP

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

17658: END IF;
17659:
17660: --3720018 (end of changes)
17661:
17662: -- Delete records from MSC_REGIONS_TEMP before returning back to calling
17663: -- application so as to clean up the table for another request within
17664: -- same session for Region Level Sourcing Support
17665:
17666: DELETE msc_regions_temp

Line 17666: DELETE msc_regions_temp

17662: -- Delete records from MSC_REGIONS_TEMP before returning back to calling
17663: -- application so as to clean up the table for another request within
17664: -- same session for Region Level Sourcing Support
17665:
17666: DELETE msc_regions_temp
17667: WHERE session_id = p_session_id;
17668:
17669: IF PG_DEBUG in ('Y', 'C') THEN
17670: msc_sch_wb.atp_debug('Call_Schedule: ' || 'Rows deleted from msc_regions_temp : '||sql%rowcount);

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

17666: DELETE msc_regions_temp
17667: WHERE session_id = p_session_id;
17668:
17669: IF PG_DEBUG in ('Y', 'C') THEN
17670: msc_sch_wb.atp_debug('Call_Schedule: ' || 'Rows deleted from msc_regions_temp : '||sql%rowcount);
17671: END IF;
17672: --bug3940999 Delete records from msc_atp_src_profile_temp before returning
17673: --back to calling application so as to clean up the table
17674: DELETE msc_atp_src_profile_temp