DBA Data[Home] [Help]

APPS.MSC_ATP_REQ dependencies on MRP_ATP_PVT

Line 3849: p_atp_record IN OUT NoCopy MRP_ATP_PVT.AtpRec,

3845:
3846: END Calculate_Atp_Dates_Qtys;
3847:
3848: PROCEDURE Check_Substitutes(
3849: p_atp_record IN OUT NoCopy MRP_ATP_PVT.AtpRec,
3850: p_parent_pegging_id IN NUMBER,
3851: p_instance_id IN NUMBER,
3852: p_scenario_id IN NUMBER,
3853: p_level IN NUMBER,

Line 4002: g_atp_record MRP_ATP_PVT.AtpRec;

3998: --4570421
3999: l_demand_quantity number; --4570421
4000: l_usage number;
4001: l_demand_id number;
4002: g_atp_record MRP_ATP_PVT.AtpRec;
4003: l_atp_insert_rec MRP_ATP_PVT.AtpRec;
4004: g_atp_period MRP_ATP_PUB.ATP_Period_Typ;
4005: g_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
4006: l_pegging_rec mrp_atp_details_temp%ROWTYPE;

Line 4003: l_atp_insert_rec MRP_ATP_PVT.AtpRec;

3999: l_demand_quantity number; --4570421
4000: l_usage number;
4001: l_demand_id number;
4002: g_atp_record MRP_ATP_PVT.AtpRec;
4003: l_atp_insert_rec MRP_ATP_PVT.AtpRec;
4004: g_atp_period MRP_ATP_PUB.ATP_Period_Typ;
4005: g_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
4006: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
4007: l_pegging_id number;

Line 4712: g_atp_record MRP_ATP_PVT.AtpRec;

4708: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
4709: l_atp_qty_tab MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
4710: --l_next_period DATE; -- time_phased_atp
4711: l_return_status VARCHAR2(1);
4712: g_atp_record MRP_ATP_PVT.AtpRec;
4713: l_net_demand number;
4714: g_quantity_ordered number;
4715: my_sqlcode NUMBER;
4716: tmp1 DATE;

Line 4723: l_atp_info MRP_ATP_PVT.ATP_Info;

4719: l_default_atp_rule_id NUMBER;
4720: l_calendar_code VARCHAR2(14);
4721: l_calendar_exception_set_id NUMBER;
4722: l_default_demand_class VARCHAR2(34);
4723: l_atp_info MRP_ATP_PVT.ATP_Info;
4724: l_pre_process_date DATE;
4725: l_processing_lead_time NUMBER;
4726: l_sysdate DATE;
4727: l_sys_next_date DATE;

Line 5609: l_res_requirements MRP_ATP_PVT.Atp_Res_Typ;

5605: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
5606: x_return_status OUT NoCopy VARCHAR2
5607: )
5608: IS
5609: l_res_requirements MRP_ATP_PVT.Atp_Res_Typ;
5610: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
5611: l_atp_qty_tab MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5612: l_requested_date_quantity number;
5613: l_resource_id number;

Line 5668: l_atp_info MRP_ATP_PVT.ATP_Info;

5664: l_calendar_code VARCHAR2(14);
5665: l_calendar_exception_set_id NUMBER;
5666: l_default_demand_class VARCHAR2(34);
5667: l_demand_class VARCHAR2(34); -- Bug 2424357
5668: l_atp_info MRP_ATP_PVT.ATP_Info;
5669: l_inv_item_id NUMBER;
5670: l_parent_line_id NUMBER; -- CTO Option Dependent Resources ODR
5671: l_routing_seq_id NUMBER; -- CTO Option Dependent Resources ODR
5672: l_routing_Type NUMBER;

Line 9125: l_comp_requirements MRP_ATP_PVT.Atp_Comp_Typ;

9121: -- Add new parameter with default value to support creation of
9122: -- Sales Orders for CTO components in a MATO case.
9123: )
9124: IS
9125: l_comp_requirements MRP_ATP_PVT.Atp_Comp_Typ;
9126: l_explode_comp MRP_ATP_PVT.Atp_Comp_Typ;
9127: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
9128: l_atp_qty_tab MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
9129: l_requested_date_quantity number;

Line 9126: l_explode_comp MRP_ATP_PVT.Atp_Comp_Typ;

9122: -- Sales Orders for CTO components in a MATO case.
9123: )
9124: IS
9125: l_comp_requirements MRP_ATP_PVT.Atp_Comp_Typ;
9126: l_explode_comp MRP_ATP_PVT.Atp_Comp_Typ;
9127: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
9128: l_atp_qty_tab MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
9129: l_requested_date_quantity number;
9130: l_resource_id number;

Line 9141: l_atp_rec MRP_ATP_PVT.AtpRec;

9137: l_next_period date;
9138: i PLS_INTEGER;
9139: j PLS_INTEGER;
9140: l_requested_comp_qty number;
9141: l_atp_rec MRP_ATP_PVT.AtpRec;
9142: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
9143: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
9144:
9145: l_comp_item_id number;

Line 9199: L_CTO_BOM_REC MRP_ATP_PVT.Atp_Comp_Typ;

9195: l_model_flag number :=2;
9196: L_PLAN_FOUND_FOR_MATCH number;
9197: L_MODEL_ATP_COMP_FLAG varchar2(1);
9198: L_MATCH_ITEM_ID number;
9199: L_CTO_BOM_REC MRP_ATP_PVT.Atp_Comp_Typ;
9200: l_lead_time number;
9201: L_REQUEST_DATE date;
9202: L_MAND_COMP_INFO_REC MSC_ATP_CTO.mand_comp_info_rec;
9203: l_atp_comp_rec MRP_ATP_PVT.ATP_COMP_REC;

Line 9203: l_atp_comp_rec MRP_ATP_PVT.ATP_COMP_REC;

9199: L_CTO_BOM_REC MRP_ATP_PVT.Atp_Comp_Typ;
9200: l_lead_time number;
9201: L_REQUEST_DATE date;
9202: L_MAND_COMP_INFO_REC MSC_ATP_CTO.mand_comp_info_rec;
9203: l_atp_comp_rec MRP_ATP_PVT.ATP_COMP_REC;
9204: l_null_atp_comp_rec MRP_ATP_PVT.ATP_COMP_REC;
9205: l_item_info_rec MSC_ATP_PVT.item_attribute_rec;
9206: l_model_error_code number := 0;
9207: --e_cto_rearch

Line 9204: l_null_atp_comp_rec MRP_ATP_PVT.ATP_COMP_REC;

9200: l_lead_time number;
9201: L_REQUEST_DATE date;
9202: L_MAND_COMP_INFO_REC MSC_ATP_CTO.mand_comp_info_rec;
9203: l_atp_comp_rec MRP_ATP_PVT.ATP_COMP_REC;
9204: l_null_atp_comp_rec MRP_ATP_PVT.ATP_COMP_REC;
9205: l_item_info_rec MSC_ATP_PVT.item_attribute_rec;
9206: l_model_error_code number := 0;
9207: --e_cto_rearch
9208:

Line 11174: l_atp_info MRP_ATP_PVT.ATP_Info;

11170: l_default_atp_rule_id NUMBER;
11171: l_calendar_code VARCHAR2(14);
11172: l_calendar_exception_set_id NUMBER;
11173: l_default_demand_class VARCHAR2(34);
11174: l_atp_info MRP_ATP_PVT.ATP_Info;
11175: l_cutoff_date DATE;
11176: l_capacity_defined NUMBER;
11177: l_pre_process_lt NUMBER;
11178: l_fix_var_lt NUMBER;

Line 13508: procedure Extend_Atp_Comp_Typ ( P_Atp_Comp_Typ IN OUT NOCOPY MRP_ATP_PVT.Atp_Comp_Typ)

13504: END Get_Transport_Cap_Atp_Info;
13505:
13506:
13507: --s_cto_rearch
13508: procedure Extend_Atp_Comp_Typ ( P_Atp_Comp_Typ IN OUT NOCOPY MRP_ATP_PVT.Atp_Comp_Typ)
13509: IS
13510: BEGIN
13511:
13512: P_Atp_Comp_Typ.inventory_item_id.extend;

Line 13551: Procedure Add_To_Comp_List(p_explode_comp_rec IN OUT NOCOPY MRP_ATP_PVT.Atp_Comp_Typ,

13547:
13548: END Extend_Atp_Comp_Typ;
13549:
13550:
13551: Procedure Add_To_Comp_List(p_explode_comp_rec IN OUT NOCOPY MRP_ATP_PVT.Atp_Comp_Typ,
13552: p_component_rec IN OUT NOCOPY MRP_ATP_PVT.Atp_Comp_Typ,
13553: p_atp_comp_rec IN MRP_ATP_PVT.ATP_COMP_REC)
13554:
13555: IS

Line 13552: p_component_rec IN OUT NOCOPY MRP_ATP_PVT.Atp_Comp_Typ,

13548: END Extend_Atp_Comp_Typ;
13549:
13550:
13551: Procedure Add_To_Comp_List(p_explode_comp_rec IN OUT NOCOPY MRP_ATP_PVT.Atp_Comp_Typ,
13552: p_component_rec IN OUT NOCOPY MRP_ATP_PVT.Atp_Comp_Typ,
13553: p_atp_comp_rec IN MRP_ATP_PVT.ATP_COMP_REC)
13554:
13555: IS
13556: j number;

Line 13553: p_atp_comp_rec IN MRP_ATP_PVT.ATP_COMP_REC)

13549:
13550:
13551: Procedure Add_To_Comp_List(p_explode_comp_rec IN OUT NOCOPY MRP_ATP_PVT.Atp_Comp_Typ,
13552: p_component_rec IN OUT NOCOPY MRP_ATP_PVT.Atp_Comp_Typ,
13553: p_atp_comp_rec IN MRP_ATP_PVT.ATP_COMP_REC)
13554:
13555: IS
13556: j number;
13557: BEGIN