APPS.OE_DEFAULT_AGREEMENT dependencies on FND_API

Line 59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

55: 'Get_Agreement'
56: );
57: END IF;
58:
59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60:
61: END Get_Agreement;
62:
63: FUNCTION Get_Agreement_Num

Line 292: IF g_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR THEN

288: BEGIN
289:
290: -- In the future call Flex APIs for defaults
291:
292: IF g_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR THEN
293: g_Agreement_rec.attribute1 := NULL;
294: END IF;
295:
296: IF g_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 296: IF g_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR THEN

292: IF g_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR THEN
293: g_Agreement_rec.attribute1 := NULL;
294: END IF;
295:
296: IF g_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR THEN
297: g_Agreement_rec.attribute10 := NULL;
298: END IF;
299:
300: IF g_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 300: IF g_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR THEN

296: IF g_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR THEN
297: g_Agreement_rec.attribute10 := NULL;
298: END IF;
299:
300: IF g_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR THEN
301: g_Agreement_rec.attribute11 := NULL;
302: END IF;
303:
304: IF g_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 304: IF g_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR THEN

300: IF g_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR THEN
301: g_Agreement_rec.attribute11 := NULL;
302: END IF;
303:
304: IF g_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR THEN
305: g_Agreement_rec.attribute12 := NULL;
306: END IF;
307:
308: IF g_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 308: IF g_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR THEN

304: IF g_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR THEN
305: g_Agreement_rec.attribute12 := NULL;
306: END IF;
307:
308: IF g_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR THEN
309: g_Agreement_rec.attribute13 := NULL;
310: END IF;
311:
312: IF g_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 312: IF g_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR THEN

308: IF g_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR THEN
309: g_Agreement_rec.attribute13 := NULL;
310: END IF;
311:
312: IF g_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR THEN
313: g_Agreement_rec.attribute14 := NULL;
314: END IF;
315:
316: IF g_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 316: IF g_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR THEN

312: IF g_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR THEN
313: g_Agreement_rec.attribute14 := NULL;
314: END IF;
315:
316: IF g_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR THEN
317: g_Agreement_rec.attribute15 := NULL;
318: END IF;
319:
320: IF g_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 320: IF g_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR THEN

316: IF g_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR THEN
317: g_Agreement_rec.attribute15 := NULL;
318: END IF;
319:
320: IF g_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR THEN
321: g_Agreement_rec.attribute2 := NULL;
322: END IF;
323:
324: IF g_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 324: IF g_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR THEN

320: IF g_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR THEN
321: g_Agreement_rec.attribute2 := NULL;
322: END IF;
323:
324: IF g_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR THEN
325: g_Agreement_rec.attribute3 := NULL;
326: END IF;
327:
328: IF g_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 328: IF g_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR THEN

324: IF g_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR THEN
325: g_Agreement_rec.attribute3 := NULL;
326: END IF;
327:
328: IF g_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR THEN
329: g_Agreement_rec.attribute4 := NULL;
330: END IF;
331:
332: IF g_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 332: IF g_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR THEN

328: IF g_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR THEN
329: g_Agreement_rec.attribute4 := NULL;
330: END IF;
331:
332: IF g_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR THEN
333: g_Agreement_rec.attribute5 := NULL;
334: END IF;
335:
336: IF g_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 336: IF g_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR THEN

332: IF g_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR THEN
333: g_Agreement_rec.attribute5 := NULL;
334: END IF;
335:
336: IF g_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR THEN
337: g_Agreement_rec.attribute6 := NULL;
338: END IF;
339:
340: IF g_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 340: IF g_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR THEN

336: IF g_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR THEN
337: g_Agreement_rec.attribute6 := NULL;
338: END IF;
339:
340: IF g_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR THEN
341: g_Agreement_rec.attribute7 := NULL;
342: END IF;
343:
344: IF g_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 344: IF g_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR THEN

340: IF g_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR THEN
341: g_Agreement_rec.attribute7 := NULL;
342: END IF;
343:
344: IF g_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR THEN
345: g_Agreement_rec.attribute8 := NULL;
346: END IF;
347:
348: IF g_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 348: IF g_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR THEN

344: IF g_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR THEN
345: g_Agreement_rec.attribute8 := NULL;
346: END IF;
347:
348: IF g_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR THEN
349: g_Agreement_rec.attribute9 := NULL;
350: END IF;
351:
352: IF g_Agreement_rec.context = FND_API.G_MISS_CHAR THEN

Line 352: IF g_Agreement_rec.context = FND_API.G_MISS_CHAR THEN

348: IF g_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR THEN
349: g_Agreement_rec.attribute9 := NULL;
350: END IF;
351:
352: IF g_Agreement_rec.context = FND_API.G_MISS_CHAR THEN
353: g_Agreement_rec.context := NULL;
354: END IF;
355:
356: END Get_Flex_Agreement;

Line 384: RAISE FND_API.G_EXC_ERROR;

380: OE_MSG_PUB.Add;
381:
382: END IF;
383:
384: RAISE FND_API.G_EXC_ERROR;
385:
386: END IF;
387:
388: -- Initialize g_Agreement_rec

Line 394: IF g_Agreement_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN

390: g_Agreement_rec := p_Agreement_rec;
391:
392: -- Default missing attributes.
393:
394: IF g_Agreement_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN
395:
396: g_Agreement_rec.accounting_rule_id := Get_Accounting_Rule;
397:
398: IF g_Agreement_rec.accounting_rule_id IS NOT NULL THEN

Line 418: IF g_Agreement_rec.agreement_contact_id = FND_API.G_MISS_NUM THEN

414: END IF;
415:
416: END IF;
417:
418: IF g_Agreement_rec.agreement_contact_id = FND_API.G_MISS_NUM THEN
419:
420: g_Agreement_rec.agreement_contact_id := Get_Agreement_Contact;
421:
422: IF g_Agreement_rec.agreement_contact_id IS NOT NULL THEN

Line 442: IF g_Agreement_rec.agreement_id = FND_API.G_MISS_NUM THEN

438: END IF;
439:
440: END IF;
441:
442: IF g_Agreement_rec.agreement_id = FND_API.G_MISS_NUM THEN
443:
444: g_Agreement_rec.agreement_id := Get_Agreement;
445:
446: IF g_Agreement_rec.agreement_id IS NOT NULL THEN

Line 466: IF g_Agreement_rec.agreement_num = FND_API.G_MISS_CHAR THEN

462: END IF;
463:
464: END IF;
465:
466: IF g_Agreement_rec.agreement_num = FND_API.G_MISS_CHAR THEN
467:
468: g_Agreement_rec.agreement_num := Get_Agreement_Num;
469:
470: IF g_Agreement_rec.agreement_num IS NOT NULL THEN

Line 490: IF g_Agreement_rec.agreement_type_code = FND_API.G_MISS_CHAR THEN

486: END IF;
487:
488: END IF;
489:
490: IF g_Agreement_rec.agreement_type_code = FND_API.G_MISS_CHAR THEN
491:
492: g_Agreement_rec.agreement_type_code := Get_Agreement_Type;
493:
494: IF g_Agreement_rec.agreement_type_code IS NOT NULL THEN

Line 515: IF g_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN

511:
512: END IF;
513: --
514:
515: IF g_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN
516:
517: g_Agreement_rec.sold_to_org_id := Get_Customer;
518:
519: IF g_Agreement_rec.sold_to_org_id IS NOT NULL THEN

Line 541: IF g_Agreement_rec.customer_id = FND_API.G_MISS_NUM THEN

537: END IF;
538:
539: --
540: /*
541: IF g_Agreement_rec.customer_id = FND_API.G_MISS_NUM THEN
542:
543: g_Agreement_rec.customer_id := Get_Customer;
544:
545: IF g_Agreement_rec.customer_id IS NOT NULL THEN

Line 566: IF g_Agreement_rec.end_date_active = FND_API.G_MISS_DATE THEN

562:
563: END IF;
564: */
565:
566: IF g_Agreement_rec.end_date_active = FND_API.G_MISS_DATE THEN
567:
568: g_Agreement_rec.end_date_active := Get_End_Date_Active;
569:
570: IF g_Agreement_rec.end_date_active IS NOT NULL THEN

Line 590: IF g_Agreement_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

586: END IF;
587:
588: END IF;
589:
590: IF g_Agreement_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
591:
592: g_Agreement_rec.freight_terms_code := Get_Freight_Terms;
593:
594: IF g_Agreement_rec.freight_terms_code IS NOT NULL THEN

Line 614: IF g_Agreement_rec.invoice_contact_id = FND_API.G_MISS_NUM THEN

610: END IF;
611:
612: END IF;
613:
614: IF g_Agreement_rec.invoice_contact_id = FND_API.G_MISS_NUM THEN
615:
616: g_Agreement_rec.invoice_contact_id := Get_Invoice_Contact;
617:
618: IF g_Agreement_rec.invoice_contact_id IS NOT NULL THEN

Line 638: /* IF g_Agreement_rec.invoice_to_site_use_id = FND_API.G_MISS_NUM THEN */

634: END IF;
635:
636: END IF;
637:
638: /* IF g_Agreement_rec.invoice_to_site_use_id = FND_API.G_MISS_NUM THEN */
639: IF g_Agreement_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN
640:
641: /* g_Agreement_rec.invoice_to_site_use_id := Get_Invoice_To_Site_Use; */
642: g_Agreement_rec.invoice_to_org_id := Get_Invoice_To_Site_Use;

Line 639: IF g_Agreement_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN

635:
636: END IF;
637:
638: /* IF g_Agreement_rec.invoice_to_site_use_id = FND_API.G_MISS_NUM THEN */
639: IF g_Agreement_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN
640:
641: /* g_Agreement_rec.invoice_to_site_use_id := Get_Invoice_To_Site_Use; */
642: g_Agreement_rec.invoice_to_org_id := Get_Invoice_To_Site_Use;
643:

Line 668: IF g_Agreement_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN

664: END IF;
665:
666: END IF;
667:
668: IF g_Agreement_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN
669:
670: g_Agreement_rec.invoicing_rule_id := Get_Invoicing_Rule;
671:
672: IF g_Agreement_rec.invoicing_rule_id IS NOT NULL THEN

Line 692: IF g_Agreement_rec.name = FND_API.G_MISS_CHAR THEN

688: END IF;
689:
690: END IF;
691:
692: IF g_Agreement_rec.name = FND_API.G_MISS_CHAR THEN
693:
694: g_Agreement_rec.name := Get_Name;
695:
696: IF g_Agreement_rec.name IS NOT NULL THEN

Line 716: IF g_Agreement_rec.override_arule_flag = FND_API.G_MISS_CHAR THEN

712: END IF;
713:
714: END IF;
715:
716: IF g_Agreement_rec.override_arule_flag = FND_API.G_MISS_CHAR THEN
717:
718: g_Agreement_rec.override_arule_flag := Get_Override_Arule;
719:
720: IF g_Agreement_rec.override_arule_flag IS NOT NULL THEN

Line 740: IF g_Agreement_rec.override_irule_flag = FND_API.G_MISS_CHAR THEN

736: END IF;
737:
738: END IF;
739:
740: IF g_Agreement_rec.override_irule_flag = FND_API.G_MISS_CHAR THEN
741:
742: g_Agreement_rec.override_irule_flag := Get_Override_Irule;
743:
744: IF g_Agreement_rec.override_irule_flag IS NOT NULL THEN

Line 764: IF g_Agreement_rec.price_list_id = FND_API.G_MISS_NUM THEN

760: END IF;
761:
762: END IF;
763:
764: IF g_Agreement_rec.price_list_id = FND_API.G_MISS_NUM THEN
765:
766: g_Agreement_rec.price_list_id := Get_Price_List;
767:
768: IF g_Agreement_rec.price_list_id IS NOT NULL THEN

Line 788: IF g_Agreement_rec.purchase_order_num = FND_API.G_MISS_CHAR THEN

784: END IF;
785:
786: END IF;
787:
788: IF g_Agreement_rec.purchase_order_num = FND_API.G_MISS_CHAR THEN
789:
790: g_Agreement_rec.purchase_order_num := Get_Purchase_Order_Num;
791:
792: IF g_Agreement_rec.purchase_order_num IS NOT NULL THEN

Line 812: IF g_Agreement_rec.revision = FND_API.G_MISS_CHAR THEN

808: END IF;
809:
810: END IF;
811:
812: IF g_Agreement_rec.revision = FND_API.G_MISS_CHAR THEN
813:
814: g_Agreement_rec.revision := Get_Revision;
815:
816: IF g_Agreement_rec.revision IS NOT NULL THEN

Line 836: IF g_Agreement_rec.revision_date = FND_API.G_MISS_DATE THEN

832: END IF;
833:
834: END IF;
835:
836: IF g_Agreement_rec.revision_date = FND_API.G_MISS_DATE THEN
837:
838: g_Agreement_rec.revision_date := Get_Revision_Date;
839:
840: IF g_Agreement_rec.revision_date IS NOT NULL THEN

Line 860: IF g_Agreement_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN

856: END IF;
857:
858: END IF;
859:
860: IF g_Agreement_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
861:
862: g_Agreement_rec.revision_reason_code := Get_Revision_Reason;
863:
864: IF g_Agreement_rec.revision_reason_code IS NOT NULL THEN

Line 884: IF g_Agreement_rec.salesrep_id = FND_API.G_MISS_NUM THEN

880: END IF;
881:
882: END IF;
883:
884: IF g_Agreement_rec.salesrep_id = FND_API.G_MISS_NUM THEN
885:
886: g_Agreement_rec.salesrep_id := Get_Salesrep;
887:
888: IF g_Agreement_rec.salesrep_id IS NOT NULL THEN

Line 908: IF g_Agreement_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

904: END IF;
905:
906: END IF;
907:
908: IF g_Agreement_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
909:
910: g_Agreement_rec.ship_method_code := Get_Ship_Method;
911:
912: IF g_Agreement_rec.ship_method_code IS NOT NULL THEN

Line 932: IF g_Agreement_rec.signature_date = FND_API.G_MISS_DATE THEN

928: END IF;
929:
930: END IF;
931:
932: IF g_Agreement_rec.signature_date = FND_API.G_MISS_DATE THEN
933:
934: g_Agreement_rec.signature_date := Get_Signature_Date;
935:
936: IF g_Agreement_rec.signature_date IS NOT NULL THEN

Line 956: IF g_Agreement_rec.start_date_active = FND_API.G_MISS_DATE THEN

952: END IF;
953:
954: END IF;
955:
956: IF g_Agreement_rec.start_date_active = FND_API.G_MISS_DATE THEN
957:
958: g_Agreement_rec.start_date_active := Get_Start_Date_Active;
959:
960: IF g_Agreement_rec.start_date_active IS NOT NULL THEN

Line 980: IF g_Agreement_rec.term_id = FND_API.G_MISS_NUM THEN

976: END IF;
977:
978: END IF;
979:
980: IF g_Agreement_rec.term_id = FND_API.G_MISS_NUM THEN
981:
982: g_Agreement_rec.term_id := Get_Term;
983:
984: IF g_Agreement_rec.term_id IS NOT NULL THEN

Line 1005: IF g_Agreement_rec.agreement_source_code = FND_API.G_MISS_CHAR THEN

1001:
1002: END IF;
1003:
1004: --Begin code added by rchellam for OKC
1005: IF g_Agreement_rec.agreement_source_code = FND_API.G_MISS_CHAR THEN
1006:
1007: g_Agreement_rec.agreement_source_code := Get_Agreement_Source;
1008:
1009: IF g_Agreement_rec.agreement_source_code IS NOT NULL THEN

Line 1029: IF g_Agreement_rec.orig_system_agr_id = FND_API.G_MISS_NUM THEN

1025: END IF;
1026:
1027: END IF;
1028:
1029: IF g_Agreement_rec.orig_system_agr_id = FND_API.G_MISS_NUM THEN
1030:
1031: g_Agreement_rec.orig_system_agr_id := Get_Orig_System_Agr;
1032:
1033: IF g_Agreement_rec.orig_system_agr_id IS NOT NULL THEN

Line 1054: IF g_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR

1050:
1051: END IF;
1052: --End code added by rchellam for OKC
1053:
1054: IF g_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR
1055: OR g_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR
1056: OR g_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR
1057: OR g_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR
1058: OR g_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR

Line 1055: OR g_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR

1051: END IF;
1052: --End code added by rchellam for OKC
1053:
1054: IF g_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR
1055: OR g_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR
1056: OR g_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR
1057: OR g_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR
1058: OR g_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR
1059: OR g_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR

Line 1056: OR g_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR

1052: --End code added by rchellam for OKC
1053:
1054: IF g_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR
1055: OR g_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR
1056: OR g_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR
1057: OR g_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR
1058: OR g_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR
1059: OR g_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR
1060: OR g_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR

Line 1057: OR g_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR

1053:
1054: IF g_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR
1055: OR g_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR
1056: OR g_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR
1057: OR g_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR
1058: OR g_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR
1059: OR g_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR
1060: OR g_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR
1061: OR g_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR

Line 1058: OR g_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR

1054: IF g_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR
1055: OR g_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR
1056: OR g_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR
1057: OR g_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR
1058: OR g_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR
1059: OR g_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR
1060: OR g_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR
1061: OR g_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR
1062: OR g_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR

Line 1059: OR g_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR

1055: OR g_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR
1056: OR g_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR
1057: OR g_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR
1058: OR g_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR
1059: OR g_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR
1060: OR g_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR
1061: OR g_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR
1062: OR g_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR
1063: OR g_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR

Line 1060: OR g_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR

1056: OR g_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR
1057: OR g_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR
1058: OR g_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR
1059: OR g_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR
1060: OR g_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR
1061: OR g_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR
1062: OR g_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR
1063: OR g_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR
1064: OR g_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR

Line 1061: OR g_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR

1057: OR g_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR
1058: OR g_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR
1059: OR g_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR
1060: OR g_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR
1061: OR g_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR
1062: OR g_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR
1063: OR g_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR
1064: OR g_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR
1065: OR g_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR

Line 1062: OR g_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR

1058: OR g_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR
1059: OR g_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR
1060: OR g_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR
1061: OR g_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR
1062: OR g_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR
1063: OR g_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR
1064: OR g_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR
1065: OR g_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR
1066: OR g_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR

Line 1063: OR g_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR

1059: OR g_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR
1060: OR g_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR
1061: OR g_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR
1062: OR g_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR
1063: OR g_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR
1064: OR g_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR
1065: OR g_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR
1066: OR g_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR
1067: OR g_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR

Line 1064: OR g_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR

1060: OR g_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR
1061: OR g_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR
1062: OR g_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR
1063: OR g_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR
1064: OR g_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR
1065: OR g_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR
1066: OR g_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR
1067: OR g_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR
1068: OR g_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR

Line 1065: OR g_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR

1061: OR g_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR
1062: OR g_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR
1063: OR g_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR
1064: OR g_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR
1065: OR g_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR
1066: OR g_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR
1067: OR g_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR
1068: OR g_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR
1069: OR g_Agreement_rec.context = FND_API.G_MISS_CHAR

Line 1066: OR g_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR

1062: OR g_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR
1063: OR g_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR
1064: OR g_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR
1065: OR g_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR
1066: OR g_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR
1067: OR g_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR
1068: OR g_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR
1069: OR g_Agreement_rec.context = FND_API.G_MISS_CHAR
1070: THEN

Line 1067: OR g_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR

1063: OR g_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR
1064: OR g_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR
1065: OR g_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR
1066: OR g_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR
1067: OR g_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR
1068: OR g_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR
1069: OR g_Agreement_rec.context = FND_API.G_MISS_CHAR
1070: THEN
1071:

Line 1068: OR g_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR

1064: OR g_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR
1065: OR g_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR
1066: OR g_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR
1067: OR g_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR
1068: OR g_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR
1069: OR g_Agreement_rec.context = FND_API.G_MISS_CHAR
1070: THEN
1071:
1072: Get_Flex_Agreement;

Line 1069: OR g_Agreement_rec.context = FND_API.G_MISS_CHAR

1065: OR g_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR
1066: OR g_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR
1067: OR g_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR
1068: OR g_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR
1069: OR g_Agreement_rec.context = FND_API.G_MISS_CHAR
1070: THEN
1071:
1072: Get_Flex_Agreement;
1073:

Line 1076: IF g_Agreement_rec.created_by = FND_API.G_MISS_NUM THEN

1072: Get_Flex_Agreement;
1073:
1074: END IF;
1075:
1076: IF g_Agreement_rec.created_by = FND_API.G_MISS_NUM THEN
1077:
1078: g_Agreement_rec.created_by := NULL;
1079:
1080: END IF;

Line 1082: IF g_Agreement_rec.creation_date = FND_API.G_MISS_DATE THEN

1078: g_Agreement_rec.created_by := NULL;
1079:
1080: END IF;
1081:
1082: IF g_Agreement_rec.creation_date = FND_API.G_MISS_DATE THEN
1083:
1084: g_Agreement_rec.creation_date := NULL;
1085:
1086: END IF;

Line 1088: IF g_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM THEN

1084: g_Agreement_rec.creation_date := NULL;
1085:
1086: END IF;
1087:
1088: IF g_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1089:
1090: g_Agreement_rec.last_updated_by := NULL;
1091:
1092: END IF;

Line 1094: IF g_Agreement_rec.last_update_date = FND_API.G_MISS_DATE THEN

1090: g_Agreement_rec.last_updated_by := NULL;
1091:
1092: END IF;
1093:
1094: IF g_Agreement_rec.last_update_date = FND_API.G_MISS_DATE THEN
1095:
1096: g_Agreement_rec.last_update_date := NULL;
1097:
1098: END IF;

Line 1100: IF g_Agreement_rec.last_update_login = FND_API.G_MISS_NUM THEN

1096: g_Agreement_rec.last_update_date := NULL;
1097:
1098: END IF;
1099:
1100: IF g_Agreement_rec.last_update_login = FND_API.G_MISS_NUM THEN
1101:
1102: g_Agreement_rec.last_update_login := NULL;
1103:
1104: END IF;

Line 1108: IF g_Agreement_rec.accounting_rule_id = FND_API.G_MISS_NUM

1104: END IF;
1105:
1106: -- Redefault if there are any missing attributes.
1107:
1108: IF g_Agreement_rec.accounting_rule_id = FND_API.G_MISS_NUM
1109: OR g_Agreement_rec.agreement_contact_id = FND_API.G_MISS_NUM
1110: OR g_Agreement_rec.agreement_id = FND_API.G_MISS_NUM
1111: OR g_Agreement_rec.agreement_num = FND_API.G_MISS_CHAR
1112: OR g_Agreement_rec.agreement_type_code = FND_API.G_MISS_CHAR

Line 1109: OR g_Agreement_rec.agreement_contact_id = FND_API.G_MISS_NUM

1105:
1106: -- Redefault if there are any missing attributes.
1107:
1108: IF g_Agreement_rec.accounting_rule_id = FND_API.G_MISS_NUM
1109: OR g_Agreement_rec.agreement_contact_id = FND_API.G_MISS_NUM
1110: OR g_Agreement_rec.agreement_id = FND_API.G_MISS_NUM
1111: OR g_Agreement_rec.agreement_num = FND_API.G_MISS_CHAR
1112: OR g_Agreement_rec.agreement_type_code = FND_API.G_MISS_CHAR
1113: OR g_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR

Line 1110: OR g_Agreement_rec.agreement_id = FND_API.G_MISS_NUM

1106: -- Redefault if there are any missing attributes.
1107:
1108: IF g_Agreement_rec.accounting_rule_id = FND_API.G_MISS_NUM
1109: OR g_Agreement_rec.agreement_contact_id = FND_API.G_MISS_NUM
1110: OR g_Agreement_rec.agreement_id = FND_API.G_MISS_NUM
1111: OR g_Agreement_rec.agreement_num = FND_API.G_MISS_CHAR
1112: OR g_Agreement_rec.agreement_type_code = FND_API.G_MISS_CHAR
1113: OR g_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR
1114: OR g_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR

Line 1111: OR g_Agreement_rec.agreement_num = FND_API.G_MISS_CHAR

1107:
1108: IF g_Agreement_rec.accounting_rule_id = FND_API.G_MISS_NUM
1109: OR g_Agreement_rec.agreement_contact_id = FND_API.G_MISS_NUM
1110: OR g_Agreement_rec.agreement_id = FND_API.G_MISS_NUM
1111: OR g_Agreement_rec.agreement_num = FND_API.G_MISS_CHAR
1112: OR g_Agreement_rec.agreement_type_code = FND_API.G_MISS_CHAR
1113: OR g_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR
1114: OR g_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR
1115: OR g_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR

Line 1112: OR g_Agreement_rec.agreement_type_code = FND_API.G_MISS_CHAR

1108: IF g_Agreement_rec.accounting_rule_id = FND_API.G_MISS_NUM
1109: OR g_Agreement_rec.agreement_contact_id = FND_API.G_MISS_NUM
1110: OR g_Agreement_rec.agreement_id = FND_API.G_MISS_NUM
1111: OR g_Agreement_rec.agreement_num = FND_API.G_MISS_CHAR
1112: OR g_Agreement_rec.agreement_type_code = FND_API.G_MISS_CHAR
1113: OR g_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR
1114: OR g_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR
1115: OR g_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR
1116: OR g_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR

Line 1113: OR g_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR

1109: OR g_Agreement_rec.agreement_contact_id = FND_API.G_MISS_NUM
1110: OR g_Agreement_rec.agreement_id = FND_API.G_MISS_NUM
1111: OR g_Agreement_rec.agreement_num = FND_API.G_MISS_CHAR
1112: OR g_Agreement_rec.agreement_type_code = FND_API.G_MISS_CHAR
1113: OR g_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR
1114: OR g_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR
1115: OR g_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR
1116: OR g_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR
1117: OR g_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR

Line 1114: OR g_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR

1110: OR g_Agreement_rec.agreement_id = FND_API.G_MISS_NUM
1111: OR g_Agreement_rec.agreement_num = FND_API.G_MISS_CHAR
1112: OR g_Agreement_rec.agreement_type_code = FND_API.G_MISS_CHAR
1113: OR g_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR
1114: OR g_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR
1115: OR g_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR
1116: OR g_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR
1117: OR g_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR
1118: OR g_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR

Line 1115: OR g_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR

1111: OR g_Agreement_rec.agreement_num = FND_API.G_MISS_CHAR
1112: OR g_Agreement_rec.agreement_type_code = FND_API.G_MISS_CHAR
1113: OR g_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR
1114: OR g_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR
1115: OR g_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR
1116: OR g_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR
1117: OR g_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR
1118: OR g_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR
1119: OR g_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR

Line 1116: OR g_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR

1112: OR g_Agreement_rec.agreement_type_code = FND_API.G_MISS_CHAR
1113: OR g_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR
1114: OR g_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR
1115: OR g_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR
1116: OR g_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR
1117: OR g_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR
1118: OR g_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR
1119: OR g_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR
1120: OR g_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR

Line 1117: OR g_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR

1113: OR g_Agreement_rec.attribute1 = FND_API.G_MISS_CHAR
1114: OR g_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR
1115: OR g_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR
1116: OR g_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR
1117: OR g_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR
1118: OR g_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR
1119: OR g_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR
1120: OR g_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR
1121: OR g_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR

Line 1118: OR g_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR

1114: OR g_Agreement_rec.attribute10 = FND_API.G_MISS_CHAR
1115: OR g_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR
1116: OR g_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR
1117: OR g_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR
1118: OR g_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR
1119: OR g_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR
1120: OR g_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR
1121: OR g_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR
1122: OR g_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR

Line 1119: OR g_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR

1115: OR g_Agreement_rec.attribute11 = FND_API.G_MISS_CHAR
1116: OR g_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR
1117: OR g_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR
1118: OR g_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR
1119: OR g_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR
1120: OR g_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR
1121: OR g_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR
1122: OR g_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR
1123: OR g_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR

Line 1120: OR g_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR

1116: OR g_Agreement_rec.attribute12 = FND_API.G_MISS_CHAR
1117: OR g_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR
1118: OR g_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR
1119: OR g_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR
1120: OR g_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR
1121: OR g_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR
1122: OR g_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR
1123: OR g_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR
1124: OR g_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR

Line 1121: OR g_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR

1117: OR g_Agreement_rec.attribute13 = FND_API.G_MISS_CHAR
1118: OR g_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR
1119: OR g_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR
1120: OR g_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR
1121: OR g_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR
1122: OR g_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR
1123: OR g_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR
1124: OR g_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR
1125: OR g_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR

Line 1122: OR g_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR

1118: OR g_Agreement_rec.attribute14 = FND_API.G_MISS_CHAR
1119: OR g_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR
1120: OR g_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR
1121: OR g_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR
1122: OR g_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR
1123: OR g_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR
1124: OR g_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR
1125: OR g_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR
1126: OR g_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR

Line 1123: OR g_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR

1119: OR g_Agreement_rec.attribute15 = FND_API.G_MISS_CHAR
1120: OR g_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR
1121: OR g_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR
1122: OR g_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR
1123: OR g_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR
1124: OR g_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR
1125: OR g_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR
1126: OR g_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR
1127: OR g_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR

Line 1124: OR g_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR

1120: OR g_Agreement_rec.attribute2 = FND_API.G_MISS_CHAR
1121: OR g_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR
1122: OR g_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR
1123: OR g_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR
1124: OR g_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR
1125: OR g_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR
1126: OR g_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR
1127: OR g_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR
1128: OR g_Agreement_rec.context = FND_API.G_MISS_CHAR

Line 1125: OR g_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR

1121: OR g_Agreement_rec.attribute3 = FND_API.G_MISS_CHAR
1122: OR g_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR
1123: OR g_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR
1124: OR g_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR
1125: OR g_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR
1126: OR g_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR
1127: OR g_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR
1128: OR g_Agreement_rec.context = FND_API.G_MISS_CHAR
1129: OR g_Agreement_rec.created_by = FND_API.G_MISS_NUM

Line 1126: OR g_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR

1122: OR g_Agreement_rec.attribute4 = FND_API.G_MISS_CHAR
1123: OR g_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR
1124: OR g_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR
1125: OR g_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR
1126: OR g_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR
1127: OR g_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR
1128: OR g_Agreement_rec.context = FND_API.G_MISS_CHAR
1129: OR g_Agreement_rec.created_by = FND_API.G_MISS_NUM
1130: OR g_Agreement_rec.creation_date = FND_API.G_MISS_DATE

Line 1127: OR g_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR

1123: OR g_Agreement_rec.attribute5 = FND_API.G_MISS_CHAR
1124: OR g_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR
1125: OR g_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR
1126: OR g_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR
1127: OR g_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR
1128: OR g_Agreement_rec.context = FND_API.G_MISS_CHAR
1129: OR g_Agreement_rec.created_by = FND_API.G_MISS_NUM
1130: OR g_Agreement_rec.creation_date = FND_API.G_MISS_DATE
1131: /* OR g_Agreement_rec.customer_id = FND_API.G_MISS_NUM */

Line 1128: OR g_Agreement_rec.context = FND_API.G_MISS_CHAR

1124: OR g_Agreement_rec.attribute6 = FND_API.G_MISS_CHAR
1125: OR g_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR
1126: OR g_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR
1127: OR g_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR
1128: OR g_Agreement_rec.context = FND_API.G_MISS_CHAR
1129: OR g_Agreement_rec.created_by = FND_API.G_MISS_NUM
1130: OR g_Agreement_rec.creation_date = FND_API.G_MISS_DATE
1131: /* OR g_Agreement_rec.customer_id = FND_API.G_MISS_NUM */
1132: OR g_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM

Line 1129: OR g_Agreement_rec.created_by = FND_API.G_MISS_NUM

1125: OR g_Agreement_rec.attribute7 = FND_API.G_MISS_CHAR
1126: OR g_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR
1127: OR g_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR
1128: OR g_Agreement_rec.context = FND_API.G_MISS_CHAR
1129: OR g_Agreement_rec.created_by = FND_API.G_MISS_NUM
1130: OR g_Agreement_rec.creation_date = FND_API.G_MISS_DATE
1131: /* OR g_Agreement_rec.customer_id = FND_API.G_MISS_NUM */
1132: OR g_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM
1133: OR g_Agreement_rec.end_date_active = FND_API.G_MISS_DATE

Line 1130: OR g_Agreement_rec.creation_date = FND_API.G_MISS_DATE

1126: OR g_Agreement_rec.attribute8 = FND_API.G_MISS_CHAR
1127: OR g_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR
1128: OR g_Agreement_rec.context = FND_API.G_MISS_CHAR
1129: OR g_Agreement_rec.created_by = FND_API.G_MISS_NUM
1130: OR g_Agreement_rec.creation_date = FND_API.G_MISS_DATE
1131: /* OR g_Agreement_rec.customer_id = FND_API.G_MISS_NUM */
1132: OR g_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM
1133: OR g_Agreement_rec.end_date_active = FND_API.G_MISS_DATE
1134: OR g_Agreement_rec.freight_terms_code = FND_API.G_MISS_CHAR

Line 1131: /* OR g_Agreement_rec.customer_id = FND_API.G_MISS_NUM */

1127: OR g_Agreement_rec.attribute9 = FND_API.G_MISS_CHAR
1128: OR g_Agreement_rec.context = FND_API.G_MISS_CHAR
1129: OR g_Agreement_rec.created_by = FND_API.G_MISS_NUM
1130: OR g_Agreement_rec.creation_date = FND_API.G_MISS_DATE
1131: /* OR g_Agreement_rec.customer_id = FND_API.G_MISS_NUM */
1132: OR g_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM
1133: OR g_Agreement_rec.end_date_active = FND_API.G_MISS_DATE
1134: OR g_Agreement_rec.freight_terms_code = FND_API.G_MISS_CHAR
1135: OR g_Agreement_rec.invoice_contact_id = FND_API.G_MISS_NUM

Line 1132: OR g_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM

1128: OR g_Agreement_rec.context = FND_API.G_MISS_CHAR
1129: OR g_Agreement_rec.created_by = FND_API.G_MISS_NUM
1130: OR g_Agreement_rec.creation_date = FND_API.G_MISS_DATE
1131: /* OR g_Agreement_rec.customer_id = FND_API.G_MISS_NUM */
1132: OR g_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM
1133: OR g_Agreement_rec.end_date_active = FND_API.G_MISS_DATE
1134: OR g_Agreement_rec.freight_terms_code = FND_API.G_MISS_CHAR
1135: OR g_Agreement_rec.invoice_contact_id = FND_API.G_MISS_NUM
1136: /* OR g_Agreement_rec.invoice_to_site_use_id = FND_API.G_MISS_NUM */

Line 1133: OR g_Agreement_rec.end_date_active = FND_API.G_MISS_DATE

1129: OR g_Agreement_rec.created_by = FND_API.G_MISS_NUM
1130: OR g_Agreement_rec.creation_date = FND_API.G_MISS_DATE
1131: /* OR g_Agreement_rec.customer_id = FND_API.G_MISS_NUM */
1132: OR g_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM
1133: OR g_Agreement_rec.end_date_active = FND_API.G_MISS_DATE
1134: OR g_Agreement_rec.freight_terms_code = FND_API.G_MISS_CHAR
1135: OR g_Agreement_rec.invoice_contact_id = FND_API.G_MISS_NUM
1136: /* OR g_Agreement_rec.invoice_to_site_use_id = FND_API.G_MISS_NUM */
1137: OR g_Agreement_rec.invoice_to_org_id = FND_API.G_MISS_NUM

Line 1134: OR g_Agreement_rec.freight_terms_code = FND_API.G_MISS_CHAR

1130: OR g_Agreement_rec.creation_date = FND_API.G_MISS_DATE
1131: /* OR g_Agreement_rec.customer_id = FND_API.G_MISS_NUM */
1132: OR g_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM
1133: OR g_Agreement_rec.end_date_active = FND_API.G_MISS_DATE
1134: OR g_Agreement_rec.freight_terms_code = FND_API.G_MISS_CHAR
1135: OR g_Agreement_rec.invoice_contact_id = FND_API.G_MISS_NUM
1136: /* OR g_Agreement_rec.invoice_to_site_use_id = FND_API.G_MISS_NUM */
1137: OR g_Agreement_rec.invoice_to_org_id = FND_API.G_MISS_NUM
1138: OR g_Agreement_rec.invoicing_rule_id = FND_API.G_MISS_NUM

Line 1135: OR g_Agreement_rec.invoice_contact_id = FND_API.G_MISS_NUM

1131: /* OR g_Agreement_rec.customer_id = FND_API.G_MISS_NUM */
1132: OR g_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM
1133: OR g_Agreement_rec.end_date_active = FND_API.G_MISS_DATE
1134: OR g_Agreement_rec.freight_terms_code = FND_API.G_MISS_CHAR
1135: OR g_Agreement_rec.invoice_contact_id = FND_API.G_MISS_NUM
1136: /* OR g_Agreement_rec.invoice_to_site_use_id = FND_API.G_MISS_NUM */
1137: OR g_Agreement_rec.invoice_to_org_id = FND_API.G_MISS_NUM
1138: OR g_Agreement_rec.invoicing_rule_id = FND_API.G_MISS_NUM
1139: OR g_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM

Line 1136: /* OR g_Agreement_rec.invoice_to_site_use_id = FND_API.G_MISS_NUM */

1132: OR g_Agreement_rec.sold_to_org_id = FND_API.G_MISS_NUM
1133: OR g_Agreement_rec.end_date_active = FND_API.G_MISS_DATE
1134: OR g_Agreement_rec.freight_terms_code = FND_API.G_MISS_CHAR
1135: OR g_Agreement_rec.invoice_contact_id = FND_API.G_MISS_NUM
1136: /* OR g_Agreement_rec.invoice_to_site_use_id = FND_API.G_MISS_NUM */
1137: OR g_Agreement_rec.invoice_to_org_id = FND_API.G_MISS_NUM
1138: OR g_Agreement_rec.invoicing_rule_id = FND_API.G_MISS_NUM
1139: OR g_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM
1140: OR g_Agreement_rec.last_update_date = FND_API.G_MISS_DATE

Line 1137: OR g_Agreement_rec.invoice_to_org_id = FND_API.G_MISS_NUM

1133: OR g_Agreement_rec.end_date_active = FND_API.G_MISS_DATE
1134: OR g_Agreement_rec.freight_terms_code = FND_API.G_MISS_CHAR
1135: OR g_Agreement_rec.invoice_contact_id = FND_API.G_MISS_NUM
1136: /* OR g_Agreement_rec.invoice_to_site_use_id = FND_API.G_MISS_NUM */
1137: OR g_Agreement_rec.invoice_to_org_id = FND_API.G_MISS_NUM
1138: OR g_Agreement_rec.invoicing_rule_id = FND_API.G_MISS_NUM
1139: OR g_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM
1140: OR g_Agreement_rec.last_update_date = FND_API.G_MISS_DATE
1141: OR g_Agreement_rec.last_update_login = FND_API.G_MISS_NUM

Line 1138: OR g_Agreement_rec.invoicing_rule_id = FND_API.G_MISS_NUM

1134: OR g_Agreement_rec.freight_terms_code = FND_API.G_MISS_CHAR
1135: OR g_Agreement_rec.invoice_contact_id = FND_API.G_MISS_NUM
1136: /* OR g_Agreement_rec.invoice_to_site_use_id = FND_API.G_MISS_NUM */
1137: OR g_Agreement_rec.invoice_to_org_id = FND_API.G_MISS_NUM
1138: OR g_Agreement_rec.invoicing_rule_id = FND_API.G_MISS_NUM
1139: OR g_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM
1140: OR g_Agreement_rec.last_update_date = FND_API.G_MISS_DATE
1141: OR g_Agreement_rec.last_update_login = FND_API.G_MISS_NUM
1142: OR g_Agreement_rec.name = FND_API.G_MISS_CHAR

Line 1139: OR g_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM

1135: OR g_Agreement_rec.invoice_contact_id = FND_API.G_MISS_NUM
1136: /* OR g_Agreement_rec.invoice_to_site_use_id = FND_API.G_MISS_NUM */
1137: OR g_Agreement_rec.invoice_to_org_id = FND_API.G_MISS_NUM
1138: OR g_Agreement_rec.invoicing_rule_id = FND_API.G_MISS_NUM
1139: OR g_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM
1140: OR g_Agreement_rec.last_update_date = FND_API.G_MISS_DATE
1141: OR g_Agreement_rec.last_update_login = FND_API.G_MISS_NUM
1142: OR g_Agreement_rec.name = FND_API.G_MISS_CHAR
1143: OR g_Agreement_rec.override_arule_flag = FND_API.G_MISS_CHAR

Line 1140: OR g_Agreement_rec.last_update_date = FND_API.G_MISS_DATE

1136: /* OR g_Agreement_rec.invoice_to_site_use_id = FND_API.G_MISS_NUM */
1137: OR g_Agreement_rec.invoice_to_org_id = FND_API.G_MISS_NUM
1138: OR g_Agreement_rec.invoicing_rule_id = FND_API.G_MISS_NUM
1139: OR g_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM
1140: OR g_Agreement_rec.last_update_date = FND_API.G_MISS_DATE
1141: OR g_Agreement_rec.last_update_login = FND_API.G_MISS_NUM
1142: OR g_Agreement_rec.name = FND_API.G_MISS_CHAR
1143: OR g_Agreement_rec.override_arule_flag = FND_API.G_MISS_CHAR
1144: OR g_Agreement_rec.override_irule_flag = FND_API.G_MISS_CHAR

Line 1141: OR g_Agreement_rec.last_update_login = FND_API.G_MISS_NUM

1137: OR g_Agreement_rec.invoice_to_org_id = FND_API.G_MISS_NUM
1138: OR g_Agreement_rec.invoicing_rule_id = FND_API.G_MISS_NUM
1139: OR g_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM
1140: OR g_Agreement_rec.last_update_date = FND_API.G_MISS_DATE
1141: OR g_Agreement_rec.last_update_login = FND_API.G_MISS_NUM
1142: OR g_Agreement_rec.name = FND_API.G_MISS_CHAR
1143: OR g_Agreement_rec.override_arule_flag = FND_API.G_MISS_CHAR
1144: OR g_Agreement_rec.override_irule_flag = FND_API.G_MISS_CHAR
1145: OR g_Agreement_rec.price_list_id = FND_API.G_MISS_NUM

Line 1142: OR g_Agreement_rec.name = FND_API.G_MISS_CHAR

1138: OR g_Agreement_rec.invoicing_rule_id = FND_API.G_MISS_NUM
1139: OR g_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM
1140: OR g_Agreement_rec.last_update_date = FND_API.G_MISS_DATE
1141: OR g_Agreement_rec.last_update_login = FND_API.G_MISS_NUM
1142: OR g_Agreement_rec.name = FND_API.G_MISS_CHAR
1143: OR g_Agreement_rec.override_arule_flag = FND_API.G_MISS_CHAR
1144: OR g_Agreement_rec.override_irule_flag = FND_API.G_MISS_CHAR
1145: OR g_Agreement_rec.price_list_id = FND_API.G_MISS_NUM
1146: OR g_Agreement_rec.purchase_order_num = FND_API.G_MISS_CHAR

Line 1143: OR g_Agreement_rec.override_arule_flag = FND_API.G_MISS_CHAR

1139: OR g_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM
1140: OR g_Agreement_rec.last_update_date = FND_API.G_MISS_DATE
1141: OR g_Agreement_rec.last_update_login = FND_API.G_MISS_NUM
1142: OR g_Agreement_rec.name = FND_API.G_MISS_CHAR
1143: OR g_Agreement_rec.override_arule_flag = FND_API.G_MISS_CHAR
1144: OR g_Agreement_rec.override_irule_flag = FND_API.G_MISS_CHAR
1145: OR g_Agreement_rec.price_list_id = FND_API.G_MISS_NUM
1146: OR g_Agreement_rec.purchase_order_num = FND_API.G_MISS_CHAR
1147: OR g_Agreement_rec.revision = FND_API.G_MISS_CHAR

Line 1144: OR g_Agreement_rec.override_irule_flag = FND_API.G_MISS_CHAR

1140: OR g_Agreement_rec.last_update_date = FND_API.G_MISS_DATE
1141: OR g_Agreement_rec.last_update_login = FND_API.G_MISS_NUM
1142: OR g_Agreement_rec.name = FND_API.G_MISS_CHAR
1143: OR g_Agreement_rec.override_arule_flag = FND_API.G_MISS_CHAR
1144: OR g_Agreement_rec.override_irule_flag = FND_API.G_MISS_CHAR
1145: OR g_Agreement_rec.price_list_id = FND_API.G_MISS_NUM
1146: OR g_Agreement_rec.purchase_order_num = FND_API.G_MISS_CHAR
1147: OR g_Agreement_rec.revision = FND_API.G_MISS_CHAR
1148: OR g_Agreement_rec.revision_date = FND_API.G_MISS_DATE

Line 1145: OR g_Agreement_rec.price_list_id = FND_API.G_MISS_NUM

1141: OR g_Agreement_rec.last_update_login = FND_API.G_MISS_NUM
1142: OR g_Agreement_rec.name = FND_API.G_MISS_CHAR
1143: OR g_Agreement_rec.override_arule_flag = FND_API.G_MISS_CHAR
1144: OR g_Agreement_rec.override_irule_flag = FND_API.G_MISS_CHAR
1145: OR g_Agreement_rec.price_list_id = FND_API.G_MISS_NUM
1146: OR g_Agreement_rec.purchase_order_num = FND_API.G_MISS_CHAR
1147: OR g_Agreement_rec.revision = FND_API.G_MISS_CHAR
1148: OR g_Agreement_rec.revision_date = FND_API.G_MISS_DATE
1149: OR g_Agreement_rec.revision_reason_code = FND_API.G_MISS_CHAR

Line 1146: OR g_Agreement_rec.purchase_order_num = FND_API.G_MISS_CHAR

1142: OR g_Agreement_rec.name = FND_API.G_MISS_CHAR
1143: OR g_Agreement_rec.override_arule_flag = FND_API.G_MISS_CHAR
1144: OR g_Agreement_rec.override_irule_flag = FND_API.G_MISS_CHAR
1145: OR g_Agreement_rec.price_list_id = FND_API.G_MISS_NUM
1146: OR g_Agreement_rec.purchase_order_num = FND_API.G_MISS_CHAR
1147: OR g_Agreement_rec.revision = FND_API.G_MISS_CHAR
1148: OR g_Agreement_rec.revision_date = FND_API.G_MISS_DATE
1149: OR g_Agreement_rec.revision_reason_code = FND_API.G_MISS_CHAR
1150: OR g_Agreement_rec.salesrep_id = FND_API.G_MISS_NUM

Line 1147: OR g_Agreement_rec.revision = FND_API.G_MISS_CHAR

1143: OR g_Agreement_rec.override_arule_flag = FND_API.G_MISS_CHAR
1144: OR g_Agreement_rec.override_irule_flag = FND_API.G_MISS_CHAR
1145: OR g_Agreement_rec.price_list_id = FND_API.G_MISS_NUM
1146: OR g_Agreement_rec.purchase_order_num = FND_API.G_MISS_CHAR
1147: OR g_Agreement_rec.revision = FND_API.G_MISS_CHAR
1148: OR g_Agreement_rec.revision_date = FND_API.G_MISS_DATE
1149: OR g_Agreement_rec.revision_reason_code = FND_API.G_MISS_CHAR
1150: OR g_Agreement_rec.salesrep_id = FND_API.G_MISS_NUM
1151: OR g_Agreement_rec.ship_method_code = FND_API.G_MISS_CHAR

Line 1148: OR g_Agreement_rec.revision_date = FND_API.G_MISS_DATE

1144: OR g_Agreement_rec.override_irule_flag = FND_API.G_MISS_CHAR
1145: OR g_Agreement_rec.price_list_id = FND_API.G_MISS_NUM
1146: OR g_Agreement_rec.purchase_order_num = FND_API.G_MISS_CHAR
1147: OR g_Agreement_rec.revision = FND_API.G_MISS_CHAR
1148: OR g_Agreement_rec.revision_date = FND_API.G_MISS_DATE
1149: OR g_Agreement_rec.revision_reason_code = FND_API.G_MISS_CHAR
1150: OR g_Agreement_rec.salesrep_id = FND_API.G_MISS_NUM
1151: OR g_Agreement_rec.ship_method_code = FND_API.G_MISS_CHAR
1152: OR g_Agreement_rec.signature_date = FND_API.G_MISS_DATE

Line 1149: OR g_Agreement_rec.revision_reason_code = FND_API.G_MISS_CHAR

1145: OR g_Agreement_rec.price_list_id = FND_API.G_MISS_NUM
1146: OR g_Agreement_rec.purchase_order_num = FND_API.G_MISS_CHAR
1147: OR g_Agreement_rec.revision = FND_API.G_MISS_CHAR
1148: OR g_Agreement_rec.revision_date = FND_API.G_MISS_DATE
1149: OR g_Agreement_rec.revision_reason_code = FND_API.G_MISS_CHAR
1150: OR g_Agreement_rec.salesrep_id = FND_API.G_MISS_NUM
1151: OR g_Agreement_rec.ship_method_code = FND_API.G_MISS_CHAR
1152: OR g_Agreement_rec.signature_date = FND_API.G_MISS_DATE
1153: OR g_Agreement_rec.start_date_active = FND_API.G_MISS_DATE

Line 1150: OR g_Agreement_rec.salesrep_id = FND_API.G_MISS_NUM

1146: OR g_Agreement_rec.purchase_order_num = FND_API.G_MISS_CHAR
1147: OR g_Agreement_rec.revision = FND_API.G_MISS_CHAR
1148: OR g_Agreement_rec.revision_date = FND_API.G_MISS_DATE
1149: OR g_Agreement_rec.revision_reason_code = FND_API.G_MISS_CHAR
1150: OR g_Agreement_rec.salesrep_id = FND_API.G_MISS_NUM
1151: OR g_Agreement_rec.ship_method_code = FND_API.G_MISS_CHAR
1152: OR g_Agreement_rec.signature_date = FND_API.G_MISS_DATE
1153: OR g_Agreement_rec.start_date_active = FND_API.G_MISS_DATE
1154: OR g_Agreement_rec.term_id = FND_API.G_MISS_NUM

Line 1151: OR g_Agreement_rec.ship_method_code = FND_API.G_MISS_CHAR

1147: OR g_Agreement_rec.revision = FND_API.G_MISS_CHAR
1148: OR g_Agreement_rec.revision_date = FND_API.G_MISS_DATE
1149: OR g_Agreement_rec.revision_reason_code = FND_API.G_MISS_CHAR
1150: OR g_Agreement_rec.salesrep_id = FND_API.G_MISS_NUM
1151: OR g_Agreement_rec.ship_method_code = FND_API.G_MISS_CHAR
1152: OR g_Agreement_rec.signature_date = FND_API.G_MISS_DATE
1153: OR g_Agreement_rec.start_date_active = FND_API.G_MISS_DATE
1154: OR g_Agreement_rec.term_id = FND_API.G_MISS_NUM
1155: --begin code added by rchellam for OKC

Line 1152: OR g_Agreement_rec.signature_date = FND_API.G_MISS_DATE

1148: OR g_Agreement_rec.revision_date = FND_API.G_MISS_DATE
1149: OR g_Agreement_rec.revision_reason_code = FND_API.G_MISS_CHAR
1150: OR g_Agreement_rec.salesrep_id = FND_API.G_MISS_NUM
1151: OR g_Agreement_rec.ship_method_code = FND_API.G_MISS_CHAR
1152: OR g_Agreement_rec.signature_date = FND_API.G_MISS_DATE
1153: OR g_Agreement_rec.start_date_active = FND_API.G_MISS_DATE
1154: OR g_Agreement_rec.term_id = FND_API.G_MISS_NUM
1155: --begin code added by rchellam for OKC
1156: OR g_Agreement_rec.agreement_source_code = FND_API.G_MISS_CHAR

Line 1153: OR g_Agreement_rec.start_date_active = FND_API.G_MISS_DATE

1149: OR g_Agreement_rec.revision_reason_code = FND_API.G_MISS_CHAR
1150: OR g_Agreement_rec.salesrep_id = FND_API.G_MISS_NUM
1151: OR g_Agreement_rec.ship_method_code = FND_API.G_MISS_CHAR
1152: OR g_Agreement_rec.signature_date = FND_API.G_MISS_DATE
1153: OR g_Agreement_rec.start_date_active = FND_API.G_MISS_DATE
1154: OR g_Agreement_rec.term_id = FND_API.G_MISS_NUM
1155: --begin code added by rchellam for OKC
1156: OR g_Agreement_rec.agreement_source_code = FND_API.G_MISS_CHAR
1157: OR g_Agreement_rec.orig_system_agr_id = FND_API.G_MISS_NUM

Line 1154: OR g_Agreement_rec.term_id = FND_API.G_MISS_NUM

1150: OR g_Agreement_rec.salesrep_id = FND_API.G_MISS_NUM
1151: OR g_Agreement_rec.ship_method_code = FND_API.G_MISS_CHAR
1152: OR g_Agreement_rec.signature_date = FND_API.G_MISS_DATE
1153: OR g_Agreement_rec.start_date_active = FND_API.G_MISS_DATE
1154: OR g_Agreement_rec.term_id = FND_API.G_MISS_NUM
1155: --begin code added by rchellam for OKC
1156: OR g_Agreement_rec.agreement_source_code = FND_API.G_MISS_CHAR
1157: OR g_Agreement_rec.orig_system_agr_id = FND_API.G_MISS_NUM
1158: --end code added by rchellam for OKC

Line 1156: OR g_Agreement_rec.agreement_source_code = FND_API.G_MISS_CHAR

1152: OR g_Agreement_rec.signature_date = FND_API.G_MISS_DATE
1153: OR g_Agreement_rec.start_date_active = FND_API.G_MISS_DATE
1154: OR g_Agreement_rec.term_id = FND_API.G_MISS_NUM
1155: --begin code added by rchellam for OKC
1156: OR g_Agreement_rec.agreement_source_code = FND_API.G_MISS_CHAR
1157: OR g_Agreement_rec.orig_system_agr_id = FND_API.G_MISS_NUM
1158: --end code added by rchellam for OKC
1159: THEN
1160:

Line 1157: OR g_Agreement_rec.orig_system_agr_id = FND_API.G_MISS_NUM

1153: OR g_Agreement_rec.start_date_active = FND_API.G_MISS_DATE
1154: OR g_Agreement_rec.term_id = FND_API.G_MISS_NUM
1155: --begin code added by rchellam for OKC
1156: OR g_Agreement_rec.agreement_source_code = FND_API.G_MISS_CHAR
1157: OR g_Agreement_rec.orig_system_agr_id = FND_API.G_MISS_NUM
1158: --end code added by rchellam for OKC
1159: THEN
1160:
1161: OE_Default_Agreement.Attributes