[Home] [Help]
PACKAGE: APPS.MSC_ATP_REQ
Source
1 PACKAGE MSC_ATP_REQ AS
2 /* $Header: MSCRATPS.pls 120.5 2007/12/12 10:39:02 sbnaik ship $ */
3
4 TYPE get_mat_in_rec IS RECORD(
5 rounding_control_flag number,
6 dest_inv_item_id number,
7 infinite_time_fence_date date,
8 plan_name varchar2(10),
9 optimized_plan number, -- 2859130
10 parent_bom_item_type number,
11 bom_item_type number,
12 replenish_to_ord_flag varchar2(1),
13 parent_repl_order_flag varchar2(1),
14 ato_model_line_id number,
15 shipping_cal_code VARCHAR2(14), -- Bug 3371817
16 sys_next_osc_date date, --bug3333114
17 receiving_cal_code VARCHAR2(14), -- Bug 3826234
18 intransit_cal_code VARCHAR2(14), -- Bug 3826234
19 manufacturing_cal_code VARCHAR2(14), -- Bug 3826234
20 to_organization_id NUMBER, -- Bug 3826234
21 organization_id NUMBER -- Bug 3826234
22 );
23
24 TYPE get_mat_out_rec IS RECORD(
25 atp_rule_name varchar2(80),
26 infinite_time_fence_date date,
27 demand_pegging_id number,
28 --3432341
29 demand_id number);
30
31 TYPE GET_COMP_INFO_REC IS RECORD(
32 line_id number,
33 bom_item_type number,
34 atp_flag varchar2(1),
35 atp_comp_flag varchar2(1),
36 fixed_lt number,
37 variable_lt number,
38 replenish_to_order_flag varchar2(1),
39 TOP_MODEL_LINE_ID number,
40 ATO_MODEL_LINE_ID number,
41 ATO_PARENT_MODEL_LINE_ID number,
42 PARENT_LINE_ID number,
43 parent_so_quantity number,
44 check_model_capacity_flag number,
45 model_sr_inv_item_id number,
46 --bug3059305
47 ship_date_this_level date
48 );
49
50 -- New record Atp_Info_Rec defined for time_phased_atp and ship_rec_cal
51 TYPE Atp_Info_Rec is RECORD (
52 instance_id NUMBER,
53 plan_id NUMBER,
54 level NUMBER,
55 identifier NUMBER,
56 scenario_id NUMBER,
57 inventory_item_id NUMBER,
58 request_item_id NUMBER,
59 organization_id NUMBER,
60 supplier_id NUMBER,
61 supplier_site_id NUMBER,
62 requested_date DATE,
63 atf_date DATE,
64 quantity_ordered NUMBER,
65 demand_class VARCHAR2(200),
66 insert_flag NUMBER,
67 substitution_window NUMBER,
68 requested_date_quantity NUMBER,
69 atf_date_quantity NUMBER,
70 atp_date_this_level DATE,
71 atp_date_quantity_this_level NUMBER,
72 rounding_control_flag NUMBER,
73 dest_inv_item_id NUMBER,
74 infinite_time_fence_date DATE,
75 plan_name VARCHAR2(10),
76 optimized_plan NUMBER,
77 atp_rule_name VARCHAR2(80),
78 shipping_cal_code VARCHAR2(30),
79 receiving_cal_code VARCHAR2(30),
80 manufacturing_cal_code VARCHAR2(30),
81 intransit_cal_code VARCHAR2(30),
82 refresh_number NUMBER, -- For summary enhancement
83 sup_cap_cum_date DATE, -- SCLT Accumulation starts from this date
84 sysdate_seq_num NUMBER, -- For ship_rec_cal
85 sup_cap_type NUMBER, -- For ship_rec_cal, value =1 means ship, 2 means dock
86 base_item_id NUMBER, -- For CTO rearch
87 bom_item_type NUMBER, -- For CTO rearch
88 rep_ord_flag VARCHAR2(1), -- For CTO rearch
89 last_cap_date DATE, -- Enforce Pur LT
90 --4570421
91 scaling_type number,
92 scale_multiple number,
93 scale_rounding_variance number,
94 rounding_direction number,
95 component_yield_factor number, --4570421
96 usage_qty NUMBER, --4775920
97 organization_type NUMBER --4775920
98 );
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
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,
114 p_parent_pegging_id IN NUMBER,
115 p_instance_id IN NUMBER,
116 p_scenario_id IN NUMBER,
117 p_level IN NUMBER,
118 p_search IN NUMBER,
119 p_plan_id IN NUMBER,
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
129 );
130
131
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
141
142 PROCEDURE Insert_Details (
143 p_instance_id IN NUMBER,
144 p_plan_id IN NUMBER,
145 p_level IN NUMBER,
146 p_identifier IN NUMBER,
147 p_scenario_id IN NUMBER,
148 p_request_item_id IN NUMBER,
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
158 );
159
160
161 PROCEDURE Get_Res_Requirements (
162 p_instance_id IN NUMBER,
163 p_plan_id IN NUMBER,
164 p_level IN NUMBER,
165 p_scenario_id IN NUMBER,
166 p_inventory_item_id IN NUMBER,
167 p_organization_id IN NUMBER,
168 p_parent_pegging_id IN NUMBER,
169 p_requested_quantity IN NUMBER,
170 p_requested_date IN DATE,
171 p_refresh_number IN NUMBER,
172 p_insert_flag IN NUMBER,
173 p_search IN NUMBER,
174 p_demand_class IN VARCHAR2,
175 --(ssurendr) Bug 2865389 Added Routing Sequence id and bill sequence id for OPM issue
176 p_routing_seq_id IN NUMBER,
177 p_bill_seq_id IN NUMBER,
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
187 PROCEDURE Get_Comp_Requirements (
188 p_instance_id IN NUMBER,
189 p_plan_id IN NUMBER,
190 p_level IN NUMBER,
191 p_scenario_id IN NUMBER,
192 p_inventory_item_id IN NUMBER,
193 p_organization_id IN NUMBER,
194 p_parent_pegging_id IN NUMBER,
195 p_demand_class IN VARCHAR2,
196 p_requested_quantity IN NUMBER,
197 p_requested_date IN DATE,
198 p_refresh_number IN NUMBER,
199 p_insert_flag IN NUMBER,
200 p_search IN NUMBER,
201 p_assign_set_id IN NUMBER,
202 --(ssurendr) Bug 2865389 Added Routing Sequence id and bill sequence id for OPM issue
203 p_routing_seq_id IN NUMBER, --Bug2745055
204 p_bill_seq_id IN NUMBER,
205 p_family_id IN NUMBER, -- For time_phased_atp
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,
215 p_op_seq_id IN NUMBER --4570421
216 -- Add new parameter with default value to support creation of
217 -- Sales Orders for CTO components in a MATO case.
218 );
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
228
229 PROCEDURE Get_Transport_Cap_Atp_Info (
230 p_plan_id IN NUMBER,
231 p_from_organization_id IN NUMBER,
232 p_to_organization_id IN NUMBER,
233 p_ship_method IN VARCHAR2,
234 p_inventory_item_id IN NUMBER,
235 p_source_org_instance_id IN NUMBER,
236 p_dest_org_instance_id IN NUMBER,
237 p_requested_date IN DATE,
238 p_quantity_ordered IN NUMBER,
239 p_insert_flag IN NUMBER,
240 p_level IN NUMBER,
241 p_scenario_id IN NUMBER,
242 p_identifier IN NUMBER,
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
252 --supplier_capacity changes
253 G_PURCHASE_ORDER_PREFERENCE NUMBER;
254 G_PROMISE_DATE CONSTANT NUMBER := 1;
255
256
257 --s_cto_rearch
258 procedure Extend_Atp_Comp_Typ ( P_Atp_Comp_Typ IN OUT NOCOPY MRP_ATP_PVT.Atp_Comp_Typ);
259
260 Procedure Add_To_Comp_List(p_explode_comp_rec IN OUT NOCOPY MRP_ATP_PVT.Atp_Comp_Typ,
261 p_component_rec IN OUT NOCOPY MRP_ATP_PVT.Atp_Comp_Typ,
262 p_atp_comp_rec IN MRP_ATP_PVT.ATP_COMP_REC);
263
264 --e_cto_rearch
265
266
267 END MSC_ATP_REQ;