190: BEGIN
191:
192: -- In the future call Flex APIs for defaults
193:
194: IF g_LIMITS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
195: g_LIMITS_rec.attribute1 := NULL;
196: END IF;
197:
198: IF g_LIMITS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
194: IF g_LIMITS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
195: g_LIMITS_rec.attribute1 := NULL;
196: END IF;
197:
198: IF g_LIMITS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
199: g_LIMITS_rec.attribute10 := NULL;
200: END IF;
201:
202: IF g_LIMITS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
198: IF g_LIMITS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
199: g_LIMITS_rec.attribute10 := NULL;
200: END IF;
201:
202: IF g_LIMITS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
203: g_LIMITS_rec.attribute11 := NULL;
204: END IF;
205:
206: IF g_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
202: IF g_LIMITS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
203: g_LIMITS_rec.attribute11 := NULL;
204: END IF;
205:
206: IF g_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
207: g_LIMITS_rec.attribute12 := NULL;
208: END IF;
209:
210: IF g_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
206: IF g_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
207: g_LIMITS_rec.attribute12 := NULL;
208: END IF;
209:
210: IF g_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
211: g_LIMITS_rec.attribute13 := NULL;
212: END IF;
213:
214: IF g_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
210: IF g_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
211: g_LIMITS_rec.attribute13 := NULL;
212: END IF;
213:
214: IF g_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
215: g_LIMITS_rec.attribute14 := NULL;
216: END IF;
217:
218: IF g_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
214: IF g_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
215: g_LIMITS_rec.attribute14 := NULL;
216: END IF;
217:
218: IF g_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
219: g_LIMITS_rec.attribute15 := NULL;
220: END IF;
221:
222: IF g_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
218: IF g_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
219: g_LIMITS_rec.attribute15 := NULL;
220: END IF;
221:
222: IF g_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
223: g_LIMITS_rec.attribute2 := NULL;
224: END IF;
225:
226: IF g_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
222: IF g_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
223: g_LIMITS_rec.attribute2 := NULL;
224: END IF;
225:
226: IF g_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
227: g_LIMITS_rec.attribute3 := NULL;
228: END IF;
229:
230: IF g_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
226: IF g_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
227: g_LIMITS_rec.attribute3 := NULL;
228: END IF;
229:
230: IF g_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
231: g_LIMITS_rec.attribute4 := NULL;
232: END IF;
233:
234: IF g_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
230: IF g_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
231: g_LIMITS_rec.attribute4 := NULL;
232: END IF;
233:
234: IF g_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
235: g_LIMITS_rec.attribute5 := NULL;
236: END IF;
237:
238: IF g_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
234: IF g_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
235: g_LIMITS_rec.attribute5 := NULL;
236: END IF;
237:
238: IF g_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
239: g_LIMITS_rec.attribute6 := NULL;
240: END IF;
241:
242: IF g_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
238: IF g_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
239: g_LIMITS_rec.attribute6 := NULL;
240: END IF;
241:
242: IF g_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
243: g_LIMITS_rec.attribute7 := NULL;
244: END IF;
245:
246: IF g_LIMITS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
242: IF g_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
243: g_LIMITS_rec.attribute7 := NULL;
244: END IF;
245:
246: IF g_LIMITS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
247: g_LIMITS_rec.attribute8 := NULL;
248: END IF;
249:
250: IF g_LIMITS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
246: IF g_LIMITS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
247: g_LIMITS_rec.attribute8 := NULL;
248: END IF;
249:
250: IF g_LIMITS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
251: g_LIMITS_rec.attribute9 := NULL;
252: END IF;
253:
254: IF g_LIMITS_rec.context = FND_API.G_MISS_CHAR THEN
250: IF g_LIMITS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
251: g_LIMITS_rec.attribute9 := NULL;
252: END IF;
253:
254: IF g_LIMITS_rec.context = FND_API.G_MISS_CHAR THEN
255: g_LIMITS_rec.context := NULL;
256: END IF;
257:
258: END Get_Flex_Limits;
280: OE_MSG_PUB.Add;
281:
282: END IF;
283:
284: RAISE FND_API.G_EXC_ERROR;
285:
286: END IF;
287:
288: -- Initialize g_LIMITS_rec
290: g_LIMITS_rec := p_LIMITS_rec;
291:
292: -- Default missing attributes.
293:
294: IF g_LIMITS_rec.amount = FND_API.G_MISS_NUM THEN
295:
296: g_LIMITS_rec.amount := Get_Amount;
297:
298: IF g_LIMITS_rec.amount IS NOT NULL THEN
314: END IF;
315:
316: END IF;
317:
318: IF g_LIMITS_rec.basis = FND_API.G_MISS_CHAR THEN
319:
320: g_LIMITS_rec.basis := Get_Basis;
321:
322: IF g_LIMITS_rec.basis IS NOT NULL THEN
338: END IF;
339:
340: END IF;
341:
342: IF g_LIMITS_rec.limit_exceed_action_code = FND_API.G_MISS_CHAR THEN
343:
344: g_LIMITS_rec.limit_exceed_action_code := Get_Limit_Exceed_Action;
345:
346: IF g_LIMITS_rec.limit_exceed_action_code IS NOT NULL THEN
362: END IF;
363:
364: END IF;
365:
366: IF g_LIMITS_rec.limit_id = FND_API.G_MISS_NUM THEN
367:
368: g_LIMITS_rec.limit_id := Get_Limit;
369: --dbms_output.put_line('Processing Limits - Inside QPXDLMTB ' || g_LIMITS_rec.limit_id);
370:
388: END IF;
389:
390: END IF;
391:
392: IF g_LIMITS_rec.limit_level_code = FND_API.G_MISS_CHAR THEN
393:
394: g_LIMITS_rec.limit_level_code := Get_Limit_Level;
395:
396: IF g_LIMITS_rec.limit_level_code IS NOT NULL THEN
412: END IF;
413:
414: END IF;
415:
416: IF g_LIMITS_rec.limit_number = FND_API.G_MISS_NUM THEN
417:
418: g_LIMITS_rec.limit_number := Get_Limit_Number;
419:
420: IF g_LIMITS_rec.limit_number IS NOT NULL THEN
436: END IF;
437:
438: END IF;
439:
440: IF g_LIMITS_rec.list_header_id = FND_API.G_MISS_NUM THEN
441:
442: g_LIMITS_rec.list_header_id := Get_List_Header;
443:
444: IF g_LIMITS_rec.list_header_id IS NOT NULL THEN
460: END IF;
461:
462: END IF;
463:
464: IF g_LIMITS_rec.list_line_id = FND_API.G_MISS_NUM THEN
465:
466: g_LIMITS_rec.list_line_id := Get_List_Line;
467:
468: IF g_LIMITS_rec.list_line_id IS NOT NULL THEN
484: END IF;
485:
486: END IF;
487:
488: IF g_LIMITS_rec.limit_hold_flag = FND_API.G_MISS_CHAR THEN
489:
490: g_LIMITS_rec.limit_hold_flag := Get_Limit_Hold;
491:
492: IF g_LIMITS_rec.limit_hold_flag IS NOT NULL THEN
509:
510: END IF;
511:
512:
513: IF g_LIMITS_rec.multival_attr1_type = FND_API.G_MISS_CHAR THEN
514:
515: g_LIMITS_rec.multival_attr1_type := Get_Multival_Attr1_Type;
516:
517: IF g_LIMITS_rec.multival_attr1_type IS NOT NULL THEN
533: END IF;
534:
535: END IF;
536:
537: IF g_LIMITS_rec.multival_attr1_context = FND_API.G_MISS_CHAR THEN
538:
539: g_LIMITS_rec.multival_attr1_context := Get_Multival_Attr1_Context;
540:
541: IF g_LIMITS_rec.multival_attr1_context IS NOT NULL THEN
557: END IF;
558:
559: END IF;
560:
561: IF g_LIMITS_rec.multival_attribute1 = FND_API.G_MISS_CHAR THEN
562:
563: g_LIMITS_rec.multival_attribute1 := Get_Multival_Attribute1;
564:
565: IF g_LIMITS_rec.multival_attribute1 IS NOT NULL THEN
581: END IF;
582:
583: END IF;
584:
585: IF g_LIMITS_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR THEN
586:
587: g_LIMITS_rec.multival_attr1_datatype := Get_Multival_Attr1_Datatype;
588:
589: IF g_LIMITS_rec.multival_attr1_datatype IS NOT NULL THEN
606:
607: END IF;
608:
609:
610: IF g_LIMITS_rec.multival_attr2_type = FND_API.G_MISS_CHAR THEN
611:
612: g_LIMITS_rec.multival_attr2_type := Get_Multival_Attr2_Type;
613:
614: IF g_LIMITS_rec.multival_attr2_type IS NOT NULL THEN
630: END IF;
631:
632: END IF;
633:
634: IF g_LIMITS_rec.multival_attr2_context = FND_API.G_MISS_CHAR THEN
635:
636: g_LIMITS_rec.multival_attr2_context := Get_Multival_Attr2_Context;
637:
638: IF g_LIMITS_rec.multival_attr2_context IS NOT NULL THEN
654: END IF;
655:
656: END IF;
657:
658: IF g_LIMITS_rec.multival_attribute2 = FND_API.G_MISS_CHAR THEN
659:
660: g_LIMITS_rec.multival_attribute2 := Get_Multival_Attribute2;
661:
662: IF g_LIMITS_rec.multival_attribute2 IS NOT NULL THEN
678: END IF;
679:
680: END IF;
681:
682: IF g_LIMITS_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR THEN
683:
684: g_LIMITS_rec.multival_attr2_datatype := Get_Multival_Attr2_Datatype;
685:
686: IF g_LIMITS_rec.multival_attr2_datatype IS NOT NULL THEN
703:
704: END IF;
705:
706:
707: IF g_LIMITS_rec.organization_flag = FND_API.G_MISS_CHAR THEN
708:
709: g_LIMITS_rec.organization_flag := Get_Organization;
710:
711: IF g_LIMITS_rec.organization_flag IS NOT NULL THEN
727: END IF;
728:
729: END IF;
730:
731: IF g_LIMITS_rec.attribute1 = FND_API.G_MISS_CHAR
732: OR g_LIMITS_rec.attribute10 = FND_API.G_MISS_CHAR
733: OR g_LIMITS_rec.attribute11 = FND_API.G_MISS_CHAR
734: OR g_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR
735: OR g_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR
728:
729: END IF;
730:
731: IF g_LIMITS_rec.attribute1 = FND_API.G_MISS_CHAR
732: OR g_LIMITS_rec.attribute10 = FND_API.G_MISS_CHAR
733: OR g_LIMITS_rec.attribute11 = FND_API.G_MISS_CHAR
734: OR g_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR
735: OR g_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR
736: OR g_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR
729: END IF;
730:
731: IF g_LIMITS_rec.attribute1 = FND_API.G_MISS_CHAR
732: OR g_LIMITS_rec.attribute10 = FND_API.G_MISS_CHAR
733: OR g_LIMITS_rec.attribute11 = FND_API.G_MISS_CHAR
734: OR g_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR
735: OR g_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR
736: OR g_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR
737: OR g_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR
730:
731: IF g_LIMITS_rec.attribute1 = FND_API.G_MISS_CHAR
732: OR g_LIMITS_rec.attribute10 = FND_API.G_MISS_CHAR
733: OR g_LIMITS_rec.attribute11 = FND_API.G_MISS_CHAR
734: OR g_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR
735: OR g_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR
736: OR g_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR
737: OR g_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR
738: OR g_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR
731: IF g_LIMITS_rec.attribute1 = FND_API.G_MISS_CHAR
732: OR g_LIMITS_rec.attribute10 = FND_API.G_MISS_CHAR
733: OR g_LIMITS_rec.attribute11 = FND_API.G_MISS_CHAR
734: OR g_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR
735: OR g_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR
736: OR g_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR
737: OR g_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR
738: OR g_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR
739: OR g_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR
732: OR g_LIMITS_rec.attribute10 = FND_API.G_MISS_CHAR
733: OR g_LIMITS_rec.attribute11 = FND_API.G_MISS_CHAR
734: OR g_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR
735: OR g_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR
736: OR g_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR
737: OR g_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR
738: OR g_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR
739: OR g_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR
740: OR g_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR
733: OR g_LIMITS_rec.attribute11 = FND_API.G_MISS_CHAR
734: OR g_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR
735: OR g_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR
736: OR g_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR
737: OR g_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR
738: OR g_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR
739: OR g_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR
740: OR g_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR
741: OR g_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR
734: OR g_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR
735: OR g_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR
736: OR g_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR
737: OR g_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR
738: OR g_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR
739: OR g_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR
740: OR g_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR
741: OR g_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR
742: OR g_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR
735: OR g_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR
736: OR g_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR
737: OR g_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR
738: OR g_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR
739: OR g_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR
740: OR g_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR
741: OR g_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR
742: OR g_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR
743: OR g_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR
736: OR g_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR
737: OR g_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR
738: OR g_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR
739: OR g_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR
740: OR g_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR
741: OR g_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR
742: OR g_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR
743: OR g_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR
744: OR g_LIMITS_rec.attribute8 = FND_API.G_MISS_CHAR
737: OR g_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR
738: OR g_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR
739: OR g_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR
740: OR g_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR
741: OR g_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR
742: OR g_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR
743: OR g_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR
744: OR g_LIMITS_rec.attribute8 = FND_API.G_MISS_CHAR
745: OR g_LIMITS_rec.attribute9 = FND_API.G_MISS_CHAR
738: OR g_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR
739: OR g_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR
740: OR g_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR
741: OR g_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR
742: OR g_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR
743: OR g_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR
744: OR g_LIMITS_rec.attribute8 = FND_API.G_MISS_CHAR
745: OR g_LIMITS_rec.attribute9 = FND_API.G_MISS_CHAR
746: OR g_LIMITS_rec.context = FND_API.G_MISS_CHAR
739: OR g_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR
740: OR g_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR
741: OR g_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR
742: OR g_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR
743: OR g_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR
744: OR g_LIMITS_rec.attribute8 = FND_API.G_MISS_CHAR
745: OR g_LIMITS_rec.attribute9 = FND_API.G_MISS_CHAR
746: OR g_LIMITS_rec.context = FND_API.G_MISS_CHAR
747: THEN
740: OR g_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR
741: OR g_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR
742: OR g_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR
743: OR g_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR
744: OR g_LIMITS_rec.attribute8 = FND_API.G_MISS_CHAR
745: OR g_LIMITS_rec.attribute9 = FND_API.G_MISS_CHAR
746: OR g_LIMITS_rec.context = FND_API.G_MISS_CHAR
747: THEN
748:
741: OR g_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR
742: OR g_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR
743: OR g_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR
744: OR g_LIMITS_rec.attribute8 = FND_API.G_MISS_CHAR
745: OR g_LIMITS_rec.attribute9 = FND_API.G_MISS_CHAR
746: OR g_LIMITS_rec.context = FND_API.G_MISS_CHAR
747: THEN
748:
749: Get_Flex_Limits;
742: OR g_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR
743: OR g_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR
744: OR g_LIMITS_rec.attribute8 = FND_API.G_MISS_CHAR
745: OR g_LIMITS_rec.attribute9 = FND_API.G_MISS_CHAR
746: OR g_LIMITS_rec.context = FND_API.G_MISS_CHAR
747: THEN
748:
749: Get_Flex_Limits;
750:
749: Get_Flex_Limits;
750:
751: END IF;
752:
753: IF g_LIMITS_rec.created_by = FND_API.G_MISS_NUM THEN
754:
755: g_LIMITS_rec.created_by := NULL;
756:
757: END IF;
755: g_LIMITS_rec.created_by := NULL;
756:
757: END IF;
758:
759: IF g_LIMITS_rec.creation_date = FND_API.G_MISS_DATE THEN
760:
761: g_LIMITS_rec.creation_date := NULL;
762:
763: END IF;
761: g_LIMITS_rec.creation_date := NULL;
762:
763: END IF;
764:
765: IF g_LIMITS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
766:
767: g_LIMITS_rec.last_updated_by := NULL;
768:
769: END IF;
767: g_LIMITS_rec.last_updated_by := NULL;
768:
769: END IF;
770:
771: IF g_LIMITS_rec.last_update_date = FND_API.G_MISS_DATE THEN
772:
773: g_LIMITS_rec.last_update_date := NULL;
774:
775: END IF;
773: g_LIMITS_rec.last_update_date := NULL;
774:
775: END IF;
776:
777: IF g_LIMITS_rec.last_update_login = FND_API.G_MISS_NUM THEN
778:
779: g_LIMITS_rec.last_update_login := NULL;
780:
781: END IF;
779: g_LIMITS_rec.last_update_login := NULL;
780:
781: END IF;
782:
783: IF g_LIMITS_rec.program_application_id = FND_API.G_MISS_NUM THEN
784:
785: g_LIMITS_rec.program_application_id := NULL;
786:
787: END IF;
785: g_LIMITS_rec.program_application_id := NULL;
786:
787: END IF;
788:
789: IF g_LIMITS_rec.program_id = FND_API.G_MISS_NUM THEN
790:
791: g_LIMITS_rec.program_id := NULL;
792:
793: END IF;
791: g_LIMITS_rec.program_id := NULL;
792:
793: END IF;
794:
795: IF g_LIMITS_rec.program_update_date = FND_API.G_MISS_DATE THEN
796:
797: g_LIMITS_rec.program_update_date := NULL;
798:
799: END IF;
797: g_LIMITS_rec.program_update_date := NULL;
798:
799: END IF;
800:
801: IF g_LIMITS_rec.request_id = FND_API.G_MISS_NUM THEN
802:
803: g_LIMITS_rec.request_id := NULL;
804:
805: END IF;
805: END IF;
806:
807: -- Redefault if there are any missing attributes.
808:
809: IF g_LIMITS_rec.amount = FND_API.G_MISS_NUM
810: OR g_LIMITS_rec.attribute1 = FND_API.G_MISS_CHAR
811: OR g_LIMITS_rec.attribute10 = FND_API.G_MISS_CHAR
812: OR g_LIMITS_rec.attribute11 = FND_API.G_MISS_CHAR
813: OR g_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR
806:
807: -- Redefault if there are any missing attributes.
808:
809: IF g_LIMITS_rec.amount = FND_API.G_MISS_NUM
810: OR g_LIMITS_rec.attribute1 = FND_API.G_MISS_CHAR
811: OR g_LIMITS_rec.attribute10 = FND_API.G_MISS_CHAR
812: OR g_LIMITS_rec.attribute11 = FND_API.G_MISS_CHAR
813: OR g_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR
814: OR g_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR
807: -- Redefault if there are any missing attributes.
808:
809: IF g_LIMITS_rec.amount = FND_API.G_MISS_NUM
810: OR g_LIMITS_rec.attribute1 = FND_API.G_MISS_CHAR
811: OR g_LIMITS_rec.attribute10 = FND_API.G_MISS_CHAR
812: OR g_LIMITS_rec.attribute11 = FND_API.G_MISS_CHAR
813: OR g_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR
814: OR g_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR
815: OR g_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR
808:
809: IF g_LIMITS_rec.amount = FND_API.G_MISS_NUM
810: OR g_LIMITS_rec.attribute1 = FND_API.G_MISS_CHAR
811: OR g_LIMITS_rec.attribute10 = FND_API.G_MISS_CHAR
812: OR g_LIMITS_rec.attribute11 = FND_API.G_MISS_CHAR
813: OR g_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR
814: OR g_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR
815: OR g_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR
816: OR g_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR
809: IF g_LIMITS_rec.amount = FND_API.G_MISS_NUM
810: OR g_LIMITS_rec.attribute1 = FND_API.G_MISS_CHAR
811: OR g_LIMITS_rec.attribute10 = FND_API.G_MISS_CHAR
812: OR g_LIMITS_rec.attribute11 = FND_API.G_MISS_CHAR
813: OR g_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR
814: OR g_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR
815: OR g_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR
816: OR g_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR
817: OR g_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR
810: OR g_LIMITS_rec.attribute1 = FND_API.G_MISS_CHAR
811: OR g_LIMITS_rec.attribute10 = FND_API.G_MISS_CHAR
812: OR g_LIMITS_rec.attribute11 = FND_API.G_MISS_CHAR
813: OR g_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR
814: OR g_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR
815: OR g_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR
816: OR g_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR
817: OR g_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR
818: OR g_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR
811: OR g_LIMITS_rec.attribute10 = FND_API.G_MISS_CHAR
812: OR g_LIMITS_rec.attribute11 = FND_API.G_MISS_CHAR
813: OR g_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR
814: OR g_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR
815: OR g_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR
816: OR g_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR
817: OR g_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR
818: OR g_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR
819: OR g_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR
812: OR g_LIMITS_rec.attribute11 = FND_API.G_MISS_CHAR
813: OR g_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR
814: OR g_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR
815: OR g_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR
816: OR g_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR
817: OR g_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR
818: OR g_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR
819: OR g_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR
820: OR g_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR
813: OR g_LIMITS_rec.attribute12 = FND_API.G_MISS_CHAR
814: OR g_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR
815: OR g_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR
816: OR g_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR
817: OR g_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR
818: OR g_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR
819: OR g_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR
820: OR g_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR
821: OR g_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR
814: OR g_LIMITS_rec.attribute13 = FND_API.G_MISS_CHAR
815: OR g_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR
816: OR g_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR
817: OR g_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR
818: OR g_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR
819: OR g_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR
820: OR g_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR
821: OR g_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR
822: OR g_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR
815: OR g_LIMITS_rec.attribute14 = FND_API.G_MISS_CHAR
816: OR g_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR
817: OR g_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR
818: OR g_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR
819: OR g_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR
820: OR g_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR
821: OR g_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR
822: OR g_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR
823: OR g_LIMITS_rec.attribute8 = FND_API.G_MISS_CHAR
816: OR g_LIMITS_rec.attribute15 = FND_API.G_MISS_CHAR
817: OR g_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR
818: OR g_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR
819: OR g_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR
820: OR g_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR
821: OR g_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR
822: OR g_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR
823: OR g_LIMITS_rec.attribute8 = FND_API.G_MISS_CHAR
824: OR g_LIMITS_rec.attribute9 = FND_API.G_MISS_CHAR
817: OR g_LIMITS_rec.attribute2 = FND_API.G_MISS_CHAR
818: OR g_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR
819: OR g_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR
820: OR g_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR
821: OR g_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR
822: OR g_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR
823: OR g_LIMITS_rec.attribute8 = FND_API.G_MISS_CHAR
824: OR g_LIMITS_rec.attribute9 = FND_API.G_MISS_CHAR
825: OR g_LIMITS_rec.basis = FND_API.G_MISS_CHAR
818: OR g_LIMITS_rec.attribute3 = FND_API.G_MISS_CHAR
819: OR g_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR
820: OR g_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR
821: OR g_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR
822: OR g_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR
823: OR g_LIMITS_rec.attribute8 = FND_API.G_MISS_CHAR
824: OR g_LIMITS_rec.attribute9 = FND_API.G_MISS_CHAR
825: OR g_LIMITS_rec.basis = FND_API.G_MISS_CHAR
826: OR g_LIMITS_rec.context = FND_API.G_MISS_CHAR
819: OR g_LIMITS_rec.attribute4 = FND_API.G_MISS_CHAR
820: OR g_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR
821: OR g_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR
822: OR g_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR
823: OR g_LIMITS_rec.attribute8 = FND_API.G_MISS_CHAR
824: OR g_LIMITS_rec.attribute9 = FND_API.G_MISS_CHAR
825: OR g_LIMITS_rec.basis = FND_API.G_MISS_CHAR
826: OR g_LIMITS_rec.context = FND_API.G_MISS_CHAR
827: OR g_LIMITS_rec.created_by = FND_API.G_MISS_NUM
820: OR g_LIMITS_rec.attribute5 = FND_API.G_MISS_CHAR
821: OR g_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR
822: OR g_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR
823: OR g_LIMITS_rec.attribute8 = FND_API.G_MISS_CHAR
824: OR g_LIMITS_rec.attribute9 = FND_API.G_MISS_CHAR
825: OR g_LIMITS_rec.basis = FND_API.G_MISS_CHAR
826: OR g_LIMITS_rec.context = FND_API.G_MISS_CHAR
827: OR g_LIMITS_rec.created_by = FND_API.G_MISS_NUM
828: OR g_LIMITS_rec.creation_date = FND_API.G_MISS_DATE
821: OR g_LIMITS_rec.attribute6 = FND_API.G_MISS_CHAR
822: OR g_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR
823: OR g_LIMITS_rec.attribute8 = FND_API.G_MISS_CHAR
824: OR g_LIMITS_rec.attribute9 = FND_API.G_MISS_CHAR
825: OR g_LIMITS_rec.basis = FND_API.G_MISS_CHAR
826: OR g_LIMITS_rec.context = FND_API.G_MISS_CHAR
827: OR g_LIMITS_rec.created_by = FND_API.G_MISS_NUM
828: OR g_LIMITS_rec.creation_date = FND_API.G_MISS_DATE
829: OR g_LIMITS_rec.last_updated_by = FND_API.G_MISS_NUM
822: OR g_LIMITS_rec.attribute7 = FND_API.G_MISS_CHAR
823: OR g_LIMITS_rec.attribute8 = FND_API.G_MISS_CHAR
824: OR g_LIMITS_rec.attribute9 = FND_API.G_MISS_CHAR
825: OR g_LIMITS_rec.basis = FND_API.G_MISS_CHAR
826: OR g_LIMITS_rec.context = FND_API.G_MISS_CHAR
827: OR g_LIMITS_rec.created_by = FND_API.G_MISS_NUM
828: OR g_LIMITS_rec.creation_date = FND_API.G_MISS_DATE
829: OR g_LIMITS_rec.last_updated_by = FND_API.G_MISS_NUM
830: OR g_LIMITS_rec.last_update_date = FND_API.G_MISS_DATE
823: OR g_LIMITS_rec.attribute8 = FND_API.G_MISS_CHAR
824: OR g_LIMITS_rec.attribute9 = FND_API.G_MISS_CHAR
825: OR g_LIMITS_rec.basis = FND_API.G_MISS_CHAR
826: OR g_LIMITS_rec.context = FND_API.G_MISS_CHAR
827: OR g_LIMITS_rec.created_by = FND_API.G_MISS_NUM
828: OR g_LIMITS_rec.creation_date = FND_API.G_MISS_DATE
829: OR g_LIMITS_rec.last_updated_by = FND_API.G_MISS_NUM
830: OR g_LIMITS_rec.last_update_date = FND_API.G_MISS_DATE
831: OR g_LIMITS_rec.last_update_login = FND_API.G_MISS_NUM
824: OR g_LIMITS_rec.attribute9 = FND_API.G_MISS_CHAR
825: OR g_LIMITS_rec.basis = FND_API.G_MISS_CHAR
826: OR g_LIMITS_rec.context = FND_API.G_MISS_CHAR
827: OR g_LIMITS_rec.created_by = FND_API.G_MISS_NUM
828: OR g_LIMITS_rec.creation_date = FND_API.G_MISS_DATE
829: OR g_LIMITS_rec.last_updated_by = FND_API.G_MISS_NUM
830: OR g_LIMITS_rec.last_update_date = FND_API.G_MISS_DATE
831: OR g_LIMITS_rec.last_update_login = FND_API.G_MISS_NUM
832: OR g_LIMITS_rec.limit_exceed_action_code = FND_API.G_MISS_CHAR
825: OR g_LIMITS_rec.basis = FND_API.G_MISS_CHAR
826: OR g_LIMITS_rec.context = FND_API.G_MISS_CHAR
827: OR g_LIMITS_rec.created_by = FND_API.G_MISS_NUM
828: OR g_LIMITS_rec.creation_date = FND_API.G_MISS_DATE
829: OR g_LIMITS_rec.last_updated_by = FND_API.G_MISS_NUM
830: OR g_LIMITS_rec.last_update_date = FND_API.G_MISS_DATE
831: OR g_LIMITS_rec.last_update_login = FND_API.G_MISS_NUM
832: OR g_LIMITS_rec.limit_exceed_action_code = FND_API.G_MISS_CHAR
833: OR g_LIMITS_rec.limit_id = FND_API.G_MISS_NUM
826: OR g_LIMITS_rec.context = FND_API.G_MISS_CHAR
827: OR g_LIMITS_rec.created_by = FND_API.G_MISS_NUM
828: OR g_LIMITS_rec.creation_date = FND_API.G_MISS_DATE
829: OR g_LIMITS_rec.last_updated_by = FND_API.G_MISS_NUM
830: OR g_LIMITS_rec.last_update_date = FND_API.G_MISS_DATE
831: OR g_LIMITS_rec.last_update_login = FND_API.G_MISS_NUM
832: OR g_LIMITS_rec.limit_exceed_action_code = FND_API.G_MISS_CHAR
833: OR g_LIMITS_rec.limit_id = FND_API.G_MISS_NUM
834: OR g_LIMITS_rec.limit_level_code = FND_API.G_MISS_CHAR
827: OR g_LIMITS_rec.created_by = FND_API.G_MISS_NUM
828: OR g_LIMITS_rec.creation_date = FND_API.G_MISS_DATE
829: OR g_LIMITS_rec.last_updated_by = FND_API.G_MISS_NUM
830: OR g_LIMITS_rec.last_update_date = FND_API.G_MISS_DATE
831: OR g_LIMITS_rec.last_update_login = FND_API.G_MISS_NUM
832: OR g_LIMITS_rec.limit_exceed_action_code = FND_API.G_MISS_CHAR
833: OR g_LIMITS_rec.limit_id = FND_API.G_MISS_NUM
834: OR g_LIMITS_rec.limit_level_code = FND_API.G_MISS_CHAR
835: OR g_LIMITS_rec.limit_number = FND_API.G_MISS_NUM
828: OR g_LIMITS_rec.creation_date = FND_API.G_MISS_DATE
829: OR g_LIMITS_rec.last_updated_by = FND_API.G_MISS_NUM
830: OR g_LIMITS_rec.last_update_date = FND_API.G_MISS_DATE
831: OR g_LIMITS_rec.last_update_login = FND_API.G_MISS_NUM
832: OR g_LIMITS_rec.limit_exceed_action_code = FND_API.G_MISS_CHAR
833: OR g_LIMITS_rec.limit_id = FND_API.G_MISS_NUM
834: OR g_LIMITS_rec.limit_level_code = FND_API.G_MISS_CHAR
835: OR g_LIMITS_rec.limit_number = FND_API.G_MISS_NUM
836: OR g_LIMITS_rec.list_header_id = FND_API.G_MISS_NUM
829: OR g_LIMITS_rec.last_updated_by = FND_API.G_MISS_NUM
830: OR g_LIMITS_rec.last_update_date = FND_API.G_MISS_DATE
831: OR g_LIMITS_rec.last_update_login = FND_API.G_MISS_NUM
832: OR g_LIMITS_rec.limit_exceed_action_code = FND_API.G_MISS_CHAR
833: OR g_LIMITS_rec.limit_id = FND_API.G_MISS_NUM
834: OR g_LIMITS_rec.limit_level_code = FND_API.G_MISS_CHAR
835: OR g_LIMITS_rec.limit_number = FND_API.G_MISS_NUM
836: OR g_LIMITS_rec.list_header_id = FND_API.G_MISS_NUM
837: OR g_LIMITS_rec.list_line_id = FND_API.G_MISS_NUM
830: OR g_LIMITS_rec.last_update_date = FND_API.G_MISS_DATE
831: OR g_LIMITS_rec.last_update_login = FND_API.G_MISS_NUM
832: OR g_LIMITS_rec.limit_exceed_action_code = FND_API.G_MISS_CHAR
833: OR g_LIMITS_rec.limit_id = FND_API.G_MISS_NUM
834: OR g_LIMITS_rec.limit_level_code = FND_API.G_MISS_CHAR
835: OR g_LIMITS_rec.limit_number = FND_API.G_MISS_NUM
836: OR g_LIMITS_rec.list_header_id = FND_API.G_MISS_NUM
837: OR g_LIMITS_rec.list_line_id = FND_API.G_MISS_NUM
838: OR g_LIMITS_rec.multival_attr1_type = FND_API.G_MISS_CHAR
831: OR g_LIMITS_rec.last_update_login = FND_API.G_MISS_NUM
832: OR g_LIMITS_rec.limit_exceed_action_code = FND_API.G_MISS_CHAR
833: OR g_LIMITS_rec.limit_id = FND_API.G_MISS_NUM
834: OR g_LIMITS_rec.limit_level_code = FND_API.G_MISS_CHAR
835: OR g_LIMITS_rec.limit_number = FND_API.G_MISS_NUM
836: OR g_LIMITS_rec.list_header_id = FND_API.G_MISS_NUM
837: OR g_LIMITS_rec.list_line_id = FND_API.G_MISS_NUM
838: OR g_LIMITS_rec.multival_attr1_type = FND_API.G_MISS_CHAR
839: OR g_LIMITS_rec.multival_attr1_context = FND_API.G_MISS_CHAR
832: OR g_LIMITS_rec.limit_exceed_action_code = FND_API.G_MISS_CHAR
833: OR g_LIMITS_rec.limit_id = FND_API.G_MISS_NUM
834: OR g_LIMITS_rec.limit_level_code = FND_API.G_MISS_CHAR
835: OR g_LIMITS_rec.limit_number = FND_API.G_MISS_NUM
836: OR g_LIMITS_rec.list_header_id = FND_API.G_MISS_NUM
837: OR g_LIMITS_rec.list_line_id = FND_API.G_MISS_NUM
838: OR g_LIMITS_rec.multival_attr1_type = FND_API.G_MISS_CHAR
839: OR g_LIMITS_rec.multival_attr1_context = FND_API.G_MISS_CHAR
840: OR g_LIMITS_rec.multival_attribute1 = FND_API.G_MISS_CHAR
833: OR g_LIMITS_rec.limit_id = FND_API.G_MISS_NUM
834: OR g_LIMITS_rec.limit_level_code = FND_API.G_MISS_CHAR
835: OR g_LIMITS_rec.limit_number = FND_API.G_MISS_NUM
836: OR g_LIMITS_rec.list_header_id = FND_API.G_MISS_NUM
837: OR g_LIMITS_rec.list_line_id = FND_API.G_MISS_NUM
838: OR g_LIMITS_rec.multival_attr1_type = FND_API.G_MISS_CHAR
839: OR g_LIMITS_rec.multival_attr1_context = FND_API.G_MISS_CHAR
840: OR g_LIMITS_rec.multival_attribute1 = FND_API.G_MISS_CHAR
841: OR g_LIMITS_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR
834: OR g_LIMITS_rec.limit_level_code = FND_API.G_MISS_CHAR
835: OR g_LIMITS_rec.limit_number = FND_API.G_MISS_NUM
836: OR g_LIMITS_rec.list_header_id = FND_API.G_MISS_NUM
837: OR g_LIMITS_rec.list_line_id = FND_API.G_MISS_NUM
838: OR g_LIMITS_rec.multival_attr1_type = FND_API.G_MISS_CHAR
839: OR g_LIMITS_rec.multival_attr1_context = FND_API.G_MISS_CHAR
840: OR g_LIMITS_rec.multival_attribute1 = FND_API.G_MISS_CHAR
841: OR g_LIMITS_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR
842: OR g_LIMITS_rec.multival_attr2_type = FND_API.G_MISS_CHAR
835: OR g_LIMITS_rec.limit_number = FND_API.G_MISS_NUM
836: OR g_LIMITS_rec.list_header_id = FND_API.G_MISS_NUM
837: OR g_LIMITS_rec.list_line_id = FND_API.G_MISS_NUM
838: OR g_LIMITS_rec.multival_attr1_type = FND_API.G_MISS_CHAR
839: OR g_LIMITS_rec.multival_attr1_context = FND_API.G_MISS_CHAR
840: OR g_LIMITS_rec.multival_attribute1 = FND_API.G_MISS_CHAR
841: OR g_LIMITS_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR
842: OR g_LIMITS_rec.multival_attr2_type = FND_API.G_MISS_CHAR
843: OR g_LIMITS_rec.multival_attr2_context = FND_API.G_MISS_CHAR
836: OR g_LIMITS_rec.list_header_id = FND_API.G_MISS_NUM
837: OR g_LIMITS_rec.list_line_id = FND_API.G_MISS_NUM
838: OR g_LIMITS_rec.multival_attr1_type = FND_API.G_MISS_CHAR
839: OR g_LIMITS_rec.multival_attr1_context = FND_API.G_MISS_CHAR
840: OR g_LIMITS_rec.multival_attribute1 = FND_API.G_MISS_CHAR
841: OR g_LIMITS_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR
842: OR g_LIMITS_rec.multival_attr2_type = FND_API.G_MISS_CHAR
843: OR g_LIMITS_rec.multival_attr2_context = FND_API.G_MISS_CHAR
844: OR g_LIMITS_rec.multival_attribute2 = FND_API.G_MISS_CHAR
837: OR g_LIMITS_rec.list_line_id = FND_API.G_MISS_NUM
838: OR g_LIMITS_rec.multival_attr1_type = FND_API.G_MISS_CHAR
839: OR g_LIMITS_rec.multival_attr1_context = FND_API.G_MISS_CHAR
840: OR g_LIMITS_rec.multival_attribute1 = FND_API.G_MISS_CHAR
841: OR g_LIMITS_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR
842: OR g_LIMITS_rec.multival_attr2_type = FND_API.G_MISS_CHAR
843: OR g_LIMITS_rec.multival_attr2_context = FND_API.G_MISS_CHAR
844: OR g_LIMITS_rec.multival_attribute2 = FND_API.G_MISS_CHAR
845: OR g_LIMITS_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR
838: OR g_LIMITS_rec.multival_attr1_type = FND_API.G_MISS_CHAR
839: OR g_LIMITS_rec.multival_attr1_context = FND_API.G_MISS_CHAR
840: OR g_LIMITS_rec.multival_attribute1 = FND_API.G_MISS_CHAR
841: OR g_LIMITS_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR
842: OR g_LIMITS_rec.multival_attr2_type = FND_API.G_MISS_CHAR
843: OR g_LIMITS_rec.multival_attr2_context = FND_API.G_MISS_CHAR
844: OR g_LIMITS_rec.multival_attribute2 = FND_API.G_MISS_CHAR
845: OR g_LIMITS_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR
846: OR g_LIMITS_rec.organization_flag = FND_API.G_MISS_CHAR
839: OR g_LIMITS_rec.multival_attr1_context = FND_API.G_MISS_CHAR
840: OR g_LIMITS_rec.multival_attribute1 = FND_API.G_MISS_CHAR
841: OR g_LIMITS_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR
842: OR g_LIMITS_rec.multival_attr2_type = FND_API.G_MISS_CHAR
843: OR g_LIMITS_rec.multival_attr2_context = FND_API.G_MISS_CHAR
844: OR g_LIMITS_rec.multival_attribute2 = FND_API.G_MISS_CHAR
845: OR g_LIMITS_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR
846: OR g_LIMITS_rec.organization_flag = FND_API.G_MISS_CHAR
847: OR g_LIMITS_rec.program_application_id = FND_API.G_MISS_NUM
840: OR g_LIMITS_rec.multival_attribute1 = FND_API.G_MISS_CHAR
841: OR g_LIMITS_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR
842: OR g_LIMITS_rec.multival_attr2_type = FND_API.G_MISS_CHAR
843: OR g_LIMITS_rec.multival_attr2_context = FND_API.G_MISS_CHAR
844: OR g_LIMITS_rec.multival_attribute2 = FND_API.G_MISS_CHAR
845: OR g_LIMITS_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR
846: OR g_LIMITS_rec.organization_flag = FND_API.G_MISS_CHAR
847: OR g_LIMITS_rec.program_application_id = FND_API.G_MISS_NUM
848: OR g_LIMITS_rec.program_id = FND_API.G_MISS_NUM
841: OR g_LIMITS_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR
842: OR g_LIMITS_rec.multival_attr2_type = FND_API.G_MISS_CHAR
843: OR g_LIMITS_rec.multival_attr2_context = FND_API.G_MISS_CHAR
844: OR g_LIMITS_rec.multival_attribute2 = FND_API.G_MISS_CHAR
845: OR g_LIMITS_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR
846: OR g_LIMITS_rec.organization_flag = FND_API.G_MISS_CHAR
847: OR g_LIMITS_rec.program_application_id = FND_API.G_MISS_NUM
848: OR g_LIMITS_rec.program_id = FND_API.G_MISS_NUM
849: OR g_LIMITS_rec.program_update_date = FND_API.G_MISS_DATE
842: OR g_LIMITS_rec.multival_attr2_type = FND_API.G_MISS_CHAR
843: OR g_LIMITS_rec.multival_attr2_context = FND_API.G_MISS_CHAR
844: OR g_LIMITS_rec.multival_attribute2 = FND_API.G_MISS_CHAR
845: OR g_LIMITS_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR
846: OR g_LIMITS_rec.organization_flag = FND_API.G_MISS_CHAR
847: OR g_LIMITS_rec.program_application_id = FND_API.G_MISS_NUM
848: OR g_LIMITS_rec.program_id = FND_API.G_MISS_NUM
849: OR g_LIMITS_rec.program_update_date = FND_API.G_MISS_DATE
850: OR g_LIMITS_rec.request_id = FND_API.G_MISS_NUM
843: OR g_LIMITS_rec.multival_attr2_context = FND_API.G_MISS_CHAR
844: OR g_LIMITS_rec.multival_attribute2 = FND_API.G_MISS_CHAR
845: OR g_LIMITS_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR
846: OR g_LIMITS_rec.organization_flag = FND_API.G_MISS_CHAR
847: OR g_LIMITS_rec.program_application_id = FND_API.G_MISS_NUM
848: OR g_LIMITS_rec.program_id = FND_API.G_MISS_NUM
849: OR g_LIMITS_rec.program_update_date = FND_API.G_MISS_DATE
850: OR g_LIMITS_rec.request_id = FND_API.G_MISS_NUM
851: THEN
844: OR g_LIMITS_rec.multival_attribute2 = FND_API.G_MISS_CHAR
845: OR g_LIMITS_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR
846: OR g_LIMITS_rec.organization_flag = FND_API.G_MISS_CHAR
847: OR g_LIMITS_rec.program_application_id = FND_API.G_MISS_NUM
848: OR g_LIMITS_rec.program_id = FND_API.G_MISS_NUM
849: OR g_LIMITS_rec.program_update_date = FND_API.G_MISS_DATE
850: OR g_LIMITS_rec.request_id = FND_API.G_MISS_NUM
851: THEN
852:
845: OR g_LIMITS_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR
846: OR g_LIMITS_rec.organization_flag = FND_API.G_MISS_CHAR
847: OR g_LIMITS_rec.program_application_id = FND_API.G_MISS_NUM
848: OR g_LIMITS_rec.program_id = FND_API.G_MISS_NUM
849: OR g_LIMITS_rec.program_update_date = FND_API.G_MISS_DATE
850: OR g_LIMITS_rec.request_id = FND_API.G_MISS_NUM
851: THEN
852:
853: QP_Default_Limits.Attributes
846: OR g_LIMITS_rec.organization_flag = FND_API.G_MISS_CHAR
847: OR g_LIMITS_rec.program_application_id = FND_API.G_MISS_NUM
848: OR g_LIMITS_rec.program_id = FND_API.G_MISS_NUM
849: OR g_LIMITS_rec.program_update_date = FND_API.G_MISS_DATE
850: OR g_LIMITS_rec.request_id = FND_API.G_MISS_NUM
851: THEN
852:
853: QP_Default_Limits.Attributes
854: ( p_LIMITS_rec => g_LIMITS_rec