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

2089: IF PG_DEBUG in ('Y', 'C') THEN
2090: msc_sch_wb.atp_debug('item_alloc_avail_opt_dtls: constrained plan: ' || p_plan_id);
2091: END IF;
2092:
2093: INSERT INTO msc_atp_sd_details_temp (
2094: ATP_Level,
2095: Order_line_id,
2096: Scenario_Id,
2097: Inventory_Item_Id,

Line 2762: INSERT INTO msc_atp_sd_details_temp (

2758: IF PG_DEBUG in ('Y', 'C') THEN
2759: msc_sch_wb.atp_debug('item_alloc_avail_unopt_dtls: UNconstrained plan: ' || p_plan_id);
2760: END IF;
2761:
2762: INSERT INTO msc_atp_sd_details_temp (
2763: ATP_Level,
2764: Order_line_id,
2765: Scenario_Id,
2766: Inventory_Item_Id,

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

4525: END IF;
4526:
4527: -- for period ATP
4528: IF PG_DEBUG in ('Y', 'C') THEN
4529: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'after insert into msc_atp_sd_details_temp');
4530: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'num rows : ' || SQL%ROWCOUNT);
4531: END IF;
4532:
4533: /*AATP Forward Consumption rajjain begin

Line 5006: -- dsting dump the data into msc_atp_sd_details_temp

5002: --rajjain trim the remaining 12/10/2002
5003: MSC_SATP_FUNC.Trim_Atp_Supply_Demand(l_temp_atp_supply_demand, l_return_status,
5004: (l_temp_atp_supply_demand.Level.Count - k));
5005:
5006: -- dsting dump the data into msc_atp_sd_details_temp
5007: -- and null out the record
5008: move_SD_plsql_into_SD_temp(l_temp_atp_supply_demand);
5009:
5010: END IF; -- IF (NVL(p_insert_flag, 0) <>0) .....

Line 6878: INSERT INTO msc_atp_sd_details_temp (

6874: IF (l_optimized_plan = 1) THEN -- Constrained Plan Bug 2809639
6875: IF PG_DEBUG in ('Y', 'C') THEN
6876: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'Constrained Plan Batching Details');
6877: END IF;
6878: INSERT INTO msc_atp_sd_details_temp (
6879: ATP_Level,
6880: Order_line_id,
6881: Scenario_Id,
6882: Inventory_Item_Id,

Line 7215: INSERT INTO msc_atp_sd_details_temp (

7211: ELSE -- now Other plans Bug 2809639
7212: IF PG_DEBUG in ('Y', 'C') THEN
7213: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'Other Plans Batching Details');
7214: END IF;
7215: INSERT INTO msc_atp_sd_details_temp (
7216: ATP_Level,
7217: Order_line_id,
7218: Scenario_Id,
7219: Inventory_Item_Id,

Line 7513: INSERT INTO msc_atp_sd_details_temp (

7509: IF (l_optimized_plan = 1) THEN -- Constrained Plan Bug 2809639
7510: IF PG_DEBUG in ('Y', 'C') THEN
7511: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'Constrained Plan No Batching Details');
7512: END IF;
7513: INSERT INTO msc_atp_sd_details_temp (
7514: ATP_Level,
7515: Order_line_id,
7516: Scenario_Id,
7517: Inventory_Item_Id,

Line 7839: INSERT INTO msc_atp_sd_details_temp (

7835: ELSE -- now Other plans Bug 2809639
7836: IF PG_DEBUG in ('Y', 'C') THEN
7837: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'Other Plans No Batching Details');
7838: END IF;
7839: INSERT INTO msc_atp_sd_details_temp (
7840: ATP_Level,
7841: Order_line_id,
7842: Scenario_Id,
7843: Inventory_Item_Id,

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

8120: END IF; --- If l_use_batching =1 then
8121:
8122: -- for period ATP
8123: IF PG_DEBUG in ('Y', 'C') THEN
8124: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'after insert into msc_atp_sd_details_temp');
8125: END IF;
8126: MSC_ATP_PROC.get_period_data_from_SD_temp(x_atp_period);
8127:
8128: l_current_atp.atp_period := x_atp_period.Period_Start_Date;

Line 9307: INSERT INTO msc_atp_sd_details_temp (

9303:
9304: IF l_check_cap_model_flag = 1 THEN
9305:
9306: -- dsting: s/d details performance enh
9307: INSERT INTO msc_atp_sd_details_temp (
9308: ATP_Level,
9309: Order_line_id,
9310: Scenario_Id,
9311: Inventory_Item_Id,

Line 9592: INSERT INTO msc_atp_sd_details_temp (

9588: ; -- dsting removed order by col25;
9589: ELSE
9590:
9591: -- dsting: s/d details performance enh
9592: INSERT INTO msc_atp_sd_details_temp (
9593: ATP_Level,
9594: Order_line_id,
9595: Scenario_Id,
9596: Inventory_Item_Id,

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

9865: -- ship_rec_cal changes end
9866: --=======================================================================================================
9867: -- for period ATP
9868: IF PG_DEBUG in ('Y', 'C') THEN
9869: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'after insert into msc_atp_sd_details_temp');
9870: END IF;
9871: MSC_ATP_PROC.get_period_data_from_SD_temp(x_atp_period);
9872:
9873: l_current_atp.atp_period := x_atp_period.Period_Start_Date;