1 PACKAGE MRP_MRPRPROP_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: MRPRPROPS.pls 120.2 2008/01/02 12:53:15 nchinnam noship $ */
3 P_DEBUG VARCHAR2(1);
4
5 P_FIRST_SORT NUMBER;
6
7 P_SECOND_SORT NUMBER;
8
9 P_THIRD_SORT NUMBER;
10
11 P_LOW_CAT VARCHAR2(240);
12
13 P_HIGH_CAT VARCHAR2(240);
14
15 P_LOW_ITEM VARCHAR2(240);
16
17 P_HIGH_ITEM VARCHAR2(240);
18
19 P_CAT_STRUCT_NUM NUMBER;
20
21 P_FLEXDATA_CAT VARCHAR2(800);
22
23 P_FLEXDATA_ITEM VARCHAR2(800);
24
25 P_CAT_RANGE VARCHAR2(240);
26
27 P_ITEM_RANGE VARCHAR2(800);
28
29 P_ITEM_ORDER_BY VARCHAR2(240);
30
31 P_ORDER_BY VARCHAR2(240);
32
33 P_LOW_BUYER NUMBER;
34
35 P_LOW_PLANNER VARCHAR2(22);
36
37 DP_DEMAND_CUTOFF_DATE VARCHAR2(30);
38
39 DP_SUPPLY_CUTOFF_DATE VARCHAR2(30);
40
41 P_ORG_ID NUMBER;
42
43 P_CATEGORY_SET NUMBER;
44
45 P_ITEM_SELECTION NUMBER;
46
47 P_DEMAND_CUTOFF_DATE DATE;
48
49 P_SUPPLY_CUTOFF_DATE DATE;
50
51 P_RESTOCK NUMBER;
52
53 P_DEFAULT_DELIVERY_TO NUMBER;
54
55 P_FORECAST VARCHAR2(32767);
56
57 P_CONC_REQUEST_ID NUMBER;
58
59 P_HIGH_PLANNER VARCHAR2(22);
60
61 P_HIGH_BUYER NUMBER;
62
63 P_DISPLAY_DESCRIPTION NUMBER;
64
65 P_USER_ID NUMBER;
66
67 P_NET_UNRSV NUMBER := 1;
68
69 P_NET_RSV NUMBER := 1;
70
71 P_NET_WIP NUMBER := 1;
72
73 P_INCLUDE_PO NUMBER;
74
75 P_INCLUDE_WIP NUMBER;
76
77 P_INCLUDE_IF NUMBER;
78
79 P_INCLUDE_NONNET NUMBER;
80
81 P_SUBINV VARCHAR2(32767);
82
83 P_PROFILE NUMBER;
84
85 P_REPETITIVE_ITEM NUMBER := 3;
86
87 P_ABC_ASSGN VARCHAR2(22);
88
89 P_ABC_CLASS VARCHAR2(22);
90
91 P_DISPLAY_ADD_INFO NUMBER;
92
93 P_LEVEL NUMBER := 1;
94
95 P_DYNAMIC_ABC VARCHAR2(100) := ''' ''';
96
97 P_REPETITIVE_MESSAGE VARCHAR2(200);
98
99 P_CAL_CODE VARCHAR2(32767);
100
101 P_EXC_SET_ID NUMBER;
102
103 P_APPROVAL NUMBER;
104
105 P_CURRENT_DATE DATE;
106
107 P_EMPLOYEE_ID NUMBER;
108
109 P_PO_ORG_ID NUMBER;
110
111 P_ENCUM_FLAG VARCHAR2(32767);
112
113 P_CUSTOMER_ID NUMBER;
114
115 P_WIP_BATCH_ID NUMBER;
116
117 P_MESSAGE_PO1 VARCHAR2(500);
118
119 P_MESSAGE_PO2 VARCHAR2(500);
120
121 P_MESSAGE_PO3 VARCHAR2(500);
122
123 P_MESSAGE_WIP1 VARCHAR2(500);
124
125 P_MESSAGE_WIP2 VARCHAR2(500);
126
127 P_MESSAGE_PO4 VARCHAR2(500);
128
129 P_PUR_REVISION NUMBER;
130
131 CHAR_QTY VARCHAR2(100);
132
133 P_MESSAGE_BATCH VARCHAR2(500);
134
135 C_LEAD_TIME_DEMAND NUMBER;
136
137 C_ONHAND_QTY NUMBER;
138
139 C_SUPPLY_QTY NUMBER;
140
141 FUNCTION BEFOREREPORT RETURN BOOLEAN;
142
143 FUNCTION AFTERREPORT RETURN BOOLEAN;
144
145 FUNCTION C_CATEGORY_WHEREFORMULA RETURN VARCHAR2;
146
147 FUNCTION C_PLANNER_RANGEFORMULA RETURN VARCHAR2;
148
149 FUNCTION C_ORDER_BYFORMULA RETURN VARCHAR2;
150
151 FUNCTION C_TOT_AVAILFORMULA(C_DEMAND_QTY IN NUMBER) RETURN NUMBER;
152
153 FUNCTION C_SAFETY_STOCKFORMULA(C_ITEM_ID IN NUMBER
154 ,C_ORD_LEAD_TIME IN NUMBER) RETURN NUMBER;
155
156 FUNCTION C_FIRST_SORT_PFORMULA RETURN VARCHAR2;
157
158 FUNCTION C_SECOND_SORT_PFORMULA RETURN VARCHAR2;
159
160 FUNCTION C_THIRD_SORT_PFORMULA RETURN VARCHAR2;
161
162 FUNCTION C_CATEGORY_SET_PFORMULA RETURN VARCHAR2;
163
164 FUNCTION C_DISPLAY_DESCRIPTION_PFORMULA RETURN VARCHAR2;
165
166 FUNCTION C_RESTOCK_PFORMULA RETURN VARCHAR2;
167
168 FUNCTION C_REORDER_POINTFORMULA(C_SAFETY_STOCK IN NUMBER) RETURN NUMBER;
169
170 FUNCTION C_DEMAND_QTYFORMULA(C_ITEM_ID IN NUMBER
171 ,C_ORD_LEAD_TIME IN NUMBER
172 ,C_LOT_CONTROL IN NUMBER) RETURN NUMBER;
173
174 FUNCTION C_REORDER_QTYFORMULA(C_ITEM_ID IN NUMBER
175 ,C_TOT_AVAIL IN NUMBER
176 ,C_REORDER_POINT IN NUMBER
177 ,C_FIX_LOT_MULT IN NUMBER
178 ,C_MIN_ORD_QTY IN NUMBER
179 ,C_MAX_ORD_QTY IN NUMBER) RETURN NUMBER;
180
181 FUNCTION C_RUN_RESTOCKFORMULA(C_TOT_AVAIL IN NUMBER
182 ,C_REORDER_POINT IN NUMBER
183 ,C_REPETITIVE_PLANNED_ITEM IN VARCHAR2
184 ,C_MAKE_BUY IN NUMBER
185 ,C_CHARGE_ACCT IN NUMBER
186 ,C_ACCRUAL_ACCT IN NUMBER
187 ,C_IPV_ACCT IN NUMBER
188 ,C_BUDGET_ACCT IN NUMBER
189 ,C_SRC_TYPE IN NUMBER
190 ,C_SRC_ORG IN VARCHAR2
191 ,C_ORDER_FLAG IN VARCHAR2
192 ,C_PURCH_FLAG IN VARCHAR2
193 ,C_PROCESS_ENABLED IN VARCHAR2
194 ,C_BUILD_IN_WIP IN VARCHAR2
195 ,C_PICK_COMPONENTS IN VARCHAR2
196 ,C_RECIPE_ENABLED IN VARCHAR2
197 ,C_EXECUTION_ENABLED IN VARCHAR2
198 ,C_ITEM_ID IN NUMBER
199 ,C_REORDER_QTY IN NUMBER
200 ,C_FIXED_LEAD_TIME IN NUMBER
201 ,C_VARIABLE_LEAD_TIME IN NUMBER
202 ,C_PUR_LEAD_TIME IN NUMBER
203 ,C_PRIMARY_UOM IN VARCHAR2
204 ,C_UNIT_PRICE IN NUMBER
205 ,C_DESCRIPTION IN VARCHAR2
206 ,C_SRC_SUBINV IN VARCHAR2) RETURN VARCHAR2;
207
208 FUNCTION C_ABC_ASSGN_PFORMULA RETURN VARCHAR2;
209
210 FUNCTION C_ABC_CLASS_PFORMULA RETURN VARCHAR2;
211
212 FUNCTION C_DEFAULT_DEL_PFORMULA RETURN VARCHAR2;
213
214 FUNCTION C_ITEM_SELECTION_PFORMULA RETURN VARCHAR2;
215
216 FUNCTION C_ABC_RANGEFORMULA RETURN VARCHAR2;
217
218 FUNCTION C_INCLUDE_PO_PFORMULA RETURN VARCHAR2;
219
220 FUNCTION C_INCLUDE_WIP_PFORMULA RETURN VARCHAR2;
221
222 FUNCTION C_INCLUDE_IF_PFORMULA RETURN VARCHAR2;
223
224 FUNCTION C_INCLUDE_NONNET_PFORMULA RETURN VARCHAR2;
225
226 FUNCTION C_DISPLAY_ADD_INFO_PFORMULA RETURN VARCHAR2;
227
228 FUNCTION C_BUYER_RANGEFORMULA(C_BUYER_FROM_P IN VARCHAR2
229 ,C_BUYER_TO_P IN VARCHAR2) RETURN VARCHAR2;
230
231 FUNCTION C_BUYER_FROM_PFORMULA RETURN VARCHAR2;
232
233 FUNCTION C_BUYER_TO_PFORMULA RETURN VARCHAR2;
234
235 FUNCTION C_ABC_WHEREFORMULA RETURN VARCHAR2;
236
237 FUNCTION C_ABC_FROMFORMULA RETURN VARCHAR2;
238
239 FUNCTION C_LEAD_TIME_DEMAND_P RETURN NUMBER;
240
241 FUNCTION C_ONHAND_QTY_P RETURN NUMBER;
242
243 FUNCTION C_SUPPLY_QTY_P RETURN NUMBER;
244
245 FUNCTION NEXT_WORK_DAY(ARG_ORG_ID IN NUMBER
246 ,ARG_BUCKET IN NUMBER
247 ,ARG_DATE IN DATE) RETURN DATE;
248
249 FUNCTION PREV_WORK_DAY(ARG_ORG_ID IN NUMBER
250 ,ARG_BUCKET IN NUMBER
251 ,ARG_DATE IN DATE) RETURN DATE;
252
253 FUNCTION DATE_OFFSET(ARG_ORG_ID IN NUMBER
254 ,ARG_BUCKET IN NUMBER
255 ,ARG_DATE IN DATE
256 ,ARG_OFFSET IN NUMBER) RETURN DATE;
257
258 FUNCTION DAYS_BETWEEN(ARG_ORG_ID IN NUMBER
259 ,ARG_BUCKET IN NUMBER
260 ,ARG_DATE1 IN DATE
261 ,ARG_DATE2 IN DATE) RETURN NUMBER;
262
263 PROCEDURE SELECT_CALENDAR_DEFAULTS(ARG_ORG_ID IN NUMBER
264 ,ARG_CALENDAR_CODE OUT NOCOPY VARCHAR2
265 ,ARG_EXCEPTION_SET_ID OUT NOCOPY NUMBER);
266
267 PROCEDURE PUT(NAME IN VARCHAR2
268 ,VAL IN VARCHAR2);
269
270 FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN;
271
272 PROCEDURE GET(NAME IN VARCHAR2
273 ,VAL OUT NOCOPY VARCHAR2);
274
275 FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2;
276
277 FUNCTION SAVE_USER(X_NAME IN VARCHAR2
278 ,X_VALUE IN VARCHAR2) RETURN BOOLEAN;
279
280 FUNCTION SAVE(X_NAME IN VARCHAR2
281 ,X_VALUE IN VARCHAR2
282 ,X_LEVEL_NAME IN VARCHAR2
283 ,X_LEVEL_VALUE IN VARCHAR2
284 ,X_LEVEL_VALUE_APP_ID IN VARCHAR2) RETURN BOOLEAN;
285
286 PROCEDURE GET_SPECIFIC(NAME_Z IN VARCHAR2
287 ,USER_ID_Z IN NUMBER
288 ,RESPONSIBILITY_ID_Z IN NUMBER
289 ,APPLICATION_ID_Z IN NUMBER
290 ,VAL_Z OUT NOCOPY VARCHAR2
291 ,DEFINED_Z OUT NOCOPY BOOLEAN);
292
293 FUNCTION VALUE_SPECIFIC(NAME IN VARCHAR2
294 ,USER_ID IN NUMBER
295 ,RESPONSIBILITY_ID IN NUMBER
296 ,APPLICATION_ID IN NUMBER) RETURN VARCHAR2;
297
298 PROCEDURE INITIALIZE(USER_ID_Z IN NUMBER
299 ,RESPONSIBILITY_ID_Z IN NUMBER
300 ,APPLICATION_ID_Z IN NUMBER
301 ,SITE_ID_Z IN NUMBER);
302
303 PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
304 ,VALS IN VARCHAR2
305 ,NUM IN NUMBER);
306
307 PROCEDURE ESTIMATE_LEADTIME(X_ORG_ID IN NUMBER
308 ,X_FIXED_LEAD IN NUMBER
309 ,X_VAR_LEAD IN NUMBER
310 ,X_QUANTITY IN NUMBER
311 ,X_PROC_DAYS IN NUMBER
312 ,X_ENTITY_TYPE IN NUMBER
313 ,X_FUSD IN DATE
314 ,X_FUCD IN DATE
315 ,X_LUSD IN DATE
316 ,X_LUCD IN DATE
317 ,X_SCHED_DIR IN NUMBER
318 ,X_EST_DATE OUT NOCOPY DATE);
319
320 FUNCTION GET_FORECAST_QUANTITY(ITEM_ID IN NUMBER
321 ,ORG_ID IN NUMBER
322 ,FORECAST_DESIG IN CHAR
323 ,START_DATE IN DATE
324 ,END_DATE IN DATE) RETURN NUMBER;
325
326 FUNCTION GET_REORDER_QTY(ITEM_ID IN NUMBER
327 ,TOT_AVAIL IN NUMBER
328 ,REORDER_POINT IN NUMBER
329 ,ORG_ID IN NUMBER
330 ,FORECAST_DESIG IN CHAR
331 ,FIX_LOT_MULT IN NUMBER
332 ,MIN_ORD_QTY IN NUMBER
333 ,MAX_ORD_QTY IN NUMBER) RETURN NUMBER;
334
335 FUNCTION GET_LEAD_TIME_DEMAND(ITEM_ID IN NUMBER
336 ,ORG_ID IN NUMBER
337 ,FORECAST_DESIG IN CHAR
338 ,ORD_LEAD_TIME IN NUMBER) RETURN NUMBER;
339
340 FUNCTION GET_DEMAND(ITEM_ID IN NUMBER
341 ,ORG_ID IN NUMBER
342 ,DEMAND_CUTOFF_DATE IN DATE
343 ,NET_RSV IN NUMBER
344 ,INCLUDE_NONNET IN NUMBER
345 ,INCLUDE_WIP IN NUMBER
346 ,NET_UNRSV IN NUMBER
347 ,NET_WIP IN NUMBER
348 ,SUBINV IN CHAR) RETURN NUMBER;
349
350 FUNCTION GET_ONHAND_QTY(ITEM_ID IN NUMBER
351 ,LOT_CONTROL IN NUMBER
352 ,ORG_ID IN NUMBER
353 ,SUBINV IN CHAR
354 ,INCLUDE_NONNET IN NUMBER) RETURN NUMBER;
355
356 FUNCTION GET_SUPPLY(SUPPLY_CUTOFF_DATE IN DATE
357 ,ORG_ID IN NUMBER
358 ,CURRENT_ITEM_ID IN NUMBER
359 ,INCLUDE_PO IN NUMBER
360 ,INCLUDE_NONNET IN NUMBER
361 ,INCLUDE_WIP IN NUMBER
362 ,INCLUDE_IF IN NUMBER
363 ,SUBINV IN CHAR) RETURN NUMBER;
364
365 END MRP_MRPRPROP_XMLP_PKG;
366