APPS.MSC_ATP_REQ dependencies on MSC_ATP_SD_DETAILS_TEMP

Line 616: INSERT INTO msc_atp_sd_details_temp (

612: IF PG_DEBUG in ('Y', 'C') THEN
613: msc_sch_wb.atp_debug('get_res_avail_opt_dtls');
614: END IF;
615:
616: INSERT INTO msc_atp_sd_details_temp (
617: ATP_Level,
618: Order_line_id,
619: Scenario_Id,
620: Inventory_Item_Id,

Line 824: INSERT INTO msc_atp_sd_details_temp (

820: IF PG_DEBUG in ('Y', 'C') THEN
821: msc_sch_wb.atp_debug('get_res_avail_unopt_dtls');
822: END IF;
823:
824: INSERT INTO msc_atp_sd_details_temp (
825: ATP_Level,
826: Order_line_id,
827: Scenario_Id,
828: Inventory_Item_Id,

Line 1034: INSERT INTO msc_atp_sd_details_temp (

1030: IF PG_DEBUG in ('Y', 'C') THEN
1031: msc_sch_wb.atp_debug('get_res_avail_opt_bat_dtls');
1032: END IF;
1033:
1034: INSERT INTO msc_atp_sd_details_temp (
1035: ATP_Level,
1036: Order_line_id,
1037: Scenario_Id,
1038: Inventory_Item_Id,

Line 1256: INSERT INTO msc_atp_sd_details_temp (

1252: IF PG_DEBUG in ('Y', 'C') THEN
1253: msc_sch_wb.atp_debug('get_res_avail_unopt_bat_dtls');
1254: END IF;
1255:
1256: INSERT INTO msc_atp_sd_details_temp (
1257: ATP_Level,
1258: Order_line_id,
1259: Scenario_Id,
1260: Inventory_Item_Id,

Line 2479: INSERT INTO msc_atp_sd_details_temp (

2475: msc_sch_wb.atp_debug('Begin get_mat_avail_ods_dtls');
2476: END IF;
2477:
2478: -- dsting: S/D details changes
2479: INSERT INTO msc_atp_sd_details_temp (
2480: ATP_Level,
2481: Order_line_id,
2482: Scenario_Id,
2483: Inventory_Item_Id,

Line 2873: INSERT INTO msc_atp_sd_details_temp (

2869: IF PG_DEBUG in ('Y', 'C') THEN
2870: msc_sch_wb.atp_debug('Begin get_mat_avail_opt_dtls');
2871: END IF;
2872:
2873: INSERT INTO msc_atp_sd_details_temp (
2874: ATP_Level,
2875: Order_line_id,
2876: Scenario_Id,
2877: Inventory_Item_Id,

Line 3085: INSERT INTO msc_atp_sd_details_temp (

3081: IF PG_DEBUG in ('Y', 'C') THEN
3082: msc_sch_wb.atp_debug('Begin get_mat_avail_unopt_dtls');
3083: END IF;
3084:
3085: INSERT INTO msc_atp_sd_details_temp (
3086: ATP_Level,
3087: Order_line_id,
3088: Scenario_Id,
3089: Inventory_Item_Id,

Line 5501: msc_sch_wb.atp_debug('Insert_Details: ' || 'after inserting into msc_atp_sd_details_temp');

5497: END IF;
5498: END IF;
5499:
5500: IF PG_DEBUG in ('Y', 'C') THEN
5501: msc_sch_wb.atp_debug('Insert_Details: ' || 'after inserting into msc_atp_sd_details_temp');
5502: msc_sch_wb.atp_debug('Insert_Details: ' || 'Total Supply/Demand Recs : '|| SQL%ROWCOUNT);
5503: END IF;
5504:
5505: -- time_phased_atp

Line 11793: INSERT INTO msc_atp_sd_details_temp (

11789: MSC_ATP_DB_UTILS.Clear_SD_Details_temp();
11790:
11791: IF l_check_cap_model_flag = 1 THEN
11792: msc_sch_wb.atp_debug('Check Sources for model, details are on');
11793: INSERT INTO msc_atp_sd_details_temp (
11794: ATP_level,
11795: Order_line_id,
11796: Scenario_Id,
11797: Inventory_Item_Id,

Line 11963: INSERT INTO msc_atp_sd_details_temp (

11959: AND Decode(p_sup_atp_info_rec.sup_cap_type, 1, p.new_ship_date,p.new_dock_date) --4055719
11960: <= least(p_sup_atp_info_rec.last_cap_date,l_cutoff_date)
11961: );
11962: ELSE
11963: INSERT INTO msc_atp_sd_details_temp (
11964: ATP_level,
11965: Order_line_id,
11966: Scenario_Id,
11967: Inventory_Item_Id,

Line 12129: msc_sch_wb.atp_debug('Get_Supplier_Atp_Info: ' || 'after inserting into msc_atp_sd_details_temp');

12125: END IF; -- IF l_check_cap_model_flag = 1 THEN
12126:
12127: -- for period ATP
12128: IF PG_DEBUG in ('Y', 'C') THEN
12129: msc_sch_wb.atp_debug('Get_Supplier_Atp_Info: ' || 'after inserting into msc_atp_sd_details_temp');
12130: msc_sch_wb.atp_debug('Get_Supplier_Atp_Info: ' || 'rows processed: ' || SQL%ROWCOUNT);
12131: END IF;
12132:
12133: MSC_ATP_PROC.get_period_data_from_SD_temp(x_atp_period);