186: BEGIN
187:
188: -- In the future call Flex APIs for defaults
189:
190: IF g_LIMIT_BALANCES_rec.attribute1 = FND_API.G_MISS_CHAR THEN
191: g_LIMIT_BALANCES_rec.attribute1 := NULL;
192: END IF;
193:
194: IF g_LIMIT_BALANCES_rec.attribute10 = FND_API.G_MISS_CHAR THEN
190: IF g_LIMIT_BALANCES_rec.attribute1 = FND_API.G_MISS_CHAR THEN
191: g_LIMIT_BALANCES_rec.attribute1 := NULL;
192: END IF;
193:
194: IF g_LIMIT_BALANCES_rec.attribute10 = FND_API.G_MISS_CHAR THEN
195: g_LIMIT_BALANCES_rec.attribute10 := NULL;
196: END IF;
197:
198: IF g_LIMIT_BALANCES_rec.attribute11 = FND_API.G_MISS_CHAR THEN
194: IF g_LIMIT_BALANCES_rec.attribute10 = FND_API.G_MISS_CHAR THEN
195: g_LIMIT_BALANCES_rec.attribute10 := NULL;
196: END IF;
197:
198: IF g_LIMIT_BALANCES_rec.attribute11 = FND_API.G_MISS_CHAR THEN
199: g_LIMIT_BALANCES_rec.attribute11 := NULL;
200: END IF;
201:
202: IF g_LIMIT_BALANCES_rec.attribute12 = FND_API.G_MISS_CHAR THEN
198: IF g_LIMIT_BALANCES_rec.attribute11 = FND_API.G_MISS_CHAR THEN
199: g_LIMIT_BALANCES_rec.attribute11 := NULL;
200: END IF;
201:
202: IF g_LIMIT_BALANCES_rec.attribute12 = FND_API.G_MISS_CHAR THEN
203: g_LIMIT_BALANCES_rec.attribute12 := NULL;
204: END IF;
205:
206: IF g_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR THEN
202: IF g_LIMIT_BALANCES_rec.attribute12 = FND_API.G_MISS_CHAR THEN
203: g_LIMIT_BALANCES_rec.attribute12 := NULL;
204: END IF;
205:
206: IF g_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR THEN
207: g_LIMIT_BALANCES_rec.attribute13 := NULL;
208: END IF;
209:
210: IF g_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR THEN
206: IF g_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR THEN
207: g_LIMIT_BALANCES_rec.attribute13 := NULL;
208: END IF;
209:
210: IF g_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR THEN
211: g_LIMIT_BALANCES_rec.attribute14 := NULL;
212: END IF;
213:
214: IF g_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR THEN
210: IF g_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR THEN
211: g_LIMIT_BALANCES_rec.attribute14 := NULL;
212: END IF;
213:
214: IF g_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR THEN
215: g_LIMIT_BALANCES_rec.attribute15 := NULL;
216: END IF;
217:
218: IF g_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR THEN
214: IF g_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR THEN
215: g_LIMIT_BALANCES_rec.attribute15 := NULL;
216: END IF;
217:
218: IF g_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR THEN
219: g_LIMIT_BALANCES_rec.attribute2 := NULL;
220: END IF;
221:
222: IF g_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR THEN
218: IF g_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR THEN
219: g_LIMIT_BALANCES_rec.attribute2 := NULL;
220: END IF;
221:
222: IF g_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR THEN
223: g_LIMIT_BALANCES_rec.attribute3 := NULL;
224: END IF;
225:
226: IF g_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR THEN
222: IF g_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR THEN
223: g_LIMIT_BALANCES_rec.attribute3 := NULL;
224: END IF;
225:
226: IF g_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR THEN
227: g_LIMIT_BALANCES_rec.attribute4 := NULL;
228: END IF;
229:
230: IF g_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR THEN
226: IF g_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR THEN
227: g_LIMIT_BALANCES_rec.attribute4 := NULL;
228: END IF;
229:
230: IF g_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR THEN
231: g_LIMIT_BALANCES_rec.attribute5 := NULL;
232: END IF;
233:
234: IF g_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR THEN
230: IF g_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR THEN
231: g_LIMIT_BALANCES_rec.attribute5 := NULL;
232: END IF;
233:
234: IF g_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR THEN
235: g_LIMIT_BALANCES_rec.attribute6 := NULL;
236: END IF;
237:
238: IF g_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR THEN
234: IF g_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR THEN
235: g_LIMIT_BALANCES_rec.attribute6 := NULL;
236: END IF;
237:
238: IF g_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR THEN
239: g_LIMIT_BALANCES_rec.attribute7 := NULL;
240: END IF;
241:
242: IF g_LIMIT_BALANCES_rec.attribute8 = FND_API.G_MISS_CHAR THEN
238: IF g_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR THEN
239: g_LIMIT_BALANCES_rec.attribute7 := NULL;
240: END IF;
241:
242: IF g_LIMIT_BALANCES_rec.attribute8 = FND_API.G_MISS_CHAR THEN
243: g_LIMIT_BALANCES_rec.attribute8 := NULL;
244: END IF;
245:
246: IF g_LIMIT_BALANCES_rec.attribute9 = FND_API.G_MISS_CHAR THEN
242: IF g_LIMIT_BALANCES_rec.attribute8 = FND_API.G_MISS_CHAR THEN
243: g_LIMIT_BALANCES_rec.attribute8 := NULL;
244: END IF;
245:
246: IF g_LIMIT_BALANCES_rec.attribute9 = FND_API.G_MISS_CHAR THEN
247: g_LIMIT_BALANCES_rec.attribute9 := NULL;
248: END IF;
249:
250: IF g_LIMIT_BALANCES_rec.context = FND_API.G_MISS_CHAR THEN
246: IF g_LIMIT_BALANCES_rec.attribute9 = FND_API.G_MISS_CHAR THEN
247: g_LIMIT_BALANCES_rec.attribute9 := NULL;
248: END IF;
249:
250: IF g_LIMIT_BALANCES_rec.context = FND_API.G_MISS_CHAR THEN
251: g_LIMIT_BALANCES_rec.context := NULL;
252: END IF;
253:
254: END Get_Flex_Limit_Balances;
276: OE_MSG_PUB.Add;
277:
278: END IF;
279:
280: RAISE FND_API.G_EXC_ERROR;
281:
282: END IF;
283:
284: -- Initialize g_LIMIT_BALANCES_rec
286: g_LIMIT_BALANCES_rec := p_LIMIT_BALANCES_rec;
287:
288: -- Default missing attributes.
289:
290: IF g_LIMIT_BALANCES_rec.available_amount = FND_API.G_MISS_NUM THEN
291:
292: g_LIMIT_BALANCES_rec.available_amount := Get_Available_Amount;
293:
294: IF g_LIMIT_BALANCES_rec.available_amount IS NOT NULL THEN
310: END IF;
311:
312: END IF;
313:
314: IF g_LIMIT_BALANCES_rec.consumed_amount = FND_API.G_MISS_NUM THEN
315:
316: g_LIMIT_BALANCES_rec.consumed_amount := Get_Consumed_Amount;
317:
318: IF g_LIMIT_BALANCES_rec.consumed_amount IS NOT NULL THEN
335:
336: END IF;
337:
338:
339: IF g_LIMIT_BALANCES_rec.limit_balance_id = FND_API.G_MISS_NUM THEN
340:
341: g_LIMIT_BALANCES_rec.limit_balance_id := Get_Limit_Balance;
342:
343: IF g_LIMIT_BALANCES_rec.limit_balance_id IS NOT NULL THEN
359: END IF;
360:
361: END IF;
362:
363: IF g_LIMIT_BALANCES_rec.limit_id = FND_API.G_MISS_NUM THEN
364:
365: g_LIMIT_BALANCES_rec.limit_id := Get_Limit;
366:
367: IF g_LIMIT_BALANCES_rec.limit_id IS NOT NULL THEN
383: END IF;
384:
385: END IF;
386:
387: IF g_LIMIT_BALANCES_rec.multival_attr1_type = FND_API.G_MISS_CHAR THEN
388:
389: g_LIMIT_BALANCES_rec.multival_attr1_type := Get_Multival_Attr1_Type;
390:
391: IF g_LIMIT_BALANCES_rec.multival_attr1_type IS NOT NULL THEN
407: END IF;
408:
409: END IF;
410:
411: IF g_LIMIT_BALANCES_rec.multival_attr1_context = FND_API.G_MISS_CHAR THEN
412:
413: g_LIMIT_BALANCES_rec.multival_attr1_context := Get_Multival_Attr1_Context;
414:
415: IF g_LIMIT_BALANCES_rec.multival_attr1_context IS NOT NULL THEN
431: END IF;
432:
433: END IF;
434:
435: IF g_LIMIT_BALANCES_rec.multival_attribute1 = FND_API.G_MISS_CHAR THEN
436:
437: g_LIMIT_BALANCES_rec.multival_attribute1 := Get_Multival_Attribute1;
438:
439: IF g_LIMIT_BALANCES_rec.multival_attribute1 IS NOT NULL THEN
455: END IF;
456:
457: END IF;
458:
459: IF g_LIMIT_BALANCES_rec.multival_attr1_value = FND_API.G_MISS_CHAR THEN
460:
461: g_LIMIT_BALANCES_rec.multival_attr1_value := Get_Multival_Attr1_Value;
462:
463: IF g_LIMIT_BALANCES_rec.multival_attr1_value IS NOT NULL THEN
479: END IF;
480:
481: END IF;
482:
483: IF g_LIMIT_BALANCES_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR THEN
484:
485: g_LIMIT_BALANCES_rec.multival_attr1_datatype := Get_Multival_Attr1_Datatype;
486:
487: IF g_LIMIT_BALANCES_rec.multival_attr1_datatype IS NOT NULL THEN
504:
505: END IF;
506:
507:
508: IF g_LIMIT_BALANCES_rec.multival_attr2_type = FND_API.G_MISS_CHAR THEN
509:
510: g_LIMIT_BALANCES_rec.multival_attr2_type := Get_Multival_Attr2_Type;
511:
512: IF g_LIMIT_BALANCES_rec.multival_attr2_type IS NOT NULL THEN
528: END IF;
529:
530: END IF;
531:
532: IF g_LIMIT_BALANCES_rec.multival_attr2_context = FND_API.G_MISS_CHAR THEN
533:
534: g_LIMIT_BALANCES_rec.multival_attr2_context := Get_Multival_Attr2_Context;
535:
536: IF g_LIMIT_BALANCES_rec.multival_attr2_context IS NOT NULL THEN
552: END IF;
553:
554: END IF;
555:
556: IF g_LIMIT_BALANCES_rec.multival_attribute2 = FND_API.G_MISS_CHAR THEN
557:
558: g_LIMIT_BALANCES_rec.multival_attribute2 := Get_Multival_Attribute2;
559:
560: IF g_LIMIT_BALANCES_rec.multival_attribute2 IS NOT NULL THEN
576: END IF;
577:
578: END IF;
579:
580: IF g_LIMIT_BALANCES_rec.multival_attr2_value = FND_API.G_MISS_CHAR THEN
581:
582: g_LIMIT_BALANCES_rec.multival_attr2_value := Get_Multival_Attr2_Value;
583:
584: IF g_LIMIT_BALANCES_rec.multival_attr2_value IS NOT NULL THEN
600: END IF;
601:
602: END IF;
603:
604: IF g_LIMIT_BALANCES_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR THEN
605:
606: g_LIMIT_BALANCES_rec.multival_attr2_datatype := Get_Multival_Attr2_Datatype;
607:
608: IF g_LIMIT_BALANCES_rec.multival_attr2_datatype IS NOT NULL THEN
624: END IF;
625:
626: END IF;
627:
628: IF g_LIMIT_BALANCES_rec.organization_attr_context = FND_API.G_MISS_CHAR THEN
629:
630: g_LIMIT_BALANCES_rec.organization_attr_context := Get_Organization_Attr_Context;
631:
632: IF g_LIMIT_BALANCES_rec.organization_attr_context IS NOT NULL THEN
648: END IF;
649:
650: END IF;
651:
652: IF g_LIMIT_BALANCES_rec.organization_attribute = FND_API.G_MISS_CHAR THEN
653:
654: g_LIMIT_BALANCES_rec.organization_attribute := Get_Organization_Attribute;
655:
656: IF g_LIMIT_BALANCES_rec.organization_attribute IS NOT NULL THEN
673:
674: END IF;
675:
676:
677: IF g_LIMIT_BALANCES_rec.organization_attr_value = FND_API.G_MISS_CHAR THEN
678:
679: g_LIMIT_BALANCES_rec.organization_attr_value := Get_Organization_Attr_Value;
680:
681: IF g_LIMIT_BALANCES_rec.organization_attr_value IS NOT NULL THEN
698:
699: END IF;
700:
701:
702: IF g_LIMIT_BALANCES_rec.reserved_amount = FND_API.G_MISS_NUM THEN
703:
704: g_LIMIT_BALANCES_rec.reserved_amount := Get_Reserved_Amount;
705:
706: IF g_LIMIT_BALANCES_rec.reserved_amount IS NOT NULL THEN
722: END IF;
723:
724: END IF;
725:
726: IF g_LIMIT_BALANCES_rec.attribute1 = FND_API.G_MISS_CHAR
727: OR g_LIMIT_BALANCES_rec.attribute10 = FND_API.G_MISS_CHAR
728: OR g_LIMIT_BALANCES_rec.attribute11 = FND_API.G_MISS_CHAR
729: OR g_LIMIT_BALANCES_rec.attribute12 = FND_API.G_MISS_CHAR
730: OR g_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR
723:
724: END IF;
725:
726: IF g_LIMIT_BALANCES_rec.attribute1 = FND_API.G_MISS_CHAR
727: OR g_LIMIT_BALANCES_rec.attribute10 = FND_API.G_MISS_CHAR
728: OR g_LIMIT_BALANCES_rec.attribute11 = FND_API.G_MISS_CHAR
729: OR g_LIMIT_BALANCES_rec.attribute12 = FND_API.G_MISS_CHAR
730: OR g_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR
731: OR g_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR
724: END IF;
725:
726: IF g_LIMIT_BALANCES_rec.attribute1 = FND_API.G_MISS_CHAR
727: OR g_LIMIT_BALANCES_rec.attribute10 = FND_API.G_MISS_CHAR
728: OR g_LIMIT_BALANCES_rec.attribute11 = FND_API.G_MISS_CHAR
729: OR g_LIMIT_BALANCES_rec.attribute12 = FND_API.G_MISS_CHAR
730: OR g_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR
731: OR g_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR
732: OR g_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR
725:
726: IF g_LIMIT_BALANCES_rec.attribute1 = FND_API.G_MISS_CHAR
727: OR g_LIMIT_BALANCES_rec.attribute10 = FND_API.G_MISS_CHAR
728: OR g_LIMIT_BALANCES_rec.attribute11 = FND_API.G_MISS_CHAR
729: OR g_LIMIT_BALANCES_rec.attribute12 = FND_API.G_MISS_CHAR
730: OR g_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR
731: OR g_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR
732: OR g_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR
733: OR g_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR
726: IF g_LIMIT_BALANCES_rec.attribute1 = FND_API.G_MISS_CHAR
727: OR g_LIMIT_BALANCES_rec.attribute10 = FND_API.G_MISS_CHAR
728: OR g_LIMIT_BALANCES_rec.attribute11 = FND_API.G_MISS_CHAR
729: OR g_LIMIT_BALANCES_rec.attribute12 = FND_API.G_MISS_CHAR
730: OR g_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR
731: OR g_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR
732: OR g_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR
733: OR g_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR
734: OR g_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR
727: OR g_LIMIT_BALANCES_rec.attribute10 = FND_API.G_MISS_CHAR
728: OR g_LIMIT_BALANCES_rec.attribute11 = FND_API.G_MISS_CHAR
729: OR g_LIMIT_BALANCES_rec.attribute12 = FND_API.G_MISS_CHAR
730: OR g_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR
731: OR g_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR
732: OR g_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR
733: OR g_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR
734: OR g_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR
735: OR g_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR
728: OR g_LIMIT_BALANCES_rec.attribute11 = FND_API.G_MISS_CHAR
729: OR g_LIMIT_BALANCES_rec.attribute12 = FND_API.G_MISS_CHAR
730: OR g_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR
731: OR g_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR
732: OR g_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR
733: OR g_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR
734: OR g_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR
735: OR g_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR
736: OR g_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR
729: OR g_LIMIT_BALANCES_rec.attribute12 = FND_API.G_MISS_CHAR
730: OR g_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR
731: OR g_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR
732: OR g_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR
733: OR g_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR
734: OR g_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR
735: OR g_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR
736: OR g_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR
737: OR g_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR
730: OR g_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR
731: OR g_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR
732: OR g_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR
733: OR g_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR
734: OR g_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR
735: OR g_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR
736: OR g_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR
737: OR g_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR
738: OR g_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR
731: OR g_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR
732: OR g_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR
733: OR g_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR
734: OR g_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR
735: OR g_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR
736: OR g_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR
737: OR g_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR
738: OR g_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR
739: OR g_LIMIT_BALANCES_rec.attribute8 = FND_API.G_MISS_CHAR
732: OR g_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR
733: OR g_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR
734: OR g_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR
735: OR g_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR
736: OR g_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR
737: OR g_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR
738: OR g_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR
739: OR g_LIMIT_BALANCES_rec.attribute8 = FND_API.G_MISS_CHAR
740: OR g_LIMIT_BALANCES_rec.attribute9 = FND_API.G_MISS_CHAR
733: OR g_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR
734: OR g_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR
735: OR g_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR
736: OR g_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR
737: OR g_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR
738: OR g_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR
739: OR g_LIMIT_BALANCES_rec.attribute8 = FND_API.G_MISS_CHAR
740: OR g_LIMIT_BALANCES_rec.attribute9 = FND_API.G_MISS_CHAR
741: OR g_LIMIT_BALANCES_rec.context = FND_API.G_MISS_CHAR
734: OR g_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR
735: OR g_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR
736: OR g_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR
737: OR g_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR
738: OR g_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR
739: OR g_LIMIT_BALANCES_rec.attribute8 = FND_API.G_MISS_CHAR
740: OR g_LIMIT_BALANCES_rec.attribute9 = FND_API.G_MISS_CHAR
741: OR g_LIMIT_BALANCES_rec.context = FND_API.G_MISS_CHAR
742: THEN
735: OR g_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR
736: OR g_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR
737: OR g_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR
738: OR g_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR
739: OR g_LIMIT_BALANCES_rec.attribute8 = FND_API.G_MISS_CHAR
740: OR g_LIMIT_BALANCES_rec.attribute9 = FND_API.G_MISS_CHAR
741: OR g_LIMIT_BALANCES_rec.context = FND_API.G_MISS_CHAR
742: THEN
743:
736: OR g_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR
737: OR g_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR
738: OR g_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR
739: OR g_LIMIT_BALANCES_rec.attribute8 = FND_API.G_MISS_CHAR
740: OR g_LIMIT_BALANCES_rec.attribute9 = FND_API.G_MISS_CHAR
741: OR g_LIMIT_BALANCES_rec.context = FND_API.G_MISS_CHAR
742: THEN
743:
744: Get_Flex_Limit_Balances;
737: OR g_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR
738: OR g_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR
739: OR g_LIMIT_BALANCES_rec.attribute8 = FND_API.G_MISS_CHAR
740: OR g_LIMIT_BALANCES_rec.attribute9 = FND_API.G_MISS_CHAR
741: OR g_LIMIT_BALANCES_rec.context = FND_API.G_MISS_CHAR
742: THEN
743:
744: Get_Flex_Limit_Balances;
745:
744: Get_Flex_Limit_Balances;
745:
746: END IF;
747:
748: IF g_LIMIT_BALANCES_rec.created_by = FND_API.G_MISS_NUM THEN
749:
750: g_LIMIT_BALANCES_rec.created_by := NULL;
751:
752: END IF;
750: g_LIMIT_BALANCES_rec.created_by := NULL;
751:
752: END IF;
753:
754: IF g_LIMIT_BALANCES_rec.creation_date = FND_API.G_MISS_DATE THEN
755:
756: g_LIMIT_BALANCES_rec.creation_date := NULL;
757:
758: END IF;
756: g_LIMIT_BALANCES_rec.creation_date := NULL;
757:
758: END IF;
759:
760: IF g_LIMIT_BALANCES_rec.last_updated_by = FND_API.G_MISS_NUM THEN
761:
762: g_LIMIT_BALANCES_rec.last_updated_by := NULL;
763:
764: END IF;
762: g_LIMIT_BALANCES_rec.last_updated_by := NULL;
763:
764: END IF;
765:
766: IF g_LIMIT_BALANCES_rec.last_update_date = FND_API.G_MISS_DATE THEN
767:
768: g_LIMIT_BALANCES_rec.last_update_date := NULL;
769:
770: END IF;
768: g_LIMIT_BALANCES_rec.last_update_date := NULL;
769:
770: END IF;
771:
772: IF g_LIMIT_BALANCES_rec.last_update_login = FND_API.G_MISS_NUM THEN
773:
774: g_LIMIT_BALANCES_rec.last_update_login := NULL;
775:
776: END IF;
774: g_LIMIT_BALANCES_rec.last_update_login := NULL;
775:
776: END IF;
777:
778: IF g_LIMIT_BALANCES_rec.program_application_id = FND_API.G_MISS_NUM THEN
779:
780: g_LIMIT_BALANCES_rec.program_application_id := NULL;
781:
782: END IF;
780: g_LIMIT_BALANCES_rec.program_application_id := NULL;
781:
782: END IF;
783:
784: IF g_LIMIT_BALANCES_rec.program_id = FND_API.G_MISS_NUM THEN
785:
786: g_LIMIT_BALANCES_rec.program_id := NULL;
787:
788: END IF;
786: g_LIMIT_BALANCES_rec.program_id := NULL;
787:
788: END IF;
789:
790: IF g_LIMIT_BALANCES_rec.program_update_date = FND_API.G_MISS_DATE THEN
791:
792: g_LIMIT_BALANCES_rec.program_update_date := NULL;
793:
794: END IF;
792: g_LIMIT_BALANCES_rec.program_update_date := NULL;
793:
794: END IF;
795:
796: IF g_LIMIT_BALANCES_rec.request_id = FND_API.G_MISS_NUM THEN
797:
798: g_LIMIT_BALANCES_rec.request_id := NULL;
799:
800: END IF;
800: END IF;
801:
802: -- Redefault if there are any missing attributes.
803:
804: IF g_LIMIT_BALANCES_rec.attribute1 = FND_API.G_MISS_CHAR
805: OR g_LIMIT_BALANCES_rec.attribute10 = FND_API.G_MISS_CHAR
806: OR g_LIMIT_BALANCES_rec.attribute11 = FND_API.G_MISS_CHAR
807: OR g_LIMIT_BALANCES_rec.attribute12 = FND_API.G_MISS_CHAR
808: OR g_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR
801:
802: -- Redefault if there are any missing attributes.
803:
804: IF g_LIMIT_BALANCES_rec.attribute1 = FND_API.G_MISS_CHAR
805: OR g_LIMIT_BALANCES_rec.attribute10 = FND_API.G_MISS_CHAR
806: OR g_LIMIT_BALANCES_rec.attribute11 = FND_API.G_MISS_CHAR
807: OR g_LIMIT_BALANCES_rec.attribute12 = FND_API.G_MISS_CHAR
808: OR g_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR
809: OR g_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR
802: -- Redefault if there are any missing attributes.
803:
804: IF g_LIMIT_BALANCES_rec.attribute1 = FND_API.G_MISS_CHAR
805: OR g_LIMIT_BALANCES_rec.attribute10 = FND_API.G_MISS_CHAR
806: OR g_LIMIT_BALANCES_rec.attribute11 = FND_API.G_MISS_CHAR
807: OR g_LIMIT_BALANCES_rec.attribute12 = FND_API.G_MISS_CHAR
808: OR g_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR
809: OR g_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR
810: OR g_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR
803:
804: IF g_LIMIT_BALANCES_rec.attribute1 = FND_API.G_MISS_CHAR
805: OR g_LIMIT_BALANCES_rec.attribute10 = FND_API.G_MISS_CHAR
806: OR g_LIMIT_BALANCES_rec.attribute11 = FND_API.G_MISS_CHAR
807: OR g_LIMIT_BALANCES_rec.attribute12 = FND_API.G_MISS_CHAR
808: OR g_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR
809: OR g_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR
810: OR g_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR
811: OR g_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR
804: IF g_LIMIT_BALANCES_rec.attribute1 = FND_API.G_MISS_CHAR
805: OR g_LIMIT_BALANCES_rec.attribute10 = FND_API.G_MISS_CHAR
806: OR g_LIMIT_BALANCES_rec.attribute11 = FND_API.G_MISS_CHAR
807: OR g_LIMIT_BALANCES_rec.attribute12 = FND_API.G_MISS_CHAR
808: OR g_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR
809: OR g_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR
810: OR g_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR
811: OR g_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR
812: OR g_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR
805: OR g_LIMIT_BALANCES_rec.attribute10 = FND_API.G_MISS_CHAR
806: OR g_LIMIT_BALANCES_rec.attribute11 = FND_API.G_MISS_CHAR
807: OR g_LIMIT_BALANCES_rec.attribute12 = FND_API.G_MISS_CHAR
808: OR g_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR
809: OR g_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR
810: OR g_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR
811: OR g_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR
812: OR g_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR
813: OR g_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR
806: OR g_LIMIT_BALANCES_rec.attribute11 = FND_API.G_MISS_CHAR
807: OR g_LIMIT_BALANCES_rec.attribute12 = FND_API.G_MISS_CHAR
808: OR g_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR
809: OR g_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR
810: OR g_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR
811: OR g_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR
812: OR g_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR
813: OR g_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR
814: OR g_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR
807: OR g_LIMIT_BALANCES_rec.attribute12 = FND_API.G_MISS_CHAR
808: OR g_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR
809: OR g_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR
810: OR g_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR
811: OR g_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR
812: OR g_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR
813: OR g_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR
814: OR g_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR
815: OR g_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR
808: OR g_LIMIT_BALANCES_rec.attribute13 = FND_API.G_MISS_CHAR
809: OR g_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR
810: OR g_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR
811: OR g_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR
812: OR g_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR
813: OR g_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR
814: OR g_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR
815: OR g_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR
816: OR g_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR
809: OR g_LIMIT_BALANCES_rec.attribute14 = FND_API.G_MISS_CHAR
810: OR g_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR
811: OR g_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR
812: OR g_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR
813: OR g_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR
814: OR g_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR
815: OR g_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR
816: OR g_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR
817: OR g_LIMIT_BALANCES_rec.attribute8 = FND_API.G_MISS_CHAR
810: OR g_LIMIT_BALANCES_rec.attribute15 = FND_API.G_MISS_CHAR
811: OR g_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR
812: OR g_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR
813: OR g_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR
814: OR g_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR
815: OR g_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR
816: OR g_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR
817: OR g_LIMIT_BALANCES_rec.attribute8 = FND_API.G_MISS_CHAR
818: OR g_LIMIT_BALANCES_rec.attribute9 = FND_API.G_MISS_CHAR
811: OR g_LIMIT_BALANCES_rec.attribute2 = FND_API.G_MISS_CHAR
812: OR g_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR
813: OR g_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR
814: OR g_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR
815: OR g_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR
816: OR g_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR
817: OR g_LIMIT_BALANCES_rec.attribute8 = FND_API.G_MISS_CHAR
818: OR g_LIMIT_BALANCES_rec.attribute9 = FND_API.G_MISS_CHAR
819: OR g_LIMIT_BALANCES_rec.available_amount = FND_API.G_MISS_NUM
812: OR g_LIMIT_BALANCES_rec.attribute3 = FND_API.G_MISS_CHAR
813: OR g_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR
814: OR g_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR
815: OR g_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR
816: OR g_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR
817: OR g_LIMIT_BALANCES_rec.attribute8 = FND_API.G_MISS_CHAR
818: OR g_LIMIT_BALANCES_rec.attribute9 = FND_API.G_MISS_CHAR
819: OR g_LIMIT_BALANCES_rec.available_amount = FND_API.G_MISS_NUM
820: OR g_LIMIT_BALANCES_rec.consumed_amount = FND_API.G_MISS_NUM
813: OR g_LIMIT_BALANCES_rec.attribute4 = FND_API.G_MISS_CHAR
814: OR g_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR
815: OR g_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR
816: OR g_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR
817: OR g_LIMIT_BALANCES_rec.attribute8 = FND_API.G_MISS_CHAR
818: OR g_LIMIT_BALANCES_rec.attribute9 = FND_API.G_MISS_CHAR
819: OR g_LIMIT_BALANCES_rec.available_amount = FND_API.G_MISS_NUM
820: OR g_LIMIT_BALANCES_rec.consumed_amount = FND_API.G_MISS_NUM
821: OR g_LIMIT_BALANCES_rec.context = FND_API.G_MISS_CHAR
814: OR g_LIMIT_BALANCES_rec.attribute5 = FND_API.G_MISS_CHAR
815: OR g_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR
816: OR g_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR
817: OR g_LIMIT_BALANCES_rec.attribute8 = FND_API.G_MISS_CHAR
818: OR g_LIMIT_BALANCES_rec.attribute9 = FND_API.G_MISS_CHAR
819: OR g_LIMIT_BALANCES_rec.available_amount = FND_API.G_MISS_NUM
820: OR g_LIMIT_BALANCES_rec.consumed_amount = FND_API.G_MISS_NUM
821: OR g_LIMIT_BALANCES_rec.context = FND_API.G_MISS_CHAR
822: OR g_LIMIT_BALANCES_rec.created_by = FND_API.G_MISS_NUM
815: OR g_LIMIT_BALANCES_rec.attribute6 = FND_API.G_MISS_CHAR
816: OR g_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR
817: OR g_LIMIT_BALANCES_rec.attribute8 = FND_API.G_MISS_CHAR
818: OR g_LIMIT_BALANCES_rec.attribute9 = FND_API.G_MISS_CHAR
819: OR g_LIMIT_BALANCES_rec.available_amount = FND_API.G_MISS_NUM
820: OR g_LIMIT_BALANCES_rec.consumed_amount = FND_API.G_MISS_NUM
821: OR g_LIMIT_BALANCES_rec.context = FND_API.G_MISS_CHAR
822: OR g_LIMIT_BALANCES_rec.created_by = FND_API.G_MISS_NUM
823: OR g_LIMIT_BALANCES_rec.creation_date = FND_API.G_MISS_DATE
816: OR g_LIMIT_BALANCES_rec.attribute7 = FND_API.G_MISS_CHAR
817: OR g_LIMIT_BALANCES_rec.attribute8 = FND_API.G_MISS_CHAR
818: OR g_LIMIT_BALANCES_rec.attribute9 = FND_API.G_MISS_CHAR
819: OR g_LIMIT_BALANCES_rec.available_amount = FND_API.G_MISS_NUM
820: OR g_LIMIT_BALANCES_rec.consumed_amount = FND_API.G_MISS_NUM
821: OR g_LIMIT_BALANCES_rec.context = FND_API.G_MISS_CHAR
822: OR g_LIMIT_BALANCES_rec.created_by = FND_API.G_MISS_NUM
823: OR g_LIMIT_BALANCES_rec.creation_date = FND_API.G_MISS_DATE
824: OR g_LIMIT_BALANCES_rec.last_updated_by = FND_API.G_MISS_NUM
817: OR g_LIMIT_BALANCES_rec.attribute8 = FND_API.G_MISS_CHAR
818: OR g_LIMIT_BALANCES_rec.attribute9 = FND_API.G_MISS_CHAR
819: OR g_LIMIT_BALANCES_rec.available_amount = FND_API.G_MISS_NUM
820: OR g_LIMIT_BALANCES_rec.consumed_amount = FND_API.G_MISS_NUM
821: OR g_LIMIT_BALANCES_rec.context = FND_API.G_MISS_CHAR
822: OR g_LIMIT_BALANCES_rec.created_by = FND_API.G_MISS_NUM
823: OR g_LIMIT_BALANCES_rec.creation_date = FND_API.G_MISS_DATE
824: OR g_LIMIT_BALANCES_rec.last_updated_by = FND_API.G_MISS_NUM
825: OR g_LIMIT_BALANCES_rec.last_update_date = FND_API.G_MISS_DATE
818: OR g_LIMIT_BALANCES_rec.attribute9 = FND_API.G_MISS_CHAR
819: OR g_LIMIT_BALANCES_rec.available_amount = FND_API.G_MISS_NUM
820: OR g_LIMIT_BALANCES_rec.consumed_amount = FND_API.G_MISS_NUM
821: OR g_LIMIT_BALANCES_rec.context = FND_API.G_MISS_CHAR
822: OR g_LIMIT_BALANCES_rec.created_by = FND_API.G_MISS_NUM
823: OR g_LIMIT_BALANCES_rec.creation_date = FND_API.G_MISS_DATE
824: OR g_LIMIT_BALANCES_rec.last_updated_by = FND_API.G_MISS_NUM
825: OR g_LIMIT_BALANCES_rec.last_update_date = FND_API.G_MISS_DATE
826: OR g_LIMIT_BALANCES_rec.last_update_login = FND_API.G_MISS_NUM
819: OR g_LIMIT_BALANCES_rec.available_amount = FND_API.G_MISS_NUM
820: OR g_LIMIT_BALANCES_rec.consumed_amount = FND_API.G_MISS_NUM
821: OR g_LIMIT_BALANCES_rec.context = FND_API.G_MISS_CHAR
822: OR g_LIMIT_BALANCES_rec.created_by = FND_API.G_MISS_NUM
823: OR g_LIMIT_BALANCES_rec.creation_date = FND_API.G_MISS_DATE
824: OR g_LIMIT_BALANCES_rec.last_updated_by = FND_API.G_MISS_NUM
825: OR g_LIMIT_BALANCES_rec.last_update_date = FND_API.G_MISS_DATE
826: OR g_LIMIT_BALANCES_rec.last_update_login = FND_API.G_MISS_NUM
827: OR g_LIMIT_BALANCES_rec.limit_balance_id = FND_API.G_MISS_NUM
820: OR g_LIMIT_BALANCES_rec.consumed_amount = FND_API.G_MISS_NUM
821: OR g_LIMIT_BALANCES_rec.context = FND_API.G_MISS_CHAR
822: OR g_LIMIT_BALANCES_rec.created_by = FND_API.G_MISS_NUM
823: OR g_LIMIT_BALANCES_rec.creation_date = FND_API.G_MISS_DATE
824: OR g_LIMIT_BALANCES_rec.last_updated_by = FND_API.G_MISS_NUM
825: OR g_LIMIT_BALANCES_rec.last_update_date = FND_API.G_MISS_DATE
826: OR g_LIMIT_BALANCES_rec.last_update_login = FND_API.G_MISS_NUM
827: OR g_LIMIT_BALANCES_rec.limit_balance_id = FND_API.G_MISS_NUM
828: OR g_LIMIT_BALANCES_rec.limit_id = FND_API.G_MISS_NUM
821: OR g_LIMIT_BALANCES_rec.context = FND_API.G_MISS_CHAR
822: OR g_LIMIT_BALANCES_rec.created_by = FND_API.G_MISS_NUM
823: OR g_LIMIT_BALANCES_rec.creation_date = FND_API.G_MISS_DATE
824: OR g_LIMIT_BALANCES_rec.last_updated_by = FND_API.G_MISS_NUM
825: OR g_LIMIT_BALANCES_rec.last_update_date = FND_API.G_MISS_DATE
826: OR g_LIMIT_BALANCES_rec.last_update_login = FND_API.G_MISS_NUM
827: OR g_LIMIT_BALANCES_rec.limit_balance_id = FND_API.G_MISS_NUM
828: OR g_LIMIT_BALANCES_rec.limit_id = FND_API.G_MISS_NUM
829: OR g_LIMIT_BALANCES_rec.multival_attr1_type = FND_API.G_MISS_CHAR
822: OR g_LIMIT_BALANCES_rec.created_by = FND_API.G_MISS_NUM
823: OR g_LIMIT_BALANCES_rec.creation_date = FND_API.G_MISS_DATE
824: OR g_LIMIT_BALANCES_rec.last_updated_by = FND_API.G_MISS_NUM
825: OR g_LIMIT_BALANCES_rec.last_update_date = FND_API.G_MISS_DATE
826: OR g_LIMIT_BALANCES_rec.last_update_login = FND_API.G_MISS_NUM
827: OR g_LIMIT_BALANCES_rec.limit_balance_id = FND_API.G_MISS_NUM
828: OR g_LIMIT_BALANCES_rec.limit_id = FND_API.G_MISS_NUM
829: OR g_LIMIT_BALANCES_rec.multival_attr1_type = FND_API.G_MISS_CHAR
830: OR g_LIMIT_BALANCES_rec.multival_attr1_context = FND_API.G_MISS_CHAR
823: OR g_LIMIT_BALANCES_rec.creation_date = FND_API.G_MISS_DATE
824: OR g_LIMIT_BALANCES_rec.last_updated_by = FND_API.G_MISS_NUM
825: OR g_LIMIT_BALANCES_rec.last_update_date = FND_API.G_MISS_DATE
826: OR g_LIMIT_BALANCES_rec.last_update_login = FND_API.G_MISS_NUM
827: OR g_LIMIT_BALANCES_rec.limit_balance_id = FND_API.G_MISS_NUM
828: OR g_LIMIT_BALANCES_rec.limit_id = FND_API.G_MISS_NUM
829: OR g_LIMIT_BALANCES_rec.multival_attr1_type = FND_API.G_MISS_CHAR
830: OR g_LIMIT_BALANCES_rec.multival_attr1_context = FND_API.G_MISS_CHAR
831: OR g_LIMIT_BALANCES_rec.multival_attribute1 = FND_API.G_MISS_CHAR
824: OR g_LIMIT_BALANCES_rec.last_updated_by = FND_API.G_MISS_NUM
825: OR g_LIMIT_BALANCES_rec.last_update_date = FND_API.G_MISS_DATE
826: OR g_LIMIT_BALANCES_rec.last_update_login = FND_API.G_MISS_NUM
827: OR g_LIMIT_BALANCES_rec.limit_balance_id = FND_API.G_MISS_NUM
828: OR g_LIMIT_BALANCES_rec.limit_id = FND_API.G_MISS_NUM
829: OR g_LIMIT_BALANCES_rec.multival_attr1_type = FND_API.G_MISS_CHAR
830: OR g_LIMIT_BALANCES_rec.multival_attr1_context = FND_API.G_MISS_CHAR
831: OR g_LIMIT_BALANCES_rec.multival_attribute1 = FND_API.G_MISS_CHAR
832: OR g_LIMIT_BALANCES_rec.multival_attr1_value = FND_API.G_MISS_CHAR
825: OR g_LIMIT_BALANCES_rec.last_update_date = FND_API.G_MISS_DATE
826: OR g_LIMIT_BALANCES_rec.last_update_login = FND_API.G_MISS_NUM
827: OR g_LIMIT_BALANCES_rec.limit_balance_id = FND_API.G_MISS_NUM
828: OR g_LIMIT_BALANCES_rec.limit_id = FND_API.G_MISS_NUM
829: OR g_LIMIT_BALANCES_rec.multival_attr1_type = FND_API.G_MISS_CHAR
830: OR g_LIMIT_BALANCES_rec.multival_attr1_context = FND_API.G_MISS_CHAR
831: OR g_LIMIT_BALANCES_rec.multival_attribute1 = FND_API.G_MISS_CHAR
832: OR g_LIMIT_BALANCES_rec.multival_attr1_value = FND_API.G_MISS_CHAR
833: OR g_LIMIT_BALANCES_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR
826: OR g_LIMIT_BALANCES_rec.last_update_login = FND_API.G_MISS_NUM
827: OR g_LIMIT_BALANCES_rec.limit_balance_id = FND_API.G_MISS_NUM
828: OR g_LIMIT_BALANCES_rec.limit_id = FND_API.G_MISS_NUM
829: OR g_LIMIT_BALANCES_rec.multival_attr1_type = FND_API.G_MISS_CHAR
830: OR g_LIMIT_BALANCES_rec.multival_attr1_context = FND_API.G_MISS_CHAR
831: OR g_LIMIT_BALANCES_rec.multival_attribute1 = FND_API.G_MISS_CHAR
832: OR g_LIMIT_BALANCES_rec.multival_attr1_value = FND_API.G_MISS_CHAR
833: OR g_LIMIT_BALANCES_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR
834: OR g_LIMIT_BALANCES_rec.multival_attr2_type = FND_API.G_MISS_CHAR
827: OR g_LIMIT_BALANCES_rec.limit_balance_id = FND_API.G_MISS_NUM
828: OR g_LIMIT_BALANCES_rec.limit_id = FND_API.G_MISS_NUM
829: OR g_LIMIT_BALANCES_rec.multival_attr1_type = FND_API.G_MISS_CHAR
830: OR g_LIMIT_BALANCES_rec.multival_attr1_context = FND_API.G_MISS_CHAR
831: OR g_LIMIT_BALANCES_rec.multival_attribute1 = FND_API.G_MISS_CHAR
832: OR g_LIMIT_BALANCES_rec.multival_attr1_value = FND_API.G_MISS_CHAR
833: OR g_LIMIT_BALANCES_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR
834: OR g_LIMIT_BALANCES_rec.multival_attr2_type = FND_API.G_MISS_CHAR
835: OR g_LIMIT_BALANCES_rec.multival_attr2_context = FND_API.G_MISS_CHAR
828: OR g_LIMIT_BALANCES_rec.limit_id = FND_API.G_MISS_NUM
829: OR g_LIMIT_BALANCES_rec.multival_attr1_type = FND_API.G_MISS_CHAR
830: OR g_LIMIT_BALANCES_rec.multival_attr1_context = FND_API.G_MISS_CHAR
831: OR g_LIMIT_BALANCES_rec.multival_attribute1 = FND_API.G_MISS_CHAR
832: OR g_LIMIT_BALANCES_rec.multival_attr1_value = FND_API.G_MISS_CHAR
833: OR g_LIMIT_BALANCES_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR
834: OR g_LIMIT_BALANCES_rec.multival_attr2_type = FND_API.G_MISS_CHAR
835: OR g_LIMIT_BALANCES_rec.multival_attr2_context = FND_API.G_MISS_CHAR
836: OR g_LIMIT_BALANCES_rec.multival_attribute2 = FND_API.G_MISS_CHAR
829: OR g_LIMIT_BALANCES_rec.multival_attr1_type = FND_API.G_MISS_CHAR
830: OR g_LIMIT_BALANCES_rec.multival_attr1_context = FND_API.G_MISS_CHAR
831: OR g_LIMIT_BALANCES_rec.multival_attribute1 = FND_API.G_MISS_CHAR
832: OR g_LIMIT_BALANCES_rec.multival_attr1_value = FND_API.G_MISS_CHAR
833: OR g_LIMIT_BALANCES_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR
834: OR g_LIMIT_BALANCES_rec.multival_attr2_type = FND_API.G_MISS_CHAR
835: OR g_LIMIT_BALANCES_rec.multival_attr2_context = FND_API.G_MISS_CHAR
836: OR g_LIMIT_BALANCES_rec.multival_attribute2 = FND_API.G_MISS_CHAR
837: OR g_LIMIT_BALANCES_rec.multival_attr2_value = FND_API.G_MISS_CHAR
830: OR g_LIMIT_BALANCES_rec.multival_attr1_context = FND_API.G_MISS_CHAR
831: OR g_LIMIT_BALANCES_rec.multival_attribute1 = FND_API.G_MISS_CHAR
832: OR g_LIMIT_BALANCES_rec.multival_attr1_value = FND_API.G_MISS_CHAR
833: OR g_LIMIT_BALANCES_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR
834: OR g_LIMIT_BALANCES_rec.multival_attr2_type = FND_API.G_MISS_CHAR
835: OR g_LIMIT_BALANCES_rec.multival_attr2_context = FND_API.G_MISS_CHAR
836: OR g_LIMIT_BALANCES_rec.multival_attribute2 = FND_API.G_MISS_CHAR
837: OR g_LIMIT_BALANCES_rec.multival_attr2_value = FND_API.G_MISS_CHAR
838: OR g_LIMIT_BALANCES_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR
831: OR g_LIMIT_BALANCES_rec.multival_attribute1 = FND_API.G_MISS_CHAR
832: OR g_LIMIT_BALANCES_rec.multival_attr1_value = FND_API.G_MISS_CHAR
833: OR g_LIMIT_BALANCES_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR
834: OR g_LIMIT_BALANCES_rec.multival_attr2_type = FND_API.G_MISS_CHAR
835: OR g_LIMIT_BALANCES_rec.multival_attr2_context = FND_API.G_MISS_CHAR
836: OR g_LIMIT_BALANCES_rec.multival_attribute2 = FND_API.G_MISS_CHAR
837: OR g_LIMIT_BALANCES_rec.multival_attr2_value = FND_API.G_MISS_CHAR
838: OR g_LIMIT_BALANCES_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR
839: OR g_LIMIT_BALANCES_rec.organization_attr_context = FND_API.G_MISS_CHAR
832: OR g_LIMIT_BALANCES_rec.multival_attr1_value = FND_API.G_MISS_CHAR
833: OR g_LIMIT_BALANCES_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR
834: OR g_LIMIT_BALANCES_rec.multival_attr2_type = FND_API.G_MISS_CHAR
835: OR g_LIMIT_BALANCES_rec.multival_attr2_context = FND_API.G_MISS_CHAR
836: OR g_LIMIT_BALANCES_rec.multival_attribute2 = FND_API.G_MISS_CHAR
837: OR g_LIMIT_BALANCES_rec.multival_attr2_value = FND_API.G_MISS_CHAR
838: OR g_LIMIT_BALANCES_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR
839: OR g_LIMIT_BALANCES_rec.organization_attr_context = FND_API.G_MISS_CHAR
840: OR g_LIMIT_BALANCES_rec.organization_attribute = FND_API.G_MISS_CHAR
833: OR g_LIMIT_BALANCES_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR
834: OR g_LIMIT_BALANCES_rec.multival_attr2_type = FND_API.G_MISS_CHAR
835: OR g_LIMIT_BALANCES_rec.multival_attr2_context = FND_API.G_MISS_CHAR
836: OR g_LIMIT_BALANCES_rec.multival_attribute2 = FND_API.G_MISS_CHAR
837: OR g_LIMIT_BALANCES_rec.multival_attr2_value = FND_API.G_MISS_CHAR
838: OR g_LIMIT_BALANCES_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR
839: OR g_LIMIT_BALANCES_rec.organization_attr_context = FND_API.G_MISS_CHAR
840: OR g_LIMIT_BALANCES_rec.organization_attribute = FND_API.G_MISS_CHAR
841: OR g_LIMIT_BALANCES_rec.organization_attr_value = FND_API.G_MISS_CHAR
834: OR g_LIMIT_BALANCES_rec.multival_attr2_type = FND_API.G_MISS_CHAR
835: OR g_LIMIT_BALANCES_rec.multival_attr2_context = FND_API.G_MISS_CHAR
836: OR g_LIMIT_BALANCES_rec.multival_attribute2 = FND_API.G_MISS_CHAR
837: OR g_LIMIT_BALANCES_rec.multival_attr2_value = FND_API.G_MISS_CHAR
838: OR g_LIMIT_BALANCES_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR
839: OR g_LIMIT_BALANCES_rec.organization_attr_context = FND_API.G_MISS_CHAR
840: OR g_LIMIT_BALANCES_rec.organization_attribute = FND_API.G_MISS_CHAR
841: OR g_LIMIT_BALANCES_rec.organization_attr_value = FND_API.G_MISS_CHAR
842: OR g_LIMIT_BALANCES_rec.program_application_id = FND_API.G_MISS_NUM
835: OR g_LIMIT_BALANCES_rec.multival_attr2_context = FND_API.G_MISS_CHAR
836: OR g_LIMIT_BALANCES_rec.multival_attribute2 = FND_API.G_MISS_CHAR
837: OR g_LIMIT_BALANCES_rec.multival_attr2_value = FND_API.G_MISS_CHAR
838: OR g_LIMIT_BALANCES_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR
839: OR g_LIMIT_BALANCES_rec.organization_attr_context = FND_API.G_MISS_CHAR
840: OR g_LIMIT_BALANCES_rec.organization_attribute = FND_API.G_MISS_CHAR
841: OR g_LIMIT_BALANCES_rec.organization_attr_value = FND_API.G_MISS_CHAR
842: OR g_LIMIT_BALANCES_rec.program_application_id = FND_API.G_MISS_NUM
843: OR g_LIMIT_BALANCES_rec.program_id = FND_API.G_MISS_NUM
836: OR g_LIMIT_BALANCES_rec.multival_attribute2 = FND_API.G_MISS_CHAR
837: OR g_LIMIT_BALANCES_rec.multival_attr2_value = FND_API.G_MISS_CHAR
838: OR g_LIMIT_BALANCES_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR
839: OR g_LIMIT_BALANCES_rec.organization_attr_context = FND_API.G_MISS_CHAR
840: OR g_LIMIT_BALANCES_rec.organization_attribute = FND_API.G_MISS_CHAR
841: OR g_LIMIT_BALANCES_rec.organization_attr_value = FND_API.G_MISS_CHAR
842: OR g_LIMIT_BALANCES_rec.program_application_id = FND_API.G_MISS_NUM
843: OR g_LIMIT_BALANCES_rec.program_id = FND_API.G_MISS_NUM
844: OR g_LIMIT_BALANCES_rec.program_update_date = FND_API.G_MISS_DATE
837: OR g_LIMIT_BALANCES_rec.multival_attr2_value = FND_API.G_MISS_CHAR
838: OR g_LIMIT_BALANCES_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR
839: OR g_LIMIT_BALANCES_rec.organization_attr_context = FND_API.G_MISS_CHAR
840: OR g_LIMIT_BALANCES_rec.organization_attribute = FND_API.G_MISS_CHAR
841: OR g_LIMIT_BALANCES_rec.organization_attr_value = FND_API.G_MISS_CHAR
842: OR g_LIMIT_BALANCES_rec.program_application_id = FND_API.G_MISS_NUM
843: OR g_LIMIT_BALANCES_rec.program_id = FND_API.G_MISS_NUM
844: OR g_LIMIT_BALANCES_rec.program_update_date = FND_API.G_MISS_DATE
845: OR g_LIMIT_BALANCES_rec.request_id = FND_API.G_MISS_NUM
838: OR g_LIMIT_BALANCES_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR
839: OR g_LIMIT_BALANCES_rec.organization_attr_context = FND_API.G_MISS_CHAR
840: OR g_LIMIT_BALANCES_rec.organization_attribute = FND_API.G_MISS_CHAR
841: OR g_LIMIT_BALANCES_rec.organization_attr_value = FND_API.G_MISS_CHAR
842: OR g_LIMIT_BALANCES_rec.program_application_id = FND_API.G_MISS_NUM
843: OR g_LIMIT_BALANCES_rec.program_id = FND_API.G_MISS_NUM
844: OR g_LIMIT_BALANCES_rec.program_update_date = FND_API.G_MISS_DATE
845: OR g_LIMIT_BALANCES_rec.request_id = FND_API.G_MISS_NUM
846: OR g_LIMIT_BALANCES_rec.reserved_amount = FND_API.G_MISS_NUM
839: OR g_LIMIT_BALANCES_rec.organization_attr_context = FND_API.G_MISS_CHAR
840: OR g_LIMIT_BALANCES_rec.organization_attribute = FND_API.G_MISS_CHAR
841: OR g_LIMIT_BALANCES_rec.organization_attr_value = FND_API.G_MISS_CHAR
842: OR g_LIMIT_BALANCES_rec.program_application_id = FND_API.G_MISS_NUM
843: OR g_LIMIT_BALANCES_rec.program_id = FND_API.G_MISS_NUM
844: OR g_LIMIT_BALANCES_rec.program_update_date = FND_API.G_MISS_DATE
845: OR g_LIMIT_BALANCES_rec.request_id = FND_API.G_MISS_NUM
846: OR g_LIMIT_BALANCES_rec.reserved_amount = FND_API.G_MISS_NUM
847: THEN
840: OR g_LIMIT_BALANCES_rec.organization_attribute = FND_API.G_MISS_CHAR
841: OR g_LIMIT_BALANCES_rec.organization_attr_value = FND_API.G_MISS_CHAR
842: OR g_LIMIT_BALANCES_rec.program_application_id = FND_API.G_MISS_NUM
843: OR g_LIMIT_BALANCES_rec.program_id = FND_API.G_MISS_NUM
844: OR g_LIMIT_BALANCES_rec.program_update_date = FND_API.G_MISS_DATE
845: OR g_LIMIT_BALANCES_rec.request_id = FND_API.G_MISS_NUM
846: OR g_LIMIT_BALANCES_rec.reserved_amount = FND_API.G_MISS_NUM
847: THEN
848:
841: OR g_LIMIT_BALANCES_rec.organization_attr_value = FND_API.G_MISS_CHAR
842: OR g_LIMIT_BALANCES_rec.program_application_id = FND_API.G_MISS_NUM
843: OR g_LIMIT_BALANCES_rec.program_id = FND_API.G_MISS_NUM
844: OR g_LIMIT_BALANCES_rec.program_update_date = FND_API.G_MISS_DATE
845: OR g_LIMIT_BALANCES_rec.request_id = FND_API.G_MISS_NUM
846: OR g_LIMIT_BALANCES_rec.reserved_amount = FND_API.G_MISS_NUM
847: THEN
848:
849: QP_Default_Limit_Balances.Attributes
842: OR g_LIMIT_BALANCES_rec.program_application_id = FND_API.G_MISS_NUM
843: OR g_LIMIT_BALANCES_rec.program_id = FND_API.G_MISS_NUM
844: OR g_LIMIT_BALANCES_rec.program_update_date = FND_API.G_MISS_DATE
845: OR g_LIMIT_BALANCES_rec.request_id = FND_API.G_MISS_NUM
846: OR g_LIMIT_BALANCES_rec.reserved_amount = FND_API.G_MISS_NUM
847: THEN
848:
849: QP_Default_Limit_Balances.Attributes
850: ( p_LIMIT_BALANCES_rec => g_LIMIT_BALANCES_rec