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