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
18549: WHERE session_id = p_session_id;
18550:
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
18549: WHERE session_id = p_session_id;
18550:
18551:
18552:
18550:
18551:
18552:
18553: IF PG_DEBUG in ('Y', 'C') THEN
18554: msc_sch_wb.atp_debug('Call_Schedule: ' || 'Rows deleted from msc_atp_src_profile_temp : '||sql%rowcount);
18555: msc_sch_wb.atp_debug('Call_Schedule: ' || 'Before calling MSC_ATP_PROC.Delete_Copy_Demand');
18556: END IF;
18557:
18558: -- Summary enhancement - Delete the copy demands that were created in this transaction if refresh number has moved.
19078: END IF;
19079:
19080: select profile_value,profile_name
19081: bulk collect into l_profile_value,l_profile_name
19082: from MSC_ATP_SRC_PROFILE_TEMP
19083: where session_id = p_session_id;
19084:
19085: FOR j in 1..l_profile_name.count LOOP
19086: