eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_AATP_PVT dependencies on MSC_ATP_SD_DETAILS_TEMP

Line 54: INSERT INTO msc_atp_sd_details_temp (

50: msc_sch_wb.atp_debug('**** PROCEDURE move_SD_plsql_into_SD_temp ****');
51: END IF;
52:
53: FORALL k IN 1..x_atp_supply_demand.Level.COUNT
54: INSERT INTO msc_atp_sd_details_temp (
55: session_id,
56: Atp_Level,
57: order_line_id,
58: scenario_id,

Line 1937: INSERT INTO msc_atp_sd_details_temp (

1933: IF PG_DEBUG in ('Y', 'C') THEN
1934: msc_sch_wb.atp_debug('item_alloc_avail_opt_dtls: constrained plan: ' || p_plan_id);
1935: END IF;
1936:
1937: INSERT INTO msc_atp_sd_details_temp (
1938: ATP_Level,
1939: Order_line_id,
1940: Scenario_Id,
1941: Inventory_Item_Id,

Line 2564: INSERT INTO msc_atp_sd_details_temp (

2560: IF PG_DEBUG in ('Y', 'C') THEN
2561: msc_sch_wb.atp_debug('item_alloc_avail_unopt_dtls: UNconstrained plan: ' || p_plan_id);
2562: END IF;
2563:
2564: INSERT INTO msc_atp_sd_details_temp (
2565: ATP_Level,
2566: Order_line_id,
2567: Scenario_Id,
2568: Inventory_Item_Id,

Line 4299: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'after insert into msc_atp_sd_details_temp');

4295: END IF;
4296:
4297: -- for period ATP
4298: IF PG_DEBUG in ('Y', 'C') THEN
4299: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'after insert into msc_atp_sd_details_temp');
4300: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'num rows : ' || SQL%ROWCOUNT);
4301: END IF;
4302:
4303: /*AATP Forward Consumption rajjain begin

Line 4776: -- dsting dump the data into msc_atp_sd_details_temp

4772: --rajjain trim the remaining 12/10/2002
4773: MSC_SATP_FUNC.Trim_Atp_Supply_Demand(l_temp_atp_supply_demand, l_return_status,
4774: (l_temp_atp_supply_demand.Level.Count - k));
4775:
4776: -- dsting dump the data into msc_atp_sd_details_temp
4777: -- and null out the record
4778: move_SD_plsql_into_SD_temp(l_temp_atp_supply_demand);
4779:
4780: END IF; -- IF (NVL(p_insert_flag, 0) <>0) .....

Line 6648: INSERT INTO msc_atp_sd_details_temp (

6644: IF (l_optimized_plan = 1) THEN -- Constrained Plan Bug 2809639
6645: IF PG_DEBUG in ('Y', 'C') THEN
6646: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'Constrained Plan Batching Details');
6647: END IF;
6648: INSERT INTO msc_atp_sd_details_temp (
6649: ATP_Level,
6650: Order_line_id,
6651: Scenario_Id,
6652: Inventory_Item_Id,

Line 6985: INSERT INTO msc_atp_sd_details_temp (

6981: ELSE -- now Other plans Bug 2809639
6982: IF PG_DEBUG in ('Y', 'C') THEN
6983: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'Other Plans Batching Details');
6984: END IF;
6985: INSERT INTO msc_atp_sd_details_temp (
6986: ATP_Level,
6987: Order_line_id,
6988: Scenario_Id,
6989: Inventory_Item_Id,

Line 7283: INSERT INTO msc_atp_sd_details_temp (

7279: IF (l_optimized_plan = 1) THEN -- Constrained Plan Bug 2809639
7280: IF PG_DEBUG in ('Y', 'C') THEN
7281: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'Constrained Plan No Batching Details');
7282: END IF;
7283: INSERT INTO msc_atp_sd_details_temp (
7284: ATP_Level,
7285: Order_line_id,
7286: Scenario_Id,
7287: Inventory_Item_Id,

Line 7609: INSERT INTO msc_atp_sd_details_temp (

7605: ELSE -- now Other plans Bug 2809639
7606: IF PG_DEBUG in ('Y', 'C') THEN
7607: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'Other Plans No Batching Details');
7608: END IF;
7609: INSERT INTO msc_atp_sd_details_temp (
7610: ATP_Level,
7611: Order_line_id,
7612: Scenario_Id,
7613: Inventory_Item_Id,

Line 7894: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'after insert into msc_atp_sd_details_temp');

7890: END IF; --- If l_use_batching =1 then
7891:
7892: -- for period ATP
7893: IF PG_DEBUG in ('Y', 'C') THEN
7894: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'after insert into msc_atp_sd_details_temp');
7895: END IF;
7896: MSC_ATP_PROC.get_period_data_from_SD_temp(x_atp_period);
7897:
7898: l_current_atp.atp_period := x_atp_period.Period_Start_Date;

Line 9076: INSERT INTO msc_atp_sd_details_temp (

9072:
9073: IF l_check_cap_model_flag = 1 THEN
9074:
9075: -- dsting: s/d details performance enh
9076: INSERT INTO msc_atp_sd_details_temp (
9077: ATP_Level,
9078: Order_line_id,
9079: Scenario_Id,
9080: Inventory_Item_Id,

Line 9361: INSERT INTO msc_atp_sd_details_temp (

9357: ; -- dsting removed order by col25;
9358: ELSE
9359:
9360: -- dsting: s/d details performance enh
9361: INSERT INTO msc_atp_sd_details_temp (
9362: ATP_Level,
9363: Order_line_id,
9364: Scenario_Id,
9365: Inventory_Item_Id,

Line 9638: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'after insert into msc_atp_sd_details_temp');

9634: -- ship_rec_cal changes end
9635: --=======================================================================================================
9636: -- for period ATP
9637: IF PG_DEBUG in ('Y', 'C') THEN
9638: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'after insert into msc_atp_sd_details_temp');
9639: END IF;
9640: MSC_ATP_PROC.get_period_data_from_SD_temp(x_atp_period);
9641:
9642: l_current_atp.atp_period := x_atp_period.Period_Start_Date;