90: 'Get_Price_List'
91: );
92: END IF;
93:
94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
95:
96: END Get_Price_List;
97:
98: FUNCTION Get_Rounding_Factor
145: BEGIN
146:
147: -- In the future call Flex APIs for defaults
148:
149: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
150: g_PRICE_LIST_rec.attribute1 := NULL;
151: END IF;
152:
153: IF g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
149: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
150: g_PRICE_LIST_rec.attribute1 := NULL;
151: END IF;
152:
153: IF g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
154: g_PRICE_LIST_rec.attribute10 := NULL;
155: END IF;
156:
157: IF g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
153: IF g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
154: g_PRICE_LIST_rec.attribute10 := NULL;
155: END IF;
156:
157: IF g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
158: g_PRICE_LIST_rec.attribute11 := NULL;
159: END IF;
160:
161: IF g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
157: IF g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
158: g_PRICE_LIST_rec.attribute11 := NULL;
159: END IF;
160:
161: IF g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
162: g_PRICE_LIST_rec.attribute12 := NULL;
163: END IF;
164:
165: IF g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
161: IF g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
162: g_PRICE_LIST_rec.attribute12 := NULL;
163: END IF;
164:
165: IF g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
166: g_PRICE_LIST_rec.attribute13 := NULL;
167: END IF;
168:
169: IF g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
165: IF g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
166: g_PRICE_LIST_rec.attribute13 := NULL;
167: END IF;
168:
169: IF g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
170: g_PRICE_LIST_rec.attribute14 := NULL;
171: END IF;
172:
173: IF g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
169: IF g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
170: g_PRICE_LIST_rec.attribute14 := NULL;
171: END IF;
172:
173: IF g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
174: g_PRICE_LIST_rec.attribute15 := NULL;
175: END IF;
176:
177: IF g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
173: IF g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
174: g_PRICE_LIST_rec.attribute15 := NULL;
175: END IF;
176:
177: IF g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
178: g_PRICE_LIST_rec.attribute2 := NULL;
179: END IF;
180:
181: IF g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
177: IF g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
178: g_PRICE_LIST_rec.attribute2 := NULL;
179: END IF;
180:
181: IF g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
182: g_PRICE_LIST_rec.attribute3 := NULL;
183: END IF;
184:
185: IF g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
181: IF g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
182: g_PRICE_LIST_rec.attribute3 := NULL;
183: END IF;
184:
185: IF g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
186: g_PRICE_LIST_rec.attribute4 := NULL;
187: END IF;
188:
189: IF g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
185: IF g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
186: g_PRICE_LIST_rec.attribute4 := NULL;
187: END IF;
188:
189: IF g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
190: g_PRICE_LIST_rec.attribute5 := NULL;
191: END IF;
192:
193: IF g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
189: IF g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
190: g_PRICE_LIST_rec.attribute5 := NULL;
191: END IF;
192:
193: IF g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
194: g_PRICE_LIST_rec.attribute6 := NULL;
195: END IF;
196:
197: IF g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
193: IF g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
194: g_PRICE_LIST_rec.attribute6 := NULL;
195: END IF;
196:
197: IF g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
198: g_PRICE_LIST_rec.attribute7 := NULL;
199: END IF;
200:
201: IF g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
197: IF g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
198: g_PRICE_LIST_rec.attribute7 := NULL;
199: END IF;
200:
201: IF g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
202: g_PRICE_LIST_rec.attribute8 := NULL;
203: END IF;
204:
205: IF g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
201: IF g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
202: g_PRICE_LIST_rec.attribute8 := NULL;
203: END IF;
204:
205: IF g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
206: g_PRICE_LIST_rec.attribute9 := NULL;
207: END IF;
208:
209: IF g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN
205: IF g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
206: g_PRICE_LIST_rec.attribute9 := NULL;
207: END IF;
208:
209: IF g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN
210: g_PRICE_LIST_rec.context := NULL;
211: END IF;
212:
213: END Get_Flex_So_Price_Lists;
234: OE_MSG_PUB.Add;
235:
236: END IF;
237:
238: RAISE FND_API.G_EXC_ERROR;
239:
240: END IF;
241:
242: -- Initialize g_PRICE_LIST_rec
244: g_PRICE_LIST_rec := p_PRICE_LIST_rec;
245:
246: -- Default missing attributes.
247:
248: IF g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR THEN
249:
250: g_PRICE_LIST_rec.comments := Get_Comments;
251:
252: IF g_PRICE_LIST_rec.comments IS NOT NULL THEN
265: END IF;
266:
267: END IF;
268:
269: IF g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
270:
271: g_PRICE_LIST_rec.currency_code := Get_Currency;
272:
273: IF g_PRICE_LIST_rec.currency_code IS NOT NULL THEN
286: END IF;
287:
288: END IF;
289:
290: IF g_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR THEN
291:
292: g_PRICE_LIST_rec.description := Get_Description;
293:
294: IF g_PRICE_LIST_rec.description IS NOT NULL THEN
307: END IF;
308:
309: END IF;
310:
311: IF g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN
312:
313: g_PRICE_LIST_rec.end_date_active := Get_End_Date_Active;
314:
315: IF g_PRICE_LIST_rec.end_date_active IS NOT NULL THEN
328: END IF;
329:
330: END IF;
331:
332: IF g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
333:
334: g_PRICE_LIST_rec.freight_terms_code := Get_Freight_Terms;
335:
336: IF g_PRICE_LIST_rec.freight_terms_code IS NOT NULL THEN
349: END IF;
350:
351: END IF;
352:
353: IF g_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR THEN
354:
355: g_PRICE_LIST_rec.name := Get_Name;
356:
357: IF g_PRICE_LIST_rec.name IS NOT NULL THEN
370: END IF;
371:
372: END IF;
373:
374: IF g_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM THEN
375:
376: g_PRICE_LIST_rec.price_list_id := Get_Price_List;
377:
378: IF g_PRICE_LIST_rec.price_list_id IS NOT NULL THEN
391: END IF;
392:
393: END IF;
394:
395: IF g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN
396:
397: g_PRICE_LIST_rec.rounding_factor := Get_Rounding_Factor;
398:
399: IF g_PRICE_LIST_rec.rounding_factor IS NOT NULL THEN
412: END IF;
413:
414: END IF;
415:
416: IF g_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM THEN
417:
418: g_PRICE_LIST_rec.secondary_price_list_id := Get_Secondary_Price_List;
419:
420: IF g_PRICE_LIST_rec.secondary_price_list_id IS NOT NULL THEN
433: END IF;
434:
435: END IF;
436:
437: IF g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
438:
439: g_PRICE_LIST_rec.ship_method_code := Get_Ship_Method;
440:
441: IF g_PRICE_LIST_rec.ship_method_code IS NOT NULL THEN
454: END IF;
455:
456: END IF;
457:
458: IF g_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN
459:
460: g_PRICE_LIST_rec.start_date_active := Get_Start_Date_Active;
461:
462: IF g_PRICE_LIST_rec.start_date_active IS NOT NULL THEN
475: END IF;
476:
477: END IF;
478:
479: IF g_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
480:
481: g_PRICE_LIST_rec.terms_id := Get_Terms;
482:
483: IF g_PRICE_LIST_rec.terms_id IS NOT NULL THEN
496: END IF;
497:
498: END IF;
499:
500: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
501: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
502: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
503: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
504: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
497:
498: END IF;
499:
500: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
501: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
502: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
503: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
504: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
505: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
498: END IF;
499:
500: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
501: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
502: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
503: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
504: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
505: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
506: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
499:
500: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
501: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
502: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
503: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
504: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
505: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
506: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
507: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
500: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
501: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
502: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
503: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
504: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
505: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
506: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
507: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
508: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
501: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
502: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
503: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
504: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
505: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
506: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
507: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
508: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
509: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
502: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
503: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
504: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
505: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
506: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
507: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
508: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
509: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
510: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
503: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
504: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
505: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
506: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
507: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
508: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
509: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
510: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
511: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
504: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
505: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
506: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
507: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
508: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
509: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
510: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
511: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
512: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
505: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
506: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
507: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
508: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
509: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
510: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
511: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
512: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
513: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
506: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
507: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
508: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
509: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
510: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
511: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
512: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
513: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
514: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
507: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
508: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
509: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
510: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
511: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
512: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
513: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
514: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
515: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
508: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
509: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
510: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
511: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
512: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
513: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
514: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
515: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
516: THEN
509: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
510: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
511: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
512: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
513: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
514: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
515: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
516: THEN
517:
510: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
511: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
512: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
513: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
514: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
515: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
516: THEN
517:
518: Get_Flex_So_Price_Lists;
511: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
512: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
513: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
514: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
515: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
516: THEN
517:
518: Get_Flex_So_Price_Lists;
519:
518: Get_Flex_So_Price_Lists;
519:
520: END IF;
521:
522: IF g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM THEN
523:
524: g_PRICE_LIST_rec.created_by := NULL;
525:
526: END IF;
524: g_PRICE_LIST_rec.created_by := NULL;
525:
526: END IF;
527:
528: IF g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN
529:
530: g_PRICE_LIST_rec.creation_date := NULL;
531:
532: END IF;
530: g_PRICE_LIST_rec.creation_date := NULL;
531:
532: END IF;
533:
534: IF g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
535:
536: g_PRICE_LIST_rec.last_updated_by := NULL;
537:
538: END IF;
536: g_PRICE_LIST_rec.last_updated_by := NULL;
537:
538: END IF;
539:
540: IF g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
541:
542: g_PRICE_LIST_rec.last_update_date := NULL;
543:
544: END IF;
542: g_PRICE_LIST_rec.last_update_date := NULL;
543:
544: END IF;
545:
546: IF g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
547:
548: g_PRICE_LIST_rec.last_update_login := NULL;
549:
550: END IF;
548: g_PRICE_LIST_rec.last_update_login := NULL;
549:
550: END IF;
551:
552: IF g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN
553:
554: g_PRICE_LIST_rec.program_application_id := NULL;
555:
556: END IF;
554: g_PRICE_LIST_rec.program_application_id := NULL;
555:
556: END IF;
557:
558: IF g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM THEN
559:
560: g_PRICE_LIST_rec.program_id := NULL;
561:
562: END IF;
560: g_PRICE_LIST_rec.program_id := NULL;
561:
562: END IF;
563:
564: IF g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
565:
566: g_PRICE_LIST_rec.program_update_date := NULL;
567:
568: END IF;
566: g_PRICE_LIST_rec.program_update_date := NULL;
567:
568: END IF;
569:
570: IF g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM THEN
571:
572: g_PRICE_LIST_rec.request_id := NULL;
573:
574: END IF;
574: END IF;
575:
576: -- Redefault if there are any missing attributes.
577:
578: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
579: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
580: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
581: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
582: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
575:
576: -- Redefault if there are any missing attributes.
577:
578: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
579: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
580: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
581: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
582: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
583: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
576: -- Redefault if there are any missing attributes.
577:
578: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
579: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
580: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
581: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
582: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
583: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
584: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
577:
578: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
579: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
580: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
581: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
582: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
583: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
584: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
585: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
578: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
579: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
580: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
581: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
582: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
583: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
584: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
585: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
586: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
579: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
580: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
581: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
582: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
583: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
584: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
585: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
586: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
587: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
580: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
581: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
582: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
583: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
584: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
585: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
586: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
587: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
588: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
581: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
582: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
583: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
584: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
585: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
586: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
587: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
588: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
589: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
582: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
583: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
584: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
585: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
586: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
587: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
588: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
589: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
590: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
583: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
584: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
585: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
586: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
587: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
588: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
589: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
590: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
591: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
584: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
585: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
586: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
587: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
588: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
589: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
590: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
591: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
592: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
585: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
586: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
587: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
588: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
589: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
590: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
591: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
592: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
593: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR
586: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
587: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
588: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
589: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
590: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
591: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
592: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
593: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR
594: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
587: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
588: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
589: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
590: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
591: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
592: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
593: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR
594: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
595: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM
588: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
589: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
590: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
591: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
592: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
593: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR
594: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
595: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM
596: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE
589: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
590: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
591: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
592: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
593: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR
594: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
595: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM
596: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE
597: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR
590: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
591: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
592: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
593: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR
594: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
595: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM
596: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE
597: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR
598: OR g_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR
591: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
592: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
593: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR
594: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
595: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM
596: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE
597: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR
598: OR g_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR
599: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE
592: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
593: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR
594: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
595: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM
596: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE
597: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR
598: OR g_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR
599: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE
600: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR
593: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR
594: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
595: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM
596: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE
597: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR
598: OR g_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR
599: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE
600: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR
601: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
594: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
595: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM
596: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE
597: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR
598: OR g_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR
599: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE
600: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR
601: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
602: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
595: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM
596: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE
597: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR
598: OR g_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR
599: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE
600: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR
601: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
602: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
603: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
596: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE
597: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR
598: OR g_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR
599: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE
600: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR
601: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
602: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
603: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
604: OR g_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR
597: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR
598: OR g_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR
599: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE
600: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR
601: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
602: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
603: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
604: OR g_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR
605: OR g_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM
598: OR g_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR
599: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE
600: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR
601: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
602: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
603: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
604: OR g_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR
605: OR g_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM
606: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
599: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE
600: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR
601: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
602: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
603: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
604: OR g_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR
605: OR g_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM
606: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
607: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
600: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR
601: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
602: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
603: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
604: OR g_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR
605: OR g_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM
606: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
607: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
608: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
601: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
602: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
603: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
604: OR g_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR
605: OR g_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM
606: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
607: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
608: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
609: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
602: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
603: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
604: OR g_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR
605: OR g_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM
606: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
607: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
608: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
609: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
610: OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
603: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
604: OR g_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR
605: OR g_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM
606: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
607: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
608: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
609: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
610: OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
611: OR g_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM
604: OR g_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR
605: OR g_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM
606: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
607: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
608: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
609: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
610: OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
611: OR g_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM
612: OR g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR
605: OR g_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM
606: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
607: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
608: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
609: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
610: OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
611: OR g_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM
612: OR g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR
613: OR g_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE
606: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
607: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
608: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
609: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
610: OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
611: OR g_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM
612: OR g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR
613: OR g_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE
614: OR g_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM
607: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
608: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
609: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
610: OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
611: OR g_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM
612: OR g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR
613: OR g_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE
614: OR g_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM
615: THEN
608: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
609: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
610: OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
611: OR g_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM
612: OR g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR
613: OR g_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE
614: OR g_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM
615: THEN
616:
609: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
610: OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
611: OR g_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM
612: OR g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR
613: OR g_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE
614: OR g_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM
615: THEN
616:
617: OE_Default_Price_List.Attributes
610: OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
611: OR g_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM
612: OR g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR
613: OR g_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE
614: OR g_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM
615: THEN
616:
617: OE_Default_Price_List.Attributes
618: ( p_PRICE_LIST_rec => g_PRICE_LIST_rec