DBA Data[Home] [Help]

APPS.OE_OE_FORM_AGREEMENT dependencies on OE_GLOBALS

Line 103: l_control_rec oe_globals.Control_Rec_Type;

99: )
100: IS
101: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
102: l_Agreement_val_rec OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;
103: l_control_rec oe_globals.Control_Rec_Type;
104: l_return_status VARCHAR2(1);
105: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
106: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
107: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

Line 161: l_Agreement_rec.operation := oe_globals.G_OPR_CREATE;

157: l_Agreement_rec.context := 'NULL';
158: */
159: -- Set Operation to Create
160:
161: l_Agreement_rec.operation := oe_globals.G_OPR_CREATE;
162:
163: -- Call OE_Pricing_Cont_PVT.Process_Pricing_Cont
164:
165: OE_Pricing_Cont_PVT.Process_Pricing_Cont

Line 422: l_control_rec oe_globals.Control_Rec_Type;

418: IS
419: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
420: l_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
421: l_Agreement_val_rec OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;
422: l_control_rec oe_globals.Control_Rec_Type;
423: l_return_status VARCHAR2(1);
424: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
425: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
426: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

Line 579: l_Agreement_rec.operation := oe_globals.G_OPR_UPDATE;

575:
576: -- Set Operation.
577:
578: IF FND_API.To_Boolean(l_Agreement_rec.db_flag) THEN
579: l_Agreement_rec.operation := oe_globals.G_OPR_UPDATE;
580: ELSE
581: l_Agreement_rec.operation := oe_globals.G_OPR_CREATE;
582: END IF;
583:

Line 581: l_Agreement_rec.operation := oe_globals.G_OPR_CREATE;

577:
578: IF FND_API.To_Boolean(l_Agreement_rec.db_flag) THEN
579: l_Agreement_rec.operation := oe_globals.G_OPR_UPDATE;
580: ELSE
581: l_Agreement_rec.operation := oe_globals.G_OPR_CREATE;
582: END IF;
583:
584: -- Call OE_Pricing_Cont_PVT.Process_Pricing_Cont
585:

Line 690: IF NOT oe_globals.Equal(l_x_Agreement_rec.accounting_rule_id,

686: );
687:
688: -- Return changed attributes.
689:
690: IF NOT oe_globals.Equal(l_x_Agreement_rec.accounting_rule_id,
691: l_Agreement_rec.accounting_rule_id)
692: THEN
693: x_accounting_rule_id := l_x_Agreement_rec.accounting_rule_id;
694: x_accounting_rule := l_Agreement_val_rec.accounting_rule;

Line 697: IF NOT oe_globals.Equal(l_x_Agreement_rec.agreement_contact_id,

693: x_accounting_rule_id := l_x_Agreement_rec.accounting_rule_id;
694: x_accounting_rule := l_Agreement_val_rec.accounting_rule;
695: END IF;
696:
697: IF NOT oe_globals.Equal(l_x_Agreement_rec.agreement_contact_id,
698: l_Agreement_rec.agreement_contact_id)
699: THEN
700: x_agreement_contact_id := l_x_Agreement_rec.agreement_contact_id;
701: x_agreement_contact := l_Agreement_val_rec.agreement_contact;

Line 704: IF NOT oe_globals.Equal(l_x_Agreement_rec.agreement_id,

700: x_agreement_contact_id := l_x_Agreement_rec.agreement_contact_id;
701: x_agreement_contact := l_Agreement_val_rec.agreement_contact;
702: END IF;
703:
704: IF NOT oe_globals.Equal(l_x_Agreement_rec.agreement_id,
705: l_Agreement_rec.agreement_id)
706: THEN
707: x_agreement_id := l_x_Agreement_rec.agreement_id;
708: x_agreement := l_Agreement_val_rec.agreement;

Line 711: IF NOT oe_globals.Equal(l_x_Agreement_rec.agreement_num,

707: x_agreement_id := l_x_Agreement_rec.agreement_id;
708: x_agreement := l_Agreement_val_rec.agreement;
709: END IF;
710:
711: IF NOT oe_globals.Equal(l_x_Agreement_rec.agreement_num,
712: l_Agreement_rec.agreement_num)
713: THEN
714: x_agreement_num := l_x_Agreement_rec.agreement_num;
715: END IF;

Line 717: IF NOT oe_globals.Equal(l_x_Agreement_rec.agreement_type_code,

713: THEN
714: x_agreement_num := l_x_Agreement_rec.agreement_num;
715: END IF;
716:
717: IF NOT oe_globals.Equal(l_x_Agreement_rec.agreement_type_code,
718: l_Agreement_rec.agreement_type_code)
719: THEN
720: x_agreement_type_code := l_x_Agreement_rec.agreement_type_code;
721: x_agreement_type := l_Agreement_val_rec.agreement_type;

Line 724: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute1,

720: x_agreement_type_code := l_x_Agreement_rec.agreement_type_code;
721: x_agreement_type := l_Agreement_val_rec.agreement_type;
722: END IF;
723:
724: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute1,
725: l_Agreement_rec.attribute1)
726: THEN
727: x_attribute1 := l_x_Agreement_rec.attribute1;
728: END IF;

Line 730: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute10,

726: THEN
727: x_attribute1 := l_x_Agreement_rec.attribute1;
728: END IF;
729:
730: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute10,
731: l_Agreement_rec.attribute10)
732: THEN
733: x_attribute10 := l_x_Agreement_rec.attribute10;
734: END IF;

Line 736: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute11,

732: THEN
733: x_attribute10 := l_x_Agreement_rec.attribute10;
734: END IF;
735:
736: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute11,
737: l_Agreement_rec.attribute11)
738: THEN
739: x_attribute11 := l_x_Agreement_rec.attribute11;
740: END IF;

Line 742: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute12,

738: THEN
739: x_attribute11 := l_x_Agreement_rec.attribute11;
740: END IF;
741:
742: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute12,
743: l_Agreement_rec.attribute12)
744: THEN
745: x_attribute12 := l_x_Agreement_rec.attribute12;
746: END IF;

Line 748: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute13,

744: THEN
745: x_attribute12 := l_x_Agreement_rec.attribute12;
746: END IF;
747:
748: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute13,
749: l_Agreement_rec.attribute13)
750: THEN
751: x_attribute13 := l_x_Agreement_rec.attribute13;
752: END IF;

Line 754: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute14,

750: THEN
751: x_attribute13 := l_x_Agreement_rec.attribute13;
752: END IF;
753:
754: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute14,
755: l_Agreement_rec.attribute14)
756: THEN
757: x_attribute14 := l_x_Agreement_rec.attribute14;
758: END IF;

Line 760: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute15,

756: THEN
757: x_attribute14 := l_x_Agreement_rec.attribute14;
758: END IF;
759:
760: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute15,
761: l_Agreement_rec.attribute15)
762: THEN
763: x_attribute15 := l_x_Agreement_rec.attribute15;
764: END IF;

Line 766: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute2,

762: THEN
763: x_attribute15 := l_x_Agreement_rec.attribute15;
764: END IF;
765:
766: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute2,
767: l_Agreement_rec.attribute2)
768: THEN
769: x_attribute2 := l_x_Agreement_rec.attribute2;
770: END IF;

Line 772: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute3,

768: THEN
769: x_attribute2 := l_x_Agreement_rec.attribute2;
770: END IF;
771:
772: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute3,
773: l_Agreement_rec.attribute3)
774: THEN
775: x_attribute3 := l_x_Agreement_rec.attribute3;
776: END IF;

Line 778: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute4,

774: THEN
775: x_attribute3 := l_x_Agreement_rec.attribute3;
776: END IF;
777:
778: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute4,
779: l_Agreement_rec.attribute4)
780: THEN
781: x_attribute4 := l_x_Agreement_rec.attribute4;
782: END IF;

Line 784: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute5,

780: THEN
781: x_attribute4 := l_x_Agreement_rec.attribute4;
782: END IF;
783:
784: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute5,
785: l_Agreement_rec.attribute5)
786: THEN
787: x_attribute5 := l_x_Agreement_rec.attribute5;
788: END IF;

Line 790: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute6,

786: THEN
787: x_attribute5 := l_x_Agreement_rec.attribute5;
788: END IF;
789:
790: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute6,
791: l_Agreement_rec.attribute6)
792: THEN
793: x_attribute6 := l_x_Agreement_rec.attribute6;
794: END IF;

Line 796: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute7,

792: THEN
793: x_attribute6 := l_x_Agreement_rec.attribute6;
794: END IF;
795:
796: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute7,
797: l_Agreement_rec.attribute7)
798: THEN
799: x_attribute7 := l_x_Agreement_rec.attribute7;
800: END IF;

Line 802: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute8,

798: THEN
799: x_attribute7 := l_x_Agreement_rec.attribute7;
800: END IF;
801:
802: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute8,
803: l_Agreement_rec.attribute8)
804: THEN
805: x_attribute8 := l_x_Agreement_rec.attribute8;
806: END IF;

Line 808: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute9,

804: THEN
805: x_attribute8 := l_x_Agreement_rec.attribute8;
806: END IF;
807:
808: IF NOT oe_globals.Equal(l_x_Agreement_rec.attribute9,
809: l_Agreement_rec.attribute9)
810: THEN
811: x_attribute9 := l_x_Agreement_rec.attribute9;
812: END IF;

Line 814: IF NOT oe_globals.Equal(l_x_Agreement_rec.context,

810: THEN
811: x_attribute9 := l_x_Agreement_rec.attribute9;
812: END IF;
813:
814: IF NOT oe_globals.Equal(l_x_Agreement_rec.context,
815: l_Agreement_rec.context)
816: THEN
817: x_context := l_x_Agreement_rec.context;
818: END IF;

Line 821: IF NOT oe_globals.Equal(l_x_Agreement_rec.customer_id,

817: x_context := l_x_Agreement_rec.context;
818: END IF;
819:
820: /*
821: IF NOT oe_globals.Equal(l_x_Agreement_rec.customer_id,
822: l_Agreement_rec.customer_id)
823: THEN
824: x_customer_id := l_x_Agreement_rec.customer_id;
825: x_customer := l_Agreement_val_rec.customer;

Line 829: IF NOT oe_globals.Equal(l_x_Agreement_rec.sold_to_org_id,

825: x_customer := l_Agreement_val_rec.customer;
826: END IF;
827: */
828:
829: IF NOT oe_globals.Equal(l_x_Agreement_rec.sold_to_org_id,
830: l_Agreement_rec.sold_to_org_id)
831: THEN
832: x_sold_to_org_id := l_x_Agreement_rec.sold_to_org_id;
833: x_customer := l_Agreement_val_rec.customer;

Line 836: IF NOT oe_globals.Equal(l_x_Agreement_rec.end_date_active,

832: x_sold_to_org_id := l_x_Agreement_rec.sold_to_org_id;
833: x_customer := l_Agreement_val_rec.customer;
834: END IF;
835:
836: IF NOT oe_globals.Equal(l_x_Agreement_rec.end_date_active,
837: l_Agreement_rec.end_date_active)
838: THEN
839: x_end_date_active := l_x_Agreement_rec.end_date_active;
840: END IF;

Line 842: IF NOT oe_globals.Equal(l_x_Agreement_rec.freight_terms_code,

838: THEN
839: x_end_date_active := l_x_Agreement_rec.end_date_active;
840: END IF;
841:
842: IF NOT oe_globals.Equal(l_x_Agreement_rec.freight_terms_code,
843: l_Agreement_rec.freight_terms_code)
844: THEN
845: x_freight_terms_code := l_x_Agreement_rec.freight_terms_code;
846: x_freight_terms := l_Agreement_val_rec.freight_terms;

Line 849: IF NOT oe_globals.Equal(l_x_Agreement_rec.invoice_contact_id,

845: x_freight_terms_code := l_x_Agreement_rec.freight_terms_code;
846: x_freight_terms := l_Agreement_val_rec.freight_terms;
847: END IF;
848:
849: IF NOT oe_globals.Equal(l_x_Agreement_rec.invoice_contact_id,
850: l_Agreement_rec.invoice_contact_id)
851: THEN
852: x_invoice_contact_id := l_x_Agreement_rec.invoice_contact_id;
853: x_invoice_contact := l_Agreement_val_rec.invoice_contact;

Line 856: /* IF NOT oe_globals.Equal(l_x_Agreement_rec.invoice_to_site_use_id,

852: x_invoice_contact_id := l_x_Agreement_rec.invoice_contact_id;
853: x_invoice_contact := l_Agreement_val_rec.invoice_contact;
854: END IF;
855:
856: /* IF NOT oe_globals.Equal(l_x_Agreement_rec.invoice_to_site_use_id,
857: l_Agreement_rec.invoice_to_site_use_id)
858: */
859: IF NOT oe_globals.Equal(l_x_Agreement_rec.invoice_to_org_id,
860: l_Agreement_rec.invoice_to_org_id)

Line 859: IF NOT oe_globals.Equal(l_x_Agreement_rec.invoice_to_org_id,

855:
856: /* IF NOT oe_globals.Equal(l_x_Agreement_rec.invoice_to_site_use_id,
857: l_Agreement_rec.invoice_to_site_use_id)
858: */
859: IF NOT oe_globals.Equal(l_x_Agreement_rec.invoice_to_org_id,
860: l_Agreement_rec.invoice_to_org_id)
861: THEN
862: /* x_invoice_to_site_use_id := l_x_Agreement_rec.invoice_to_site_use_id;*/
863: x_invoice_to_org_id := l_x_Agreement_rec.invoice_to_org_id;

Line 869: IF NOT oe_globals.Equal(l_x_Agreement_rec.invoicing_rule_id,

865: x_invoice_to_site_use := l_Agreement_val_rec.invoice_to_site_use;
866: /* x_invoice_to_org := l_Agreement_val_rec.invoice_to_org; */
867: END IF;
868:
869: IF NOT oe_globals.Equal(l_x_Agreement_rec.invoicing_rule_id,
870: l_Agreement_rec.invoicing_rule_id)
871: THEN
872: x_invoicing_rule_id := l_x_Agreement_rec.invoicing_rule_id;
873: x_invoicing_rule := l_Agreement_val_rec.invoicing_rule;

Line 876: IF NOT oe_globals.Equal(l_x_Agreement_rec.name,

872: x_invoicing_rule_id := l_x_Agreement_rec.invoicing_rule_id;
873: x_invoicing_rule := l_Agreement_val_rec.invoicing_rule;
874: END IF;
875:
876: IF NOT oe_globals.Equal(l_x_Agreement_rec.name,
877: l_Agreement_rec.name)
878: THEN
879: x_name := l_x_Agreement_rec.name;
880: END IF;

Line 882: IF NOT oe_globals.Equal(l_x_Agreement_rec.override_arule_flag,

878: THEN
879: x_name := l_x_Agreement_rec.name;
880: END IF;
881:
882: IF NOT oe_globals.Equal(l_x_Agreement_rec.override_arule_flag,
883: l_Agreement_rec.override_arule_flag)
884: THEN
885: x_override_arule_flag := l_x_Agreement_rec.override_arule_flag;
886: x_override_arule := l_Agreement_val_rec.override_arule;

Line 889: IF NOT oe_globals.Equal(l_x_Agreement_rec.override_irule_flag,

885: x_override_arule_flag := l_x_Agreement_rec.override_arule_flag;
886: x_override_arule := l_Agreement_val_rec.override_arule;
887: END IF;
888:
889: IF NOT oe_globals.Equal(l_x_Agreement_rec.override_irule_flag,
890: l_Agreement_rec.override_irule_flag)
891: THEN
892: x_override_irule_flag := l_x_Agreement_rec.override_irule_flag;
893: x_override_irule := l_Agreement_val_rec.override_irule;

Line 896: IF NOT oe_globals.Equal(l_x_Agreement_rec.price_list_id,

892: x_override_irule_flag := l_x_Agreement_rec.override_irule_flag;
893: x_override_irule := l_Agreement_val_rec.override_irule;
894: END IF;
895:
896: IF NOT oe_globals.Equal(l_x_Agreement_rec.price_list_id,
897: l_Agreement_rec.price_list_id)
898: THEN
899: x_price_list_id := l_x_Agreement_rec.price_list_id;
900: x_price_list := l_Agreement_val_rec.price_list;

Line 903: IF NOT oe_globals.Equal(l_x_Agreement_rec.purchase_order_num,

899: x_price_list_id := l_x_Agreement_rec.price_list_id;
900: x_price_list := l_Agreement_val_rec.price_list;
901: END IF;
902:
903: IF NOT oe_globals.Equal(l_x_Agreement_rec.purchase_order_num,
904: l_Agreement_rec.purchase_order_num)
905: THEN
906: x_purchase_order_num := l_x_Agreement_rec.purchase_order_num;
907: END IF;

Line 909: IF NOT oe_globals.Equal(l_x_Agreement_rec.revision,

905: THEN
906: x_purchase_order_num := l_x_Agreement_rec.purchase_order_num;
907: END IF;
908:
909: IF NOT oe_globals.Equal(l_x_Agreement_rec.revision,
910: l_Agreement_rec.revision)
911: THEN
912: x_revision := l_x_Agreement_rec.revision;
913: END IF;

Line 915: IF NOT oe_globals.Equal(l_x_Agreement_rec.revision_date,

911: THEN
912: x_revision := l_x_Agreement_rec.revision;
913: END IF;
914:
915: IF NOT oe_globals.Equal(l_x_Agreement_rec.revision_date,
916: l_Agreement_rec.revision_date)
917: THEN
918: x_revision_date := l_x_Agreement_rec.revision_date;
919: END IF;

Line 921: IF NOT oe_globals.Equal(l_x_Agreement_rec.revision_reason_code,

917: THEN
918: x_revision_date := l_x_Agreement_rec.revision_date;
919: END IF;
920:
921: IF NOT oe_globals.Equal(l_x_Agreement_rec.revision_reason_code,
922: l_Agreement_rec.revision_reason_code)
923: THEN
924: x_revision_reason_code := l_x_Agreement_rec.revision_reason_code;
925: x_revision_reason := l_Agreement_val_rec.revision_reason;

Line 928: IF NOT oe_globals.Equal(l_x_Agreement_rec.salesrep_id,

924: x_revision_reason_code := l_x_Agreement_rec.revision_reason_code;
925: x_revision_reason := l_Agreement_val_rec.revision_reason;
926: END IF;
927:
928: IF NOT oe_globals.Equal(l_x_Agreement_rec.salesrep_id,
929: l_Agreement_rec.salesrep_id)
930: THEN
931: x_salesrep_id := l_x_Agreement_rec.salesrep_id;
932: x_salesrep := l_Agreement_val_rec.salesrep;

Line 935: IF NOT oe_globals.Equal(l_x_Agreement_rec.ship_method_code,

931: x_salesrep_id := l_x_Agreement_rec.salesrep_id;
932: x_salesrep := l_Agreement_val_rec.salesrep;
933: END IF;
934:
935: IF NOT oe_globals.Equal(l_x_Agreement_rec.ship_method_code,
936: l_Agreement_rec.ship_method_code)
937: THEN
938: x_ship_method_code := l_x_Agreement_rec.ship_method_code;
939: x_ship_method := l_Agreement_val_rec.ship_method;

Line 942: IF NOT oe_globals.Equal(l_x_Agreement_rec.signature_date,

938: x_ship_method_code := l_x_Agreement_rec.ship_method_code;
939: x_ship_method := l_Agreement_val_rec.ship_method;
940: END IF;
941:
942: IF NOT oe_globals.Equal(l_x_Agreement_rec.signature_date,
943: l_Agreement_rec.signature_date)
944: THEN
945: x_signature_date := l_x_Agreement_rec.signature_date;
946: END IF;

Line 948: IF NOT oe_globals.Equal(l_x_Agreement_rec.start_date_active,

944: THEN
945: x_signature_date := l_x_Agreement_rec.signature_date;
946: END IF;
947:
948: IF NOT oe_globals.Equal(l_x_Agreement_rec.start_date_active,
949: l_Agreement_rec.start_date_active)
950: THEN
951: x_start_date_active := l_x_Agreement_rec.start_date_active;
952: END IF;

Line 954: IF NOT oe_globals.Equal(l_x_Agreement_rec.term_id,

950: THEN
951: x_start_date_active := l_x_Agreement_rec.start_date_active;
952: END IF;
953:
954: IF NOT oe_globals.Equal(l_x_Agreement_rec.term_id,
955: l_Agreement_rec.term_id)
956: THEN
957: x_term_id := l_x_Agreement_rec.term_id;
958: x_term := l_Agreement_val_rec.term;

Line 962: IF NOT oe_globals.Equal(l_x_Agreement_rec.agreement_source_code,

958: x_term := l_Agreement_val_rec.term;
959: END IF;
960:
961: --Begin code added by rchellam for OKC
962: IF NOT oe_globals.Equal(l_x_Agreement_rec.agreement_source_code,
963: l_Agreement_rec.agreement_source_code)
964: THEN
965: x_agreement_source_code := l_x_Agreement_rec.agreement_source_code;
966: x_agreement_source := l_Agreement_val_rec.agreement_source;

Line 969: IF NOT oe_globals.Equal(l_x_Agreement_rec.orig_system_agr_id,

965: x_agreement_source_code := l_x_Agreement_rec.agreement_source_code;
966: x_agreement_source := l_Agreement_val_rec.agreement_source;
967: END IF;
968:
969: IF NOT oe_globals.Equal(l_x_Agreement_rec.orig_system_agr_id,
970: l_Agreement_rec.orig_system_agr_id)
971: THEN
972: x_orig_system_agr_id := l_x_Agreement_rec.orig_system_agr_id;
973: END IF;

Line 977: IF NOT oe_globals.Equal(l_x_Agreement_rec.invoice_to_customer_id,

973: END IF;
974: --End code added by rchellam for OKC
975:
976: -- Added for bug#4029589
977: IF NOT oe_globals.Equal(l_x_Agreement_rec.invoice_to_customer_id,
978: l_Agreement_rec.invoice_to_customer_id)
979: THEN
980: x_invoice_to_customer_id := l_x_Agreement_rec.invoice_to_customer_id;
981: END IF;

Line 1075: l_control_rec oe_globals.Control_Rec_Type;

1071: )
1072: IS
1073: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1074: l_old_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1075: l_control_rec oe_globals.Control_Rec_Type;
1076: l_return_status VARCHAR2(1);
1077: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1078: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1079: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

Line 1123: l_Agreement_rec.operation := oe_globals.G_OPR_UPDATE;

1119:
1120: -- Set Operation.
1121:
1122: IF FND_API.To_Boolean(l_Agreement_rec.db_flag) THEN
1123: l_Agreement_rec.operation := oe_globals.G_OPR_UPDATE;
1124: ELSE
1125: l_Agreement_rec.operation := oe_globals.G_OPR_CREATE;
1126: END IF;
1127:

Line 1125: l_Agreement_rec.operation := oe_globals.G_OPR_CREATE;

1121:
1122: IF FND_API.To_Boolean(l_Agreement_rec.db_flag) THEN
1123: l_Agreement_rec.operation := oe_globals.G_OPR_UPDATE;
1124: ELSE
1125: l_Agreement_rec.operation := oe_globals.G_OPR_CREATE;
1126: END IF;
1127:
1128:
1129:

Line 1132: and l_Agreement_rec.operation = oe_globals.G_OPR_UPDATE ) THEN

1128:
1129:
1130: --Revision Control S
1131: IF ( l_old_agreement_rec.revision <> l_agreement_rec.revision
1132: and l_Agreement_rec.operation = oe_globals.G_OPR_UPDATE ) THEN
1133:
1134: select oe_agreements_s.nextval into l_agreement_rec.agreement_id from dual;
1135:
1136: l_Agreement_rec.operation := oe_globals.G_OPR_CREATE;

Line 1136: l_Agreement_rec.operation := oe_globals.G_OPR_CREATE;

1132: and l_Agreement_rec.operation = oe_globals.G_OPR_UPDATE ) THEN
1133:
1134: select oe_agreements_s.nextval into l_agreement_rec.agreement_id from dual;
1135:
1136: l_Agreement_rec.operation := oe_globals.G_OPR_CREATE;
1137: l_Agreement_rec.db_flag := FND_API.G_FALSE;
1138: --OE_OE_Form_Contract.Create_Revision(l_agreement_rec.agreement_id);
1139: END IF;
1140: --Revision Control E

Line 1282: l_control_rec oe_globals.Control_Rec_Type;

1278: , p_agreement_id IN NUMBER
1279: )
1280: IS
1281: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1282: l_control_rec oe_globals.Control_Rec_Type;
1283: l_return_status VARCHAR2(1);
1284: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1285: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1286: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

Line 1322: l_Agreement_rec.operation := oe_globals.G_OPR_DELETE;

1318: );
1319:
1320: -- Set Operation.
1321:
1322: l_Agreement_rec.operation := oe_globals.G_OPR_DELETE;
1323:
1324: -- Call OE_Pricing_Cont_PVT.Process_Pricing_Cont
1325:
1326: OE_Pricing_Cont_PVT.Process_Pricing_Cont

Line 1421: l_control_rec oe_globals.Control_Rec_Type;

1417: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1418: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1419: )
1420: IS
1421: l_control_rec oe_globals.Control_Rec_Type;
1422: l_return_status VARCHAR2(1);
1423: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1424: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1425: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

Line 1441: l_control_rec.process_entity := oe_globals.G_ENTITY_AGREEMENT;

1437: -- Set control flags.
1438:
1439: l_control_rec.controlled_operation := TRUE;
1440: l_control_rec.process := TRUE;
1441: l_control_rec.process_entity := oe_globals.G_ENTITY_AGREEMENT;
1442:
1443: l_control_rec.default_attributes := FALSE;
1444: l_control_rec.change_attributes := FALSE;
1445: l_control_rec.validate_entity := FALSE;