1 PACKAGE MSC_Rel_Plan_PUB AUTHID CURRENT_USER AS
2 /* $Header: MSCPRELS.pls 120.11 2011/05/12 11:02:27 lsindhur ship $ */
3
4 -- Start of Comments
5 -- API name MSC_Release_Plan_Sc
6 -- Type Public
7 -- Procedure
8 --
9 -- Pre-reqs
10 --
11 -- Parameters
12 --
13 -- Version Current version = 1.0
14 -- Initial version = 1.0
15 --
16 -- Notes
17 --
18 -- End of Comments
19
20 -- New Data Type
21
22 TYPE NumTblTyp IS TABLE OF NUMBER;
23
24 -- CONSTANTS --
25 SYS_YES CONSTANT INTEGER := 1;
26 SYS_NO CONSTANT INTEGER := 2;
27
28 RELEASE_ATTEMPTED CONSTANT NUMBER := 1;
29 NOT_RELEASABLE CONSTANT NUMBER := -1;
30 RELEASABLE CONSTANT NUMBER := 0;
31
32 REQ_GRP_ALL_ON_ONE CONSTANT INTEGER := 1; -- PO group by
33 REQ_GRP_ITEM CONSTANT INTEGER := 2;
34 REQ_GRP_BUYER CONSTANT INTEGER := 3;
35 REQ_GRP_PLANNER CONSTANT INTEGER := 4;
36 REQ_GRP_VENDOR CONSTANT INTEGER := 5;
37 REQ_GRP_ONE_EACH CONSTANT INTEGER := 6;
38 REQ_GRP_CATEGORY CONSTANT INTEGER := 7;
39 REQ_GRP_LOCATION CONSTANT INTEGER := 8;
40
41 WIP_DIS_MASS_LOAD CONSTANT INTEGER := 1;
42 WIP_REP_MASS_LOAD CONSTANT INTEGER := 2;
43 WIP_DIS_MASS_RESCHEDULE CONSTANT INTEGER := 4;
44 PO_MASS_LOAD CONSTANT INTEGER := 8;
45 PO_MASS_RESCHEDULE CONSTANT INTEGER := 16;
46
47 DRP_REQ_LOAD constant integer := 32; -- drp release
48 DRP_REQ_RESCHED constant integer := 64; -- drp release
49
50 ERO_LOAD CONSTANT NUMBER := 128;
51 IRO_LOAD CONSTANT NUMBER := 256;
52
53 /*USAF*/
54 CMRO_EAM_MASS_LOAD CONSTANT INTEGER := 257;
55 CMRO_EAM_RESCHED CONSTANT INTEGER := 258;
56
57 PURCHASE_ORDER CONSTANT INTEGER := 1; -- order type lookup
58 PURCH_REQ CONSTANT INTEGER := 2;
59 WORK_ORDER CONSTANT INTEGER := 3;
60 REPETITVE_SCHEDULE CONSTANT INTEGER := 4;
61 PLANNED_ORDER CONSTANT INTEGER := 5;
62 MATERIAL_TRANSFER CONSTANT INTEGER := 6;
63 NONSTD_JOB CONSTANT INTEGER := 7;
64 RECEIPT_PURCH_ORDER CONSTANT INTEGER := 8;
65 REQUIREMENT CONSTANT INTEGER := 9;
66 FPO_SUPPLY CONSTANT INTEGER := 10;
67
68 NOT_UNDER_REV_CONTROL CONSTANT INTEGER := 1;
69 UNDER_REV_CONTROL CONSTANT INTEGER := 2;
70
71 PURCHASING_BY_REV CONSTANT INTEGER := 1;
72 NOT_PURCHASING_BY_REV CONSTANT INTEGER := 2;
73 PLANNED_REP_WO CONSTANT INTEGER := 79;
74 RESCHEDULE_EAM_CMRO CONSTANT INTEGER := 70;
75
76
77
78 LT_RESOURCE CONSTANT INTEGER := 1; -- wip details load type
79 LT_COMPONENT CONSTANT INTEGER := 2;
80 LT_OPERATION CONSTANT INTEGER := 3;
81 LT_RESOURCE_USAGE CONSTANT INTEGER := 4;
82 LT_SUB_COMPONENT CONSTANT INTEGER := 5;
83
84 SUBST_DELETE CONSTANT INTEGER := 1; -- wip details substitution
85 SUBST_ADD CONSTANT INTEGER := 2; -- type
86 SUBST_CHANGE CONSTANT INTEGER := 3;
87
88 -- Variables --
89 v_hour_uom VARCHAR2(4);
90 v_purchasing_by_rev NUMBER;
91 v_instance_code_length NUMBER;
92
93 g_batch_id NUMBER := -1;
94 g_prev_batch_id NUMBER := g_batch_id;
95 G_SPP_SPLIT_YN VARCHAR2(1) := NVL(FND_PROFILE.VALUE('MSO_ENABLE_ROUNDING_OF_FRACTIONAL_SUPPLIES_FOR_SRP'),'N');
96
97 -- Procedures --
98
99 /*Procedure MSC_RELEASE_PLAN_SC has been overloaded since this will be called
100 differently by ASCP engine and RP engine
101 The procedure called by ASCP currently has 6 new parameters for the USAF project
102
103 We are retaining the old signature for RP engine */
104
105
106 PROCEDURE MSC_RELEASE_PLAN_SC
107 ( arg_plan_id IN NUMBER
108 , arg_log_org_id IN NUMBER
109 , arg_log_sr_instance IN NUMBER
110 , arg_org_id IN NUMBER
111 , arg_sr_instance IN NUMBER
112 , arg_compile_desig IN VARCHAR2
113 , arg_user_id IN NUMBER
114 , arg_po_group_by IN NUMBER
115 , arg_po_batch_number IN NUMBER
116 , arg_wip_group_id IN NUMBER
117 , arg_loaded_jobs IN OUT NOCOPY NumTblTyp
118 , arg_loaded_reqs IN OUT NOCOPY NumTblTyp
119 , arg_loaded_scheds IN OUT NOCOPY NumTblTyp
120 , arg_resched_jobs IN OUT NOCOPY NumTblTyp
121 , arg_resched_reqs IN OUT NOCOPY NumTblTyp
122 , arg_wip_req_id IN OUT NOCOPY NumTblTyp
123 , arg_req_load_id IN OUT NOCOPY NumTblTyp
124 , arg_req_resched_id IN OUT NOCOPY NumTblTyp
125 , arg_released_instance IN OUT NOCOPY NumTblTyp
126 , arg_mode IN VARCHAR2 DEFAULT NULL
127 , arg_transaction_id IN NUMBER DEFAULT NULL
128 , arg_loaded_lot_jobs IN OUT NOCOPY NumTblTyp
129 , arg_resched_lot_jobs IN OUT NOCOPY NumTblTyp
130 , arg_osfm_req_id IN OUT NOCOPY NumTblTyp
131 -- the following 2 parameters added for dsr
132 , arg_resched_eam_jobs IN OUT NOCOPY NumTblTyp
133 , arg_eam_req_id IN OUT NOCOPY NumTblTyp
134 -- the following 4 parameters added for drp release
135 , arg_loaded_int_reqs IN OUT NOCOPY NumTblTyp
136 , arg_resched_int_reqs IN OUT NOCOPY NumTblTyp
137 , arg_int_req_load_id IN OUT NOCOPY NumTblTyp
138 , arg_int_req_resched_id IN OUT NOCOPY NumTblTyp
139 , arg_loaded_int_repair_orders IN OUT NOCOPY NumTblTyp -- for release of IRO
140 , arg_int_repair_orders_id IN OUT NOCOPY NumTblTyp --for release of IRO
141 , arg_loaded_ext_repair_orders IN OUT NOCOPY NumTblTyp -- for release of ERO
142 , arg_ext_repair_orders_id IN OUT NOCOPY NumTblTyp --for release of ERO
143 );
144
145 PROCEDURE MSC_RELEASE_PLAN_SC
146 ( arg_plan_id IN NUMBER
147 , arg_log_org_id IN NUMBER
148 , arg_log_sr_instance IN NUMBER
149 , arg_org_id IN NUMBER
150 , arg_sr_instance IN NUMBER
151 , arg_compile_desig IN VARCHAR2
152 , arg_user_id IN NUMBER
153 , arg_po_group_by IN NUMBER
154 , arg_po_batch_number IN NUMBER
155 , arg_wip_group_id IN NUMBER
156 , arg_loaded_jobs IN OUT NOCOPY NumTblTyp
157 , arg_loaded_reqs IN OUT NOCOPY NumTblTyp
158 , arg_loaded_scheds IN OUT NOCOPY NumTblTyp
159 , arg_resched_jobs IN OUT NOCOPY NumTblTyp
160 , arg_resched_reqs IN OUT NOCOPY NumTblTyp
161 , arg_wip_req_id IN OUT NOCOPY NumTblTyp
162 , arg_req_load_id IN OUT NOCOPY NumTblTyp
163 , arg_req_resched_id IN OUT NOCOPY NumTblTyp
164 , arg_released_instance IN OUT NOCOPY NumTblTyp
165 , arg_mode IN VARCHAR2 DEFAULT NULL
166 , arg_transaction_id IN NUMBER DEFAULT NULL
167 , arg_loaded_lot_jobs IN OUT NOCOPY NumTblTyp
168 , arg_resched_lot_jobs IN OUT NOCOPY NumTblTyp
169 , arg_osfm_req_id IN OUT NOCOPY NumTblTyp
170 -- the following 2 parameters added for dsr
171 , arg_resched_eam_jobs IN OUT NOCOPY NumTblTyp
172 --arg_eam_req_id will return the request id for the rescheduled EAM jobs
173 , arg_eam_req_id IN OUT NOCOPY NumTblTyp
174 -- the following 4 parameters added for drp release
175 , arg_loaded_int_reqs IN OUT NOCOPY NumTblTyp
176 , arg_resched_int_reqs IN OUT NOCOPY NumTblTyp
177 , arg_int_req_load_id IN OUT NOCOPY NumTblTyp
178 , arg_int_req_resched_id IN OUT NOCOPY NumTblTyp
179 , arg_loaded_int_repair_orders IN OUT NOCOPY NumTblTyp -- for release of IRO
180 , arg_int_repair_orders_id IN OUT NOCOPY NumTblTyp --for release of IRO
181 , arg_loaded_ext_repair_orders IN OUT NOCOPY NumTblTyp -- for release of ERO
182 , arg_ext_repair_orders_id IN OUT NOCOPY NumTblTyp --for release of ERO
183 --The following 6 parameters are added for the' USAF project -eAM/cMRO integration
184 , arg_loaded_eam_jobs IN OUT NOCOPY NumTblTyp
185 , arg_loaded_eam_req_id IN OUT NOCOPY NumTblTyp
186 , arg_resched_cmro_jobs IN OUT NOCOPY NumTblTyp
187 , arg_resched_cmro_req_id IN OUT NOCOPY NumTblTyp
188 , arg_loaded_cmro_jobs IN OUT NOCOPY NumTblTyp
189 , arg_loaded_cmro_req_id IN OUT NOCOPY NumTblTyp
190 );
191
192 PROCEDURE MSC_RELEASE_PLAN_SC
193 ( arg_plan_id IN NUMBER
194 , arg_log_org_id IN NUMBER
195 , arg_log_sr_instance IN NUMBER
196 , arg_org_id IN NUMBER
197 , arg_sr_instance IN NUMBER
198 , arg_compile_desig IN VARCHAR2
199 , arg_user_id IN NUMBER
200 , arg_po_group_by IN NUMBER
201 , arg_po_batch_number IN NUMBER
202 , arg_wip_group_id IN NUMBER
203 , arg_loaded_jobs IN OUT NOCOPY NumTblTyp
204 , arg_loaded_reqs IN OUT NOCOPY NumTblTyp
205 , arg_loaded_scheds IN OUT NOCOPY NumTblTyp
206 , arg_resched_jobs IN OUT NOCOPY NumTblTyp
207 , arg_resched_reqs IN OUT NOCOPY NumTblTyp
208 , arg_wip_req_id IN OUT NOCOPY NumTblTyp
209 , arg_req_load_id IN OUT NOCOPY NumTblTyp
210 , arg_req_resched_id IN OUT NOCOPY NumTblTyp
211 , arg_released_instance IN OUT NOCOPY NumTblTyp
212 , arg_mode IN VARCHAR2 DEFAULT NULL
213 , arg_transaction_id IN NUMBER DEFAULT NULL
214 -- the following 4 parameters added for drp release
215 , arg_loaded_int_reqs IN OUT NOCOPY NumTblTyp
216 , arg_resched_int_reqs IN OUT NOCOPY NumTblTyp
217 , arg_int_req_load_id IN OUT NOCOPY NumTblTyp
218 , arg_int_req_resched_id IN OUT NOCOPY NumTblTyp
219 , arg_loaded_int_repair_orders IN OUT NOCOPY NumTblTyp -- for release of IRO
220 , arg_int_repair_orders_id IN OUT NOCOPY NumTblTyp --for release of IRO
221 , arg_loaded_ext_repair_orders IN OUT NOCOPY NumTblTyp -- for release of ERO
222 , arg_ext_repair_orders_id IN OUT NOCOPY NumTblTyp --for release of ERO
223 --The following 6 parameters are added for the' USAF project -eAM/cMRO integration
224 , arg_loaded_eam_jobs IN OUT NOCOPY NumTblTyp
225 , arg_loaded_eam_req_id IN OUT NOCOPY NumTblTyp
226 , arg_resched_cmro_jobs IN OUT NOCOPY NumTblTyp
227 , arg_resched_cmro_req_id IN OUT NOCOPY NumTblTyp
228 , arg_loaded_cmro_jobs IN OUT NOCOPY NumTblTyp
229 , arg_loaded_cmro_req_id IN OUT NOCOPY NumTblTyp
230 );
231
232 PROCEDURE LOAD_MSC_INTERFACE
233 ( arg_dblink IN VARCHAR2
234 , arg_plan_id IN NUMBER
235 , arg_log_org_id IN NUMBER
236 , arg_org_instance IN NUMBER
237 , arg_owning_org_id IN NUMBER
238 , arg_owning_instance IN NUMBER
239 , arg_compile_desig IN VARCHAR2
240 , arg_user_id IN NUMBER
241 , arg_po_group_by IN NUMBER
242 , arg_po_batch_number IN NUMBER
243 , arg_wip_group_id IN NUMBER
244 , arg_loaded_jobs IN OUT NOCOPY NUMBER
245 , arg_loaded_lot_jobs IN OUT NOCOPY NUMBER
246 ,arg_resched_lot_jobs IN OUT NOCOPY NUMBER
247 , arg_loaded_reqs IN OUT NOCOPY NUMBER
248 , arg_loaded_scheds IN OUT NOCOPY NUMBER
249 , arg_resched_jobs IN OUT NOCOPY NUMBER
250 , arg_resched_reqs IN OUT NOCOPY NUMBER
251 , arg_wip_req_id IN OUT NOCOPY NUMBER
252 ,arg_osfm_req_id IN OUT NOCOPY NUMBER
253 , arg_req_load_id IN OUT NOCOPY NUMBER
254 , arg_req_resched_id IN OUT NOCOPY NUMBER
255 , arg_mode IN VARCHAR2 DEFAULT NULL
256 , arg_transaction_id IN NUMBER DEFAULT NULL
257 , l_apps_ver IN VARCHAR2
258 -- dsr
259 , arg_resched_eam_jobs IN OUT NOCOPY NUMBER
260 , arg_eam_req_id IN OUT NOCOPY NUMBER
261 -- the following 4 parameters added for drp release
262 , arg_loaded_int_reqs IN OUT NOCOPY Number
263 , arg_resched_int_reqs IN OUT NOCOPY Number
264 , arg_int_req_load_id IN OUT NOCOPY Number
265 , arg_int_req_resched_id IN OUT NOCOPY Number
266 , arg_loaded_int_repair_orders IN OUT NOCOPY Number -- for release of IRO
267 , arg_int_repair_orders_id IN OUT NOCOPY Number --for release of IRO
268 , arg_loaded_ext_repair_orders IN OUT NOCOPY Number -- for release of ERO
269 , arg_ext_repair_orders_id IN OUT NOCOPY Number --for release of ERO
270 /*USAF*/
271 , arg_loaded_eam_jobs IN OUT NOCOPY NUMBER
272 , arg_loaded_eam_req_id IN OUT NOCOPY NUMBER
273 , arg_resched_cmro_jobs IN OUT NOCOPY NUMBER
274 , arg_resched_cmro_req_id IN OUT NOCOPY NUMBER
275 , arg_loaded_cmro_jobs IN OUT NOCOPY NUMBER
276 , arg_loaded_cmro_req_id IN OUT NOCOPY NUMBER
277
278 );
279
280
281
282 FUNCTION load_wip_discrete_jobs
283 ( arg_plan_id IN NUMBER
284 , arg_log_org_id IN NUMBER
285 , arg_org_instance IN NUMBER
286 , arg_owning_org_id IN NUMBER
287 , arg_owning_instance IN NUMBER
288 , arg_user_id IN NUMBER
289 , arg_wip_group_id IN NUMBER
290 , arg_mode IN VARCHAR2
291 , arg_transaction_id IN NUMBER
292 , l_apps_ver IN VARCHAR2
293 )RETURN NUMBER;
294
295
296 FUNCTION load_osfm_lot_jobs
297 ( arg_plan_id IN NUMBER
298 , arg_log_org_id IN NUMBER
299 , arg_org_instance IN NUMBER
300 , arg_owning_org_id IN NUMBER
301 , arg_owning_instance IN NUMBER
302 , arg_user_id IN NUMBER
303 , arg_wip_group_id IN NUMBER
304 , arg_mode IN VARCHAR2
305 , arg_transaction_id IN NUMBER,
306 l_apps_ver IN VARCHAR2
307 )RETURN NUMBER;
308
309
310 FUNCTION reschedule_osfm_lot_jobs
311 ( arg_plan_id IN NUMBER
312 , arg_log_org_id IN NUMBER
313 , arg_org_instance IN NUMBER
314 , arg_owning_org_id IN NUMBER
315 , arg_owning_instance IN NUMBER
316 , arg_user_id IN NUMBER
317 , arg_wip_group_id IN NUMBER
318 , arg_mode IN VARCHAR2
319 , arg_transaction_id IN NUMBER
320 )RETURN NUMBER;
321
322
323 FUNCTION reschedule_wip_discrete_jobs
324 ( arg_plan_id IN NUMBER
325 , arg_log_org_id IN NUMBER
326 , arg_org_instance IN NUMBER
327 , arg_owning_org_id IN NUMBER
328 , arg_owning_instance IN NUMBER
329 , arg_user_id IN NUMBER
330 , arg_wip_group_id IN NUMBER
331 , arg_mode IN VARCHAR2
332 , arg_transaction_id IN NUMBER
333 , l_apps_ver IN VARCHAR2
334 , arg_load_type IN NUMBER DEFAULT NULL -- dsr
335 )RETURN NUMBER;
336
337 FUNCTION load_repetitive_schedules
338 ( arg_plan_id IN NUMBER
339 , arg_log_org_id IN NUMBER
340 , arg_org_instance IN NUMBER
341 , arg_owning_org_id IN NUMBER
342 , arg_owning_instance IN NUMBER
343 , arg_user_id IN NUMBER
344 , arg_wip_group_id IN NUMBER
345 , arg_mode IN VARCHAR2
346 , arg_transaction_id IN NUMBER
347 )RETURN NUMBER;
348
349 FUNCTION load_po_requisitions
350 ( arg_plan_id IN NUMBER
351 , arg_log_org_id IN NUMBER
352 , arg_org_instance IN NUMBER
353 , arg_owning_org_id IN NUMBER
354 , arg_owning_instance IN NUMBER
355 , arg_user_id IN NUMBER
356 , arg_po_group_by IN NUMBER
357 , arg_po_batch_number IN NUMBER
358 , arg_mode IN VARCHAR2
359 , arg_transaction_id IN NUMBER
360 )RETURN NUMBER;
361
362 FUNCTION reschedule_po
363 ( arg_plan_id IN NUMBER
364 , arg_log_org_id IN NUMBER
365 , arg_org_instance IN NUMBER
366 , arg_owning_org_id IN NUMBER
367 , arg_owning_instance IN NUMBER
368 , arg_user_id IN NUMBER
369 , arg_po_batch_number IN NUMBER
370 , arg_mode IN VARCHAR2
371 , arg_transaction_id IN NUMBER
372 )RETURN NUMBER;
373
374 FUNCTION reschedule_po_wf
375 ( arg_dblink IN VARCHAR2
376 , arg_plan_id IN NUMBER
377 , arg_log_org_id IN NUMBER
378 , arg_org_instance IN NUMBER
379 , arg_owning_org_id IN NUMBER
380 , arg_owning_instance IN NUMBER
381 , arg_user_id IN NUMBER
382 , arg_mode IN VARCHAR2
383 , arg_transaction_id IN NUMBER
384 )RETURN NUMBER;
385
386 FUNCTION GET_CAL_DATE ( lv_inst_id in number
387 , lv_calendar_date in date
388 ,lv_calendar_code in varchar2) return date ;
389 FUNCTION GET_COPRODUCT_QTY ( inst_id in number , pln_id in number ,disp_id in number, bill_seq_id in number) return number ;
390
391 FUNCTION GET_REV_CUM_YIELD (inst_id in number , pln_id in number, process_seq_id in number,trans_id in number,org_id in number) return number ;
392
393 FUNCTION GET_REV_CUM_YIELD_DISC (inst_id IN NUMBER,
394 pln_id IN NUMBER,
395 process_seq_id IN NUMBER,
396 trans_id IN NUMBER,
397 org_id IN NUMBER,
398 org_type IN NUMBER)
399 RETURN NUMBER;
400
401 FUNCTION GET_REV_CUM_YIELD_DISC_COMP( inst_id IN NUMBER
402 ,pln_id IN NUMBER
403 ,process_seq_id IN NUMBER
404 ,trans_id IN NUMBER
405 ,org_id IN NUMBER
406 ,org_type IN NUMBER
407 ,op_seq_num IN NUMBER
408 )
409 RETURN NUMBER;
410
411
412 FUNCTION GET_USAGE_QUANTITY ( p_plan_id IN NUMBER
413 ,p_inst_id IN NUMBER
414 ,p_org_id IN NUMBER
415 ,p_using_assy_id IN NUMBER
416 ,p_comp_seq_id IN NUMBER) RETURN NUMBER;
417 FUNCTION GET_WIP_SUPPLY_TYPE ( p_plan_id IN NUMBER
418 ,p_inst_id IN NUMBER
419 ,p_process_seq_id IN NUMBER
420 ,p_item_id IN NUMBER
421 ,p_comp_item_id IN NUMBER
422 ,p_org_id IN NUMBER) RETURN NUMBER;
423
424 /* Added these @ functions to get the SR_TP_ID and the TP_SITE_LOCATION
425 based on the arguments */
426 FUNCTION GET_MODELED_SR_TP_ID (pMODELED_SUPPLIER_ID IN NUMBER,
427 pSR_INSTANCE_ID IN NUMBER)
428 RETURN NUMBER;
429
430 FUNCTION GET_MODELED_TP_SITE_CODE (pMODELED_SUPPLIER_ID IN NUMBER,
431 pMODELED_SUPPLIER_SITE_ID IN NUMBER,
432 pSR_INSTANCE_ID IN NUMBER)
433 RETURN VARCHAR2;
434
435 FUNCTION Decode_Sales_Order_Number(p_order_number_string in VARCHAR2)
436 return NUMBER;
437 PROCEDURE POPULATE_ISO_IN_SOURCE(
438 l_dblink IN varchar2,
439 l_arg_po_batch_number IN number,
440 l_arg_owning_instance IN number,
441 l_arg_po_group_by IN number,
442 l_arg_plan_id IN number,
443 l_arg_log_org_id IN number,
444 l_arg_owning_org_id IN number,
445 l_arg_org_instance IN number,
446 l_arg_mode IN varchar2,
447 l_arg_transaction_id IN number,
448 arg_loaded_int_reqs IN OUT NOCOPY number,
449 arg_resched_int_reqs IN OUT NOCOPY number,
450 p_load_type IN number);
451
452 PROCEDURE POPULATE_ISO_IN_SOURCE_2(
453 l_dblink IN varchar2,
454 l_arg_po_batch_number IN number,
455 l_arg_owning_instance IN number,
456 l_arg_po_group_by IN number,
457 l_arg_plan_id IN number,
458 l_arg_log_org_id IN number,
459 l_arg_owning_org_id IN number,
460 l_arg_org_instance IN number,
461 l_arg_mode IN varchar2,
462 l_arg_transaction_id IN number,
463 arg_loaded_int_reqs IN OUT NOCOPY number,
464 arg_resched_int_reqs IN OUT NOCOPY number,
465 p_load_type IN number);
466
467 Procedure Release_IRO(
468 p_dblink IN varchar2,
469 p_arg_iro_batch_number IN number,
470 p_arg_owning_instance IN number,
471 p_arg_po_group_by IN number,
472 p_arg_plan_id IN number,
473 p_arg_log_org_id IN number,
474 p_arg_owning_org_id IN number,
475 p_arg_org_instance IN number,
476 p_arg_mode IN varchar2,
477 p_arg_transaction_id IN number,
478 p_arg_loaded_int_repair_orders IN OUT NOCOPY number,
479 p_load_type IN number);
480
481 Procedure Release_IRO_2(
482 p_dblink IN varchar2,
483 p_arg_iro_batch_number IN number,
484 p_arg_owning_instance IN number,
485 p_arg_po_group_by IN number,
486 p_arg_plan_id IN number,
487 p_arg_log_org_id IN number,
488 p_arg_owning_org_id IN number,
489 p_arg_org_instance IN number,
490 p_arg_mode IN varchar2,
491 p_arg_transaction_id IN number,
492 p_arg_loaded_int_repair_orders IN OUT NOCOPY number,
493 p_load_type IN number);
494
495
496 PROCEDURE Release_Ero(
497 p_dblink IN VARCHAR2,
498 p_arg_ero_batch_number IN number,
499 p_arg_owning_instance IN NUMBER,
500 p_arg_po_group_by IN NUMBER,
501 p_arg_plan_id IN NUMBER,
502 p_arg_log_org_id IN NUMBER,
503 p_arg_owning_org_id IN NUMBER,
504 p_arg_org_instance IN NUMBER,
505 p_arg_mode IN VARCHAR2,
506 p_arg_transaction_id IN NUMBER,
507 p_arg_loaded_ext_repair_orders IN OUT nocopy NUMBER,
508 p_load_type IN NUMBER);
509 PROCEDURE Release_Ero_2(
510 p_dblink IN VARCHAR2,
511 p_arg_ero_batch_number IN number,
512 p_arg_owning_instance IN NUMBER,
513 p_arg_po_group_by IN NUMBER,
514 p_arg_plan_id IN NUMBER,
515 p_arg_log_org_id IN NUMBER,
516 p_arg_owning_org_id IN NUMBER,
517 p_arg_org_instance IN NUMBER,
518 p_arg_mode IN VARCHAR2,
519 p_arg_transaction_id IN NUMBER,
520 p_arg_loaded_ext_repair_orders IN OUT nocopy NUMBER,
521 p_load_type IN NUMBER);
522
523 PROCEDURE load_eam_cmro_jobs
524 ( p_arg_plan_id IN NUMBER
525 , p_arg_log_org_id IN NUMBER
526 , p_arg_org_instance IN NUMBER
527 , p_arg_owning_org_id IN NUMBER
528 , p_arg_owning_instance IN NUMBER
529 , p_arg_user_id IN NUMBER
530 , p_arg_wip_group_id IN NUMBER
531 , p_arg_mode IN VARCHAR2
532 , p_arg_transaction_id IN NUMBER
533 , p_l_apps_ver IN VARCHAR2
534 , p_loaded_eam_jobs IN OUT NOCOPY NUMBER
535 , p_loaded_cmro_jobs IN OUT NOCOPY NUMBER
536 );
537
538 FUNCTION reschedule_eam_jobs
539 ( arg_plan_id IN NUMBER
540 , arg_log_org_id IN NUMBER
541 , arg_org_instance IN NUMBER
542 , arg_owning_org_id IN NUMBER
543 , arg_owning_instance IN NUMBER
544 , arg_user_id IN NUMBER
545 , arg_wip_group_id IN NUMBER
546 , arg_mode IN VARCHAR2
547 , arg_transaction_id IN NUMBER
548 , l_apps_ver IN VARCHAR2
549 , arg_load_type IN NUMBER DEFAULT NULL
550 )RETURN NUMBER;
551
552 FUNCTION reschedule_cmro_jobs
553 ( arg_plan_id IN NUMBER
554 , arg_log_org_id IN NUMBER
555 , arg_org_instance IN NUMBER
556 , arg_owning_org_id IN NUMBER
557 , arg_owning_instance IN NUMBER
558 , arg_user_id IN NUMBER
559 , arg_wip_group_id IN NUMBER
560 , arg_mode IN VARCHAR2
561 , arg_transaction_id IN NUMBER
562 , l_apps_ver IN VARCHAR2
563 , arg_load_type IN NUMBER DEFAULT NULL
564 )RETURN NUMBER;
565
566 PROCEDURE SET_RP_TIMESTAMP_WIP(p_group_id IN NUMBER);
567 PROCEDURE SET_RP_TIMESTAMP_PO(p_arg_batch_id IN NUMBER);
568 END MSC_Rel_Plan_PUB;