DBA Data[Home] [Help]

APPS.MSC_ATP_PVT dependencies on MSC_REGIONS_TEMP

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

18532: END IF;
18533:
18534: --3720018 (end of changes)
18535:
18536: -- Delete records from MSC_REGIONS_TEMP before returning back to calling
18537: -- application so as to clean up the table for another request within
18538: -- same session for Region Level Sourcing Support
18539:
18540: DELETE msc_regions_temp

Line 18540: DELETE msc_regions_temp

18536: -- Delete records from MSC_REGIONS_TEMP before returning back to calling
18537: -- application so as to clean up the table for another request within
18538: -- same session for Region Level Sourcing Support
18539:
18540: DELETE msc_regions_temp
18541: WHERE session_id = p_session_id;
18542:
18543: IF PG_DEBUG in ('Y', 'C') THEN
18544: msc_sch_wb.atp_debug('Call_Schedule: ' || 'Rows deleted from msc_regions_temp : '||sql%rowcount);

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

18540: DELETE msc_regions_temp
18541: WHERE session_id = p_session_id;
18542:
18543: IF PG_DEBUG in ('Y', 'C') THEN
18544: msc_sch_wb.atp_debug('Call_Schedule: ' || 'Rows deleted from msc_regions_temp : '||sql%rowcount);
18545: END IF;
18546: --bug3940999 Delete records from msc_atp_src_profile_temp before returning
18547: --back to calling application so as to clean up the table
18548: DELETE msc_atp_src_profile_temp