APPS.MSC_ATP_DB_UTILS dependencies on MSC_ATP_SD_DETAILS_TEMP

Line 4691: * Copy the data from the msc_atp_sd_details_temp table

4687:
4688: /*
4689: * dsting: 9/17/2002
4690: *
4691: * Copy the data from the msc_atp_sd_details_temp table
4692: * into mrp_atp_details_temp. Plus, slap on a pegging id and
4693: * end_pegging_id
4694: *
4695: * Delete the entries in msc_atp_sd_details_temp

Line 4695: * Delete the entries in msc_atp_sd_details_temp

4691: * Copy the data from the msc_atp_sd_details_temp table
4692: * into mrp_atp_details_temp. Plus, slap on a pegging id and
4693: * end_pegging_id
4694: *
4695: * Delete the entries in msc_atp_sd_details_temp
4696: * since we don't need them anymore too.
4697: */
4698: PROCEDURE move_SD_temp_into_mrp_details(
4699: p_pegging_id IN NUMBER,

Line 4811: FROM msc_atp_sd_details_temp;

4807: ORIG_CUSTOMER_NAME, --bug3263368
4808: ORIG_DEMAND_CLASS, --bug3263368
4809: ORIG_REQUEST_DATE, --bug3263368
4810: INVENTORY_ITEM_NAME --bug3579625
4811: FROM msc_atp_sd_details_temp;
4812:
4813: IF PG_DEBUG in ('Y', 'C') THEN
4814: msc_sch_wb.atp_debug('move_SD_temp_into_mrp_details: ' || ' Num rows dumped: ' || SQL%ROWCOUNT);
4815: END IF;

Line 4827: DELETE msc_atp_sd_details_temp;

4823: msc_sch_wb.atp_debug('PG_Clear_SD_Details_Temp: ' || PG_CLEAR_SD_DETAILS_TEMP);
4824: END IF;
4825:
4826: IF PG_CLEAR_SD_DETAILS_TEMP = 1 THEN
4827: DELETE msc_atp_sd_details_temp;
4828: IF PG_DEBUG in ('Y', 'C') THEN
4829: msc_sch_wb.atp_debug('Clear_SD_Details_Temp rows: ' || SQL%ROWCOUNT);
4830: END IF;
4831: END IF;