APPS.MSC_ATP_DB_UTILS dependencies on MSC_ATP_SD_DETAILS_TEMP

Line 4509: * Copy the data from the msc_atp_sd_details_temp table

4505:
4506: /*
4507: * dsting: 9/17/2002
4508: *
4509: * Copy the data from the msc_atp_sd_details_temp table
4510: * into mrp_atp_details_temp. Plus, slap on a pegging id and
4511: * end_pegging_id
4512: *
4513: * Delete the entries in msc_atp_sd_details_temp

Line 4513: * Delete the entries in msc_atp_sd_details_temp

4509: * Copy the data from the msc_atp_sd_details_temp table
4510: * into mrp_atp_details_temp. Plus, slap on a pegging id and
4511: * end_pegging_id
4512: *
4513: * Delete the entries in msc_atp_sd_details_temp
4514: * since we don't need them anymore too.
4515: */
4516: PROCEDURE move_SD_temp_into_mrp_details(
4517: p_pegging_id IN NUMBER,

Line 4629: FROM msc_atp_sd_details_temp;

4625: ORIG_CUSTOMER_NAME, --bug3263368
4626: ORIG_DEMAND_CLASS, --bug3263368
4627: ORIG_REQUEST_DATE, --bug3263368
4628: INVENTORY_ITEM_NAME --bug3579625
4629: FROM msc_atp_sd_details_temp;
4630:
4631: IF PG_DEBUG in ('Y', 'C') THEN
4632: msc_sch_wb.atp_debug('move_SD_temp_into_mrp_details: ' || ' Num rows dumped: ' || SQL%ROWCOUNT);
4633: END IF;

Line 4645: DELETE msc_atp_sd_details_temp;

4641: msc_sch_wb.atp_debug('PG_Clear_SD_Details_Temp: ' || PG_CLEAR_SD_DETAILS_TEMP);
4642: END IF;
4643:
4644: IF PG_CLEAR_SD_DETAILS_TEMP = 1 THEN
4645: DELETE msc_atp_sd_details_temp;
4646: IF PG_DEBUG in ('Y', 'C') THEN
4647: msc_sch_wb.atp_debug('Clear_SD_Details_Temp rows: ' || SQL%ROWCOUNT);
4648: END IF;
4649: END IF;