[Home] [Help]
PACKAGE: APPS.MSC_ATP_PF
Source
1 PACKAGE MSC_ATP_PF AUTHID CURRENT_USER AS
2 /* $Header: MSCPFATS.pls 120.1 2007/12/12 10:35:44 sbnaik ship $ */
3
4 /* Types of consumption*/
5 Backward CONSTANT INTEGER := 1;
6 Forward CONSTANT INTEGER := 2;
7 Cum CONSTANT INTEGER := 3;
8 Bw_Fw_Cum CONSTANT INTEGER := 4;
9 Bw_Fw CONSTANT INTEGER := 5;
10
11 /* Profile setup*/
12 Demand_Priority CONSTANT INTEGER := 1;
13 User_Defined_DC CONSTANT INTEGER := 2;
14 User_Defined_CC CONSTANT INTEGER := 3;
15
16 MADT CONSTANT NUMBER := 1;
17 MASDDT CONSTANT NUMBER := 2;
18
19 TYPE Bucketed_Demands_Rec is RECORD (
20 mem_item_id NUMBER,
21 mem_bd_date DATE,
22 mem_bd_qty NUMBER,
23 mem_display_flag NUMBER,
24 pf_item_id NUMBER,
25 pf_bd_date DATE,
26 pf_bd_qty NUMBER,
27 pf_display_flag NUMBER,
28 insert_mem_bd VARCHAR2(1),
29 insert_pf_bd VARCHAR2(1)
30 );
31
32 PROCEDURE Add_PF_Bucketed_Demands(
33 p_atp_rec IN MRP_ATP_PVT.AtpRec,
34 p_plan_id IN NUMBER,
35 p_parent_demand_id IN NUMBER,
36 p_refresh_number IN NUMBER,
37 x_return_status OUT NOCOPY VARCHAR2
38 );
39
40 PROCEDURE Update_PF_Bucketed_Demands(
41 p_plan_id IN NUMBER,
42 p_parent_demand_id IN NUMBER,
43 p_demand_date IN DATE,
44 p_atf_date IN DATE,
45 p_old_demand_date_qty IN NUMBER,
46 p_new_demand_date_qty IN NUMBER,
47 x_return_status OUT NOCOPY VARCHAR2
48 );
49
50 PROCEDURE Increment_Bucketed_Demands_Qty(
51 p_atp_rec IN OUT NOCOPY MRP_ATP_PVT.AtpRec,
52 p_plan_id IN NUMBER,
53 p_parent_demand_id IN NUMBER,
54 x_return_status OUT NOCOPY VARCHAR2
55 );
56
57 PROCEDURE Move_PF_Bucketed_Demands(
58 p_plan_id IN NUMBER,
59 p_parent_demand_id IN NUMBER,
60 p_old_demand_date IN DATE,
61 p_new_demand_date IN DATE,
62 p_demand_qty IN NUMBER,
63 p_new_demand_date_qty IN NUMBER,
64 p_atf_date IN DATE,
65 p_atf_date_qty IN NUMBER,
66 x_return_status OUT NOCOPY VARCHAR2,
67 p_bkwd_pass_atf_date_qty IN NUMBER, --bug3397904
68 p_atp_rec IN MRP_ATP_PVT.AtpRec := NULL
69 );
70
71 PROCEDURE Find_PF_Bucketed_Demands(
72 p_plan_id IN NUMBER,
73 p_parent_demand_id IN NUMBER,
74 p_bucketed_demands_rec IN OUT NOCOPY MSC_ATP_PF.Bucketed_Demands_Rec,
75 x_return_status OUT NOCOPY VARCHAR2
76 );
77
78 PROCEDURE Add_PF_Rollup_Supplies(
79 p_plan_id IN NUMBER,
80 p_member_item_id IN NUMBER,
81 p_family_item_id IN NUMBER,
82 p_organization_id IN NUMBER,
83 p_instance_id IN NUMBER,
84 p_demand_class IN VARCHAR2,
85 p_schedule_date IN DATE,
86 p_orig_order_type IN NUMBER,
87 p_order_quantity IN NUMBER,
88 p_parent_transaction_id IN NUMBER,
89 p_atf_date IN DATE,
90 p_refresh_number IN NUMBER,
91 x_return_status OUT NOCOPY VARCHAR2
92 );
93
94 PROCEDURE Update_PF_Rollup_Supplies(
95 p_plan_id IN NUMBER,
96 p_parent_transaction_id IN NUMBER,
97 p_mem_item_id IN NUMBER,
98 p_pf_item_id IN NUMBER,
99 p_date IN DATE,
100 p_quantity IN NUMBER,
101 p_atf_date IN DATE,
102 x_return_status OUT NOCOPY VARCHAR2
103 );
104
105 PROCEDURE Add_PF_Stealing_Supply_Details (
106 p_plan_id IN NUMBER,
107 p_identifier IN NUMBER,
108 p_mem_item_id IN NUMBER,
109 p_pf_item_id IN NUMBER,
110 p_organization_id IN NUMBER,
111 p_sr_instance_id IN NUMBER,
112 p_mem_stealing_quantity IN NUMBER,
113 p_pf_stealing_quantity IN NUMBER,
114 p_stealing_demand_class IN VARCHAR2,
115 p_stolen_demand_class IN VARCHAR2,
116 p_ship_date IN DATE,
117 p_atf_date IN DATE,
118 p_refresh_number IN NUMBER, -- for summary enhancement
119 p_transaction_id OUT NOCOPY NUMBER,
120 p_ato_model_line_id IN NUMBER,
121 p_demand_source_type IN NUMBER,--cmro
122 --bug3684383
123 p_order_number IN NUMBER,
124 x_return_status OUT NOCOPY VARCHAR2
125 );
126
127 PROCEDURE Get_Mat_Avail_Pf(
128 p_summary_flag IN VARCHAR2,
129 p_item_id IN NUMBER,
130 p_request_item_id IN NUMBER,
131 p_org_id IN NUMBER,
132 p_instance_id IN NUMBER,
133 p_plan_id IN NUMBER,
134 p_cal_code IN VARCHAR2,
135 p_sysdate_seq_num IN NUMBER,
136 p_sys_next_date IN DATE,
137 p_demand_class IN VARCHAR2,
138 p_default_atp_rule_id IN NUMBER,
139 p_default_dmd_class IN VARCHAR2,
140 p_itf IN DATE,
141 p_refresh_number IN NUMBER,
142 x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
143 x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
144 x_return_status OUT NOCOPY VARCHAR2
145 );
146
147 PROCEDURE Get_Mat_Avail_Pf_Dtls (
148 p_item_id IN NUMBER,
149 p_request_item_id IN NUMBER,
150 p_org_id IN NUMBER,
151 p_instance_id IN NUMBER,
152 p_plan_id IN NUMBER,
153 p_cal_code IN VARCHAR2,
154 p_sysdate_seq_num IN NUMBER,
155 p_sys_next_date IN DATE,
156 p_demand_class IN VARCHAR2,
157 p_default_atp_rule_id IN NUMBER,
158 p_default_dmd_class IN VARCHAR2,
159 p_itf IN DATE,
160 p_level IN NUMBER,
161 p_scenario_id IN NUMBER,
162 p_identifier IN NUMBER,
163 x_return_status OUT NOCOPY VARCHAR2
164 );
165
166 PROCEDURE Set_Alloc_Rule_Variables (
167 p_member_id IN NUMBER,
168 p_family_id IN NUMBER,
169 p_org_id IN NUMBER,
170 p_instance_id IN NUMBER,
171 p_demand_class IN VARCHAR2,
172 p_atf_date IN DATE,
173 x_return_status OUT NOCOPY VARCHAR2
174 );
175
176 PROCEDURE Item_Alloc_Avail_Pf (
177 p_member_id IN NUMBER,
178 p_family_id IN NUMBER,
179 p_org_id IN NUMBER,
180 p_instance_id IN NUMBER,
181 p_plan_id IN NUMBER,
182 p_demand_class IN VARCHAR2,
183 p_level_id IN NUMBER,
184 p_itf IN DATE,
185 p_sys_next_date IN DATE, --bug3099066
186 p_atf_date IN DATE,
187 x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
188 x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
189 x_return_status OUT NOCOPY VARCHAR2
190 );
191
192 PROCEDURE Item_Alloc_Avail_Pf_Unalloc (
193 p_member_id IN NUMBER,
194 p_family_id IN NUMBER,
195 p_org_id IN NUMBER,
196 p_instance_id IN NUMBER,
197 p_plan_id IN NUMBER,
198 p_demand_class IN VARCHAR2,
199 p_level_id IN NUMBER,
200 p_itf IN DATE,
201 p_sys_next_date IN DATE, --bug3099066
202 p_atf_date IN DATE,
203 x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
204 x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
205 x_atp_unalloc_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
206 x_return_status OUT NOCOPY VARCHAR2
207 );
208
209 PROCEDURE Item_Alloc_Avail_Pf_Dtls (
210 p_member_id IN NUMBER,
211 p_family_id IN NUMBER,
212 p_sr_member_id IN NUMBER,
213 p_sr_family_id IN NUMBER,
214 p_org_id IN NUMBER,
215 p_instance_id IN NUMBER,
216 p_plan_id IN NUMBER,
217 p_demand_class IN VARCHAR2,
218 p_level_id IN NUMBER,
219 p_itf IN DATE,
220 p_level IN NUMBER,
221 p_identifier IN NUMBER,
222 p_scenario_id IN NUMBER,
223 p_uom_code IN VARCHAR2,
224 p_sys_next_date IN DATE, --bug3099066
225 p_atf_date IN DATE,
226 x_return_status OUT NOCOPY VARCHAR2
227 );
228
229 PROCEDURE Item_Prealloc_Avail_Pf (
230 p_member_id IN NUMBER,
231 p_family_id IN NUMBER,
232 p_org_id IN NUMBER,
233 p_instance_id IN NUMBER,
234 p_plan_id IN NUMBER,
235 p_demand_class IN VARCHAR2,
236 p_itf IN DATE,
237 x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
238 x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
239 x_return_status OUT NOCOPY VARCHAR2
240 );
241
242 PROCEDURE Item_Prealloc_Avail_Pf_Summ (
243 p_member_id IN NUMBER,
244 p_family_id IN NUMBER,
245 p_org_id IN NUMBER,
246 p_instance_id IN NUMBER,
247 p_plan_id IN NUMBER,
248 p_demand_class IN VARCHAR2,
249 p_itf IN DATE,
250 p_refresh_number IN NUMBER,
251 x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
252 x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
253 x_return_status OUT NOCOPY VARCHAR2
254 );
255
256 PROCEDURE Item_Prealloc_Avail_Pf_Dtls (
257 p_member_id IN NUMBER,
258 p_family_id IN NUMBER,
259 p_sr_member_id IN NUMBER,
260 p_sr_family_id IN NUMBER,
261 p_org_id IN NUMBER,
262 p_instance_id IN NUMBER,
263 p_plan_id IN NUMBER,
264 p_demand_class IN VARCHAR2,
265 p_itf IN DATE,
266 p_atf_date IN DATE,
267 p_level IN NUMBER,
268 p_identifier IN NUMBER,
269 p_scenario_id IN NUMBER,
270 p_uom_code IN VARCHAR2,
271 x_return_status OUT NOCOPY VARCHAR2
272 );
273
274 PROCEDURE Get_Forward_Mat_Pf (
275 p_member_id IN NUMBER,
276 p_family_id IN NUMBER,
277 p_org_id IN NUMBER,
278 p_instance_id IN NUMBER,
279 p_plan_id IN NUMBER,
280 p_itf IN DATE,
281 x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
282 x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
283 x_atp_dcs OUT NOCOPY MRP_ATP_PUB.char80_arr,
284 x_return_status OUT NOCOPY VARCHAR2
285 );
286
287 PROCEDURE Get_Forward_Mat_Pf_Summ (
288 p_member_id IN NUMBER,
289 p_family_id IN NUMBER,
290 p_org_id IN NUMBER,
291 p_instance_id IN NUMBER,
292 p_plan_id IN NUMBER,
293 p_itf IN DATE,
294 p_refresh_number IN NUMBER,
295 x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
296 x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
297 x_atp_dcs OUT NOCOPY MRP_ATP_PUB.char80_arr,
298 x_return_status OUT NOCOPY VARCHAR2
299 );
300
301 PROCEDURE Insert_SD_Into_Details_Temp (
302 p_type IN INTEGER,
303 p_member_id IN NUMBER,
304 p_family_id IN NUMBER,
305 p_sr_member_id IN NUMBER,
306 p_sr_family_id IN NUMBER,
307 p_org_id IN NUMBER,
308 --bug3671294 now we donot need this as we will join with msc_system_items
309 --p_inv_item_name IN VARCHAR2,
310 p_org_code IN VARCHAR2,
311 p_instance_id IN NUMBER,
312 p_plan_id IN NUMBER,
313 p_itf IN DATE,
314 p_level_id IN PLS_INTEGER,
315 p_session_id IN NUMBER,
316 p_record_type IN PLS_INTEGER,
317 p_scenario_id IN NUMBER,
318 p_uom_code IN VARCHAR2,
319 x_insert_count OUT NOCOPY NUMBER,
320 x_return_status OUT NOCOPY VARCHAR2
321 );
322
323 PROCEDURE Populate_Original_Demand_Qty(
324 p_table IN NUMBER,
325 p_session_id IN NUMBER,
326 p_plan_id IN NUMBER,
327 p_demand_class IN VARCHAR2,
328 x_return_status OUT NOCOPY VARCHAR2
329 );
330
331 PROCEDURE PF_Atp_Consume(
332 p_atp_qty IN OUT NOCOPY MRP_ATP_PUB.number_arr,
333 x_return_status OUT NOCOPY VARCHAR2,
334 p_atp_period IN MRP_ATP_PUB.date_arr :=NULL,
335 p_consumption_type IN NUMBER := Bw_Fw_Cum,
336 p_atf_date IN DATE := NULL
337 );
338
339 PROCEDURE PF_Atp_Alloc_Consume(
340 p_atp_qty IN OUT NOCOPY MRP_ATP_PUB.number_arr,
341 p_atp_period IN MRP_ATP_PUB.date_arr,
342 p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,
343 p_atf_date IN DATE,
344 x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
345 x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
346 x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
347 x_return_status OUT NOCOPY VARCHAR2
348 );
349
350 PROCEDURE Get_Period_Data_From_Sd_Temp(
351 x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
352 x_return_status OUT NOCOPY VARCHAR2
353 );
354
355 PROCEDURE Get_Unalloc_Data_From_Sd_Temp(
356 x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
357 p_unallocated_atp IN OUT NOCOPY MRP_ATP_PVT.ATP_Info,
358 x_return_status OUT NOCOPY VARCHAR2
359 );
360
361 PROCEDURE Get_Period_From_Details_Temp(
362 p_type IN INTEGER,
363 p_inv_item_id IN NUMBER,
364 p_org_id IN NUMBER,
365 p_instance_id IN NUMBER,
366 p_scenario_id IN NUMBER,
367 p_level_id IN NUMBER,
368 p_record_type IN PLS_INTEGER,
369 p_session_id IN NUMBER,
370 x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
371 x_return_status OUT NOCOPY VARCHAR2
372 );
373
374 FUNCTION Get_Pf_Atp_Item_Id(
375 p_instance_id IN NUMBER,
376 p_plan_id IN NUMBER,
377 p_inventory_item_id IN NUMBER,
378 p_organization_id IN NUMBER
379 )
380 RETURN NUMBER;
381
382 FUNCTION Get_Atf_Date(
383 p_instance_id IN NUMBER,
384 p_inventory_item_id IN NUMBER,
385 p_organization_id IN NUMBER,
386 p_plan_id IN NUMBER
387 )
388 RETURN DATE;
389
390 FUNCTION Get_Atf_Days(
391 p_instance_id IN NUMBER,
392 p_inventory_item_id IN NUMBER,
393 p_organization_id IN NUMBER
394 )
395 RETURN NUMBER;
396
397 PROCEDURE Get_Family_Item_Info(
398 p_instance_id IN NUMBER,
399 p_plan_id IN NUMBER,
400 p_inventory_item_id IN NUMBER,
401 p_organization_id IN NUMBER,
402 p_family_id OUT NOCOPY NUMBER,
403 p_sr_family_id OUT NOCOPY NUMBER,
404 p_atf_date OUT NOCOPY DATE,
405 --bug3700564
406 p_family_name OUT NOCOPY VARCHAR2,
407 x_return_status OUT NOCOPY VARCHAR2
408 );
409
410 PROCEDURE Get_PF_Plan_Info(
411 p_instance_id IN NUMBER,
412 p_member_item_id IN NUMBER,
413 p_family_item_id IN NUMBER,
414 p_org_id IN NUMBER,
415 p_demand_class IN VARCHAR2,
416 p_atf_date OUT NOCOPY DATE,
417 p_error_code OUT NOCOPY NUMBER,
418 x_return_status OUT NOCOPY VARCHAR2,
419 p_parent_plan_id IN NUMBER DEFAULT NULL --bug3510475
420 );
421
422 PROCEDURE Populate_ATF_Dates(
423 p_plan_id IN NUMBER,
424 x_member_count OUT NOCOPY NUMBER,
425 x_return_status OUT NOCOPY VARCHAR2
426 );
427
428 PROCEDURE Pf_Post_Plan_Proc(
429 ERRBUF OUT NOCOPY VARCHAR2,
430 RETCODE OUT NOCOPY NUMBER,
431 p_plan_id IN NUMBER,
432 p_demand_priority IN VARCHAR2
433 );
434 --CTO-PF start
435 PROCEDURE Create_PF_Allocation_Reliefs (
436 p_plan_id IN NUMBER,
437 p_insert_table IN VARCHAR2,
438 p_user_id IN NUMBER,
439 p_sysdate IN DATE,
440 x_return_status OUT NOCOPY VARCHAR2
441 );
442
443 PROCEDURE Create_PF_DP_Alloc_Reliefs (
444 p_plan_id IN NUMBER,
445 p_insert_table IN VARCHAR2,
446 p_user_id IN NUMBER,
447 p_sysdate IN DATE,
448 x_return_status OUT NOCOPY VARCHAR2
449 );
450 --CTO-PF end
451 END MSC_ATP_PF;