99:
100: --5216528/5216528 Start This record will out teh values from check_subs
101: --5081149 Initializing the collections
102: TYPE get_subs_out_rec IS RECORD(
103: pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
104: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
105: sub_atp_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
106: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
107: pf_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(), --5283809
100: --5216528/5216528 Start This record will out teh values from check_subs
101: --5081149 Initializing the collections
102: TYPE get_subs_out_rec IS RECORD(
103: pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
104: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
105: sub_atp_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
106: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
107: pf_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(), --5283809
108: atf_date_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
101: --5081149 Initializing the collections
102: TYPE get_subs_out_rec IS RECORD(
103: pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
104: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
105: sub_atp_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
106: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
107: pf_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(), --5283809
108: atf_date_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
109: quantity_ordered MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
102: TYPE get_subs_out_rec IS RECORD(
103: pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
104: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
105: sub_atp_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
106: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
107: pf_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(), --5283809
108: atf_date_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
109: quantity_ordered MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
110: );
103: pegging_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
104: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
105: sub_atp_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
106: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
107: pf_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(), --5283809
108: atf_date_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
109: quantity_ordered MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
110: );
111: --5216528/5216528 End
104: inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
105: sub_atp_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
106: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
107: pf_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(), --5283809
108: atf_date_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
109: quantity_ordered MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
110: );
111: --5216528/5216528 End
112: PROCEDURE Check_Substitutes(
105: sub_atp_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
106: demand_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
107: pf_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(), --5283809
108: atf_date_quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
109: quantity_ordered MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
110: );
111: --5216528/5216528 End
112: PROCEDURE Check_Substitutes(
113: p_atp_record IN OUT NoCopy MRP_ATP_PVT.AtpRec,
120: p_inventory_item_id IN NUMBER,
121: p_organization_id IN NUMBER,
122: p_quantity IN NUMBER,
123: l_net_demand IN OUT NoCopy NUMBER,
124: l_supply_demand IN OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
125: l_atp_period IN OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
126: l_substitutes_rec OUT NoCopy MSC_ATP_REQ.get_subs_out_rec, --5216528/5216528
127: l_return_status OUT NoCopy varchar2,
128: p_refresh_number IN NUMBER -- For summary enhancement
121: p_organization_id IN NUMBER,
122: p_quantity IN NUMBER,
123: l_net_demand IN OUT NoCopy NUMBER,
124: l_supply_demand IN OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
125: l_atp_period IN OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
126: l_substitutes_rec OUT NoCopy MSC_ATP_REQ.get_subs_out_rec, --5216528/5216528
127: l_return_status OUT NoCopy varchar2,
128: p_refresh_number IN NUMBER -- For summary enhancement
129: );
132: /* time_phased_atp
133: Grouped various input parameters to this procedure in a new record Atp_Info_Rec*/
134: PROCEDURE Get_Material_Atp_Info (
135: p_mat_atp_info_rec IN OUT NOCOPY Atp_Info_Rec,
136: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
137: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
138: x_return_status OUT NoCopy VARCHAR2
139: );
140:
133: Grouped various input parameters to this procedure in a new record Atp_Info_Rec*/
134: PROCEDURE Get_Material_Atp_Info (
135: p_mat_atp_info_rec IN OUT NOCOPY Atp_Info_Rec,
136: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
137: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
138: x_return_status OUT NoCopy VARCHAR2
139: );
140:
141:
149: p_inventory_item_id IN NUMBER,
150: p_organization_id IN NUMBER,
151: p_demand_class IN VARCHAR2,
152: p_insert_flag IN NUMBER,
153: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
154: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
155: x_return_status OUT NoCopy VARCHAR2,
156: p_get_mat_in_rec IN MSC_ATP_REQ.get_mat_in_rec,
157: p_atf_date IN DATE -- For time_phased_atp
150: p_organization_id IN NUMBER,
151: p_demand_class IN VARCHAR2,
152: p_insert_flag IN NUMBER,
153: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
154: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
155: x_return_status OUT NoCopy VARCHAR2,
156: p_get_mat_in_rec IN MSC_ATP_REQ.get_mat_in_rec,
157: p_atf_date IN DATE -- For time_phased_atp
158: );
178: p_parent_ship_date IN DATE, -- Bug 2814872 Cut-off Date for Resource Check
179: p_line_identifier IN NUMBER, -- CTO ODR Identifies the line being processed.
180: x_avail_assembly_qty OUT NoCopy NUMBER,
181: x_atp_date OUT NoCopy DATE,
182: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
183: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
184: x_return_status OUT NoCopy VARCHAR2
185: );
186:
179: p_line_identifier IN NUMBER, -- CTO ODR Identifies the line being processed.
180: x_avail_assembly_qty OUT NoCopy NUMBER,
181: x_atp_date OUT NoCopy DATE,
182: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
183: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
184: x_return_status OUT NoCopy VARCHAR2
185: );
186:
187: PROCEDURE Get_Comp_Requirements (
206: p_atf_date IN DATE, -- For time_phased_atp
207: p_manufacturing_cal_code IN VARCHAR2, -- For ship_rec_cal
208: x_avail_assembly_qty OUT NoCopy NUMBER,
209: x_atp_date OUT NoCopy DATE,
210: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
211: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
212: x_return_status OUT NoCopy VARCHAR2,
213: p_comp_info_rec IN OUT NOCOPY MSC_ATP_REQ.get_comp_info_rec,
214: p_order_number IN NUMBER := NULL,
207: p_manufacturing_cal_code IN VARCHAR2, -- For ship_rec_cal
208: x_avail_assembly_qty OUT NoCopy NUMBER,
209: x_atp_date OUT NoCopy DATE,
210: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
211: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
212: x_return_status OUT NoCopy VARCHAR2,
213: p_comp_info_rec IN OUT NOCOPY MSC_ATP_REQ.get_comp_info_rec,
214: p_order_number IN NUMBER := NULL,
215: p_op_seq_id IN NUMBER --4570421
219:
220:
221: PROCEDURE Get_Supplier_Atp_Info (
222: p_sup_atp_info_rec IN OUT NOCOPY MSC_ATP_REQ.Atp_Info_Rec,
223: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
224: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
225: x_return_status OUT NOCOPY VARCHAR2
226: );
227:
220:
221: PROCEDURE Get_Supplier_Atp_Info (
222: p_sup_atp_info_rec IN OUT NOCOPY MSC_ATP_REQ.Atp_Info_Rec,
223: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
224: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
225: x_return_status OUT NOCOPY VARCHAR2
226: );
227:
228:
243: p_parent_pegging_id IN NUMBER,
244: x_requested_date_quantity OUT NoCopy NUMBER,
245: x_atp_date_this_level OUT NoCopy DATE,
246: x_atp_date_quantity_this_level OUT NoCopy NUMBER,
247: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
248: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
249: x_return_status OUT NoCopy VARCHAR2
250: );
251:
244: x_requested_date_quantity OUT NoCopy NUMBER,
245: x_atp_date_this_level OUT NoCopy DATE,
246: x_atp_date_quantity_this_level OUT NoCopy NUMBER,
247: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
248: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
249: x_return_status OUT NoCopy VARCHAR2
250: );
251:
252: --supplier_capacity changes