[Home] [Help]
PACKAGE BODY: APPS.CSP_PLANNING_PARAMETERS_PKG
Source
1 PACKAGE BODY CSP_PLANNING_PARAMETERS_PKG as
2 /* $Header: csptpprb.pls 120.3 2007/12/09 20:32:12 hhaugeru ship $ */
3 -- Start of Comments
4 -- Package name : CSP_PLANNING_PARAMETERS_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_PLANNING_PARAMETERS_PKG';
11 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csptpprb.pls';
12 PROCEDURE Insert_Row(
13 px_PLANNING_PARAMETERS_ID NUMBER
14 ,p_CREATED_BY NUMBER
15 ,p_CREATION_DATE DATE
16 ,p_LAST_UPDATED_BY NUMBER
17 ,p_LAST_UPDATE_DATE DATE
18 ,p_LAST_UPDATE_LOGIN NUMBER
19 ,p_FORECAST_RULE_ID NUMBER
20 ,p_ORGANIZATION_TYPE VARCHAR2
21 ,p_ORGANIZATION_ID NUMBER
22 ,p_SECONDARY_INVENTORY VARCHAR2
23 ,p_SERVICE_LEVEL NUMBER
24 ,p_EDQ_FACTOR NUMBER
25 ,p_PLANNER_CODE VARCHAR2
26 ,p_CONDITION_TYPE VARCHAR2
27 ,p_ASL_FLAG VARCHAR2
28 ,p_SAFETY_STOCK_FLAG VARCHAR2
29 ,p_EXCESS_RULE_ID NUMBER
30 ,p_NOTIFICATION_RULE_ID NUMBER
31 ,p_RECOMMENDATION_RULE_ID NUMBER
32 ,p_ATTRIBUTE_CATEGORY VARCHAR2
33 ,p_ATTRIBUTE1 VARCHAR2
34 ,p_ATTRIBUTE2 VARCHAR2
35 ,p_ATTRIBUTE3 VARCHAR2
36 ,p_ATTRIBUTE4 VARCHAR2
37 ,p_ATTRIBUTE5 VARCHAR2
38 ,p_ATTRIBUTE6 VARCHAR2
39 ,p_ATTRIBUTE7 VARCHAR2
40 ,p_ATTRIBUTE8 VARCHAR2
41 ,p_ATTRIBUTE9 VARCHAR2
42 ,p_ATTRIBUTE10 VARCHAR2
43 ,p_ATTRIBUTE11 VARCHAR2
44 ,p_ATTRIBUTE12 VARCHAR2
45 ,p_ATTRIBUTE13 VARCHAR2
46 ,p_ATTRIBUTE14 VARCHAR2
47 ,p_ATTRIBUTE15 VARCHAR2
48 ,p_CATEGORY_SET_ID NUMBER
49 ,p_CATEGORY_ID NUMBER
50 ,p_RECOMMEND_METHOD VARCHAR2
51 ,p_EDQ_MULTIPLE NUMBER
52 ,p_MINIMUM_VALUE NUMBER
53 ,p_USABLE_ASSIGNMENT_SET_ID NUMBER
54 ,p_DEFECTIVE_ASSIGNMENT_SET_ID NUMBER
55 ,p_REPAIR_ASSIGNMENT_SET_ID NUMBER
56 ,p_PRODUCT_NORM VARCHAR2
57 ,P_PRODUCT_NORM_NODE_ID NUMBER
58 ,P_USAGE_WEIGHT1 NUMBER
59 ,P_USAGE_WEIGHT2 NUMBER
60 ,P_USAGE_WEIGHT3 NUMBER
61 ,P_USAGE_WEIGHT4 NUMBER
62 ,p_DEFAULT_FORECAST_RULE_ID VARCHAR2
63 ,p_DEFAULT_SERVICE_LEVEL VARCHAR2
64 ,p_DEFAULT_EDQ_FACTOR VARCHAR2
65 ,p_DEFAULT_PLANNER_CODE VARCHAR2
66 ,p_DEFAULT_CONDITION_TYPE VARCHAR2
67 ,p_DEFAULT_ASL_FLAG VARCHAR2
68 ,p_DEFAULT_SAFETY_STOCK_FLAG VARCHAR2
69 ,p_DEFAULT_EXCESS_RULE_ID VARCHAR2
70 ,p_DEFAULT_CATEGORY_SET_ID VARCHAR2
71 ,p_DEFAULT_CATEGORY_ID VARCHAR2
72 ,p_DEFAULT_RECOMMEND_METHOD VARCHAR2
73 ,P_DEFAULT_PRODUCT_NORM_NODE_ID VARCHAR2
74 ,P_DEFAULT_USAGE_WEIGHT1 VARCHAR2
75 ,P_DEFAULT_USAGE_WEIGHT2 VARCHAR2
76 ,P_DEFAULT_USAGE_WEIGHT3 VARCHAR2
77 ,P_DEFAULT_USAGE_WEIGHT4 VARCHAR2
78 ,P_DEFAULT_REC_RULE_ID VARCHAR2
79 ,p_OVERRIDE_FORECAST_RULE_ID VARCHAR2
80 ,p_OVERRIDE_SERVICE_LEVEL VARCHAR2
81 ,p_OVERRIDE_EDQ_FACTOR VARCHAR2
82 ,p_OVERRIDE_PLANNER_CODE VARCHAR2
83 ,p_OVERRIDE_CONDITION_TYPE VARCHAR2
84 ,p_OVERRIDE_ASL_FLAG VARCHAR2
85 ,p_OVERRIDE_SAFETY_STOCK_FLAG VARCHAR2
86 ,p_OVERRIDE_EXCESS_RULE_ID VARCHAR2
87 ,p_OVERRIDE_CATEGORY_SET_ID VARCHAR2
88 ,p_OVERRIDE_CATEGORY_ID VARCHAR2
89 ,p_OVERRIDE_RECOMMEND_METHOD VARCHAR2
90 ,P_OVERRIDE_USAGE_WEIGHT1 VARCHAR2
91 ,P_OVERRIDE_USAGE_WEIGHT2 VARCHAR2
92 ,P_OVERRIDE_USAGE_WEIGHT3 VARCHAR2
93 ,P_OVERRIDE_USAGE_WEIGHT4 VARCHAR2
94 ,P_OVERRIDE_REC_RULE_ID VARCHAR2
95 ,p_NODE_TYPE VARCHAR2
96 ,p_NODE_NAME VARCHAR2
97 ,p_PARENT_NODE_ID NUMBER
98 ,p_LEVEL_ID VARCHAR2
99 ,p_EXCESS_EDQ_FACTOR VARCHAR2
100 ,p_REPAIR_EDQ_FACTOR VARCHAR2
101 ,p_NEWBUY_EDQ_FACTOR VARCHAR2
102 ,p_EXCESS_SERVICE_LEVEL VARCHAR2
103 ,p_REPAIR_SERVICE_LEVEL VARCHAR2
104 ,p_NEWBUY_SERVICE_LEVEL VARCHAR2
105 ,p_RESCHEDULE_RULE_ID NUMBER
106 ,p_WRP_RULE_ID NUMBER)
107 IS
108 p_PLANNING_PARAMETERS_ID Number;
109 CURSOR C2 IS SELECT CSP_PLANNING_PARAMETERS_S1.nextval FROM sys.dual;
110 BEGIN
111
112 If (px_PLANNING_PARAMETERS_ID IS NULL) OR (px_PLANNING_PARAMETERS_ID = FND_API.G_MISS_NUM) then
113 OPEN C2;
114 FETCH C2 INTO p_PLANNING_PARAMETERS_ID;
115 CLOSE C2;
116 End If;
117
118 INSERT INTO CSP_PLANNING_PARAMETERS(
119 PLANNING_PARAMETERS_ID
120 ,CREATED_BY
121 ,CREATION_DATE
122 ,LAST_UPDATED_BY
123 ,LAST_UPDATE_DATE
124 ,LAST_UPDATE_LOGIN
125 ,FORECAST_RULE_ID
126 ,ORGANIZATION_TYPE
127 ,ORGANIZATION_ID
128 ,SECONDARY_INVENTORY
129 ,SERVICE_LEVEL
130 ,EDQ_FACTOR
131 ,PLANNER_CODE
132 ,CONDITION_TYPE
133 ,ASL_FLAG
134 ,SAFETY_STOCK_FLAG
135 ,EXCESS_RULE_ID
136 ,NOTIFICATION_RULE_ID
137 ,RECOMMENDATION_RULE_ID
138 ,ATTRIBUTE_CATEGORY
139 ,ATTRIBUTE1
140 ,ATTRIBUTE2
141 ,ATTRIBUTE3
142 ,ATTRIBUTE4
143 ,ATTRIBUTE5
144 ,ATTRIBUTE6
145 ,ATTRIBUTE7
146 ,ATTRIBUTE8
147 ,ATTRIBUTE9
148 ,ATTRIBUTE10
149 ,ATTRIBUTE11
150 ,ATTRIBUTE12
151 ,ATTRIBUTE13
152 ,ATTRIBUTE14
153 ,ATTRIBUTE15
154 ,CATEGORY_SET_ID
155 ,CATEGORY_ID
156 ,RECOMMEND_METHOD
157 ,EDQ_MULTIPLE
158 ,MINIMUM_VALUE
159 ,USABLE_ASSIGNMENT_SET_ID
160 ,DEFECTIVE_ASSIGNMENT_SET_ID
161 ,REPAIR_ASSIGNMENT_SET_ID
162 ,PRODUCT_NORM
163 ,PRODUCT_NORM_NODE_ID
164 ,USAGE_WEIGHT1
165 ,USAGE_WEIGHT2
166 ,USAGE_WEIGHT3
167 ,USAGE_WEIGHT4
168 ,DEFAULT_FORECAST_RULE_ID
169 ,DEFAULT_SERVICE_LEVEL
170 ,DEFAULT_EDQ_FACTOR
171 ,DEFAULT_PLANNER_CODE
172 ,DEFAULT_CONDITION_TYPE
173 ,DEFAULT_ASL_FLAG
174 ,DEFAULT_SAFETY_STOCK_FLAG
175 ,DEFAULT_EXCESS_RULE_ID
176 ,DEFAULT_CATEGORY_SET_ID
177 ,DEFAULT_CATEGORY_ID
178 ,DEFAULT_RECOMMEND_METHOD
179 ,DEFAULT_PRODUCT_NORM_NODE_ID
180 ,DEFAULT_USAGE_WEIGHT1
181 ,DEFAULT_USAGE_WEIGHT2
182 ,DEFAULT_USAGE_WEIGHT3
183 ,DEFAULT_USAGE_WEIGHT4
184 ,DEFAULT_REC_RULE_ID
185 ,OVERRIDE_FORECAST_RULE_ID
186 ,OVERRIDE_SERVICE_LEVEL
187 ,OVERRIDE_EDQ_FACTOR
188 ,OVERRIDE_PLANNER_CODE
189 ,OVERRIDE_CONDITION_TYPE
190 ,OVERRIDE_ASL_FLAG
191 ,OVERRIDE_SAFETY_STOCK_FLAG
192 ,OVERRIDE_EXCESS_RULE_ID
193 ,OVERRIDE_CATEGORY_SET_ID
194 ,OVERRIDE_CATEGORY_ID
195 ,OVERRIDE_RECOMMEND_METHOD
196 ,OVERRIDE_USAGE_WEIGHT1
197 ,OVERRIDE_USAGE_WEIGHT2
198 ,OVERRIDE_USAGE_WEIGHT3
199 ,OVERRIDE_USAGE_WEIGHT4
200 ,OVERRIDE_REC_RULE_ID
201 ,NODE_TYPE
202 ,NODE_NAME
203 ,PARENT_NODE_ID
204 ,LEVEL_ID
205 ,EXCESS_EDQ_FACTOR
206 ,REPAIR_EDQ_FACTOR
207 ,NEWBUY_EDQ_FACTOR
208 ,EXCESS_SERVICE_LEVEL
209 ,REPAIR_SERVICE_LEVEL
210 ,NEWBUY_SERVICE_LEVEL
211 ,RESCHEDULE_RULE_ID
212 ,WRP_RULE_ID
213 ) VALUES (
214 nvl(px_PLANNING_PARAMETERS_ID,p_PLANNING_PARAMETERS_ID)
215 ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
216 ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
217 ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
218 ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
219 ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
220 ,decode( p_FORECAST_RULE_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_RULE_ID)
221 ,decode( p_ORGANIZATION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ORGANIZATION_TYPE)
222 ,decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID)
223 ,decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SECONDARY_INVENTORY)
224 ,decode( p_SERVICE_LEVEL, FND_API.G_MISS_NUM, NULL, p_SERVICE_LEVEL)
225 ,decode( p_EDQ_FACTOR, FND_API.G_MISS_NUM, NULL, p_EDQ_FACTOR)
226 ,decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_PLANNER_CODE)
227 ,decode( p_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_CONDITION_TYPE)
228 ,decode( p_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_ASL_FLAG)
229 ,decode( p_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_SAFETY_STOCK_FLAG)
230 ,decode( p_EXCESS_RULE_ID, FND_API.G_MISS_NUM, NULL, p_EXCESS_RULE_ID)
231 ,decode( p_NOTIFICATION_RULE_ID, FND_API.G_MISS_NUM, NULL, p_NOTIFICATION_RULE_ID)
232 ,decode( p_RECOMMENDATION_RULE_ID, FND_API.G_MISS_NUM, NULL, p_RECOMMENDATION_RULE_ID)
233 ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
234 ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
235 ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
236 ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
237 ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
238 ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
239 ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
240 ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
241 ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
242 ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
243 ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
244 ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
245 ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
246 ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
247 ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
248 ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
249 ,decode( p_CATEGORY_SET_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_SET_ID)
250 ,decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_ID)
251 ,decode( p_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_RECOMMEND_METHOD)
252 ,decode( p_EDQ_MULTIPLE, FND_API.G_MISS_NUM, NULL, p_EDQ_MULTIPLE)
253 ,decode( p_MINIMUM_VALUE, FND_API.G_MISS_NUM, NULL, p_MINIMUM_VALUE)
254 ,decode( p_USABLE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_USABLE_ASSIGNMENT_SET_ID)
255 ,decode( p_DEFECTIVE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_DEFECTIVE_ASSIGNMENT_SET_ID)
256 ,decode( p_REPAIR_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_ASSIGNMENT_SET_ID)
257 ,decode( p_PRODUCT_NORM, FND_API.G_MISS_CHAR, NULL, p_PRODUCT_NORM)
258 ,decode( p_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_NUM, NULL, p_PRODUCT_NORM_NODE_ID)
259 ,decode( p_USAGE_WEIGHT1, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT1)
260 ,decode( p_USAGE_WEIGHT2, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT2)
261 ,decode( p_USAGE_WEIGHT3, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT3)
262 ,decode( p_USAGE_WEIGHT4, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT4)
263 ,decode( p_DEFAULT_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_FORECAST_RULE_ID)
264 ,decode( p_DEFAULT_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_SERVICE_LEVEL)
265 ,decode( p_DEFAULT_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_EDQ_FACTOR)
266 ,decode( p_DEFAULT_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_PLANNER_CODE)
267 ,decode( p_DEFAULT_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CONDITION_TYPE)
268 ,decode( p_DEFAULT_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_ASL_FLAG)
269 ,decode( p_DEFAULT_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_SAFETY_STOCK_FLAG)
270 ,decode( p_DEFAULT_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_EXCESS_RULE_ID)
271 ,decode( p_DEFAULT_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CATEGORY_SET_ID)
272 ,decode( p_DEFAULT_CATEGORY_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CATEGORY_ID)
273 ,decode( p_DEFAULT_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_RECOMMEND_METHOD)
274 ,decode( p_DEFAULT_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_PRODUCT_NORM_NODE_ID)
275 ,decode( p_DEFAULT_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT1)
276 ,decode( p_DEFAULT_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT2)
277 ,decode( p_DEFAULT_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT3)
278 ,decode( p_DEFAULT_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT4)
279 ,decode( p_DEFAULT_REC_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_REC_RULE_ID)
280 ,decode( p_OVERRIDE_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_FORECAST_RULE_ID)
281 ,decode( p_OVERRIDE_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_SERVICE_LEVEL)
282 ,decode( p_OVERRIDE_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_EDQ_FACTOR)
283 ,decode( p_OVERRIDE_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_PLANNER_CODE)
284 ,decode( p_OVERRIDE_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CONDITION_TYPE)
285 ,decode( p_OVERRIDE_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_ASL_FLAG)
286 ,decode( p_OVERRIDE_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_SAFETY_STOCK_FLAG)
287 ,decode( p_OVERRIDE_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_EXCESS_RULE_ID)
288 ,decode( p_OVERRIDE_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CATEGORY_SET_ID)
289 ,decode( p_OVERRIDE_CATEGORY_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CATEGORY_ID)
290 ,decode( p_OVERRIDE_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_RECOMMEND_METHOD)
291 ,decode( p_OVERRIDE_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT1)
292 ,decode( p_OVERRIDE_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT2)
293 ,decode( p_OVERRIDE_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT3)
294 ,decode( p_OVERRIDE_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT4)
295 ,decode( p_OVERRIDE_REC_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_REC_RULE_ID)
296 ,decode( p_NODE_TYPE, FND_API.G_MISS_CHAR, NULL, p_NODE_TYPE)
297 ,decode( p_NODE_NAME, FND_API.G_MISS_CHAR, NULL, p_NODE_NAME)
298 ,decode( p_PARENT_NODE_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_NODE_ID)
299 ,decode( p_LEVEL_ID, FND_API.G_MISS_CHAR, NULL, p_LEVEL_ID)
300 ,decode( p_EXCESS_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_EXCESS_EDQ_FACTOR)
301 ,decode( p_REPAIR_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_REPAIR_EDQ_FACTOR)
305 ,decode( p_NEWBUY_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_NEWBUY_SERVICE_LEVEL)
302 ,decode( p_NEWBUY_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_NEWBUY_EDQ_FACTOR)
303 ,decode( p_EXCESS_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_EXCESS_SERVICE_LEVEL)
304 ,decode( p_REPAIR_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_REPAIR_SERVICE_LEVEL)
306 ,decode( p_RESCHEDULE_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_RESCHEDULE_RULE_ID)
307 ,decode( p_WRP_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_WRP_RULE_ID));
308 End Insert_Row;
309
310 PROCEDURE Update_Row(
311 p_PLANNING_PARAMETERS_ID NUMBER
312 ,p_CREATED_BY NUMBER
313 ,p_CREATION_DATE DATE
314 ,p_LAST_UPDATED_BY NUMBER
315 ,p_LAST_UPDATE_DATE DATE
316 ,p_LAST_UPDATE_LOGIN NUMBER
317 ,p_FORECAST_RULE_ID NUMBER
318 ,p_ORGANIZATION_TYPE VARCHAR2
319 ,p_ORGANIZATION_ID NUMBER
320 ,p_SECONDARY_INVENTORY VARCHAR2
321 ,p_SERVICE_LEVEL NUMBER
322 ,p_EDQ_FACTOR NUMBER
323 ,p_PLANNER_CODE VARCHAR2
324 ,p_CONDITION_TYPE VARCHAR2
325 ,p_ASL_FLAG VARCHAR2
326 ,p_SAFETY_STOCK_FLAG VARCHAR2
327 ,p_EXCESS_RULE_ID NUMBER
328 ,p_NOTIFICATION_RULE_ID NUMBER
329 ,p_RECOMMENDATION_RULE_ID NUMBER
330 ,p_ATTRIBUTE_CATEGORY VARCHAR2
331 ,p_ATTRIBUTE1 VARCHAR2
332 ,p_ATTRIBUTE2 VARCHAR2
333 ,p_ATTRIBUTE3 VARCHAR2
334 ,p_ATTRIBUTE4 VARCHAR2
335 ,p_ATTRIBUTE5 VARCHAR2
336 ,p_ATTRIBUTE6 VARCHAR2
337 ,p_ATTRIBUTE7 VARCHAR2
338 ,p_ATTRIBUTE8 VARCHAR2
339 ,p_ATTRIBUTE9 VARCHAR2
340 ,p_ATTRIBUTE10 VARCHAR2
341 ,p_ATTRIBUTE11 VARCHAR2
342 ,p_ATTRIBUTE12 VARCHAR2
343 ,p_ATTRIBUTE13 VARCHAR2
344 ,p_ATTRIBUTE14 VARCHAR2
345 ,p_ATTRIBUTE15 VARCHAR2
346 ,p_CATEGORY_SET_ID NUMBER
347 ,p_CATEGORY_ID NUMBER
348 ,p_RECOMMEND_METHOD VARCHAR2
349 ,p_EDQ_MULTIPLE NUMBER
350 ,p_MINIMUM_VALUE NUMBER
351 ,p_USABLE_ASSIGNMENT_SET_ID NUMBER
352 ,p_DEFECTIVE_ASSIGNMENT_SET_ID NUMBER
353 ,p_REPAIR_ASSIGNMENT_SET_ID NUMBER
354 ,p_PRODUCT_NORM VARCHAR2
355 ,P_PRODUCT_NORM_NODE_ID NUMBER
356 ,P_USAGE_WEIGHT1 NUMBER
357 ,P_USAGE_WEIGHT2 NUMBER
358 ,P_USAGE_WEIGHT3 NUMBER
359 ,P_USAGE_WEIGHT4 NUMBER
360 ,p_DEFAULT_FORECAST_RULE_ID VARCHAR2
361 ,p_DEFAULT_SERVICE_LEVEL VARCHAR2
362 ,p_DEFAULT_EDQ_FACTOR VARCHAR2
363 ,p_DEFAULT_PLANNER_CODE VARCHAR2
364 ,p_DEFAULT_CONDITION_TYPE VARCHAR2
365 ,p_DEFAULT_ASL_FLAG VARCHAR2
366 ,p_DEFAULT_SAFETY_STOCK_FLAG VARCHAR2
367 ,p_DEFAULT_EXCESS_RULE_ID VARCHAR2
368 ,p_DEFAULT_CATEGORY_SET_ID VARCHAR2
369 ,p_DEFAULT_CATEGORY_ID VARCHAR2
370 ,p_DEFAULT_RECOMMEND_METHOD VARCHAR2
371 ,P_DEFAULT_PRODUCT_NORM_NODE_ID VARCHAR2
372 ,P_DEFAULT_USAGE_WEIGHT1 VARCHAR2
373 ,P_DEFAULT_USAGE_WEIGHT2 VARCHAR2
374 ,P_DEFAULT_USAGE_WEIGHT3 VARCHAR2
375 ,P_DEFAULT_USAGE_WEIGHT4 VARCHAR2
376 ,P_DEFAULT_REC_RULE_ID VARCHAR2
377 ,p_OVERRIDE_FORECAST_RULE_ID VARCHAR2
378 ,p_OVERRIDE_SERVICE_LEVEL VARCHAR2
379 ,p_OVERRIDE_EDQ_FACTOR VARCHAR2
380 ,p_OVERRIDE_PLANNER_CODE VARCHAR2
381 ,p_OVERRIDE_CONDITION_TYPE VARCHAR2
382 ,p_OVERRIDE_ASL_FLAG VARCHAR2
383 ,p_OVERRIDE_SAFETY_STOCK_FLAG VARCHAR2
384 ,p_OVERRIDE_EXCESS_RULE_ID VARCHAR2
385 ,p_OVERRIDE_CATEGORY_SET_ID VARCHAR2
386 ,p_OVERRIDE_CATEGORY_ID VARCHAR2
387 ,p_OVERRIDE_RECOMMEND_METHOD VARCHAR2
388 ,P_OVERRIDE_USAGE_WEIGHT1 VARCHAR2
389 ,P_OVERRIDE_USAGE_WEIGHT2 VARCHAR2
390 ,P_OVERRIDE_USAGE_WEIGHT3 VARCHAR2
391 ,P_OVERRIDE_USAGE_WEIGHT4 VARCHAR2
392 ,P_OVERRIDE_REC_RULE_ID VARCHAR2
393 ,p_NODE_TYPE VARCHAR2
394 ,p_NODE_NAME VARCHAR2
395 ,p_PARENT_NODE_ID NUMBER
396 ,p_LEVEL_ID VARCHAR2
397 ,p_EXCESS_EDQ_FACTOR VARCHAR2
398 ,p_REPAIR_EDQ_FACTOR VARCHAR2
399 ,p_NEWBUY_EDQ_FACTOR VARCHAR2
400 ,p_EXCESS_SERVICE_LEVEL VARCHAR2
401 ,p_REPAIR_SERVICE_LEVEL VARCHAR2
402 ,p_NEWBUY_SERVICE_LEVEL VARCHAR2
403 ,p_RESCHEDULE_RULE_ID NUMBER
404 ,p_WRP_RULE_ID NUMBER)
405 IS
406 BEGIN
407 Update CSP_PLANNING_PARAMETERS
408 SET
409 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
410 ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
411 ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
412 ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
413 ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
414 ,FORECAST_RULE_ID = decode( p_FORECAST_RULE_ID, FND_API.G_MISS_NUM, FORECAST_RULE_ID, p_FORECAST_RULE_ID)
418 ,SERVICE_LEVEL = decode( p_SERVICE_LEVEL, FND_API.G_MISS_NUM, SERVICE_LEVEL, p_SERVICE_LEVEL)
415 ,ORGANIZATION_TYPE = decode( p_ORGANIZATION_TYPE, FND_API.G_MISS_CHAR, ORGANIZATION_TYPE, p_ORGANIZATION_TYPE)
416 ,ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID)
417 ,SECONDARY_INVENTORY = decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, SECONDARY_INVENTORY, p_SECONDARY_INVENTORY)
419 ,EDQ_FACTOR = decode( p_EDQ_FACTOR, FND_API.G_MISS_NUM, EDQ_FACTOR, p_EDQ_FACTOR)
420 ,PLANNER_CODE = decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, PLANNER_CODE, p_PLANNER_CODE)
421 ,CONDITION_TYPE = decode( p_CONDITION_TYPE, FND_API.G_MISS_CHAR, CONDITION_TYPE, p_CONDITION_TYPE)
422 ,ASL_FLAG = decode( p_ASL_FLAG, FND_API.G_MISS_CHAR, ASL_FLAG, p_ASL_FLAG)
423 ,SAFETY_STOCK_FLAG = decode( p_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, SAFETY_STOCK_FLAG, p_SAFETY_STOCK_FLAG)
424 ,EXCESS_RULE_ID = decode( p_EXCESS_RULE_ID, FND_API.G_MISS_NUM, EXCESS_RULE_ID, p_EXCESS_RULE_ID)
425 ,NOTIFICATION_RULE_ID = decode( p_NOTIFICATION_RULE_ID, FND_API.G_MISS_NUM, NOTIFICATION_RULE_ID, p_NOTIFICATION_RULE_ID)
426 ,RECOMMENDATION_RULE_ID = decode( p_RECOMMENDATION_RULE_ID, FND_API.G_MISS_NUM, RECOMMENDATION_RULE_ID, p_RECOMMENDATION_RULE_ID)
427 ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
428 ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
429 ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
430 ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
431 ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
432 ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
433 ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
434 ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
435 ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
436 ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
437 ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
438 ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
439 ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
440 ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
441 ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
442 ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
443 ,CATEGORY_SET_ID = decode( p_CATEGORY_SET_ID, FND_API.G_MISS_NUM, CATEGORY_SET_ID, p_CATEGORY_SET_ID)
444 ,CATEGORY_ID = decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, CATEGORY_ID, p_CATEGORY_ID)
445 ,RECOMMEND_METHOD = decode( p_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, RECOMMEND_METHOD, p_RECOMMEND_METHOD)
446 ,EDQ_MULTIPLE = decode( p_EDQ_MULTIPLE, FND_API.G_MISS_NUM, EDQ_MULTIPLE, p_EDQ_MULTIPLE)
447 ,MINIMUM_VALUE = decode( p_MINIMUM_VALUE, FND_API.G_MISS_NUM, MINIMUM_VALUE, p_MINIMUM_VALUE)
448 ,USABLE_ASSIGNMENT_SET_ID = decode( p_USABLE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, USABLE_ASSIGNMENT_SET_ID, p_USABLE_ASSIGNMENT_SET_ID)
449 ,DEFECTIVE_ASSIGNMENT_SET_ID = decode( p_DEFECTIVE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, DEFECTIVE_ASSIGNMENT_SET_ID, p_DEFECTIVE_ASSIGNMENT_SET_ID)
450 ,REPAIR_ASSIGNMENT_SET_ID = decode( p_REPAIR_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, REPAIR_ASSIGNMENT_SET_ID, p_REPAIR_ASSIGNMENT_SET_ID)
451 ,PRODUCT_NORM = decode( p_PRODUCT_NORM, FND_API.G_MISS_CHAR, PRODUCT_NORM, p_PRODUCT_NORM)
452 ,PRODUCT_NORM_NODE_ID = decode( p_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_NUM, PRODUCT_NORM_NODE_ID, p_PRODUCT_NORM_NODE_ID)
453 ,USAGE_WEIGHT1 = decode( p_USAGE_WEIGHT1, FND_API.G_MISS_NUM, USAGE_WEIGHT1, p_USAGE_WEIGHT1)
454 ,USAGE_WEIGHT2 = decode( p_USAGE_WEIGHT2, FND_API.G_MISS_NUM, USAGE_WEIGHT2, p_USAGE_WEIGHT2)
455 ,USAGE_WEIGHT3 = decode( p_USAGE_WEIGHT3, FND_API.G_MISS_NUM, USAGE_WEIGHT3, p_USAGE_WEIGHT3)
456 ,USAGE_WEIGHT4 = decode( p_USAGE_WEIGHT4, FND_API.G_MISS_NUM, USAGE_WEIGHT4, p_USAGE_WEIGHT4)
457 ,DEFAULT_FORECAST_RULE_ID = decode( p_DEFAULT_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_FORECAST_RULE_ID, p_DEFAULT_FORECAST_RULE_ID)
458 ,DEFAULT_SERVICE_LEVEL = decode( p_DEFAULT_SERVICE_LEVEL, FND_API.G_MISS_CHAR, DEFAULT_SERVICE_LEVEL, p_DEFAULT_SERVICE_LEVEL)
459 ,DEFAULT_EDQ_FACTOR = decode( p_DEFAULT_EDQ_FACTOR, FND_API.G_MISS_CHAR, DEFAULT_EDQ_FACTOR, p_DEFAULT_EDQ_FACTOR)
460 ,DEFAULT_PLANNER_CODE = decode( p_DEFAULT_PLANNER_CODE, FND_API.G_MISS_CHAR, DEFAULT_PLANNER_CODE, p_DEFAULT_PLANNER_CODE)
461 ,DEFAULT_CONDITION_TYPE = decode( p_DEFAULT_CONDITION_TYPE, FND_API.G_MISS_CHAR, DEFAULT_CONDITION_TYPE, p_DEFAULT_CONDITION_TYPE)
462 ,DEFAULT_ASL_FLAG = decode( p_DEFAULT_ASL_FLAG, FND_API.G_MISS_CHAR, DEFAULT_ASL_FLAG, p_DEFAULT_ASL_FLAG)
463 ,DEFAULT_SAFETY_STOCK_FLAG = decode( p_DEFAULT_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, DEFAULT_SAFETY_STOCK_FLAG, p_DEFAULT_SAFETY_STOCK_FLAG)
464 ,DEFAULT_EXCESS_RULE_ID = decode( p_DEFAULT_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_EXCESS_RULE_ID, p_DEFAULT_EXCESS_RULE_ID)
465 ,DEFAULT_CATEGORY_SET_ID = decode( p_DEFAULT_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, DEFAULT_CATEGORY_SET_ID, p_DEFAULT_CATEGORY_SET_ID)
466 ,DEFAULT_CATEGORY_ID = decode( p_DEFAULT_CATEGORY_ID, FND_API.G_MISS_CHAR, DEFAULT_CATEGORY_ID, p_DEFAULT_CATEGORY_ID)
467 ,DEFAULT_RECOMMEND_METHOD = decode( p_DEFAULT_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, DEFAULT_RECOMMEND_METHOD, p_DEFAULT_RECOMMEND_METHOD)
468 ,DEFAULT_PRODUCT_NORM_NODE_ID = decode( p_DEFAULT_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_CHAR, DEFAULT_PRODUCT_NORM_NODE_ID, p_DEFAULT_PRODUCT_NORM_NODE_ID)
472 ,DEFAULT_USAGE_WEIGHT4 = decode( p_DEFAULT_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT4, p_DEFAULT_USAGE_WEIGHT4)
469 ,DEFAULT_USAGE_WEIGHT1 = decode( p_DEFAULT_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT1, p_DEFAULT_USAGE_WEIGHT1)
470 ,DEFAULT_USAGE_WEIGHT2 = decode( p_DEFAULT_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT2, p_DEFAULT_USAGE_WEIGHT2)
471 ,DEFAULT_USAGE_WEIGHT3 = decode( p_DEFAULT_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT3, p_DEFAULT_USAGE_WEIGHT3)
473 ,DEFAULT_REC_RULE_ID = decode( p_DEFAULT_REC_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_REC_RULE_ID, p_DEFAULT_REC_RULE_ID)
474 ,OVERRIDE_FORECAST_RULE_ID = decode( p_OVERRIDE_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_FORECAST_RULE_ID, p_OVERRIDE_FORECAST_RULE_ID)
475 ,OVERRIDE_SERVICE_LEVEL = decode( p_OVERRIDE_SERVICE_LEVEL, FND_API.G_MISS_CHAR, OVERRIDE_SERVICE_LEVEL, p_OVERRIDE_SERVICE_LEVEL)
476 ,OVERRIDE_EDQ_FACTOR = decode( p_OVERRIDE_EDQ_FACTOR, FND_API.G_MISS_CHAR, OVERRIDE_EDQ_FACTOR, p_OVERRIDE_EDQ_FACTOR)
477 ,OVERRIDE_PLANNER_CODE = decode( p_OVERRIDE_PLANNER_CODE, FND_API.G_MISS_CHAR, OVERRIDE_PLANNER_CODE, p_OVERRIDE_PLANNER_CODE)
478 ,OVERRIDE_CONDITION_TYPE = decode( p_OVERRIDE_CONDITION_TYPE, FND_API.G_MISS_CHAR, OVERRIDE_CONDITION_TYPE, p_OVERRIDE_CONDITION_TYPE)
479 ,OVERRIDE_ASL_FLAG = decode( p_OVERRIDE_ASL_FLAG, FND_API.G_MISS_CHAR, OVERRIDE_ASL_FLAG, p_OVERRIDE_ASL_FLAG)
480 ,OVERRIDE_SAFETY_STOCK_FLAG = decode( p_OVERRIDE_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, OVERRIDE_SAFETY_STOCK_FLAG, p_OVERRIDE_SAFETY_STOCK_FLAG)
481 ,OVERRIDE_EXCESS_RULE_ID = decode( p_OVERRIDE_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_EXCESS_RULE_ID, p_OVERRIDE_EXCESS_RULE_ID)
482 ,OVERRIDE_CATEGORY_SET_ID = decode( p_OVERRIDE_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, OVERRIDE_CATEGORY_SET_ID, p_OVERRIDE_CATEGORY_SET_ID)
483 ,OVERRIDE_CATEGORY_ID = decode( p_OVERRIDE_CATEGORY_ID, FND_API.G_MISS_CHAR, OVERRIDE_CATEGORY_ID, p_OVERRIDE_CATEGORY_ID)
484 ,OVERRIDE_RECOMMEND_METHOD = decode( p_OVERRIDE_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, OVERRIDE_RECOMMEND_METHOD, p_OVERRIDE_RECOMMEND_METHOD)
485 ,OVERRIDE_USAGE_WEIGHT1 = decode( p_OVERRIDE_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT1, p_OVERRIDE_USAGE_WEIGHT1)
486 ,OVERRIDE_USAGE_WEIGHT2 = decode( p_OVERRIDE_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT2, p_OVERRIDE_USAGE_WEIGHT2)
487 ,OVERRIDE_USAGE_WEIGHT3 = decode( p_OVERRIDE_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT3, p_OVERRIDE_USAGE_WEIGHT3)
488 ,OVERRIDE_USAGE_WEIGHT4 = decode( p_OVERRIDE_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT4, p_OVERRIDE_USAGE_WEIGHT4)
489 ,OVERRIDE_REC_RULE_ID = decode( p_OVERRIDE_REC_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_REC_RULE_ID, p_OVERRIDE_REC_RULE_ID)
490 ,NODE_TYPE = decode( p_NODE_TYPE, FND_API.G_MISS_CHAR, NODE_TYPE, p_NODE_TYPE)
491 ,NODE_NAME = decode( p_NODE_NAME, FND_API.G_MISS_CHAR, NODE_NAME, p_NODE_NAME)
492 ,PARENT_NODE_ID = decode( p_PARENT_NODE_ID, FND_API.G_MISS_NUM, PARENT_NODE_ID, p_PARENT_NODE_ID)
493 ,EXCESS_EDQ_FACTOR = decode( p_EXCESS_EDQ_FACTOR, FND_API.G_MISS_CHAR, EXCESS_EDQ_FACTOR, p_EXCESS_EDQ_FACTOR)
494 ,REPAIR_EDQ_FACTOR = decode( p_REPAIR_EDQ_FACTOR, FND_API.G_MISS_CHAR, REPAIR_EDQ_FACTOR, p_REPAIR_EDQ_FACTOR)
495 ,NEWBUY_EDQ_FACTOR = decode( p_NEWBUY_EDQ_FACTOR, FND_API.G_MISS_CHAR, NEWBUY_EDQ_FACTOR, p_NEWBUY_EDQ_FACTOR)
496 ,EXCESS_SERVICE_LEVEL = decode( p_EXCESS_SERVICE_LEVEL, FND_API.G_MISS_CHAR, EXCESS_SERVICE_LEVEL, p_EXCESS_SERVICE_LEVEL)
497 ,REPAIR_SERVICE_LEVEL = decode( p_REPAIR_SERVICE_LEVEL, FND_API.G_MISS_CHAR, REPAIR_SERVICE_LEVEL, p_REPAIR_SERVICE_LEVEL)
498 ,NEWBUY_SERVICE_LEVEL = decode( p_NEWBUY_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NEWBUY_SERVICE_LEVEL, p_NEWBUY_SERVICE_LEVEL)
499 ,RESCHEDULE_RULE_ID = decode( p_RESCHEDULE_RULE_ID, FND_API.G_MISS_NUM, RESCHEDULE_RULE_ID, p_RESCHEDULE_RULE_ID)
500 ,WRP_RULE_ID = decode( p_WRP_RULE_ID, FND_API.G_MISS_NUM, WRP_RULE_ID, p_WRP_RULE_ID)
501 where PLANNING_PARAMETERS_ID = p_PLANNING_PARAMETERS_ID;
502 If (SQL%NOTFOUND) then
503 RAISE NO_DATA_FOUND;
504 End If;
505 END Update_Row;
506
507 PROCEDURE Delete_Row( p_LEVEL_ID VARCHAR2)
508 IS
509 BEGIN
510 DELETE FROM CSP_PLANNING_PARAMETERS
511 -- WHERE PLANNING_PARAMETERS_ID = p_PLANNING_PARAMETERS_ID;
512 WHERE LEVEL_ID LIKE p_LEVEL_ID||'%';
513
514 If (SQL%NOTFOUND) then
515 RAISE NO_DATA_FOUND;
516 End If;
517 END Delete_Row;
518
519 PROCEDURE Lock_Row(
520 p_PLANNING_PARAMETERS_ID NUMBER
521 ,p_CREATED_BY NUMBER
522 ,p_CREATION_DATE DATE
523 ,p_LAST_UPDATED_BY NUMBER
524 ,p_LAST_UPDATE_DATE DATE
525 ,p_LAST_UPDATE_LOGIN NUMBER
526 ,p_FORECAST_RULE_ID NUMBER
527 ,p_ORGANIZATION_TYPE VARCHAR2
528 ,p_ORGANIZATION_ID NUMBER
529 ,p_SECONDARY_INVENTORY VARCHAR2
530 ,p_SERVICE_LEVEL NUMBER
531 ,p_EDQ_FACTOR NUMBER
532 ,p_PLANNER_CODE VARCHAR2
533 ,p_CONDITION_TYPE VARCHAR2
534 ,p_ASL_FLAG VARCHAR2
535 ,p_SAFETY_STOCK_FLAG VARCHAR2
536 ,p_EXCESS_RULE_ID NUMBER
537 ,p_NOTIFICATION_RULE_ID NUMBER
538 ,p_RECOMMENDATION_RULE_ID NUMBER
539 ,p_ATTRIBUTE_CATEGORY VARCHAR2
540 ,p_ATTRIBUTE1 VARCHAR2
541 ,p_ATTRIBUTE2 VARCHAR2
542 ,p_ATTRIBUTE3 VARCHAR2
543 ,p_ATTRIBUTE4 VARCHAR2
544 ,p_ATTRIBUTE5 VARCHAR2
545 ,p_ATTRIBUTE6 VARCHAR2
546 ,p_ATTRIBUTE7 VARCHAR2
547 ,p_ATTRIBUTE8 VARCHAR2
548 ,p_ATTRIBUTE9 VARCHAR2
549 ,p_ATTRIBUTE10 VARCHAR2
550 ,p_ATTRIBUTE11 VARCHAR2
551 ,p_ATTRIBUTE12 VARCHAR2
555 ,p_CATEGORY_SET_ID NUMBER
552 ,p_ATTRIBUTE13 VARCHAR2
553 ,p_ATTRIBUTE14 VARCHAR2
554 ,p_ATTRIBUTE15 VARCHAR2
556 ,p_CATEGORY_ID NUMBER
557 ,p_RECOMMEND_METHOD VARCHAR2
558 ,p_EDQ_MULTIPLE NUMBER
559 ,p_MINIMUM_VALUE NUMBER
560 ,p_USABLE_ASSIGNMENT_SET_ID NUMBER
561 ,p_DEFECTIVE_ASSIGNMENT_SET_ID NUMBER
562 ,p_REPAIR_ASSIGNMENT_SET_ID NUMBER
563 ,p_PRODUCT_NORM VARCHAR2
564 ,P_PRODUCT_NORM_NODE_ID NUMBER
565 ,P_USAGE_WEIGHT1 NUMBER
566 ,P_USAGE_WEIGHT2 NUMBER
567 ,P_USAGE_WEIGHT3 NUMBER
568 ,P_USAGE_WEIGHT4 NUMBER
569 ,p_DEFAULT_FORECAST_RULE_ID VARCHAR2
570 ,p_DEFAULT_SERVICE_LEVEL VARCHAR2
571 ,p_DEFAULT_EDQ_FACTOR VARCHAR2
572 ,p_DEFAULT_PLANNER_CODE VARCHAR2
573 ,p_DEFAULT_CONDITION_TYPE VARCHAR2
574 ,p_DEFAULT_ASL_FLAG VARCHAR2
575 ,p_DEFAULT_SAFETY_STOCK_FLAG VARCHAR2
576 ,p_DEFAULT_EXCESS_RULE_ID VARCHAR2
577 ,p_DEFAULT_CATEGORY_SET_ID VARCHAR2
578 ,p_DEFAULT_CATEGORY_ID VARCHAR2
579 ,p_DEFAULT_RECOMMEND_METHOD VARCHAR2
580 ,P_DEFAULT_PRODUCT_NORM_NODE_ID VARCHAR2
581 ,P_DEFAULT_USAGE_WEIGHT1 VARCHAR2
582 ,P_DEFAULT_USAGE_WEIGHT2 VARCHAR2
583 ,P_DEFAULT_USAGE_WEIGHT3 VARCHAR2
584 ,P_DEFAULT_USAGE_WEIGHT4 VARCHAR2
585 ,P_DEFAULT_REC_RULE_ID VARCHAR2
586 ,p_OVERRIDE_FORECAST_RULE_ID VARCHAR2
587 ,p_OVERRIDE_SERVICE_LEVEL VARCHAR2
588 ,p_OVERRIDE_EDQ_FACTOR VARCHAR2
589 ,p_OVERRIDE_PLANNER_CODE VARCHAR2
590 ,p_OVERRIDE_CONDITION_TYPE VARCHAR2
591 ,p_OVERRIDE_ASL_FLAG VARCHAR2
592 ,p_OVERRIDE_SAFETY_STOCK_FLAG VARCHAR2
593 ,p_OVERRIDE_EXCESS_RULE_ID VARCHAR2
594 ,p_OVERRIDE_CATEGORY_SET_ID VARCHAR2
595 ,p_OVERRIDE_CATEGORY_ID VARCHAR2
596 ,p_OVERRIDE_RECOMMEND_METHOD VARCHAR2
597 ,P_OVERRIDE_USAGE_WEIGHT1 VARCHAR2
598 ,P_OVERRIDE_USAGE_WEIGHT2 VARCHAR2
599 ,P_OVERRIDE_USAGE_WEIGHT3 VARCHAR2
600 ,P_OVERRIDE_USAGE_WEIGHT4 VARCHAR2
601 ,P_OVERRIDE_REC_RULE_ID VARCHAR2
602 ,p_NODE_TYPE VARCHAR2
603 ,p_NODE_NAME VARCHAR2
604 ,p_PARENT_NODE_ID NUMBER
605 ,p_LEVEL_ID VARCHAR2
606 ,p_EXCESS_EDQ_FACTOR VARCHAR2
607 ,p_REPAIR_EDQ_FACTOR VARCHAR2
608 ,p_NEWBUY_EDQ_FACTOR VARCHAR2
609 ,p_EXCESS_SERVICE_LEVEL VARCHAR2
610 ,p_REPAIR_SERVICE_LEVEL VARCHAR2
611 ,p_NEWBUY_SERVICE_LEVEL VARCHAR2
612 ,p_RESCHEDULE_RULE_ID NUMBER
613 ,p_WRP_RULE_ID NUMBER)
614 IS
615 CURSOR C IS
616 SELECT *
617 FROM CSP_PLANNING_PARAMETERS
618 WHERE PLANNING_PARAMETERS_ID = p_PLANNING_PARAMETERS_ID
619 FOR UPDATE of PLANNING_PARAMETERS_ID NOWAIT;
620 Recinfo C%ROWTYPE;
621 BEGIN
622 OPEN C;
623 FETCH C INTO Recinfo;
624 If (C%NOTFOUND) then
625 CLOSE C;
626 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
627 APP_EXCEPTION.RAISE_EXCEPTION;
628 End If;
629 CLOSE C;
630 if (
631 ( Recinfo.PLANNING_PARAMETERS_ID = p_PLANNING_PARAMETERS_ID)
632 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
633 OR ( ( Recinfo.CREATED_BY IS NULL )
634 AND ( p_CREATED_BY IS NULL )))
635 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
636 OR ( ( Recinfo.CREATION_DATE IS NULL )
637 AND ( p_CREATION_DATE IS NULL )))
638 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
639 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
640 AND ( p_LAST_UPDATED_BY IS NULL )))
641 AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
642 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
643 AND ( p_LAST_UPDATE_DATE IS NULL )))
644 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
645 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
646 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
647 AND ( ( Recinfo.FORECAST_RULE_ID = p_FORECAST_RULE_ID)
648 OR ( ( Recinfo.FORECAST_RULE_ID IS NULL )
649 AND ( p_FORECAST_RULE_ID IS NULL )))
650 AND ( ( Recinfo.ORGANIZATION_TYPE = p_ORGANIZATION_TYPE)
651 OR ( ( Recinfo.ORGANIZATION_TYPE IS NULL )
652 AND ( p_ORGANIZATION_TYPE IS NULL )))
653 AND ( ( Recinfo.ORGANIZATION_ID = p_ORGANIZATION_ID)
654 OR ( ( Recinfo.ORGANIZATION_ID IS NULL )
655 AND ( p_ORGANIZATION_ID IS NULL )))
656 AND ( ( Recinfo.SECONDARY_INVENTORY = p_SECONDARY_INVENTORY)
657 OR ( ( Recinfo.SECONDARY_INVENTORY IS NULL )
658 AND ( p_SECONDARY_INVENTORY IS NULL )))
659 AND ( ( Recinfo.SERVICE_LEVEL = p_SERVICE_LEVEL)
660 OR ( ( Recinfo.SERVICE_LEVEL IS NULL )
661 AND ( p_SERVICE_LEVEL IS NULL )))
662 AND ( ( Recinfo.EDQ_FACTOR = p_EDQ_FACTOR)
663 OR ( ( Recinfo.EDQ_FACTOR IS NULL )
664 AND ( p_EDQ_FACTOR IS NULL )))
665 AND ( ( Recinfo.PLANNER_CODE = p_PLANNER_CODE)
669 OR ( ( Recinfo.CONDITION_TYPE IS NULL )
666 OR ( ( Recinfo.PLANNER_CODE IS NULL )
667 AND ( p_PLANNER_CODE IS NULL )))
668 AND ( ( Recinfo.CONDITION_TYPE = p_CONDITION_TYPE)
670 AND ( p_CONDITION_TYPE IS NULL )))
671 AND ( ( Recinfo.ASL_FLAG = p_ASL_FLAG)
672 OR ( ( Recinfo.ASL_FLAG IS NULL )
673 AND ( p_ASL_FLAG IS NULL )))
674 AND ( ( Recinfo.SAFETY_STOCK_FLAG = p_SAFETY_STOCK_FLAG)
675 OR ( ( Recinfo.SAFETY_STOCK_FLAG IS NULL )
676 AND ( p_SAFETY_STOCK_FLAG IS NULL )))
677 AND ( ( Recinfo.EXCESS_RULE_ID = p_EXCESS_RULE_ID)
678 OR ( ( Recinfo.EXCESS_RULE_ID IS NULL )
679 AND ( p_EXCESS_RULE_ID IS NULL )))
680 AND ( ( Recinfo.NOTIFICATION_RULE_ID = p_NOTIFICATION_RULE_ID)
681 OR ( ( Recinfo.NOTIFICATION_RULE_ID IS NULL )
682 AND ( p_NOTIFICATION_RULE_ID IS NULL )))
683 AND ( ( Recinfo.RECOMMENDATION_RULE_ID = p_RECOMMENDATION_RULE_ID)
684 OR ( ( Recinfo.RECOMMENDATION_RULE_ID IS NULL )
685 AND ( p_RECOMMENDATION_RULE_ID IS NULL )))
686 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
687 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
688 AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
689 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
690 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
691 AND ( p_ATTRIBUTE1 IS NULL )))
692 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
693 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
694 AND ( p_ATTRIBUTE2 IS NULL )))
695 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
696 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
697 AND ( p_ATTRIBUTE3 IS NULL )))
698 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
699 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
700 AND ( p_ATTRIBUTE4 IS NULL )))
701 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
702 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
703 AND ( p_ATTRIBUTE5 IS NULL )))
704 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
705 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
706 AND ( p_ATTRIBUTE6 IS NULL )))
707 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
708 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
709 AND ( p_ATTRIBUTE7 IS NULL )))
710 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
711 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
712 AND ( p_ATTRIBUTE8 IS NULL )))
713 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
714 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
715 AND ( p_ATTRIBUTE9 IS NULL )))
716 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
717 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
718 AND ( p_ATTRIBUTE10 IS NULL )))
719 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
720 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
721 AND ( p_ATTRIBUTE11 IS NULL )))
722 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
723 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
724 AND ( p_ATTRIBUTE12 IS NULL )))
725 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
726 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
727 AND ( p_ATTRIBUTE13 IS NULL )))
728 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
729 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
730 AND ( p_ATTRIBUTE14 IS NULL )))
731 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
732 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
733 AND ( p_ATTRIBUTE15 IS NULL )))
734 AND ( ( Recinfo.CATEGORY_SET_ID = p_CATEGORY_SET_ID)
735 OR ( ( Recinfo.CATEGORY_SET_ID IS NULL )
736 AND ( p_CATEGORY_SET_ID IS NULL )))
737 AND ( ( Recinfo.CATEGORY_ID = p_CATEGORY_ID)
738 OR ( ( Recinfo.CATEGORY_ID IS NULL )
739 AND ( p_CATEGORY_ID IS NULL )))
740 AND ( ( Recinfo.RECOMMEND_METHOD = p_RECOMMEND_METHOD)
741 OR ( ( Recinfo.RECOMMEND_METHOD IS NULL )
742 AND ( p_RECOMMEND_METHOD IS NULL )))
743 AND ( ( Recinfo.EDQ_MULTIPLE = p_EDQ_MULTIPLE)
744 OR ( ( Recinfo.EDQ_MULTIPLE IS NULL )
745 AND ( p_EDQ_MULTIPLE IS NULL )))
746 AND ( ( Recinfo.MINIMUM_VALUE = p_MINIMUM_VALUE)
747 OR ( ( Recinfo.MINIMUM_VALUE IS NULL )
748 AND ( p_MINIMUM_VALUE IS NULL )))
749 AND ( ( Recinfo.USABLE_ASSIGNMENT_SET_ID = p_USABLE_ASSIGNMENT_SET_ID)
750 OR ( ( Recinfo.USABLE_ASSIGNMENT_SET_ID IS NULL )
751 AND ( p_USABLE_ASSIGNMENT_SET_ID IS NULL )))
752 AND ( ( Recinfo.DEFECTIVE_ASSIGNMENT_SET_ID = p_DEFECTIVE_ASSIGNMENT_SET_ID)
753 OR ( ( Recinfo.DEFECTIVE_ASSIGNMENT_SET_ID IS NULL )
754 AND ( p_DEFECTIVE_ASSIGNMENT_SET_ID IS NULL )))
755 AND ( ( Recinfo.REPAIR_ASSIGNMENT_SET_ID = p_REPAIR_ASSIGNMENT_SET_ID)
756 OR ( ( Recinfo.REPAIR_ASSIGNMENT_SET_ID IS NULL )
757 AND ( p_REPAIR_ASSIGNMENT_SET_ID IS NULL )))
758 AND ( ( Recinfo.PRODUCT_NORM = p_PRODUCT_NORM)
759 OR ( ( Recinfo.PRODUCT_NORM IS NULL )
760 AND ( p_PRODUCT_NORM IS NULL )))
761 AND ( ( Recinfo.PRODUCT_NORM_NODE_ID = p_PRODUCT_NORM_NODE_ID)
762 OR ( ( Recinfo.PRODUCT_NORM_NODE_ID IS NULL )
763 AND ( p_PRODUCT_NORM_NODE_ID IS NULL )))
764 AND ( ( Recinfo.USAGE_WEIGHT1 = p_USAGE_WEIGHT1)
768 OR ( ( Recinfo.USAGE_WEIGHT2 IS NULL )
765 OR ( ( Recinfo.USAGE_WEIGHT1 IS NULL )
766 AND ( p_USAGE_WEIGHT1 IS NULL )))
767 AND ( ( Recinfo.USAGE_WEIGHT2 = p_USAGE_WEIGHT2)
769 AND ( p_USAGE_WEIGHT2 IS NULL )))
770 AND ( ( Recinfo.USAGE_WEIGHT3 = p_USAGE_WEIGHT3)
771 OR ( ( Recinfo.USAGE_WEIGHT3 IS NULL )
772 AND ( p_USAGE_WEIGHT3 IS NULL )))
773 AND ( ( Recinfo.USAGE_WEIGHT4 = p_USAGE_WEIGHT4)
774 OR ( ( Recinfo.USAGE_WEIGHT4 IS NULL )
775 AND ( p_USAGE_WEIGHT4 IS NULL )))
776 AND ( ( Recinfo.DEFAULT_FORECAST_RULE_ID = p_DEFAULT_FORECAST_RULE_ID)
777 OR ( ( Recinfo.DEFAULT_FORECAST_RULE_ID IS NULL )
778 AND ( p_DEFAULT_FORECAST_RULE_ID IS NULL )))
779 AND ( ( Recinfo.DEFAULT_SERVICE_LEVEL = p_DEFAULT_SERVICE_LEVEL)
780 OR ( ( Recinfo.DEFAULT_SERVICE_LEVEL IS NULL )
781 AND ( p_DEFAULT_SERVICE_LEVEL IS NULL )))
782 AND ( ( Recinfo.DEFAULT_EDQ_FACTOR = p_DEFAULT_EDQ_FACTOR)
783 OR ( ( Recinfo.DEFAULT_EDQ_FACTOR IS NULL )
784 AND ( p_DEFAULT_EDQ_FACTOR IS NULL )))
785 AND ( ( Recinfo.DEFAULT_PLANNER_CODE = p_DEFAULT_PLANNER_CODE)
786 OR ( ( Recinfo.DEFAULT_PLANNER_CODE IS NULL )
787 AND ( p_DEFAULT_PLANNER_CODE IS NULL )))
788 AND ( ( Recinfo.DEFAULT_CONDITION_TYPE = p_DEFAULT_CONDITION_TYPE)
789 OR ( ( Recinfo.DEFAULT_CONDITION_TYPE IS NULL )
790 AND ( p_DEFAULT_CONDITION_TYPE IS NULL )))
791 AND ( ( Recinfo.DEFAULT_ASL_FLAG = p_DEFAULT_ASL_FLAG)
792 OR ( ( Recinfo.DEFAULT_ASL_FLAG IS NULL )
793 AND ( p_DEFAULT_ASL_FLAG IS NULL )))
794 AND ( ( Recinfo.DEFAULT_SAFETY_STOCK_FLAG = p_DEFAULT_SAFETY_STOCK_FLAG)
795 OR ( ( Recinfo.DEFAULT_SAFETY_STOCK_FLAG IS NULL )
796 AND ( p_DEFAULT_SAFETY_STOCK_FLAG IS NULL )))
797 AND ( ( Recinfo.DEFAULT_EXCESS_RULE_ID = p_DEFAULT_EXCESS_RULE_ID)
798 OR ( ( Recinfo.DEFAULT_EXCESS_RULE_ID IS NULL )
799 AND ( p_DEFAULT_EXCESS_RULE_ID IS NULL )))
800 AND ( ( Recinfo.DEFAULT_CATEGORY_SET_ID = p_DEFAULT_CATEGORY_SET_ID)
801 OR ( ( Recinfo.DEFAULT_CATEGORY_SET_ID IS NULL )
802 AND ( p_DEFAULT_CATEGORY_SET_ID IS NULL )))
803 AND ( ( Recinfo.DEFAULT_CATEGORY_ID = p_DEFAULT_CATEGORY_ID)
804 OR ( ( Recinfo.DEFAULT_CATEGORY_ID IS NULL )
805 AND ( p_DEFAULT_CATEGORY_ID IS NULL )))
806 AND ( ( Recinfo.DEFAULT_RECOMMEND_METHOD = p_DEFAULT_RECOMMEND_METHOD)
807 OR ( ( Recinfo.DEFAULT_RECOMMEND_METHOD IS NULL )
808 AND ( p_DEFAULT_RECOMMEND_METHOD IS NULL )))
809 AND ( ( Recinfo.DEFAULT_PRODUCT_NORM_NODE_ID = p_DEFAULT_PRODUCT_NORM_NODE_ID)
810 OR ( ( Recinfo.DEFAULT_PRODUCT_NORM_NODE_ID IS NULL )
811 AND ( p_DEFAULT_PRODUCT_NORM_NODE_ID IS NULL )))
812 AND ( ( Recinfo.DEFAULT_USAGE_WEIGHT1 = p_DEFAULT_USAGE_WEIGHT1)
813 OR ( ( Recinfo.DEFAULT_USAGE_WEIGHT1 IS NULL )
814 AND ( p_DEFAULT_USAGE_WEIGHT1 IS NULL )))
815 AND ( ( Recinfo.DEFAULT_USAGE_WEIGHT2 = p_DEFAULT_USAGE_WEIGHT2)
816 OR ( ( Recinfo.DEFAULT_USAGE_WEIGHT2 IS NULL )
817 AND ( p_DEFAULT_USAGE_WEIGHT2 IS NULL )))
818 AND ( ( Recinfo.DEFAULT_USAGE_WEIGHT3 = p_DEFAULT_USAGE_WEIGHT3)
819 OR ( ( Recinfo.DEFAULT_USAGE_WEIGHT3 IS NULL )
820 AND ( p_DEFAULT_USAGE_WEIGHT3 IS NULL )))
821 AND ( ( Recinfo.DEFAULT_USAGE_WEIGHT4 = p_DEFAULT_USAGE_WEIGHT4)
822 OR ( ( Recinfo.DEFAULT_USAGE_WEIGHT4 IS NULL )
823 AND ( p_DEFAULT_USAGE_WEIGHT4 IS NULL )))
824 AND ( ( Recinfo.DEFAULT_REC_RULE_ID = p_DEFAULT_REC_RULE_ID)
825 OR ( ( Recinfo.DEFAULT_REC_RULE_ID IS NULL )
826 AND ( p_DEFAULT_REC_RULE_ID IS NULL )))
827 AND ( ( Recinfo.OVERRIDE_FORECAST_RULE_ID = p_OVERRIDE_FORECAST_RULE_ID)
828 OR ( ( Recinfo.OVERRIDE_FORECAST_RULE_ID IS NULL )
829 AND ( p_OVERRIDE_FORECAST_RULE_ID IS NULL )))
830 AND ( ( Recinfo.OVERRIDE_SERVICE_LEVEL = p_OVERRIDE_SERVICE_LEVEL)
831 OR ( ( Recinfo.OVERRIDE_SERVICE_LEVEL IS NULL )
832 AND ( p_OVERRIDE_SERVICE_LEVEL IS NULL )))
833 AND ( ( Recinfo.OVERRIDE_EDQ_FACTOR = p_OVERRIDE_EDQ_FACTOR)
834 OR ( ( Recinfo.OVERRIDE_EDQ_FACTOR IS NULL )
835 AND ( p_OVERRIDE_EDQ_FACTOR IS NULL )))
836 AND ( ( Recinfo.OVERRIDE_PLANNER_CODE = p_OVERRIDE_PLANNER_CODE)
837 OR ( ( Recinfo.OVERRIDE_PLANNER_CODE IS NULL )
838 AND ( p_OVERRIDE_PLANNER_CODE IS NULL )))
839 AND ( ( Recinfo.OVERRIDE_CONDITION_TYPE = p_OVERRIDE_CONDITION_TYPE)
840 OR ( ( Recinfo.OVERRIDE_CONDITION_TYPE IS NULL )
841 AND ( p_OVERRIDE_CONDITION_TYPE IS NULL )))
842 AND ( ( Recinfo.OVERRIDE_ASL_FLAG = p_OVERRIDE_ASL_FLAG)
843 OR ( ( Recinfo.OVERRIDE_ASL_FLAG IS NULL )
844 AND ( p_OVERRIDE_ASL_FLAG IS NULL )))
845 AND ( ( Recinfo.OVERRIDE_SAFETY_STOCK_FLAG = p_OVERRIDE_SAFETY_STOCK_FLAG)
846 OR ( ( Recinfo.OVERRIDE_SAFETY_STOCK_FLAG IS NULL )
847 AND ( p_OVERRIDE_SAFETY_STOCK_FLAG IS NULL )))
848 AND ( ( Recinfo.OVERRIDE_EXCESS_RULE_ID = p_OVERRIDE_EXCESS_RULE_ID)
849 OR ( ( Recinfo.OVERRIDE_EXCESS_RULE_ID IS NULL )
850 AND ( p_OVERRIDE_EXCESS_RULE_ID IS NULL )))
851 AND ( ( Recinfo.OVERRIDE_CATEGORY_SET_ID = p_OVERRIDE_CATEGORY_SET_ID)
852 OR ( ( Recinfo.OVERRIDE_CATEGORY_SET_ID IS NULL )
853 AND ( p_OVERRIDE_CATEGORY_SET_ID IS NULL )))
854 AND ( ( Recinfo.OVERRIDE_CATEGORY_ID = p_OVERRIDE_CATEGORY_ID)
855 OR ( ( Recinfo.OVERRIDE_CATEGORY_ID IS NULL )
856 AND ( p_OVERRIDE_CATEGORY_ID IS NULL )))
857 AND ( ( Recinfo.OVERRIDE_RECOMMEND_METHOD = p_OVERRIDE_RECOMMEND_METHOD)
858 OR ( ( Recinfo.OVERRIDE_RECOMMEND_METHOD IS NULL )
859 AND ( p_OVERRIDE_RECOMMEND_METHOD IS NULL )))
860 AND ( ( Recinfo.OVERRIDE_USAGE_WEIGHT1 = p_OVERRIDE_USAGE_WEIGHT1)
861 OR ( ( Recinfo.OVERRIDE_USAGE_WEIGHT1 IS NULL )
862 AND ( p_OVERRIDE_USAGE_WEIGHT1 IS NULL )))
863 AND ( ( Recinfo.OVERRIDE_USAGE_WEIGHT2 = p_OVERRIDE_USAGE_WEIGHT2)
864 OR ( ( Recinfo.OVERRIDE_USAGE_WEIGHT2 IS NULL )
865 AND ( p_OVERRIDE_USAGE_WEIGHT2 IS NULL )))
866 AND ( ( Recinfo.OVERRIDE_USAGE_WEIGHT3 = p_OVERRIDE_USAGE_WEIGHT3)
867 OR ( ( Recinfo.OVERRIDE_USAGE_WEIGHT3 IS NULL )
868 AND ( p_OVERRIDE_USAGE_WEIGHT3 IS NULL )))
869 AND ( ( Recinfo.OVERRIDE_USAGE_WEIGHT4 = p_OVERRIDE_USAGE_WEIGHT4)
870 OR ( ( Recinfo.OVERRIDE_USAGE_WEIGHT4 IS NULL )
871 AND ( p_OVERRIDE_USAGE_WEIGHT4 IS NULL )))
872 AND ( ( Recinfo.OVERRIDE_REC_RULE_ID = p_OVERRIDE_REC_RULE_ID)
873 OR ( ( Recinfo.OVERRIDE_REC_RULE_ID IS NULL )
874 AND ( p_OVERRIDE_REC_RULE_ID IS NULL )))
875 AND ( ( Recinfo.NODE_TYPE = p_NODE_TYPE)
876 OR ( ( Recinfo.NODE_TYPE IS NULL )
877 AND ( p_NODE_TYPE IS NULL )))
878 AND ( ( Recinfo.NODE_NAME = p_NODE_NAME)
879 OR ( ( Recinfo.NODE_NAME IS NULL )
880 AND ( p_NODE_NAME IS NULL )))
881 AND ( ( Recinfo.PARENT_NODE_ID = p_PARENT_NODE_ID)
882 OR ( ( Recinfo.PARENT_NODE_ID IS NULL )
883 AND ( p_PARENT_NODE_ID IS NULL )))
884 AND ( ( Recinfo.LEVEL_ID = p_LEVEL_ID)
885 OR ( ( Recinfo.LEVEL_ID IS NULL )
886 AND ( p_LEVEL_ID IS NULL )))
887 AND ( ( Recinfo.EXCESS_EDQ_FACTOR = p_EXCESS_EDQ_FACTOR)
888 OR ( ( Recinfo.EXCESS_EDQ_FACTOR IS NULL )
889 AND ( p_EXCESS_EDQ_FACTOR IS NULL )))
890 AND ( ( Recinfo.REPAIR_EDQ_FACTOR = p_REPAIR_EDQ_FACTOR)
891 OR ( ( Recinfo.REPAIR_EDQ_FACTOR IS NULL )
892 AND ( p_REPAIR_EDQ_FACTOR IS NULL )))
893 AND ( ( Recinfo.NEWBUY_EDQ_FACTOR = p_NEWBUY_EDQ_FACTOR)
894 OR ( ( Recinfo.NEWBUY_EDQ_FACTOR IS NULL )
895 AND ( p_NEWBUY_EDQ_FACTOR IS NULL )))
896 AND ( ( Recinfo.EXCESS_SERVICE_LEVEL = p_EXCESS_SERVICE_LEVEL)
897 OR ( ( Recinfo.EXCESS_SERVICE_LEVEL IS NULL )
898 AND ( p_EXCESS_SERVICE_LEVEL IS NULL )))
899 AND ( ( Recinfo.REPAIR_SERVICE_LEVEL = p_REPAIR_SERVICE_LEVEL)
900 OR ( ( Recinfo.REPAIR_SERVICE_LEVEL IS NULL )
901 AND ( p_REPAIR_SERVICE_LEVEL IS NULL )))
902 AND ( ( Recinfo.NEWBUY_SERVICE_LEVEL = p_NEWBUY_SERVICE_LEVEL)
903 OR ( ( Recinfo.NEWBUY_SERVICE_LEVEL IS NULL )
904 AND ( p_NEWBUY_SERVICE_LEVEL IS NULL )))
905 AND ( ( Recinfo.RESCHEDULE_RULE_ID = p_RESCHEDULE_RULE_ID)
906 OR ( ( Recinfo.RESCHEDULE_RULE_ID IS NULL )
907 AND ( p_RESCHEDULE_RULE_ID IS NULL )))
908 AND ( ( Recinfo.WRP_RULE_ID = p_WRP_RULE_ID)
909 OR ( ( Recinfo.WRP_RULE_ID IS NULL )
910 AND ( p_WRP_RULE_ID IS NULL )))
911 ) then
912 return;
913 else
914 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
915 APP_EXCEPTION.RAISE_EXCEPTION;
916 End If;
917 END Lock_Row;
918 End CSP_PLANNING_PARAMETERS_PKG;