DBA Data[Home] [Help]

APPS.MSC_ATP_PVT dependencies on MRP_ATP_PVT

Line 99: l_sources MRP_ATP_PVT.Atp_Source_Typ;

95: l_overall_status PLS_INTEGER;
96: l_ship_set_status PLS_INTEGER;
97: l_arrival_set_status PLS_INTEGER;
98: l_process_arrival_set VARCHAR2(30) := '@@@';
99: l_sources MRP_ATP_PVT.Atp_Source_Typ;
100: l_atp_rec MRP_ATP_PVT.AtpRec;
101: l_future_atp_rec MRP_ATP_PVT.AtpRec;
102: l_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
103: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

Line 100: l_atp_rec MRP_ATP_PVT.AtpRec;

96: l_ship_set_status PLS_INTEGER;
97: l_arrival_set_status PLS_INTEGER;
98: l_process_arrival_set VARCHAR2(30) := '@@@';
99: l_sources MRP_ATP_PVT.Atp_Source_Typ;
100: l_atp_rec MRP_ATP_PVT.AtpRec;
101: l_future_atp_rec MRP_ATP_PVT.AtpRec;
102: l_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
103: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
104: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 101: l_future_atp_rec MRP_ATP_PVT.AtpRec;

97: l_arrival_set_status PLS_INTEGER;
98: l_process_arrival_set VARCHAR2(30) := '@@@';
99: l_sources MRP_ATP_PVT.Atp_Source_Typ;
100: l_atp_rec MRP_ATP_PVT.AtpRec;
101: l_future_atp_rec MRP_ATP_PVT.AtpRec;
102: l_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
103: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
104: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
105: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;

Line 294: l_atp_insert_rec MRP_ATP_PVT.AtpRec;

290: l_msg_name varchar2(30);
291: l_error_code INTEGER;
292:
293: -- Bug 3226083
294: l_atp_insert_rec MRP_ATP_PVT.AtpRec;
295: l_mem_dest_id NUMBER;
296: l_pf_dest_id NUMBER;
297:
298: l_sysdate_orc DATE; --bug3439591

Line 329: l_last_success_atp_rec MRP_ATP_PVT.AtpRec;

325: l_number_of_iterations NUMBER; --Used in binary search algo
326: l_second_good_run NUMBER; --Used in binary search algo
327: l_loop_count NUMBER; --Used in binary search algo
328: l_g_inv_ctp NUMBER; --Used in binary search algo
329: l_last_success_atp_rec MRP_ATP_PVT.AtpRec;
330:
331: --Pegging ids used for deletion and hide/un-hide.
332: l_atp_peg_id NUMBER;
333: l_ctp_parent_peg_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 6645: PROCEDURE ATP_Check (p_atp_record IN OUT NoCopy MRP_ATP_PVT.AtpRec,

6641: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6642: END Schedule;
6643:
6644:
6645: PROCEDURE ATP_Check (p_atp_record IN OUT NoCopy MRP_ATP_PVT.AtpRec,
6646: p_plan_id IN NUMBER,
6647: p_level IN NUMBER,
6648: p_scenario_id IN NUMBER,
6649: p_search IN NUMBER,

Line 6677: l_sources MRP_ATP_PVT.Atp_Source_Typ;

6673: l_ship_method VARCHAR2(30);
6674: l_to_location_id NUMBER;
6675: l_atp_date_this_level DATE;
6676: l_atp_date_quantity_this_level NUMBER;
6677: l_sources MRP_ATP_PVT.Atp_Source_Typ;
6678: i PLS_INTEGER;
6679: j PLS_INTEGER;
6680: l_atp_rec MRP_ATP_PVT.AtpRec;
6681: l_net_demand NUMBER := 0; --5478124

Line 6680: l_atp_rec MRP_ATP_PVT.AtpRec;

6676: l_atp_date_quantity_this_level NUMBER;
6677: l_sources MRP_ATP_PVT.Atp_Source_Typ;
6678: i PLS_INTEGER;
6679: j PLS_INTEGER;
6680: l_atp_rec MRP_ATP_PVT.AtpRec;
6681: l_net_demand NUMBER := 0; --5478124
6682: l_sched_status BOOLEAN;
6683: l_atp_insert_rec MRP_ATP_PVT.AtpRec;
6684: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

Line 6683: l_atp_insert_rec MRP_ATP_PVT.AtpRec;

6679: j PLS_INTEGER;
6680: l_atp_rec MRP_ATP_PVT.AtpRec;
6681: l_net_demand NUMBER := 0; --5478124
6682: l_sched_status BOOLEAN;
6683: l_atp_insert_rec MRP_ATP_PVT.AtpRec;
6684: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6685: l_atp_period_first MRP_ATP_PUB.ATP_Period_Typ;
6686: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6687: l_res_atp_period MRP_ATP_PUB.ATP_Period_Typ;

Line 6699: g_atp_record MRP_ATP_PVT.AtpRec;

6695:
6696: l_inv_item_id NUMBER;
6697:
6698: temp NUMBER;
6699: g_atp_record MRP_ATP_PVT.AtpRec;
6700: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
6701: l_pegging_id NUMBER;
6702: l_parent_pegging_id NUMBER;
6703: l_atp_pegging_id NUMBER;