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 11826: INSERT INTO msc_atp_sd_details_temp (

11822: MSC_ATP_DB_UTILS.Clear_SD_Details_temp();
11823:
11824: IF l_check_cap_model_flag = 1 THEN
11825: msc_sch_wb.atp_debug('Check Sources for model, details are on');
11826: INSERT INTO msc_atp_sd_details_temp (
11827: ATP_level,
11828: Order_line_id,
11829: Scenario_Id,
11830: Inventory_Item_Id,

Line 11996: INSERT INTO msc_atp_sd_details_temp (

11992: AND Decode(p_sup_atp_info_rec.sup_cap_type, 1, p.new_ship_date,p.new_dock_date) --4055719
11993: <= least(p_sup_atp_info_rec.last_cap_date,l_cutoff_date)
11994: );
11995: ELSE
11996: INSERT INTO msc_atp_sd_details_temp (
11997: ATP_level,
11998: Order_line_id,
11999: Scenario_Id,
12000: Inventory_Item_Id,

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

12158: END IF; -- IF l_check_cap_model_flag = 1 THEN
12159:
12160: -- for period ATP
12161: IF PG_DEBUG in ('Y', 'C') THEN
12162: msc_sch_wb.atp_debug('Get_Supplier_Atp_Info: ' || 'after inserting into msc_atp_sd_details_temp');
12163: msc_sch_wb.atp_debug('Get_Supplier_Atp_Info: ' || 'rows processed: ' || SQL%ROWCOUNT);
12164: END IF;
12165:
12166: MSC_ATP_PROC.get_period_data_from_SD_temp(x_atp_period);