APPS.MSC_ATP_PVT dependencies on MSC_ATP_SRC_PROFILE_TEMP

Line 17672: --bug3940999 Delete records from msc_atp_src_profile_temp before returning

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
17675: WHERE session_id = p_session_id;
17676:

Line 17674: DELETE msc_atp_src_profile_temp

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
17675: WHERE session_id = p_session_id;
17676:
17677:
17678:

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

17676:
17677:
17678:
17679: IF PG_DEBUG in ('Y', 'C') THEN
17680: msc_sch_wb.atp_debug('Call_Schedule: ' || 'Rows deleted from msc_atp_src_profile_temp : '||sql%rowcount);
17681: msc_sch_wb.atp_debug('Call_Schedule: ' || 'Before calling MSC_ATP_PROC.Delete_Copy_Demand');
17682: END IF;
17683:
17684: -- Summary enhancement - Delete the copy demands that were created in this transaction if refresh number has moved.

Line 18208: from MSC_ATP_SRC_PROFILE_TEMP

18204: END IF;
18205:
18206: select profile_value,profile_name
18207: bulk collect into l_profile_value,l_profile_name
18208: from MSC_ATP_SRC_PROFILE_TEMP
18209: where session_id = p_session_id;
18210:
18211: FOR j in 1..l_profile_name.count LOOP
18212: