1 PACKAGE WIP_ATO_JOBS_PRIV AUTHID CURRENT_USER AS
2 /* $Header: wipvfass.pls 120.0.12020000.3 2013/01/10 10:55:06 abhissri ship $ */
3 /*========================================================================+
4 | Copyright (c) 1997 Oracle Corporation Redwood Shores, California, USA |
5 | All rights reserved. |
6 +=========================================================================+
7 | |
8 | File Name : WIPVFASS.PLS |
9 | |
10 | DESCRIPTION : Package Specification for Autocreate FAS. |
11 | |
12 | Coders : Amit Garg |
13 | |
14 | PURPOSE: Create Discrete Jobs to satisfy sales order demand for |
15 | replenish-to-order items that meet the user-input criteria|
16 | |
17 | |
18 | |
19 | PROGRAM SYNOPSIS: |
20 | 1. Update records in mtl_demand that meet criteria with a group_id |
21 | 2. Insert records into wip_entities_interface for mtl_demands records |
22 | marked with group_id |
23 | 3. Read wip_entities_interface records and inform OE of sales order |
24 | lines that have been linked to WIP |
25 | 4. Call mass load routine to create jobs from wip_entities_interface |
26 | records |
27 | 5. Do feedback: |
28 | 1. Update mtl_demand for jobs successfully loaded |
29 | 2. Create records in wip_so_allocations |
30 | 3. Read wip_entities_interface and inform OE of sales order |
31 | lines that should be unlinked from WIP |
32 | 4. Update mtl_demand for jobs that failed load so they can be |
33 | picked up again |
34 | 6. Launch report of what occurred in process |
35 | 7. Delete records from interface table |
36 | |
37 | CALLED BY: Concurrent Program |
38 | |
39 | |
40 | HISTORY: |
41 +=========================================================================*/
42
43 --Global Constants
44
45
46 /*-----------------------------------------------------------+
47 | Defines for linking or unlinking OE order to WIP |
48 +-----------------------------------------------------------+*/
49 WILINK CONSTANT NUMBER := 1;
50 WIUNLINK CONSTANT NUMBER := 2;
51
52 WPENDING CONSTANT NUMBER := 1;
53 WRUNNING CONSTANT NUMBER := 2;
54 WERROR CONSTANT NUMBER := 3;
55 WCOMPLETED CONSTANT NUMBER := 4;
56 WWARNING CONSTANT NUMBER := 5;
57
58 WIP_ML_VALIDATION CONSTANT NUMBER := 2;
59 WIP_ML_EXPLOSION CONSTANT NUMBER := 3;
60 WIP_ML_INSERTION CONSTANT NUMBER := 5;
61 WIP_ML_COMPLETE CONSTANT NUMBER := 4;
62
63
64
65 /* Flow ER 14595064: Overloading this function CREATE_JOBS. Without retaining
66 this old signature, manual progress order of sales order line will fail
67 because for manual progress order, the call comes from the workflow. The
68 workflow doesn't have the new parameter and will have to be modified.
69 Overloading avoids modifications in the wft file. The workflow will call
70 the procedure without the new parameter whereas the program will call the
71 procedure with the new parameter.
72 */
73 PROCEDURE CREATE_JOBS(
74 ERRBUF OUT NOCOPY VARCHAR2 ,
75 RETCODE OUT NOCOPY VARCHAR2,
76 P_ORDER_NUMBER IN VARCHAR2 ,
77 P_DUMMY_FIELD IN VARCHAR2 ,
78 P_OFFSET_DAYS IN VARCHAR2 ,
79 P_LOAD_TYPE IN VARCHAR2 , --CHANGED
80 P_STATUS_TYPE IN VARCHAR2 , --CHANGED
81 P_ORG_ID IN VARCHAR2 , --CHANGED
82 P_CLASS_CODE IN VARCHAR2 , --CHANGED
83 P_FAILED_REQ_ID IN VARCHAR2 ,
84 P_ORDER_LINE_ID IN VARCHAR2 ,
85 P_BATCH_ID IN VARCHAR2);
86
87 PROCEDURE CREATE_JOBS(
88 ERRBUF OUT NOCOPY VARCHAR2 ,
89 RETCODE OUT NOCOPY VARCHAR2,
90 P_ORDER_NUMBER IN VARCHAR2 ,
91 P_DUMMY_FIELD IN VARCHAR2 ,
92 P_OFFSET_DAYS IN VARCHAR2 ,
93 P_LOAD_TYPE IN VARCHAR2 , --CHANGED
94 P_STATUS_TYPE IN VARCHAR2 , --CHANGED
95 P_ORG_ID IN VARCHAR2 , --CHANGED
96 P_CLASS_CODE IN VARCHAR2 , --CHANGED
97 P_FAILED_REQ_ID IN VARCHAR2 ,
98 P_CREATE_FLOW_SCHEDULES IN NUMBER , --Flow ER 14595064
99 P_ORDER_LINE_ID IN VARCHAR2 ,
100 P_BATCH_ID IN VARCHAR2);
101
102
103 FUNCTION LOAD_ORDERS
104 (
105 ERRBUF OUT NOCOPY VARCHAR2,
106 RETCODE OUT NOCOPY VARCHAR2,
107 P_ORDER_NUMBER IN NUMBER DEFAULT -1,
108 p_DUMMY_FIELD IN NUMBER DEFAULT -1,
109 p_OFFSET_DAYS IN NUMBER DEFAULT -1,
110 p_LOAD_TYPE IN NUMBER DEFAULT -1,
111 p_STATUS_TYPE IN NUMBER DEFAULT -1,
112 p_ORG_ID IN NUMBER DEFAULT -1,
113 p_CLASS_CODE IN VARCHAR2 DEFAULT -1,
114 p_FAILED_REQ_ID IN NUMBER DEFAULT -1,
115 p_ORDER_LINE_ID IN NUMBER DEFAULT -1,
116 p_BATCH_ID IN NUMBER DEFAULT -1,
117 --Flow ER 14595064
118 p_create_flow_schedules IN NUMBER DEFAULT 2,
119 p_all_success_ptr IN OUT NOCOPY NUMBER )
120
121 RETURN boolean;
122
123
124 Function delete_interface_orders(p_wei_group_id NUMBER)
125 return boolean ;
126
127
128 END WIP_ATO_JOBS_PRIV;
129