DBA Data[Home] [Help]

APPS.MSC_ATP_PVT dependencies on MRP_ATP_PVT

Line 97: l_sources MRP_ATP_PVT.Atp_Source_Typ;

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

Line 98: l_atp_rec MRP_ATP_PVT.AtpRec;

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

Line 99: l_future_atp_rec MRP_ATP_PVT.AtpRec;

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

Line 292: l_atp_insert_rec MRP_ATP_PVT.AtpRec;

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

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

6025: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6026: END Schedule;
6027:
6028:
6029: PROCEDURE ATP_Check (p_atp_record IN OUT NoCopy MRP_ATP_PVT.AtpRec,
6030: p_plan_id IN NUMBER,
6031: p_level IN NUMBER,
6032: p_scenario_id IN NUMBER,
6033: p_search IN NUMBER,

Line 6061: l_sources MRP_ATP_PVT.Atp_Source_Typ;

6057: l_ship_method VARCHAR2(30);
6058: l_to_location_id NUMBER;
6059: l_atp_date_this_level DATE;
6060: l_atp_date_quantity_this_level NUMBER;
6061: l_sources MRP_ATP_PVT.Atp_Source_Typ;
6062: i PLS_INTEGER;
6063: j PLS_INTEGER;
6064: l_atp_rec MRP_ATP_PVT.AtpRec;
6065: l_net_demand NUMBER := 0; --5478124

Line 6064: l_atp_rec MRP_ATP_PVT.AtpRec;

6060: l_atp_date_quantity_this_level NUMBER;
6061: l_sources MRP_ATP_PVT.Atp_Source_Typ;
6062: i PLS_INTEGER;
6063: j PLS_INTEGER;
6064: l_atp_rec MRP_ATP_PVT.AtpRec;
6065: l_net_demand NUMBER := 0; --5478124
6066: l_sched_status BOOLEAN;
6067: l_atp_insert_rec MRP_ATP_PVT.AtpRec;
6068: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

Line 6067: l_atp_insert_rec MRP_ATP_PVT.AtpRec;

6063: j PLS_INTEGER;
6064: l_atp_rec MRP_ATP_PVT.AtpRec;
6065: l_net_demand NUMBER := 0; --5478124
6066: l_sched_status BOOLEAN;
6067: l_atp_insert_rec MRP_ATP_PVT.AtpRec;
6068: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6069: l_atp_period_first MRP_ATP_PUB.ATP_Period_Typ;
6070: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6071: l_res_atp_period MRP_ATP_PUB.ATP_Period_Typ;

Line 6083: g_atp_record MRP_ATP_PVT.AtpRec;

6079:
6080: l_inv_item_id NUMBER;
6081:
6082: temp NUMBER;
6083: g_atp_record MRP_ATP_PVT.AtpRec;
6084: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
6085: l_pegging_id NUMBER;
6086: l_parent_pegging_id NUMBER;
6087: l_atp_pegging_id NUMBER;