eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_VERSION_BLANKET_COMP dependencies on OE_GLOBALS

Line 20: l_org_id := OE_GLOBALS.G_ORG_ID;

16: oe_debug_pub.add('header' ||p_header_id);
17: oe_debug_pub.add('version' ||p_version);
18: oe_debug_pub.add('phase_change_flag' ||p_phase_change_flag);
19: END IF;
20: l_org_id := OE_GLOBALS.G_ORG_ID;
21:
22: IF l_org_id IS NULL THEN
23: OE_GLOBALS.Set_Context;
24: l_org_id := OE_GLOBALS.G_ORG_ID;

Line 23: OE_GLOBALS.Set_Context;

19: END IF;
20: l_org_id := OE_GLOBALS.G_ORG_ID;
21:
22: IF l_org_id IS NULL THEN
23: OE_GLOBALS.Set_Context;
24: l_org_id := OE_GLOBALS.G_ORG_ID;
25: END IF;
26:
27: SELECT ACCOUNTING_RULE_ID

Line 24: l_org_id := OE_GLOBALS.G_ORG_ID;

20: l_org_id := OE_GLOBALS.G_ORG_ID;
21:
22: IF l_org_id IS NULL THEN
23: OE_GLOBALS.Set_Context;
24: l_org_id := OE_GLOBALS.G_ORG_ID;
25: END IF;
26:
27: SELECT ACCOUNTING_RULE_ID
28: , AGREEMENT_ID

Line 244: l_org_id := OE_GLOBALS.G_ORG_ID;

240: oe_debug_pub.add('Entering OE_BLKT_VERSION_COMPARISION.QUERY_HEADER_TRANS_ROW');
241: oe_debug_pub.add('header' ||p_header_id);
242: oe_debug_pub.add('version' ||p_version);
243: END IF;
244: l_org_id := OE_GLOBALS.G_ORG_ID;
245:
246: IF l_org_id IS NULL THEN
247: OE_GLOBALS.Set_Context;
248: l_org_id := OE_GLOBALS.G_ORG_ID;

Line 247: OE_GLOBALS.Set_Context;

243: END IF;
244: l_org_id := OE_GLOBALS.G_ORG_ID;
245:
246: IF l_org_id IS NULL THEN
247: OE_GLOBALS.Set_Context;
248: l_org_id := OE_GLOBALS.G_ORG_ID;
249: END IF;
250:
251:

Line 248: l_org_id := OE_GLOBALS.G_ORG_ID;

244: l_org_id := OE_GLOBALS.G_ORG_ID;
245:
246: IF l_org_id IS NULL THEN
247: OE_GLOBALS.Set_Context;
248: l_org_id := OE_GLOBALS.G_ORG_ID;
249: END IF;
250:
251:
252: SELECT ACCOUNTING_RULE_ID

Line 615: IF OE_Globals.Equal(

611: /* START ACCOUNTING_RULE_ID*/
612:
613: prior_exists := 'N';
614: IF p_prior_version IS NOT NULL THEN
615: IF OE_Globals.Equal(
616: p_curr_rec.accounting_rule_id,
617: p_prior_rec.accounting_rule_id) THEN
618: null;
619: ELSE

Line 631: IF OE_Globals.Equal(

627: END IF;
628: END IF; /* PRIOR */
629: /****************************/
630: IF p_next_version IS NOT NULL THEN
631: IF OE_Globals.Equal(
632: p_curr_rec.accounting_rule_id,
633: p_next_rec.accounting_rule_id) THEN
634: IF prior_exists = 'Y' THEN
635: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Accounting_Rule(p_curr_rec.accounting_rule_id);

Line 659: IF OE_Globals.Equal(

655: /* START PAYMENT_TERM_ID*/
656:
657: prior_exists := 'N';
658: IF p_prior_version IS NOT NULL THEN
659: IF OE_Globals.Equal(
660: p_curr_rec.PAYMENT_TERM_ID,
661: p_prior_rec.PAYMENT_TERM_ID) THEN
662: null;
663: ELSE

Line 675: IF OE_Globals.Equal(

671: END IF;
672: END IF; /* PRIOR */
673: /****************************/
674: IF p_next_version IS NOT NULL THEN
675: IF OE_Globals.Equal(
676: p_curr_rec.PAYMENT_TERM_ID,
677: p_next_rec.PAYMENT_TERM_ID) THEN
678: IF prior_exists = 'Y' THEN
679: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PAYMENT_TERM(p_curr_rec.PAYMENT_TERM_ID);

Line 703: IF OE_Globals.Equal(

699: /* START agreement_id*/
700:
701: prior_exists := 'N';
702: IF p_prior_version IS NOT NULL THEN
703: IF OE_Globals.Equal(
704: p_curr_rec.agreement_id,
705: p_prior_rec.agreement_id) THEN
706: null;
707: ELSE

Line 719: IF OE_Globals.Equal(

715: END IF;
716: END IF; /* PRIOR */
717: /****************************/
718: IF p_next_version IS NOT NULL THEN
719: IF OE_Globals.Equal(
720: p_curr_rec.agreement_id,
721: p_next_rec.agreement_id) THEN
722: IF prior_exists = 'Y' THEN
723: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Agreement(p_curr_rec.agreement_id);

Line 747: IF OE_Globals.Equal(

743: /* START attribute1*/
744:
745: prior_exists := 'N';
746: IF p_prior_version IS NOT NULL THEN
747: IF OE_Globals.Equal(
748: p_curr_rec.attribute1,
749: p_prior_rec.attribute1) THEN
750: null;
751: ELSE

Line 761: IF OE_Globals.Equal(

757: END IF;
758: END IF; /* PRIOR */
759: /****************************/
760: IF p_next_version IS NOT NULL THEN
761: IF OE_Globals.Equal(
762: p_curr_rec.attribute1,
763: p_next_rec.attribute1) THEN
764: IF prior_exists = 'Y' THEN
765: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.attribute1;

Line 786: IF OE_Globals.Equal(

782: /* START attribute2*/
783:
784: prior_exists := 'N';
785: IF p_prior_version IS NOT NULL THEN
786: IF OE_Globals.Equal(
787: p_curr_rec.attribute2,
788: p_prior_rec.attribute2) THEN
789: null;
790: ELSE

Line 800: IF OE_Globals.Equal(

796: END IF;
797: END IF; /* PRIOR */
798: /****************************/
799: IF p_next_version IS NOT NULL THEN
800: IF OE_Globals.Equal(
801: p_curr_rec.attribute2,
802: p_next_rec.attribute2) THEN
803: IF prior_exists = 'Y' THEN
804: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.attribute2;

Line 824: IF OE_Globals.Equal(

820: /* START attribute3*/
821:
822: prior_exists := 'N';
823: IF p_prior_version IS NOT NULL THEN
824: IF OE_Globals.Equal(
825: p_curr_rec.attribute3,
826: p_prior_rec.attribute3) THEN
827: null;
828: ELSE

Line 838: IF OE_Globals.Equal(

834: END IF;
835: END IF; /* PRIOR */
836: /****************************/
837: IF p_next_version IS NOT NULL THEN
838: IF OE_Globals.Equal(
839: p_curr_rec.attribute3,
840: p_next_rec.attribute3) THEN
841: IF prior_exists = 'Y' THEN
842: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.attribute3;

Line 863: IF OE_Globals.Equal(

859: /* START attribute4*/
860:
861: prior_exists := 'N';
862: IF p_prior_version IS NOT NULL THEN
863: IF OE_Globals.Equal(
864: p_curr_rec.attribute4,
865: p_prior_rec.attribute4) THEN
866: null;
867: ELSE

Line 877: IF OE_Globals.Equal(

873: END IF;
874: END IF; /* PRIOR */
875: /****************************/
876: IF p_next_version IS NOT NULL THEN
877: IF OE_Globals.Equal(
878: p_curr_rec.attribute4,
879: p_next_rec.attribute4) THEN
880: IF prior_exists = 'Y' THEN
881: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.attribute4;

Line 901: IF OE_Globals.Equal(

897: /* START attribute5*/
898:
899: prior_exists := 'N';
900: IF p_prior_version IS NOT NULL THEN
901: IF OE_Globals.Equal(
902: p_curr_rec.attribute5,
903: p_prior_rec.attribute5) THEN
904: null;
905: ELSE

Line 915: IF OE_Globals.Equal(

911: END IF;
912: END IF; /* PRIOR */
913: /****************************/
914: IF p_next_version IS NOT NULL THEN
915: IF OE_Globals.Equal(
916: p_curr_rec.attribute5,
917: p_next_rec.attribute5) THEN
918: IF prior_exists = 'Y' THEN
919: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.attribute5;

Line 940: IF OE_Globals.Equal(

936: /* START attribute6*/
937:
938: prior_exists := 'N';
939: IF p_prior_version IS NOT NULL THEN
940: IF OE_Globals.Equal(
941: p_curr_rec.attribute6,
942: p_prior_rec.attribute6) THEN
943: null;
944: ELSE

Line 954: IF OE_Globals.Equal(

950: END IF;
951: END IF; /* PRIOR */
952: /****************************/
953: IF p_next_version IS NOT NULL THEN
954: IF OE_Globals.Equal(
955: p_curr_rec.attribute6,
956: p_next_rec.attribute6) THEN
957: IF prior_exists = 'Y' THEN
958: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.attribute6;

Line 978: IF OE_Globals.Equal(

974: /* START attribute7*/
975:
976: prior_exists := 'N';
977: IF p_prior_version IS NOT NULL THEN
978: IF OE_Globals.Equal(
979: p_curr_rec.attribute7,
980: p_prior_rec.attribute7) THEN
981: null;
982: ELSE

Line 992: IF OE_Globals.Equal(

988: END IF;
989: END IF; /* PRIOR */
990: /****************************/
991: IF p_next_version IS NOT NULL THEN
992: IF OE_Globals.Equal(
993: p_curr_rec.attribute7,
994: p_next_rec.attribute7) THEN
995: IF prior_exists = 'Y' THEN
996: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.attribute7;

Line 1017: IF OE_Globals.Equal(

1013: /* START attribute8*/
1014:
1015: prior_exists := 'N';
1016: IF p_prior_version IS NOT NULL THEN
1017: IF OE_Globals.Equal(
1018: p_curr_rec.attribute8,
1019: p_prior_rec.attribute8) THEN
1020: null;
1021: ELSE

Line 1031: IF OE_Globals.Equal(

1027: END IF;
1028: END IF; /* PRIOR */
1029: /****************************/
1030: IF p_next_version IS NOT NULL THEN
1031: IF OE_Globals.Equal(
1032: p_curr_rec.attribute8,
1033: p_next_rec.attribute8) THEN
1034: IF prior_exists = 'Y' THEN
1035: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.attribute8;

Line 1055: IF OE_Globals.Equal(

1051: /* START attribute9*/
1052:
1053: prior_exists := 'N';
1054: IF p_prior_version IS NOT NULL THEN
1055: IF OE_Globals.Equal(
1056: p_curr_rec.attribute9,
1057: p_prior_rec.attribute9) THEN
1058: null;
1059: ELSE

Line 1069: IF OE_Globals.Equal(

1065: END IF;
1066: END IF; /* PRIOR */
1067: /****************************/
1068: IF p_next_version IS NOT NULL THEN
1069: IF OE_Globals.Equal(
1070: p_curr_rec.attribute9,
1071: p_next_rec.attribute9) THEN
1072: IF prior_exists = 'Y' THEN
1073: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.attribute9;

Line 1094: IF OE_Globals.Equal(

1090: /* START attribute10*/
1091:
1092: prior_exists := 'N';
1093: IF p_prior_version IS NOT NULL THEN
1094: IF OE_Globals.Equal(
1095: p_curr_rec.attribute10,
1096: p_prior_rec.attribute10) THEN
1097: null;
1098: ELSE

Line 1108: IF OE_Globals.Equal(

1104: END IF;
1105: END IF; /* PRIOR */
1106: /****************************/
1107: IF p_next_version IS NOT NULL THEN
1108: IF OE_Globals.Equal(
1109: p_curr_rec.attribute10,
1110: p_next_rec.attribute10) THEN
1111: IF prior_exists = 'Y' THEN
1112: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.attribute10;

Line 1132: IF OE_Globals.Equal(

1128: /* START attribute11*/
1129:
1130: prior_exists := 'N';
1131: IF p_prior_version IS NOT NULL THEN
1132: IF OE_Globals.Equal(
1133: p_curr_rec.attribute11,
1134: p_prior_rec.attribute11) THEN
1135: null;
1136: ELSE

Line 1146: IF OE_Globals.Equal(

1142: END IF;
1143: END IF; /* PRIOR */
1144: /****************************/
1145: IF p_next_version IS NOT NULL THEN
1146: IF OE_Globals.Equal(
1147: p_curr_rec.attribute11,
1148: p_next_rec.attribute11) THEN
1149: IF prior_exists = 'Y' THEN
1150: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.attribute11;

Line 1171: IF OE_Globals.Equal(

1167: /* START attribute12*/
1168:
1169: prior_exists := 'N';
1170: IF p_prior_version IS NOT NULL THEN
1171: IF OE_Globals.Equal(
1172: p_curr_rec.attribute12,
1173: p_prior_rec.attribute12) THEN
1174: null;
1175: ELSE

Line 1185: IF OE_Globals.Equal(

1181: END IF;
1182: END IF; /* PRIOR */
1183: /****************************/
1184: IF p_next_version IS NOT NULL THEN
1185: IF OE_Globals.Equal(
1186: p_curr_rec.attribute12,
1187: p_next_rec.attribute12) THEN
1188: IF prior_exists = 'Y' THEN
1189: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.attribute12;

Line 1210: IF OE_Globals.Equal(

1206: /* START attribute13*/
1207:
1208: prior_exists := 'N';
1209: IF p_prior_version IS NOT NULL THEN
1210: IF OE_Globals.Equal(
1211: p_curr_rec.attribute13,
1212: p_prior_rec.attribute13) THEN
1213: null;
1214: ELSE

Line 1224: IF OE_Globals.Equal(

1220: END IF;
1221: END IF; /* PRIOR */
1222: /****************************/
1223: IF p_next_version IS NOT NULL THEN
1224: IF OE_Globals.Equal(
1225: p_curr_rec.attribute13,
1226: p_next_rec.attribute13) THEN
1227: IF prior_exists = 'Y' THEN
1228: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.attribute13;

Line 1249: IF OE_Globals.Equal(

1245: /* START attribute14*/
1246:
1247: prior_exists := 'N';
1248: IF p_prior_version IS NOT NULL THEN
1249: IF OE_Globals.Equal(
1250: p_curr_rec.attribute14,
1251: p_prior_rec.attribute14) THEN
1252: null;
1253: ELSE

Line 1263: IF OE_Globals.Equal(

1259: END IF;
1260: END IF; /* PRIOR */
1261: /****************************/
1262: IF p_next_version IS NOT NULL THEN
1263: IF OE_Globals.Equal(
1264: p_curr_rec.attribute14,
1265: p_next_rec.attribute14) THEN
1266: IF prior_exists = 'Y' THEN
1267: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.attribute14;

Line 1288: IF OE_Globals.Equal(

1284: /* START attribute15*/
1285:
1286: prior_exists := 'N';
1287: IF p_prior_version IS NOT NULL THEN
1288: IF OE_Globals.Equal(
1289: p_curr_rec.attribute15,
1290: p_prior_rec.attribute15) THEN
1291: null;
1292: ELSE

Line 1302: IF OE_Globals.Equal(

1298: END IF;
1299: END IF; /* PRIOR */
1300: /****************************/
1301: IF p_next_version IS NOT NULL THEN
1302: IF OE_Globals.Equal(
1303: p_curr_rec.attribute15,
1304: p_next_rec.attribute15) THEN
1305: IF prior_exists = 'Y' THEN
1306: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.attribute15;

Line 1326: IF OE_Globals.Equal(

1322: /* START context*/
1323:
1324: prior_exists := 'N';
1325: IF p_prior_version IS NOT NULL THEN
1326: IF OE_Globals.Equal(
1327: p_curr_rec.context,
1328: p_prior_rec.context) THEN
1329: null;
1330: ELSE

Line 1340: IF OE_Globals.Equal(

1336: END IF;
1337: END IF; /* PRIOR */
1338: /****************************/
1339: IF p_next_version IS NOT NULL THEN
1340: IF OE_Globals.Equal(
1341: p_curr_rec.context,
1342: p_next_rec.context) THEN
1343: IF prior_exists = 'Y' THEN
1344: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.context;

Line 1366: IF OE_Globals.Equal(

1362: /* START conversion_type_code*/
1363:
1364: prior_exists := 'N';
1365: IF p_prior_version IS NOT NULL THEN
1366: IF OE_Globals.Equal(
1367: p_curr_rec.conversion_type_code,
1368: p_prior_rec.conversion_type_code) THEN
1369: null;
1370: ELSE

Line 1382: IF OE_Globals.Equal(

1378: END IF;
1379: END IF; /* PRIOR */
1380: /****************************/
1381: IF p_next_version IS NOT NULL THEN
1382: IF OE_Globals.Equal(
1383: p_curr_rec.conversion_type_code,
1384: p_next_rec.conversion_type_code) THEN
1385: IF prior_exists = 'Y' THEN
1386: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Conversion_Type(p_curr_rec.conversion_type_code);

Line 1410: IF OE_Globals.Equal(

1406: /* START cust_po_number*/
1407:
1408: prior_exists := 'N';
1409: IF p_prior_version IS NOT NULL THEN
1410: IF OE_Globals.Equal(
1411: p_curr_rec.cust_po_number,
1412: p_prior_rec.cust_po_number) THEN
1413: null;
1414: ELSE

Line 1424: IF OE_Globals.Equal(

1420: END IF;
1421: END IF; /* PRIOR */
1422: /****************************/
1423: IF p_next_version IS NOT NULL THEN
1424: IF OE_Globals.Equal(
1425: p_curr_rec.cust_po_number,
1426: p_next_rec.cust_po_number) THEN
1427: IF prior_exists = 'Y' THEN
1428: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.cust_po_number;

Line 1449: IF OE_Globals.Equal(

1445: /* START deliver_to_org_id*/
1446:
1447: prior_exists := 'N';
1448: IF p_prior_version IS NOT NULL THEN
1449: IF OE_Globals.Equal(
1450: p_curr_rec.deliver_to_org_id,
1451: p_prior_rec.deliver_to_org_id) THEN
1452: null;
1453: ELSE

Line 1521: IF OE_Globals.Equal(

1517: END IF;
1518: END IF; /* PRIOR */
1519: /****************************/
1520: IF p_next_version IS NOT NULL THEN
1521: IF OE_Globals.Equal(
1522: p_curr_rec.deliver_to_org_id,
1523: p_next_rec.deliver_to_org_id) THEN
1524: IF prior_exists = 'Y' THEN
1525: x_header_changed_attr_tbl(ind).next_value := x_prior_deliver_to_address;

Line 1634: IF OE_Globals.Equal(

1630: /* START freight_terms_code*/
1631:
1632: prior_exists := 'N';
1633: IF p_prior_version IS NOT NULL THEN
1634: IF OE_Globals.Equal(
1635: p_curr_rec.freight_terms_code,
1636: p_prior_rec.freight_terms_code) THEN
1637: null;
1638: ELSE

Line 1651: IF OE_Globals.Equal(

1647: END IF; /* PRIOR */
1648: /****************************/
1649:
1650: IF p_next_version IS NOT NULL THEN
1651: IF OE_Globals.Equal(
1652: p_curr_rec.freight_terms_code,
1653: p_next_rec.freight_terms_code) THEN
1654: IF prior_exists = 'Y' THEN
1655: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Freight_terms(p_curr_rec.freight_terms_code);

Line 1678: IF OE_Globals.Equal(

1674: /* START invoice_to_org_id*/
1675:
1676: prior_exists := 'N';
1677: IF p_prior_version IS NOT NULL THEN
1678: IF OE_Globals.Equal(
1679: p_curr_rec.invoice_to_org_id,
1680: p_prior_rec.invoice_to_org_id) THEN
1681: null;
1682: ELSE

Line 1752: IF OE_Globals.Equal(

1748: END IF; /* PRIOR */
1749: /****************************/
1750:
1751: IF p_next_version IS NOT NULL THEN
1752: IF OE_Globals.Equal(
1753: p_curr_rec.invoice_to_org_id,
1754: p_next_rec.invoice_to_org_id) THEN
1755: IF prior_exists = 'Y' THEN
1756: x_header_changed_attr_tbl(ind).next_value := x_current_invoice_to_address;

Line 1864: IF OE_Globals.Equal(

1860: /* START invoicing_rule_id*/
1861:
1862: prior_exists := 'N';
1863: IF p_prior_version IS NOT NULL THEN
1864: IF OE_Globals.Equal(
1865: p_curr_rec.invoicing_rule_id,
1866: p_prior_rec.invoicing_rule_id) THEN
1867: null;
1868: ELSE

Line 1880: IF OE_Globals.Equal(

1876: END IF;
1877: END IF; /* PRIOR */
1878: /****************************/
1879: IF p_next_version IS NOT NULL THEN
1880: IF OE_Globals.Equal(
1881: p_curr_rec.invoicing_rule_id,
1882: p_next_rec.invoicing_rule_id) THEN
1883: IF prior_exists = 'Y' THEN
1884: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Invoicing_Rule(p_curr_rec.invoicing_rule_id);

Line 1908: IF OE_Globals.Equal(

1904: /* START order_number*/
1905:
1906: prior_exists := 'N';
1907: IF p_prior_version IS NOT NULL THEN
1908: IF OE_Globals.Equal(
1909: p_curr_rec.order_number,
1910: p_prior_rec.order_number) THEN
1911: null;
1912: ELSE

Line 1922: IF OE_Globals.Equal(

1918: END IF;
1919: END IF; /* PRIOR */
1920: /****************************/
1921: IF p_next_version IS NOT NULL THEN
1922: IF OE_Globals.Equal(
1923: p_curr_rec.order_number,
1924: p_next_rec.order_number) THEN
1925: IF prior_exists = 'Y' THEN
1926: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.order_number;

Line 1946: IF OE_Globals.Equal(

1942: /* START order_type_id*/
1943:
1944: prior_exists := 'N';
1945: IF p_prior_version IS NOT NULL THEN
1946: IF OE_Globals.Equal(
1947: p_curr_rec.order_type_id,
1948: p_prior_rec.order_type_id) THEN
1949: null;
1950: ELSE

Line 1962: IF OE_Globals.Equal(

1958: END IF;
1959: END IF; /* PRIOR */
1960: /****************************/
1961: IF p_next_version IS NOT NULL THEN
1962: IF OE_Globals.Equal(
1963: p_curr_rec.order_type_id,
1964: p_next_rec.order_type_id) THEN
1965: IF prior_exists = 'Y' THEN
1966: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.order_Type(p_curr_rec.order_type_id);

Line 1989: IF OE_Globals.Equal(

1985: /* START PRICE_LIST_ID*/
1986:
1987: prior_exists := 'N';
1988: IF p_prior_version IS NOT NULL THEN
1989: IF OE_Globals.Equal(
1990: p_curr_rec.PRICE_LIST_ID,
1991: p_prior_rec.PRICE_LIST_ID) THEN
1992: null;
1993: ELSE

Line 2005: IF OE_Globals.Equal(

2001: END IF;
2002: END IF; /* PRIOR */
2003: /****************************/
2004: IF p_next_version IS NOT NULL THEN
2005: IF OE_Globals.Equal(
2006: p_curr_rec.PRICE_LIST_ID,
2007: p_next_rec.PRICE_LIST_ID) THEN
2008: IF prior_exists = 'Y' THEN
2009: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.PRICE_LIST_ID);

Line 2033: IF OE_Globals.Equal(

2029: /* START SALESREP_ID*/
2030:
2031: prior_exists := 'N';
2032: IF p_prior_version IS NOT NULL THEN
2033: IF OE_Globals.Equal(
2034: p_curr_rec.SALESREP_ID,
2035: p_prior_rec.SALESREP_ID) THEN
2036: null;
2037: ELSE

Line 2049: IF OE_Globals.Equal(

2045: END IF;
2046: END IF; /* PRIOR */
2047: /****************************/
2048: IF p_next_version IS NOT NULL THEN
2049: IF OE_Globals.Equal(
2050: p_curr_rec.SALESREP_ID,
2051: p_next_rec.SALESREP_ID) THEN
2052: IF prior_exists = 'Y' THEN
2053: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.SALESREP(p_curr_rec.SALESREP_ID);

Line 2076: IF OE_Globals.Equal(

2072: /* START SHIPPING_METHOD_CODE*/
2073:
2074: prior_exists := 'N';
2075: IF p_prior_version IS NOT NULL THEN
2076: IF OE_Globals.Equal(
2077: p_curr_rec.SHIPPING_METHOD_CODE,
2078: p_prior_rec.SHIPPING_METHOD_CODE) THEN
2079: null;
2080: ELSE

Line 2092: IF OE_Globals.Equal(

2088: END IF;
2089: END IF; /* PRIOR */
2090: /****************************/
2091: IF p_next_version IS NOT NULL THEN
2092: IF OE_Globals.Equal(
2093: p_curr_rec.SHIPPING_METHOD_CODE,
2094: p_next_rec.SHIPPING_METHOD_CODE) THEN
2095: IF prior_exists = 'Y' THEN
2096: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.ship_method(p_curr_rec.SHIPPING_METHOD_CODE);

Line 2120: IF OE_Globals.Equal(

2116: /* START ship_from_org_id*/
2117:
2118: prior_exists := 'N';
2119: IF p_prior_version IS NOT NULL THEN
2120: IF OE_Globals.Equal(
2121: p_curr_rec.ship_from_org_id,
2122: p_prior_rec.ship_from_org_id) THEN
2123: null;
2124: ELSE

Line 2178: IF OE_Globals.Equal(

2174: END IF; /* PRIOR */
2175: /****************************/
2176:
2177: IF p_next_version IS NOT NULL THEN
2178: IF OE_Globals.Equal(
2179: p_curr_rec.ship_from_org_id,
2180: p_next_rec.ship_from_org_id) THEN
2181: IF prior_exists = 'Y' THEN
2182: x_header_changed_attr_tbl(ind).next_value := x_current_ship_from_org;

Line 2268: IF OE_Globals.Equal(

2264: /* START ship_to_org_id*/
2265:
2266: prior_exists := 'N';
2267: IF p_prior_version IS NOT NULL THEN
2268: IF OE_Globals.Equal(
2269: p_curr_rec.ship_to_org_id,
2270: p_prior_rec.ship_to_org_id) THEN
2271: null;
2272: ELSE

Line 2341: IF OE_Globals.Equal(

2337: END IF; /* PRIOR */
2338: /****************************/
2339:
2340: IF p_next_version IS NOT NULL THEN
2341: IF OE_Globals.Equal(
2342: p_curr_rec.ship_to_org_id,
2343: p_next_rec.ship_to_org_id) THEN
2344: IF prior_exists = 'Y' THEN
2345: x_header_changed_attr_tbl(ind).next_value := x_current_ship_to_address;

Line 2453: IF OE_Globals.Equal(

2449: /* START sold_TO_CONTACT_ID*/
2450:
2451: prior_exists := 'N';
2452: IF p_prior_version IS NOT NULL THEN
2453: IF OE_Globals.Equal(
2454: p_curr_rec.sold_to_contact_id,
2455: p_prior_rec.sold_to_contact_id) THEN
2456: null;
2457: ELSE

Line 2469: IF OE_Globals.Equal(

2465: END IF;
2466: END IF; /* PRIOR */
2467: /****************************/
2468: IF p_next_version IS NOT NULL THEN
2469: IF OE_Globals.Equal(
2470: p_curr_rec.sold_to_contact_id,
2471: p_next_rec.sold_to_contact_id) THEN
2472: IF prior_exists = 'Y' THEN
2473: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.sold_To_Contact(p_curr_rec.sold_to_contact_id);

Line 2497: IF OE_Globals.Equal(

2493: /* START SOLD_TO_ORG_ID*/
2494:
2495: prior_exists := 'N';
2496: IF p_prior_version IS NOT NULL THEN
2497: IF OE_Globals.Equal(
2498: p_curr_rec.SOLD_TO_ORG_ID,
2499: p_prior_rec.SOLD_TO_ORG_ID) THEN
2500: null;
2501: ELSE

Line 2523: IF OE_Globals.Equal(

2519: END IF;
2520: END IF; /* PRIOR */
2521: /****************************/
2522: IF p_next_version IS NOT NULL THEN
2523: IF OE_Globals.Equal(
2524: p_curr_rec.SOLD_TO_ORG_ID,
2525: p_next_rec.SOLD_TO_ORG_ID) THEN
2526: IF prior_exists = 'Y' THEN
2527: x_header_changed_attr_tbl(ind).next_value := x_current_customer_name;

Line 2566: IF OE_Globals.Equal(

2562: /* START TRANSACTIONAL_CURR_CODE*/
2563:
2564: prior_exists := 'N';
2565: IF p_prior_version IS NOT NULL THEN
2566: IF OE_Globals.Equal(
2567: p_curr_rec.TRANSACTIONAL_CURR_CODE,
2568: p_prior_rec.TRANSACTIONAL_CURR_CODE) THEN
2569: null;
2570: ELSE

Line 2580: IF OE_Globals.Equal(

2576: END IF;
2577: END IF; /* PRIOR */
2578: /****************************/
2579: IF p_next_version IS NOT NULL THEN
2580: IF OE_Globals.Equal(
2581: p_curr_rec.TRANSACTIONAL_CURR_CODE,
2582: p_next_rec.TRANSACTIONAL_CURR_CODE) THEN
2583: IF prior_exists = 'Y' THEN
2584: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.TRANSACTIONAL_CURR_CODE;

Line 2605: IF OE_Globals.Equal(

2601: /* START shipping_instructions*/
2602:
2603: prior_exists := 'N';
2604: IF p_prior_version IS NOT NULL THEN
2605: IF OE_Globals.Equal(
2606: p_curr_rec.shipping_instructions,
2607: p_prior_rec.shipping_instructions) THEN
2608: null;
2609: ELSE

Line 2619: IF OE_Globals.Equal(

2615: END IF;
2616: END IF; /* PRIOR */
2617: /****************************/
2618: IF p_next_version IS NOT NULL THEN
2619: IF OE_Globals.Equal(
2620: p_curr_rec.shipping_instructions,
2621: p_next_rec.shipping_instructions) THEN
2622: IF prior_exists = 'Y' THEN
2623: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.shipping_instructions;

Line 2644: IF OE_Globals.Equal(

2640: /* START packing_instructions*/
2641:
2642: prior_exists := 'N';
2643: IF p_prior_version IS NOT NULL THEN
2644: IF OE_Globals.Equal(
2645: p_curr_rec.packing_instructions,
2646: p_prior_rec.packing_instructions) THEN
2647: null;
2648: ELSE

Line 2658: IF OE_Globals.Equal(

2654: END IF;
2655: END IF; /* PRIOR */
2656: /****************************/
2657: IF p_next_version IS NOT NULL THEN
2658: IF OE_Globals.Equal(
2659: p_curr_rec.packing_instructions,
2660: p_next_rec.packing_instructions) THEN
2661: IF prior_exists = 'Y' THEN
2662: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.packing_instructions;

Line 2683: IF OE_Globals.Equal(

2679: /* START flow_status_code*/
2680:
2681: prior_exists := 'N';
2682: IF p_prior_version IS NOT NULL THEN
2683: IF OE_Globals.Equal(
2684: p_curr_rec.flow_status_code,
2685: p_prior_rec.flow_status_code) THEN
2686: null;
2687: ELSE

Line 2699: IF OE_Globals.Equal(

2695: END IF;
2696: END IF; /* PRIOR */
2697: /****************************/
2698: IF p_next_version IS NOT NULL THEN
2699: IF OE_Globals.Equal(
2700: p_curr_rec.flow_status_code,
2701: p_next_rec.flow_status_code) THEN
2702: IF prior_exists = 'Y' THEN
2703: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.flow_status(p_curr_rec.flow_status_code);

Line 2727: IF OE_Globals.Equal(

2723: /* START sales_document_name*/
2724:
2725: prior_exists := 'N';
2726: IF p_prior_version IS NOT NULL THEN
2727: IF OE_Globals.Equal(
2728: p_curr_rec.sales_document_name,
2729: p_prior_rec.sales_document_name) THEN
2730: null;
2731: ELSE

Line 2741: IF OE_Globals.Equal(

2737: END IF;
2738: END IF; /* PRIOR */
2739: /****************************/
2740: IF p_next_version IS NOT NULL THEN
2741: IF OE_Globals.Equal(
2742: p_curr_rec.sales_document_name,
2743: p_next_rec.sales_document_name) THEN
2744: IF prior_exists = 'Y' THEN
2745: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.sales_document_name;

Line 2765: IF OE_Globals.Equal(

2761: /* START transaction_phase_code*/
2762:
2763: prior_exists := 'N';
2764: IF p_prior_version IS NOT NULL THEN
2765: IF OE_Globals.Equal(
2766: p_curr_rec.transaction_phase_code,
2767: p_prior_rec.transaction_phase_code) THEN
2768: null;
2769: ELSE

Line 2781: IF OE_Globals.Equal(

2777: END IF;
2778: END IF; /* PRIOR */
2779: /****************************/
2780: IF p_next_version IS NOT NULL THEN
2781: IF OE_Globals.Equal(
2782: p_curr_rec.transaction_phase_code,
2783: p_next_rec.transaction_phase_code) THEN
2784: IF prior_exists = 'Y' THEN
2785: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Transaction_Phase(p_curr_rec.transaction_phase_code);

Line 2808: IF OE_Globals.Equal(

2804: /* START user_status_code*/
2805:
2806: prior_exists := 'N';
2807: IF p_prior_version IS NOT NULL THEN
2808: IF OE_Globals.Equal(
2809: p_curr_rec.user_status_code,
2810: p_prior_rec.user_status_code) THEN
2811: null;
2812: ELSE

Line 2824: IF OE_Globals.Equal(

2820: END IF;
2821: END IF; /* PRIOR */
2822: /****************************/
2823: IF p_next_version IS NOT NULL THEN
2824: IF OE_Globals.Equal(
2825: p_curr_rec.user_status_code,
2826: p_next_rec.user_status_code) THEN
2827: IF prior_exists = 'Y' THEN
2828: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.User_Status(p_curr_rec.user_status_code);

Line 2854: IF OE_Globals.Equal(

2850: /* START sold_to_site_use_id*/
2851:
2852: prior_exists := 'N';
2853: IF p_prior_version IS NOT NULL THEN
2854: IF OE_Globals.Equal(
2855: p_curr_rec.sold_to_site_use_id,
2856: p_prior_rec.sold_to_site_use_id) THEN
2857: null;
2858: ELSE

Line 2925: IF OE_Globals.Equal(

2921: END IF; /* PRIOR */
2922: /****************************/
2923:
2924: IF p_next_version IS NOT NULL THEN
2925: IF OE_Globals.Equal(
2926: p_curr_rec.sold_to_site_use_id,
2927: p_next_rec.sold_to_site_use_id) THEN
2928: IF prior_exists = 'Y' THEN
2929: x_header_changed_attr_tbl(ind).next_value := x_current_sold_to_location;

Line 3034: IF OE_Globals.Equal(

3030: /* START SUPPLIER_SIGNATURE*/
3031:
3032: prior_exists := 'N';
3033: IF p_prior_version IS NOT NULL THEN
3034: IF OE_Globals.Equal(
3035: p_curr_rec.SUPPLIER_SIGNATURE,
3036: p_prior_rec.SUPPLIER_SIGNATURE) THEN
3037: null;
3038: ELSE

Line 3048: IF OE_Globals.Equal(

3044: END IF;
3045: END IF; /* PRIOR */
3046: /****************************/
3047: IF p_next_version IS NOT NULL THEN
3048: IF OE_Globals.Equal(
3049: p_curr_rec.SUPPLIER_SIGNATURE,
3050: p_next_rec.SUPPLIER_SIGNATURE) THEN
3051: IF prior_exists = 'Y' THEN
3052: x_header_changed_attr_tbl(ind).next_value := to_char(p_curr_rec.SUPPLIER_SIGNATURE,'DD-MON-YYYY HH24:MI:SS');

Line 3072: IF OE_Globals.Equal(

3068: /* START SUPPLIER_SIGNATURE_DATE*/
3069:
3070: prior_exists := 'N';
3071: IF p_prior_version IS NOT NULL THEN
3072: IF OE_Globals.Equal(
3073: p_curr_rec.SUPPLIER_SIGNATURE_DATE,
3074: p_prior_rec.SUPPLIER_SIGNATURE_DATE) THEN
3075: null;
3076: ELSE

Line 3086: IF OE_Globals.Equal(

3082: END IF;
3083: END IF; /* PRIOR */
3084: /****************************/
3085: IF p_next_version IS NOT NULL THEN
3086: IF OE_Globals.Equal(
3087: p_curr_rec.SUPPLIER_SIGNATURE_DATE,
3088: p_next_rec.SUPPLIER_SIGNATURE_DATE) THEN
3089: IF prior_exists = 'Y' THEN
3090: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.SUPPLIER_SIGNATURE_DATE;

Line 3110: IF OE_Globals.Equal(

3106: /* START CUSTOMER_SIGNATURE*/
3107:
3108: prior_exists := 'N';
3109: IF p_prior_version IS NOT NULL THEN
3110: IF OE_Globals.Equal(
3111: p_curr_rec.CUSTOMER_SIGNATURE,
3112: p_prior_rec.CUSTOMER_SIGNATURE) THEN
3113: null;
3114: ELSE

Line 3124: IF OE_Globals.Equal(

3120: END IF;
3121: END IF; /* PRIOR */
3122: /****************************/
3123: IF p_next_version IS NOT NULL THEN
3124: IF OE_Globals.Equal(
3125: p_curr_rec.CUSTOMER_SIGNATURE,
3126: p_next_rec.CUSTOMER_SIGNATURE) THEN
3127: IF prior_exists = 'Y' THEN
3128: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.CUSTOMER_SIGNATURE;

Line 3148: IF OE_Globals.Equal(

3144: /* START CUSTOMER_SIGNATURE_DATE*/
3145:
3146: prior_exists := 'N';
3147: IF p_prior_version IS NOT NULL THEN
3148: IF OE_Globals.Equal(
3149: p_curr_rec.CUSTOMER_SIGNATURE_DATE,
3150: p_prior_rec.CUSTOMER_SIGNATURE_DATE) THEN
3151: null;
3152: ELSE

Line 3162: IF OE_Globals.Equal(

3158: END IF;
3159: END IF; /* PRIOR */
3160: /****************************/
3161: IF p_next_version IS NOT NULL THEN
3162: IF OE_Globals.Equal(
3163: p_curr_rec.CUSTOMER_SIGNATURE_DATE,
3164: p_next_rec.CUSTOMER_SIGNATURE_DATE) THEN
3165: IF prior_exists = 'Y' THEN
3166: x_header_changed_attr_tbl(ind).next_value := to_char(p_curr_rec.CUSTOMER_SIGNATURE_DATE,'DD-MON-YYYY HH24:MI:SS');

Line 3187: IF OE_Globals.Equal(

3183: /* START START_DATE_ACTIVE*/
3184:
3185: prior_exists := 'N';
3186: IF p_prior_version IS NOT NULL THEN
3187: IF OE_Globals.Equal(
3188: p_curr_rec.START_DATE_ACTIVE,
3189: p_prior_rec.START_DATE_ACTIVE) THEN
3190: null;
3191: ELSE

Line 3201: IF OE_Globals.Equal(

3197: END IF;
3198: END IF; /* PRIOR */
3199: /****************************/
3200: IF p_next_version IS NOT NULL THEN
3201: IF OE_Globals.Equal(
3202: p_curr_rec.START_DATE_ACTIVE,
3203: p_next_rec.START_DATE_ACTIVE) THEN
3204: IF prior_exists = 'Y' THEN
3205: x_header_changed_attr_tbl(ind).next_value := to_char(p_curr_rec.START_DATE_ACTIVE,'DD-MON-YYYY HH24:MI:SS');

Line 3226: IF OE_Globals.Equal(

3222: /* START END_DATE_ACTIVE*/
3223:
3224: prior_exists := 'N';
3225: IF p_prior_version IS NOT NULL THEN
3226: IF OE_Globals.Equal(
3227: p_curr_rec.END_DATE_ACTIVE,
3228: p_prior_rec.END_DATE_ACTIVE) THEN
3229: null;
3230: ELSE

Line 3240: IF OE_Globals.Equal(

3236: END IF;
3237: END IF; /* PRIOR */
3238: /****************************/
3239: IF p_next_version IS NOT NULL THEN
3240: IF OE_Globals.Equal(
3241: p_curr_rec.END_DATE_ACTIVE,
3242: p_next_rec.END_DATE_ACTIVE) THEN
3243: IF prior_exists = 'Y' THEN
3244: x_header_changed_attr_tbl(ind).next_value := to_char(p_curr_rec.END_DATE_ACTIVE,'DD-MON-YYYY HH24:MI:SS');

Line 3265: IF OE_Globals.Equal(

3261: /* START on_hold_flag*/
3262:
3263: prior_exists := 'N';
3264: IF p_prior_version IS NOT NULL THEN
3265: IF OE_Globals.Equal(
3266: p_curr_rec.on_hold_flag,
3267: p_prior_rec.on_hold_flag) THEN
3268: null;
3269: ELSE

Line 3279: IF OE_Globals.Equal(

3275: END IF;
3276: END IF; /* PRIOR */
3277: /****************************/
3278: IF p_next_version IS NOT NULL THEN
3279: IF OE_Globals.Equal(
3280: p_curr_rec.on_hold_flag,
3281: p_next_rec.on_hold_flag) THEN
3282: IF prior_exists = 'Y' THEN
3283: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.on_hold_flag;

Line 3304: IF OE_Globals.Equal(

3300: /* START ENFORCE_PRICE_LIST_FLAG*/
3301:
3302: prior_exists := 'N';
3303: IF p_prior_version IS NOT NULL THEN
3304: IF OE_Globals.Equal(
3305: p_curr_rec.ENFORCE_PRICE_LIST_FLAG,
3306: p_prior_rec.ENFORCE_PRICE_LIST_FLAG) THEN
3307: null;
3308: ELSE

Line 3318: IF OE_Globals.Equal(

3314: END IF;
3315: END IF; /* PRIOR */
3316: /****************************/
3317: IF p_next_version IS NOT NULL THEN
3318: IF OE_Globals.Equal(
3319: p_curr_rec.ENFORCE_PRICE_LIST_FLAG,
3320: p_next_rec.ENFORCE_PRICE_LIST_FLAG) THEN
3321: IF prior_exists = 'Y' THEN
3322: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.ENFORCE_PRICE_LIST_FLAG;

Line 3343: IF OE_Globals.Equal(

3339: /* START enforce_ship_to_flag*/
3340:
3341: prior_exists := 'N';
3342: IF p_prior_version IS NOT NULL THEN
3343: IF OE_Globals.Equal(
3344: p_curr_rec.enforce_ship_to_flag,
3345: p_prior_rec.enforce_ship_to_flag) THEN
3346: null;
3347: ELSE

Line 3357: IF OE_Globals.Equal(

3353: END IF;
3354: END IF; /* PRIOR */
3355: /****************************/
3356: IF p_next_version IS NOT NULL THEN
3357: IF OE_Globals.Equal(
3358: p_curr_rec.enforce_ship_to_flag,
3359: p_next_rec.enforce_ship_to_flag) THEN
3360: IF prior_exists = 'Y' THEN
3361: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.enforce_ship_to_flag;

Line 3382: IF OE_Globals.Equal(

3378: /* START enforce_invoice_to_flag*/
3379:
3380: prior_exists := 'N';
3381: IF p_prior_version IS NOT NULL THEN
3382: IF OE_Globals.Equal(
3383: p_curr_rec.enforce_invoice_to_flag,
3384: p_prior_rec.enforce_invoice_to_flag) THEN
3385: null;
3386: ELSE

Line 3396: IF OE_Globals.Equal(

3392: END IF;
3393: END IF; /* PRIOR */
3394: /****************************/
3395: IF p_next_version IS NOT NULL THEN
3396: IF OE_Globals.Equal(
3397: p_curr_rec.enforce_invoice_to_flag,
3398: p_next_rec.enforce_invoice_to_flag) THEN
3399: IF prior_exists = 'Y' THEN
3400: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.enforce_invoice_to_flag;

Line 3421: IF OE_Globals.Equal(

3417: /* START enforce_freight_term_flag*/
3418:
3419: prior_exists := 'N';
3420: IF p_prior_version IS NOT NULL THEN
3421: IF OE_Globals.Equal(
3422: p_curr_rec.enforce_freight_term_flag,
3423: p_prior_rec.enforce_freight_term_flag) THEN
3424: null;
3425: ELSE

Line 3435: IF OE_Globals.Equal(

3431: END IF;
3432: END IF; /* PRIOR */
3433: /****************************/
3434: IF p_next_version IS NOT NULL THEN
3435: IF OE_Globals.Equal(
3436: p_curr_rec.enforce_freight_term_flag,
3437: p_next_rec.enforce_freight_term_flag) THEN
3438: IF prior_exists = 'Y' THEN
3439: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.enforce_freight_term_flag;

Line 3460: IF OE_Globals.Equal(

3456: /* START enforce_shipping_method_flag*/
3457:
3458: prior_exists := 'N';
3459: IF p_prior_version IS NOT NULL THEN
3460: IF OE_Globals.Equal(
3461: p_curr_rec.enforce_shipping_method_flag,
3462: p_prior_rec.enforce_shipping_method_flag) THEN
3463: null;
3464: ELSE

Line 3474: IF OE_Globals.Equal(

3470: END IF;
3471: END IF; /* PRIOR */
3472: /****************************/
3473: IF p_next_version IS NOT NULL THEN
3474: IF OE_Globals.Equal(
3475: p_curr_rec.enforce_shipping_method_flag,
3476: p_next_rec.enforce_shipping_method_flag) THEN
3477: IF prior_exists = 'Y' THEN
3478: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.enforce_shipping_method_flag;

Line 3499: IF OE_Globals.Equal(

3495: /* START enforce_payment_term_flag*/
3496:
3497: prior_exists := 'N';
3498: IF p_prior_version IS NOT NULL THEN
3499: IF OE_Globals.Equal(
3500: p_curr_rec.enforce_payment_term_flag,
3501: p_prior_rec.enforce_payment_term_flag) THEN
3502: null;
3503: ELSE

Line 3513: IF OE_Globals.Equal(

3509: END IF;
3510: END IF; /* PRIOR */
3511: /****************************/
3512: IF p_next_version IS NOT NULL THEN
3513: IF OE_Globals.Equal(
3514: p_curr_rec.enforce_payment_term_flag,
3515: p_next_rec.enforce_payment_term_flag) THEN
3516: IF prior_exists = 'Y' THEN
3517: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.enforce_payment_term_flag;

Line 3538: IF OE_Globals.Equal(

3534: /* START enforce_accounting_rule_flag*/
3535:
3536: prior_exists := 'N';
3537: IF p_prior_version IS NOT NULL THEN
3538: IF OE_Globals.Equal(
3539: p_curr_rec.enforce_accounting_rule_flag,
3540: p_prior_rec.enforce_accounting_rule_flag) THEN
3541: null;
3542: ELSE

Line 3552: IF OE_Globals.Equal(

3548: END IF;
3549: END IF; /* PRIOR */
3550: /****************************/
3551: IF p_next_version IS NOT NULL THEN
3552: IF OE_Globals.Equal(
3553: p_curr_rec.enforce_accounting_rule_flag,
3554: p_next_rec.enforce_accounting_rule_flag) THEN
3555: IF prior_exists = 'Y' THEN
3556: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.enforce_accounting_rule_flag;

Line 3577: IF OE_Globals.Equal(

3573: /* START enforce_invoicing_rule_flag*/
3574:
3575: prior_exists := 'N';
3576: IF p_prior_version IS NOT NULL THEN
3577: IF OE_Globals.Equal(
3578: p_curr_rec.enforce_invoicing_rule_flag,
3579: p_prior_rec.enforce_invoicing_rule_flag) THEN
3580: null;
3581: ELSE

Line 3591: IF OE_Globals.Equal(

3587: END IF;
3588: END IF; /* PRIOR */
3589: /****************************/
3590: IF p_next_version IS NOT NULL THEN
3591: IF OE_Globals.Equal(
3592: p_curr_rec.enforce_invoicing_rule_flag,
3593: p_next_rec.enforce_invoicing_rule_flag) THEN
3594: IF prior_exists = 'Y' THEN
3595: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.enforce_invoicing_rule_flag;

Line 3616: IF OE_Globals.Equal(

3612: /* START OVERRIDE_AMOUNT_FLAG*/
3613:
3614: prior_exists := 'N';
3615: IF p_prior_version IS NOT NULL THEN
3616: IF OE_Globals.Equal(
3617: p_curr_rec.OVERRIDE_AMOUNT_FLAG,
3618: p_prior_rec.OVERRIDE_AMOUNT_FLAG) THEN
3619: null;
3620: ELSE

Line 3630: IF OE_Globals.Equal(

3626: END IF;
3627: END IF; /* PRIOR */
3628: /****************************/
3629: IF p_next_version IS NOT NULL THEN
3630: IF OE_Globals.Equal(
3631: p_curr_rec.OVERRIDE_AMOUNT_FLAG,
3632: p_next_rec.OVERRIDE_AMOUNT_FLAG) THEN
3633: IF prior_exists = 'Y' THEN
3634: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.OVERRIDE_AMOUNT_FLAG;

Line 3655: IF OE_Globals.Equal(

3651: /* START BLANKET_MAX_AMOUNT*/
3652:
3653: prior_exists := 'N';
3654: IF p_prior_version IS NOT NULL THEN
3655: IF OE_Globals.Equal(
3656: p_curr_rec.BLANKET_MAX_AMOUNT,
3657: p_prior_rec.BLANKET_MAX_AMOUNT) THEN
3658: null;
3659: ELSE

Line 3669: IF OE_Globals.Equal(

3665: END IF;
3666: END IF; /* PRIOR */
3667: /****************************/
3668: IF p_next_version IS NOT NULL THEN
3669: IF OE_Globals.Equal(
3670: p_curr_rec.BLANKET_MAX_AMOUNT,
3671: p_next_rec.BLANKET_MAX_AMOUNT) THEN
3672: IF prior_exists = 'Y' THEN
3673: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.BLANKET_MAX_AMOUNT;

Line 3694: IF OE_Globals.Equal(

3690: /* START BLANKET_MIN_AMOUNT*/
3691:
3692: prior_exists := 'N';
3693: IF p_prior_version IS NOT NULL THEN
3694: IF OE_Globals.Equal(
3695: p_curr_rec.BLANKET_MIN_AMOUNT,
3696: p_prior_rec.BLANKET_MIN_AMOUNT) THEN
3697: null;
3698: ELSE

Line 3708: IF OE_Globals.Equal(

3704: END IF;
3705: END IF; /* PRIOR */
3706: /****************************/
3707: IF p_next_version IS NOT NULL THEN
3708: IF OE_Globals.Equal(
3709: p_curr_rec.BLANKET_MIN_AMOUNT,
3710: p_next_rec.BLANKET_MIN_AMOUNT) THEN
3711: IF prior_exists = 'Y' THEN
3712: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.BLANKET_MIN_AMOUNT;

Line 3733: IF OE_Globals.Equal(

3729: /* START RELEASED_AMOUNT*/
3730:
3731: prior_exists := 'N';
3732: IF p_prior_version IS NOT NULL THEN
3733: IF OE_Globals.Equal(
3734: p_curr_rec.RELEASED_AMOUNT,
3735: p_prior_rec.RELEASED_AMOUNT) THEN
3736: null;
3737: ELSE

Line 3747: IF OE_Globals.Equal(

3743: END IF;
3744: END IF; /* PRIOR */
3745: /****************************/
3746: IF p_next_version IS NOT NULL THEN
3747: IF OE_Globals.Equal(
3748: p_curr_rec.RELEASED_AMOUNT,
3749: p_next_rec.RELEASED_AMOUNT) THEN
3750: IF prior_exists = 'Y' THEN
3751: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.RELEASED_AMOUNT;

Line 3772: IF OE_Globals.Equal(

3768: /* START FULFILLED_AMOUNT*/
3769:
3770: prior_exists := 'N';
3771: IF p_prior_version IS NOT NULL THEN
3772: IF OE_Globals.Equal(
3773: p_curr_rec.FULFILLED_AMOUNT,
3774: p_prior_rec.FULFILLED_AMOUNT) THEN
3775: null;
3776: ELSE

Line 3786: IF OE_Globals.Equal(

3782: END IF;
3783: END IF; /* PRIOR */
3784: /****************************/
3785: IF p_next_version IS NOT NULL THEN
3786: IF OE_Globals.Equal(
3787: p_curr_rec.FULFILLED_AMOUNT,
3788: p_next_rec.FULFILLED_AMOUNT) THEN
3789: IF prior_exists = 'Y' THEN
3790: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.FULFILLED_AMOUNT;

Line 3811: IF OE_Globals.Equal(

3807: /* START RETURNED_AMOUNT*/
3808:
3809: prior_exists := 'N';
3810: IF p_prior_version IS NOT NULL THEN
3811: IF OE_Globals.Equal(
3812: p_curr_rec.RETURNED_AMOUNT,
3813: p_prior_rec.RETURNED_AMOUNT) THEN
3814: null;
3815: ELSE

Line 3825: IF OE_Globals.Equal(

3821: END IF;
3822: END IF; /* PRIOR */
3823: /****************************/
3824: IF p_next_version IS NOT NULL THEN
3825: IF OE_Globals.Equal(
3826: p_curr_rec.RETURNED_AMOUNT,
3827: p_next_rec.RETURNED_AMOUNT) THEN
3828: IF prior_exists = 'Y' THEN
3829: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.RETURNED_AMOUNT;

Line 3850: IF OE_Globals.Equal(

3846: /* START NEW_PRICE_LIST_ID*/
3847:
3848: prior_exists := 'N';
3849: IF p_prior_version IS NOT NULL THEN
3850: IF OE_Globals.Equal(
3851: p_curr_rec.NEW_PRICE_LIST_ID,
3852: p_prior_rec.NEW_PRICE_LIST_ID) THEN
3853: null;
3854: ELSE

Line 3866: IF OE_Globals.Equal(

3862: END IF;
3863: END IF; /* PRIOR */
3864: /****************************/
3865: IF p_next_version IS NOT NULL THEN
3866: IF OE_Globals.Equal(
3867: p_curr_rec.NEW_PRICE_LIST_ID,
3868: p_next_rec.NEW_PRICE_LIST_ID) THEN
3869: IF prior_exists = 'Y' THEN
3870: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.NEW_PRICE_LIST_ID);

Line 3894: IF OE_Globals.Equal(

3890: /* START NEW_MODIFIER_LIST_ID*/
3891:
3892: prior_exists := 'N';
3893: IF p_prior_version IS NOT NULL THEN
3894: IF OE_Globals.Equal(
3895: p_curr_rec.NEW_MODIFIER_LIST_ID,
3896: p_prior_rec.NEW_MODIFIER_LIST_ID) THEN
3897: null;
3898: ELSE

Line 3910: IF OE_Globals.Equal(

3906: END IF;
3907: END IF; /* PRIOR */
3908: /****************************/
3909: IF p_next_version IS NOT NULL THEN
3910: IF OE_Globals.Equal(
3911: p_curr_rec.NEW_MODIFIER_LIST_ID,
3912: p_next_rec.NEW_MODIFIER_LIST_ID) THEN
3913: IF prior_exists = 'Y' THEN
3914: x_header_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.NEW_MODIFIER_LIST(p_curr_rec.NEW_MODIFIER_LIST_ID);

Line 3938: IF OE_Globals.Equal(

3934: /* START default_discount_percent*/
3935:
3936: prior_exists := 'N';
3937: IF p_prior_version IS NOT NULL THEN
3938: IF OE_Globals.Equal(
3939: p_curr_rec.default_discount_percent,
3940: p_prior_rec.default_discount_percent) THEN
3941: null;
3942: ELSE

Line 3952: IF OE_Globals.Equal(

3948: END IF;
3949: END IF; /* PRIOR */
3950: /****************************/
3951: IF p_next_version IS NOT NULL THEN
3952: IF OE_Globals.Equal(
3953: p_curr_rec.default_discount_percent,
3954: p_next_rec.default_discount_percent) THEN
3955: IF prior_exists = 'Y' THEN
3956: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.default_discount_percent;

Line 3977: IF OE_Globals.Equal(

3973: /* START default_discount_amount*/
3974:
3975: prior_exists := 'N';
3976: IF p_prior_version IS NOT NULL THEN
3977: IF OE_Globals.Equal(
3978: p_curr_rec.default_discount_amount,
3979: p_prior_rec.default_discount_amount) THEN
3980: null;
3981: ELSE

Line 3991: IF OE_Globals.Equal(

3987: END IF;
3988: END IF; /* PRIOR */
3989: /****************************/
3990: IF p_next_version IS NOT NULL THEN
3991: IF OE_Globals.Equal(
3992: p_curr_rec.default_discount_amount,
3993: p_next_rec.default_discount_amount) THEN
3994: IF prior_exists = 'Y' THEN
3995: x_header_changed_attr_tbl(ind).next_value := p_curr_rec.default_discount_amount;

Line 4048: l_org_id := OE_GLOBALS.G_ORG_ID;

4044: oe_debug_pub.add('version' ||p_version);
4045: oe_debug_pub.add('phase_change_lfag' ||p_phase_change_flag);
4046: END IF;
4047:
4048: l_org_id := OE_GLOBALS.G_ORG_ID;
4049:
4050: IF l_org_id IS NULL THEN
4051: OE_GLOBALS.Set_Context;
4052: l_org_id := OE_GLOBALS.G_ORG_ID;

Line 4051: OE_GLOBALS.Set_Context;

4047:
4048: l_org_id := OE_GLOBALS.G_ORG_ID;
4049:
4050: IF l_org_id IS NULL THEN
4051: OE_GLOBALS.Set_Context;
4052: l_org_id := OE_GLOBALS.G_ORG_ID;
4053: END IF;
4054:
4055: SELECT ACCOUNTING_RULE_ID

Line 4052: l_org_id := OE_GLOBALS.G_ORG_ID;

4048: l_org_id := OE_GLOBALS.G_ORG_ID;
4049:
4050: IF l_org_id IS NULL THEN
4051: OE_GLOBALS.Set_Context;
4052: l_org_id := OE_GLOBALS.G_ORG_ID;
4053: END IF;
4054:
4055: SELECT ACCOUNTING_RULE_ID
4056: , AGREEMENT_ID

Line 4257: l_org_id := OE_GLOBALS.G_ORG_ID;

4253: oe_debug_pub.add('header' ||p_header_id);
4254: oe_debug_pub.add('version' ||p_version);
4255: END IF;
4256:
4257: l_org_id := OE_GLOBALS.G_ORG_ID;
4258:
4259: IF l_org_id IS NULL THEN
4260: OE_GLOBALS.Set_Context;
4261: l_org_id := OE_GLOBALS.G_ORG_ID;

Line 4260: OE_GLOBALS.Set_Context;

4256:
4257: l_org_id := OE_GLOBALS.G_ORG_ID;
4258:
4259: IF l_org_id IS NULL THEN
4260: OE_GLOBALS.Set_Context;
4261: l_org_id := OE_GLOBALS.G_ORG_ID;
4262: END IF;
4263:
4264: SELECT ACCOUNTING_RULE_ID

Line 4261: l_org_id := OE_GLOBALS.G_ORG_ID;

4257: l_org_id := OE_GLOBALS.G_ORG_ID;
4258:
4259: IF l_org_id IS NULL THEN
4260: OE_GLOBALS.Set_Context;
4261: l_org_id := OE_GLOBALS.G_ORG_ID;
4262: END IF;
4263:
4264: SELECT ACCOUNTING_RULE_ID
4265: , AGREEMENT_ID

Line 4719: IF OE_Globals.Equal(

4715: /****************************/
4716: /* START ACCOUNTING_RULE_ID*/
4717: prior_exists := 'N';
4718: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4719: IF OE_Globals.Equal(
4720: p_curr_rec.accounting_rule_id,
4721: p_prior_rec.accounting_rule_id) THEN
4722: null;
4723: ELSE

Line 4736: IF OE_Globals.Equal(

4732: END IF;
4733: END IF; /* PRIOR */
4734: /****************************/
4735: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4736: IF OE_Globals.Equal(
4737: p_curr_rec.accounting_rule_id,
4738: p_next_rec.accounting_rule_id) THEN
4739: IF prior_exists = 'Y' THEN
4740: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Accounting_Rule(p_curr_rec.accounting_rule_id);

Line 4765: IF OE_Globals.Equal(

4761: /* START agreement_id*/
4762:
4763: prior_exists := 'N';
4764: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4765: IF OE_Globals.Equal(
4766: p_curr_rec.agreement_id,
4767: p_prior_rec.agreement_id) THEN
4768: null;
4769: ELSE

Line 4782: IF OE_Globals.Equal(

4778: END IF;
4779: END IF; /* PRIOR */
4780: /****************************/
4781: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4782: IF OE_Globals.Equal(
4783: p_curr_rec.agreement_id,
4784: p_next_rec.agreement_id) THEN
4785: IF prior_exists = 'Y' THEN
4786: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Agreement(p_curr_rec.agreement_id);

Line 4811: IF OE_Globals.Equal(

4807: /* START attribute1*/
4808:
4809: prior_exists := 'N';
4810: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4811: IF OE_Globals.Equal(
4812: p_curr_rec.attribute1,
4813: p_prior_rec.attribute1) THEN
4814: null;
4815: ELSE

Line 4826: IF OE_Globals.Equal(

4822: END IF;
4823: END IF; /* PRIOR */
4824: /****************************/
4825: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4826: IF OE_Globals.Equal(
4827: p_curr_rec.attribute1,
4828: p_next_rec.attribute1) THEN
4829: IF prior_exists = 'Y' THEN
4830: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.attribute1;

Line 4852: IF OE_Globals.Equal(

4848: /* START attribute2*/
4849:
4850: prior_exists := 'N';
4851: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4852: IF OE_Globals.Equal(
4853: p_curr_rec.attribute2,
4854: p_prior_rec.attribute2) THEN
4855: null;
4856: ELSE

Line 4867: IF OE_Globals.Equal(

4863: END IF;
4864: END IF; /* PRIOR */
4865: /****************************/
4866: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4867: IF OE_Globals.Equal(
4868: p_curr_rec.attribute2,
4869: p_next_rec.attribute2) THEN
4870: IF prior_exists = 'Y' THEN
4871: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.attribute2;

Line 4892: IF OE_Globals.Equal(

4888: /* START attribute3*/
4889:
4890: prior_exists := 'N';
4891: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4892: IF OE_Globals.Equal(
4893: p_curr_rec.attribute3,
4894: p_prior_rec.attribute3) THEN
4895: null;
4896: ELSE

Line 4907: IF OE_Globals.Equal(

4903: END IF;
4904: END IF; /* PRIOR */
4905: /****************************/
4906: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4907: IF OE_Globals.Equal(
4908: p_curr_rec.attribute3,
4909: p_next_rec.attribute3) THEN
4910: IF prior_exists = 'Y' THEN
4911: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.attribute3;

Line 4933: IF OE_Globals.Equal(

4929: /* START attribute4*/
4930:
4931: prior_exists := 'N';
4932: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4933: IF OE_Globals.Equal(
4934: p_curr_rec.attribute4,
4935: p_prior_rec.attribute4) THEN
4936: null;
4937: ELSE

Line 4948: IF OE_Globals.Equal(

4944: END IF;
4945: END IF; /* PRIOR */
4946: /****************************/
4947: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4948: IF OE_Globals.Equal(
4949: p_curr_rec.attribute4,
4950: p_next_rec.attribute4) THEN
4951: IF prior_exists = 'Y' THEN
4952: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.attribute4;

Line 4973: IF OE_Globals.Equal(

4969: /* START attribute5*/
4970:
4971: prior_exists := 'N';
4972: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4973: IF OE_Globals.Equal(
4974: p_curr_rec.attribute5,
4975: p_prior_rec.attribute5) THEN
4976: null;
4977: ELSE

Line 4988: IF OE_Globals.Equal(

4984: END IF;
4985: END IF; /* PRIOR */
4986: /****************************/
4987: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4988: IF OE_Globals.Equal(
4989: p_curr_rec.attribute5,
4990: p_next_rec.attribute5) THEN
4991: IF prior_exists = 'Y' THEN
4992: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.attribute5;

Line 5014: IF OE_Globals.Equal(

5010: /* START attribute6*/
5011:
5012: prior_exists := 'N';
5013: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5014: IF OE_Globals.Equal(
5015: p_curr_rec.attribute6,
5016: p_prior_rec.attribute6) THEN
5017: null;
5018: ELSE

Line 5029: IF OE_Globals.Equal(

5025: END IF;
5026: END IF; /* PRIOR */
5027: /****************************/
5028: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5029: IF OE_Globals.Equal(
5030: p_curr_rec.attribute6,
5031: p_next_rec.attribute6) THEN
5032: IF prior_exists = 'Y' THEN
5033: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.attribute6;

Line 5054: IF OE_Globals.Equal(

5050: /* START attribute7*/
5051:
5052: prior_exists := 'N';
5053: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5054: IF OE_Globals.Equal(
5055: p_curr_rec.attribute7,
5056: p_prior_rec.attribute7) THEN
5057: null;
5058: ELSE

Line 5069: IF OE_Globals.Equal(

5065: END IF;
5066: END IF; /* PRIOR */
5067: /****************************/
5068: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5069: IF OE_Globals.Equal(
5070: p_curr_rec.attribute7,
5071: p_next_rec.attribute7) THEN
5072: IF prior_exists = 'Y' THEN
5073: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.attribute7;

Line 5095: IF OE_Globals.Equal(

5091: /* START attribute8*/
5092:
5093: prior_exists := 'N';
5094: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5095: IF OE_Globals.Equal(
5096: p_curr_rec.attribute8,
5097: p_prior_rec.attribute8) THEN
5098: null;
5099: ELSE

Line 5110: IF OE_Globals.Equal(

5106: END IF;
5107: END IF; /* PRIOR */
5108: /****************************/
5109: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5110: IF OE_Globals.Equal(
5111: p_curr_rec.attribute8,
5112: p_next_rec.attribute8) THEN
5113: IF prior_exists = 'Y' THEN
5114: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.attribute8;

Line 5136: IF OE_Globals.Equal(

5132: /* START attribute9*/
5133:
5134: prior_exists := 'N';
5135: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5136: IF OE_Globals.Equal(
5137: p_curr_rec.attribute9,
5138: p_prior_rec.attribute9) THEN
5139: null;
5140: ELSE

Line 5151: IF OE_Globals.Equal(

5147: END IF;
5148: END IF; /* PRIOR */
5149: /****************************/
5150: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5151: IF OE_Globals.Equal(
5152: p_curr_rec.attribute9,
5153: p_next_rec.attribute9) THEN
5154: IF prior_exists = 'Y' THEN
5155: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.attribute9;

Line 5177: IF OE_Globals.Equal(

5173: /* START attribute10*/
5174:
5175: prior_exists := 'N';
5176: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5177: IF OE_Globals.Equal(
5178: p_curr_rec.attribute10,
5179: p_prior_rec.attribute10) THEN
5180: null;
5181: ELSE

Line 5192: IF OE_Globals.Equal(

5188: END IF;
5189: END IF; /* PRIOR */
5190: /****************************/
5191: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5192: IF OE_Globals.Equal(
5193: p_curr_rec.attribute10,
5194: p_next_rec.attribute10) THEN
5195: IF prior_exists = 'Y' THEN
5196: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.attribute10;

Line 5217: IF OE_Globals.Equal(

5213: /* START attribute11*/
5214:
5215: prior_exists := 'N';
5216: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5217: IF OE_Globals.Equal(
5218: p_curr_rec.attribute11,
5219: p_prior_rec.attribute11) THEN
5220: null;
5221: ELSE

Line 5232: IF OE_Globals.Equal(

5228: END IF;
5229: END IF; /* PRIOR */
5230: /****************************/
5231: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5232: IF OE_Globals.Equal(
5233: p_curr_rec.attribute11,
5234: p_next_rec.attribute11) THEN
5235: IF prior_exists = 'Y' THEN
5236: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.attribute11;

Line 5258: IF OE_Globals.Equal(

5254: /* START attribute12*/
5255:
5256: prior_exists := 'N';
5257: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5258: IF OE_Globals.Equal(
5259: p_curr_rec.attribute12,
5260: p_prior_rec.attribute12) THEN
5261: null;
5262: ELSE

Line 5273: IF OE_Globals.Equal(

5269: END IF;
5270: END IF; /* PRIOR */
5271: /****************************/
5272: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5273: IF OE_Globals.Equal(
5274: p_curr_rec.attribute12,
5275: p_next_rec.attribute12) THEN
5276: IF prior_exists = 'Y' THEN
5277: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.attribute12;

Line 5299: IF OE_Globals.Equal(

5295: /* START attribute13*/
5296:
5297: prior_exists := 'N';
5298: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5299: IF OE_Globals.Equal(
5300: p_curr_rec.attribute13,
5301: p_prior_rec.attribute13) THEN
5302: null;
5303: ELSE

Line 5314: IF OE_Globals.Equal(

5310: END IF;
5311: END IF; /* PRIOR */
5312: /****************************/
5313: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5314: IF OE_Globals.Equal(
5315: p_curr_rec.attribute13,
5316: p_next_rec.attribute13) THEN
5317: IF prior_exists = 'Y' THEN
5318: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.attribute13;

Line 5340: IF OE_Globals.Equal(

5336: /* START attribute14*/
5337:
5338: prior_exists := 'N';
5339: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5340: IF OE_Globals.Equal(
5341: p_curr_rec.attribute14,
5342: p_prior_rec.attribute14) THEN
5343: null;
5344: ELSE

Line 5355: IF OE_Globals.Equal(

5351: END IF;
5352: END IF; /* PRIOR */
5353: /****************************/
5354: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5355: IF OE_Globals.Equal(
5356: p_curr_rec.attribute14,
5357: p_next_rec.attribute14) THEN
5358: IF prior_exists = 'Y' THEN
5359: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.attribute14;

Line 5381: IF OE_Globals.Equal(

5377: /* START attribute15*/
5378:
5379: prior_exists := 'N';
5380: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5381: IF OE_Globals.Equal(
5382: p_curr_rec.attribute15,
5383: p_prior_rec.attribute15) THEN
5384: null;
5385: ELSE

Line 5396: IF OE_Globals.Equal(

5392: END IF;
5393: END IF; /* PRIOR */
5394: /****************************/
5395: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5396: IF OE_Globals.Equal(
5397: p_curr_rec.attribute15,
5398: p_next_rec.attribute15) THEN
5399: IF prior_exists = 'Y' THEN
5400: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.attribute15;

Line 5421: IF OE_Globals.Equal(

5417: /* START context*/
5418:
5419: prior_exists := 'N';
5420: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5421: IF OE_Globals.Equal(
5422: p_curr_rec.context,
5423: p_prior_rec.context) THEN
5424: null;
5425: ELSE

Line 5436: IF OE_Globals.Equal(

5432: END IF;
5433: END IF; /* PRIOR */
5434: /****************************/
5435: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5436: IF OE_Globals.Equal(
5437: p_curr_rec.context,
5438: p_next_rec.context) THEN
5439: IF prior_exists = 'Y' THEN
5440: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.context;

Line 5461: IF OE_Globals.Equal(

5457: /* START cust_po_number*/
5458:
5459: prior_exists := 'N';
5460: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5461: IF OE_Globals.Equal(
5462: p_curr_rec.cust_po_number,
5463: p_prior_rec.cust_po_number) THEN
5464: null;
5465: ELSE

Line 5477: IF OE_Globals.Equal(

5473: END IF; /* PRIOR */
5474: /****************************/
5475:
5476: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5477: IF OE_Globals.Equal(
5478: p_curr_rec.cust_po_number,
5479: p_next_rec.cust_po_number) THEN
5480: IF prior_exists = 'Y' THEN
5481: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.cust_po_number;

Line 5503: IF OE_Globals.Equal(

5499: /* START deliver_to_org_id*/
5500:
5501: prior_exists := 'N';
5502: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5503: IF OE_Globals.Equal(
5504: p_curr_rec.deliver_to_org_id,
5505: p_prior_rec.deliver_to_org_id) THEN
5506: null;
5507: ELSE

Line 5577: IF OE_Globals.Equal(

5573: END IF; /* PRIOR */
5574: /****************************/
5575:
5576: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5577: IF OE_Globals.Equal(
5578: p_curr_rec.deliver_to_org_id,
5579: p_next_rec.deliver_to_org_id) THEN
5580: IF prior_exists = 'Y' THEN
5581: x_line_changed_attr_tbl(ind).next_value := x_current_deliver_to_address;

Line 5691: IF OE_Globals.Equal(

5687: /* START freight_terms_code*/
5688:
5689: prior_exists := 'N';
5690: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5691: IF OE_Globals.Equal(
5692: p_curr_rec.freight_terms_code,
5693: p_prior_rec.freight_terms_code) THEN
5694: null;
5695: ELSE

Line 5708: IF OE_Globals.Equal(

5704: END IF;
5705: END IF; /* PRIOR */
5706: /****************************/
5707: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5708: IF OE_Globals.Equal(
5709: p_curr_rec.freight_terms_code,
5710: p_next_rec.freight_terms_code) THEN
5711: IF prior_exists = 'Y' THEN
5712: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Freight_terms(p_curr_rec.freight_terms_code);

Line 5737: IF OE_Globals.Equal(

5733: /* START min_release_quantity*/
5734:
5735: prior_exists := 'N';
5736: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5737: IF OE_Globals.Equal(
5738: p_curr_rec.min_release_quantity,
5739: p_prior_rec.min_release_quantity) THEN
5740: null;
5741: ELSE

Line 5752: IF OE_Globals.Equal(

5748: END IF;
5749: END IF; /* PRIOR */
5750: /****************************/
5751: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5752: IF OE_Globals.Equal(
5753: p_curr_rec.min_release_quantity,
5754: p_next_rec.min_release_quantity) THEN
5755: IF prior_exists = 'Y' THEN
5756: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.min_release_quantity;

Line 5778: IF OE_Globals.Equal(

5774: /* START max_release_quantity*/
5775:
5776: prior_exists := 'N';
5777: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5778: IF OE_Globals.Equal(
5779: p_curr_rec.max_release_quantity,
5780: p_prior_rec.max_release_quantity) THEN
5781: null;
5782: ELSE

Line 5793: IF OE_Globals.Equal(

5789: END IF;
5790: END IF; /* PRIOR */
5791: /****************************/
5792: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5793: IF OE_Globals.Equal(
5794: p_curr_rec.max_release_quantity,
5795: p_next_rec.max_release_quantity) THEN
5796: IF prior_exists = 'Y' THEN
5797: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.max_release_quantity;

Line 5819: IF OE_Globals.Equal(

5815: /* START invoice_to_org_id*/
5816:
5817: prior_exists := 'N';
5818: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5819: IF OE_Globals.Equal(
5820: p_curr_rec.invoice_to_org_id,
5821: p_prior_rec.invoice_to_org_id) THEN
5822: null;
5823: ELSE

Line 5894: IF OE_Globals.Equal(

5890: END IF; /* PRIOR */
5891: /****************************/
5892:
5893: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5894: IF OE_Globals.Equal(
5895: p_curr_rec.invoice_to_org_id,
5896: p_next_rec.invoice_to_org_id) THEN
5897: IF prior_exists = 'Y' THEN
5898: x_line_changed_attr_tbl(ind).next_value := x_current_invoice_to_address;

Line 6007: IF OE_Globals.Equal(

6003: /* START invoicing_rule_id*/
6004:
6005: prior_exists := 'N';
6006: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
6007: IF OE_Globals.Equal(
6008: p_curr_rec.invoicing_rule_id,
6009: p_prior_rec.invoicing_rule_id) THEN
6010: null;
6011: ELSE

Line 6024: IF OE_Globals.Equal(

6020: END IF;
6021: END IF; /* PRIOR */
6022: /****************************/
6023: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
6024: IF OE_Globals.Equal(
6025: p_curr_rec.invoicing_rule_id,
6026: p_next_rec.invoicing_rule_id) THEN
6027: IF prior_exists = 'Y' THEN
6028: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.Invoicing_Rule(p_curr_rec.invoicing_rule_id);

Line 6053: IF OE_Globals.Equal(

6049: /****************************/
6050: /* START ORDERED_ITEM*/
6051: prior_exists := 'N';
6052: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
6053: IF OE_Globals.Equal(
6054: p_curr_rec.ORDERED_ITEM,
6055: p_prior_rec.ORDERED_ITEM) THEN
6056: null;
6057: ELSE

Line 6068: IF OE_Globals.Equal(

6064: END IF;
6065: END IF; /* PRIOR */
6066: /****************************/
6067: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
6068: IF OE_Globals.Equal(
6069: p_curr_rec.ORDERED_ITEM,
6070: p_next_rec.ORDERED_ITEM) THEN
6071: IF prior_exists = 'Y' THEN
6072: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.ORDERED_ITEM;

Line 6094: IF OE_Globals.Equal(

6090: /* START ORDER_QUANTITY_UOM*/
6091:
6092: prior_exists := 'N';
6093: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
6094: IF OE_Globals.Equal(
6095: p_curr_rec.ORDER_QUANTITY_UOM,
6096: p_prior_rec.ORDER_QUANTITY_UOM) THEN
6097: null;
6098: ELSE

Line 6109: IF OE_Globals.Equal(

6105: END IF;
6106: END IF; /* PRIOR */
6107: /****************************/
6108: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
6109: IF OE_Globals.Equal(
6110: p_curr_rec.ORDER_QUANTITY_UOM,
6111: p_next_rec.ORDER_QUANTITY_UOM) THEN
6112: IF prior_exists = 'Y' THEN
6113: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.ORDER_QUANTITY_UOM;

Line 6134: IF OE_Globals.Equal(

6130: /* START PRICE_LIST_ID*/
6131:
6132: prior_exists := 'N';
6133: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
6134: IF OE_Globals.Equal(
6135: p_curr_rec.PRICE_LIST_ID,
6136: p_prior_rec.PRICE_LIST_ID) THEN
6137: null;
6138: ELSE

Line 6152: IF OE_Globals.Equal(

6148: END IF; /* PRIOR */
6149: /****************************/
6150:
6151: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
6152: IF OE_Globals.Equal(
6153: p_curr_rec.PRICE_LIST_ID,
6154: p_next_rec.PRICE_LIST_ID) THEN
6155: IF prior_exists = 'Y' THEN
6156: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.PRICE_LIST(p_curr_rec.PRICE_LIST_ID);

Line 6181: IF OE_Globals.Equal(

6177: /* START SALESREP_ID*/
6178:
6179: prior_exists := 'N';
6180: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
6181: IF OE_Globals.Equal(
6182: p_curr_rec.SALESREP_ID,
6183: p_prior_rec.SALESREP_ID) THEN
6184: null;
6185: ELSE

Line 6198: IF OE_Globals.Equal(

6194: END IF;
6195: END IF; /* PRIOR */
6196: /****************************/
6197: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
6198: IF OE_Globals.Equal(
6199: p_curr_rec.SALESREP_ID,
6200: p_next_rec.SALESREP_ID) THEN
6201: IF prior_exists = 'Y' THEN
6202: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.SALESREP(p_curr_rec.SALESREP_ID);

Line 6226: IF OE_Globals.Equal(

6222: /* START SHIPPING_METHOD_CODE*/
6223:
6224: prior_exists := 'N';
6225: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
6226: IF OE_Globals.Equal(
6227: p_curr_rec.SHIPPING_METHOD_CODE,
6228: p_prior_rec.SHIPPING_METHOD_CODE) THEN
6229: null;
6230: ELSE

Line 6243: IF OE_Globals.Equal(

6239: END IF;
6240: END IF; /* PRIOR */
6241: /****************************/
6242: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
6243: IF OE_Globals.Equal(
6244: p_curr_rec.SHIPPING_METHOD_CODE,
6245: p_next_rec.SHIPPING_METHOD_CODE) THEN
6246: IF prior_exists = 'Y' THEN
6247: x_line_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.ship_method(p_curr_rec.SHIPPING_METHOD_CODE);

Line 6272: IF OE_Globals.Equal(

6268: /* START ship_from_org_id*/
6269:
6270: prior_exists := 'N';
6271: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
6272: IF OE_Globals.Equal(
6273: p_curr_rec.ship_from_org_id,
6274: p_prior_rec.ship_from_org_id) THEN
6275: null;
6276: ELSE

Line 6331: IF OE_Globals.Equal(

6327: END IF; /* PRIOR */
6328: /****************************/
6329:
6330: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
6331: IF OE_Globals.Equal(
6332: p_curr_rec.ship_from_org_id,
6333: p_next_rec.ship_from_org_id) THEN
6334: IF prior_exists = 'Y' THEN
6335: x_line_changed_attr_tbl(ind).next_value := x_current_ship_from_org;

Line 6423: IF OE_Globals.Equal(

6419: /* START ship_to_org_id*/
6420:
6421: prior_exists := 'N';
6422: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
6423: IF OE_Globals.Equal(
6424: p_curr_rec.ship_to_org_id,
6425: p_prior_rec.ship_to_org_id) THEN
6426: null;
6427: ELSE

Line 6497: IF OE_Globals.Equal(

6493: END IF; /* PRIOR */
6494: /****************************/
6495:
6496: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
6497: IF OE_Globals.Equal(
6498: p_curr_rec.ship_to_org_id,
6499: p_next_rec.ship_to_org_id) THEN
6500: IF prior_exists = 'Y' THEN
6501: x_line_changed_attr_tbl(ind).next_value := x_current_ship_to_address;

Line 6610: IF OE_Globals.Equal(

6606: /* START shipping_instructions*/
6607:
6608: prior_exists := 'N';
6609: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
6610: IF OE_Globals.Equal(
6611: p_curr_rec.shipping_instructions,
6612: p_prior_rec.shipping_instructions) THEN
6613: null;
6614: ELSE

Line 6625: IF OE_Globals.Equal(

6621: END IF;
6622: END IF; /* PRIOR */
6623: /****************************/
6624: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
6625: IF OE_Globals.Equal(
6626: p_curr_rec.shipping_instructions,
6627: p_next_rec.shipping_instructions) THEN
6628: IF prior_exists = 'Y' THEN
6629: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.shipping_instructions;

Line 6651: IF OE_Globals.Equal(

6647: /* START packing_instructions*/
6648:
6649: prior_exists := 'N';
6650: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
6651: IF OE_Globals.Equal(
6652: p_curr_rec.packing_instructions,
6653: p_prior_rec.packing_instructions) THEN
6654: null;
6655: ELSE

Line 6666: IF OE_Globals.Equal(

6662: END IF;
6663: END IF; /* PRIOR */
6664: /****************************/
6665: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
6666: IF OE_Globals.Equal(
6667: p_curr_rec.packing_instructions,
6668: p_next_rec.packing_instructions) THEN
6669: IF prior_exists = 'Y' THEN
6670: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.packing_instructions;

Line 6692: IF OE_Globals.Equal(

6688: /* START MAX_RELEASE_AMOUNT*/
6689:
6690: prior_exists := 'N';
6691: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
6692: IF OE_Globals.Equal(
6693: p_curr_rec.MAX_RELEASE_AMOUNT,
6694: p_prior_rec.MAX_RELEASE_AMOUNT) THEN
6695: null;
6696: ELSE

Line 6707: IF OE_Globals.Equal(

6703: END IF;
6704: END IF; /* PRIOR */
6705: /****************************/
6706: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
6707: IF OE_Globals.Equal(
6708: p_curr_rec.MAX_RELEASE_AMOUNT,
6709: p_next_rec.MAX_RELEASE_AMOUNT) THEN
6710: IF prior_exists = 'Y' THEN
6711: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.MAX_RELEASE_AMOUNT;

Line 6733: IF OE_Globals.Equal(

6729: /* START MIN_RELEASE_AMOUNT*/
6730:
6731: prior_exists := 'N';
6732: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
6733: IF OE_Globals.Equal(
6734: p_curr_rec.MIN_RELEASE_AMOUNT,
6735: p_prior_rec.MIN_RELEASE_AMOUNT) THEN
6736: null;
6737: ELSE

Line 6748: IF OE_Globals.Equal(

6744: END IF;
6745: END IF; /* PRIOR */
6746: /****************************/
6747: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
6748: IF OE_Globals.Equal(
6749: p_curr_rec.MIN_RELEASE_AMOUNT,
6750: p_next_rec.MIN_RELEASE_AMOUNT) THEN
6751: IF prior_exists = 'Y' THEN
6752: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.MIN_RELEASE_AMOUNT;

Line 6773: IF OE_Globals.Equal(

6769: /* START START_DATE_ACTIVE*/
6770:
6771: prior_exists := 'N';
6772: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
6773: IF OE_Globals.Equal(
6774: p_curr_rec.START_DATE_ACTIVE,
6775: p_prior_rec.START_DATE_ACTIVE) THEN
6776: null;
6777: ELSE

Line 6788: IF OE_Globals.Equal(

6784: END IF;
6785: END IF; /* PRIOR */
6786: /****************************/
6787: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
6788: IF OE_Globals.Equal(
6789: p_curr_rec.START_DATE_ACTIVE,
6790: p_next_rec.START_DATE_ACTIVE) THEN
6791: IF prior_exists = 'Y' THEN
6792: x_line_changed_attr_tbl(ind).next_value := to_char(p_curr_rec.START_DATE_ACTIVE,'DD-MON-YYYY HH24:MI:SS');

Line 6814: IF OE_Globals.Equal(

6810: /* START END_DATE_ACTIVE*/
6811:
6812: prior_exists := 'N';
6813: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
6814: IF OE_Globals.Equal(
6815: p_curr_rec.END_DATE_ACTIVE,
6816: p_prior_rec.END_DATE_ACTIVE) THEN
6817: null;
6818: ELSE

Line 6829: IF OE_Globals.Equal(

6825: END IF;
6826: END IF; /* PRIOR */
6827: /****************************/
6828: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
6829: IF OE_Globals.Equal(
6830: p_curr_rec.END_DATE_ACTIVE,
6831: p_next_rec.END_DATE_ACTIVE) THEN
6832: IF prior_exists = 'Y' THEN
6833: x_line_changed_attr_tbl(ind).next_value := to_char(p_curr_rec.END_DATE_ACTIVE,'DD-MON-YYYY HH24:MI:SS');

Line 6855: IF OE_Globals.Equal(

6851: /* START BLANKET_MAX_QUANTITY*/
6852:
6853: prior_exists := 'N';
6854: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
6855: IF OE_Globals.Equal(
6856: p_curr_rec.BLANKET_MAX_QUANTITY,
6857: p_prior_rec.BLANKET_MAX_QUANTITY) THEN
6858: null;
6859: ELSE

Line 6870: IF OE_Globals.Equal(

6866: END IF;
6867: END IF; /* PRIOR */
6868: /****************************/
6869: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
6870: IF OE_Globals.Equal(
6871: p_curr_rec.BLANKET_MAX_QUANTITY,
6872: p_next_rec.BLANKET_MAX_QUANTITY) THEN
6873: IF prior_exists = 'Y' THEN
6874: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.BLANKET_MAX_QUANTITY;

Line 6895: IF OE_Globals.Equal(

6891: /* START BLANKET_MIN_QUANTITY*/
6892:
6893: prior_exists := 'N';
6894: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
6895: IF OE_Globals.Equal(
6896: p_curr_rec.BLANKET_MIN_QUANTITY,
6897: p_prior_rec.BLANKET_MIN_QUANTITY) THEN
6898: null;
6899: ELSE

Line 6910: IF OE_Globals.Equal(

6906: END IF;
6907: END IF; /* PRIOR */
6908: /****************************/
6909: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
6910: IF OE_Globals.Equal(
6911: p_curr_rec.BLANKET_MIN_QUANTITY,
6912: p_next_rec.BLANKET_MIN_QUANTITY) THEN
6913: IF prior_exists = 'Y' THEN
6914: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.BLANKET_MIN_QUANTITY;

Line 6936: IF OE_Globals.Equal(

6932: /* START OVERRIDE_BLANKET_CONTROLS_FLAG*/
6933:
6934: prior_exists := 'N';
6935: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
6936: IF OE_Globals.Equal(
6937: p_curr_rec.OVERRIDE_BLANKET_CONTROLS_FLAG,
6938: p_prior_rec.OVERRIDE_BLANKET_CONTROLS_FLAG) THEN
6939: null;
6940: ELSE

Line 6951: IF OE_Globals.Equal(

6947: END IF;
6948: END IF; /* PRIOR */
6949: /****************************/
6950: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
6951: IF OE_Globals.Equal(
6952: p_curr_rec.OVERRIDE_BLANKET_CONTROLS_FLAG,
6953: p_next_rec.OVERRIDE_BLANKET_CONTROLS_FLAG) THEN
6954: IF prior_exists = 'Y' THEN
6955: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.OVERRIDE_BLANKET_CONTROLS_FLAG;

Line 6977: IF OE_Globals.Equal(

6973: /* START OVERRIDE_RELEASE_CONTROLS_FLAG*/
6974:
6975: prior_exists := 'N';
6976: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
6977: IF OE_Globals.Equal(
6978: p_curr_rec.OVERRIDE_RELEASE_CONTROLS_FLAG,
6979: p_prior_rec.OVERRIDE_RELEASE_CONTROLS_FLAG) THEN
6980: null;
6981: ELSE

Line 6992: IF OE_Globals.Equal(

6988: END IF;
6989: END IF; /* PRIOR */
6990: /****************************/
6991: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
6992: IF OE_Globals.Equal(
6993: p_curr_rec.OVERRIDE_RELEASE_CONTROLS_FLAG,
6994: p_next_rec.OVERRIDE_RELEASE_CONTROLS_FLAG) THEN
6995: IF prior_exists = 'Y' THEN
6996: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.OVERRIDE_RELEASE_CONTROLS_FLAG;

Line 7017: IF OE_Globals.Equal(

7013: /* START ENFORCE_PRICE_LIST_FLAG*/
7014:
7015: prior_exists := 'N';
7016: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
7017: IF OE_Globals.Equal(
7018: p_curr_rec.ENFORCE_PRICE_LIST_FLAG,
7019: p_prior_rec.ENFORCE_PRICE_LIST_FLAG) THEN
7020: null;
7021: ELSE

Line 7032: IF OE_Globals.Equal(

7028: END IF;
7029: END IF; /* PRIOR */
7030: /****************************/
7031: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
7032: IF OE_Globals.Equal(
7033: p_curr_rec.ENFORCE_PRICE_LIST_FLAG,
7034: p_next_rec.ENFORCE_PRICE_LIST_FLAG) THEN
7035: IF prior_exists = 'Y' THEN
7036: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.ENFORCE_PRICE_LIST_FLAG;

Line 7058: IF OE_Globals.Equal(

7054: /* START enforce_ship_to_flag*/
7055:
7056: prior_exists := 'N';
7057: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
7058: IF OE_Globals.Equal(
7059: p_curr_rec.enforce_ship_to_flag,
7060: p_prior_rec.enforce_ship_to_flag) THEN
7061: null;
7062: ELSE

Line 7073: IF OE_Globals.Equal(

7069: END IF;
7070: END IF; /* PRIOR */
7071: /****************************/
7072: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
7073: IF OE_Globals.Equal(
7074: p_curr_rec.enforce_ship_to_flag,
7075: p_next_rec.enforce_ship_to_flag) THEN
7076: IF prior_exists = 'Y' THEN
7077: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.enforce_ship_to_flag;

Line 7099: IF OE_Globals.Equal(

7095: /* START enforce_invoice_to_flag*/
7096:
7097: prior_exists := 'N';
7098: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
7099: IF OE_Globals.Equal(
7100: p_curr_rec.enforce_invoice_to_flag,
7101: p_prior_rec.enforce_invoice_to_flag) THEN
7102: null;
7103: ELSE

Line 7114: IF OE_Globals.Equal(

7110: END IF;
7111: END IF; /* PRIOR */
7112: /****************************/
7113: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
7114: IF OE_Globals.Equal(
7115: p_curr_rec.enforce_invoice_to_flag,
7116: p_next_rec.enforce_invoice_to_flag) THEN
7117: IF prior_exists = 'Y' THEN
7118: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.enforce_invoice_to_flag;

Line 7140: IF OE_Globals.Equal(

7136: /* START enforce_freight_term_flag*/
7137:
7138: prior_exists := 'N';
7139: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
7140: IF OE_Globals.Equal(
7141: p_curr_rec.enforce_freight_term_flag,
7142: p_prior_rec.enforce_freight_term_flag) THEN
7143: null;
7144: ELSE

Line 7155: IF OE_Globals.Equal(

7151: END IF;
7152: END IF; /* PRIOR */
7153: /****************************/
7154: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
7155: IF OE_Globals.Equal(
7156: p_curr_rec.enforce_freight_term_flag,
7157: p_next_rec.enforce_freight_term_flag) THEN
7158: IF prior_exists = 'Y' THEN
7159: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.enforce_freight_term_flag;

Line 7181: IF OE_Globals.Equal(

7177: /* START enforce_shipping_method_flag*/
7178:
7179: prior_exists := 'N';
7180: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
7181: IF OE_Globals.Equal(
7182: p_curr_rec.enforce_shipping_method_flag,
7183: p_prior_rec.enforce_shipping_method_flag) THEN
7184: null;
7185: ELSE

Line 7196: IF OE_Globals.Equal(

7192: END IF;
7193: END IF; /* PRIOR */
7194: /****************************/
7195: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
7196: IF OE_Globals.Equal(
7197: p_curr_rec.enforce_shipping_method_flag,
7198: p_next_rec.enforce_shipping_method_flag) THEN
7199: IF prior_exists = 'Y' THEN
7200: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.enforce_shipping_method_flag;

Line 7222: IF OE_Globals.Equal(

7218: /* START enforce_payment_term_flag*/
7219:
7220: prior_exists := 'N';
7221: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
7222: IF OE_Globals.Equal(
7223: p_curr_rec.enforce_payment_term_flag,
7224: p_prior_rec.enforce_payment_term_flag) THEN
7225: null;
7226: ELSE

Line 7237: IF OE_Globals.Equal(

7233: END IF;
7234: END IF; /* PRIOR */
7235: /****************************/
7236: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
7237: IF OE_Globals.Equal(
7238: p_curr_rec.enforce_payment_term_flag,
7239: p_next_rec.enforce_payment_term_flag) THEN
7240: IF prior_exists = 'Y' THEN
7241: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.enforce_payment_term_flag;

Line 7263: IF OE_Globals.Equal(

7259: /* START enforce_accounting_rule_flag*/
7260:
7261: prior_exists := 'N';
7262: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
7263: IF OE_Globals.Equal(
7264: p_curr_rec.enforce_accounting_rule_flag,
7265: p_prior_rec.enforce_accounting_rule_flag) THEN
7266: null;
7267: ELSE

Line 7278: IF OE_Globals.Equal(

7274: END IF;
7275: END IF; /* PRIOR */
7276: /****************************/
7277: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
7278: IF OE_Globals.Equal(
7279: p_curr_rec.enforce_accounting_rule_flag,
7280: p_next_rec.enforce_accounting_rule_flag) THEN
7281: IF prior_exists = 'Y' THEN
7282: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.enforce_accounting_rule_flag;

Line 7304: IF OE_Globals.Equal(

7300: /* START BLANKET_MAX_AMOUNT*/
7301:
7302: prior_exists := 'N';
7303: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
7304: IF OE_Globals.Equal(
7305: p_curr_rec.BLANKET_MAX_AMOUNT,
7306: p_prior_rec.BLANKET_MAX_AMOUNT) THEN
7307: null;
7308: ELSE

Line 7319: IF OE_Globals.Equal(

7315: END IF;
7316: END IF; /* PRIOR */
7317: /****************************/
7318: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
7319: IF OE_Globals.Equal(
7320: p_curr_rec.BLANKET_MAX_AMOUNT,
7321: p_next_rec.BLANKET_MAX_AMOUNT) THEN
7322: IF prior_exists = 'Y' THEN
7323: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.BLANKET_MAX_AMOUNT;

Line 7345: IF OE_Globals.Equal(

7341: /* START BLANKET_MIN_AMOUNT*/
7342:
7343: prior_exists := 'N';
7344: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
7345: IF OE_Globals.Equal(
7346: p_curr_rec.BLANKET_MIN_AMOUNT,
7347: p_prior_rec.BLANKET_MIN_AMOUNT) THEN
7348: null;
7349: ELSE

Line 7360: IF OE_Globals.Equal(

7356: END IF;
7357: END IF; /* PRIOR */
7358: /****************************/
7359: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
7360: IF OE_Globals.Equal(
7361: p_curr_rec.BLANKET_MIN_AMOUNT,
7362: p_next_rec.BLANKET_MIN_AMOUNT) THEN
7363: IF prior_exists = 'Y' THEN
7364: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.BLANKET_MIN_AMOUNT;

Line 7386: IF OE_Globals.Equal(

7382: /* START FULFILLED_QUANTITY*/
7383:
7384: prior_exists := 'N';
7385: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
7386: IF OE_Globals.Equal(
7387: p_curr_rec.FULFILLED_QUANTITY,
7388: p_prior_rec.FULFILLED_QUANTITY) THEN
7389: null;
7390: ELSE

Line 7401: IF OE_Globals.Equal(

7397: END IF;
7398: END IF; /* PRIOR */
7399: /****************************/
7400: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
7401: IF OE_Globals.Equal(
7402: p_curr_rec.FULFILLED_QUANTITY,
7403: p_next_rec.FULFILLED_QUANTITY) THEN
7404: IF prior_exists = 'Y' THEN
7405: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.FULFILLED_QUANTITY;

Line 7427: IF OE_Globals.Equal(

7423: /* START RELEASED_QUANTITY*/
7424:
7425: prior_exists := 'N';
7426: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
7427: IF OE_Globals.Equal(
7428: p_curr_rec.RELEASED_QUANTITY,
7429: p_prior_rec.RELEASED_QUANTITY) THEN
7430: null;
7431: ELSE

Line 7442: IF OE_Globals.Equal(

7438: END IF;
7439: END IF; /* PRIOR */
7440: /****************************/
7441: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
7442: IF OE_Globals.Equal(
7443: p_curr_rec.RELEASED_QUANTITY,
7444: p_next_rec.RELEASED_QUANTITY) THEN
7445: IF prior_exists = 'Y' THEN
7446: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.RELEASED_QUANTITY;

Line 7468: IF OE_Globals.Equal(

7464: /* START RETURNED_QUANTITY*/
7465:
7466: prior_exists := 'N';
7467: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
7468: IF OE_Globals.Equal(
7469: p_curr_rec.RETURNED_QUANTITY,
7470: p_prior_rec.RETURNED_QUANTITY) THEN
7471: null;
7472: ELSE

Line 7483: IF OE_Globals.Equal(

7479: END IF;
7480: END IF; /* PRIOR */
7481: /****************************/
7482: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
7483: IF OE_Globals.Equal(
7484: p_curr_rec.RETURNED_QUANTITY,
7485: p_next_rec.RETURNED_QUANTITY) THEN
7486: IF prior_exists = 'Y' THEN
7487: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.RETURNED_QUANTITY;

Line 7509: IF OE_Globals.Equal(

7505: /* START ORDER_NUMBER*/
7506:
7507: prior_exists := 'N';
7508: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
7509: IF OE_Globals.Equal(
7510: p_curr_rec.ORDER_NUMBER,
7511: p_prior_rec.ORDER_NUMBER) THEN
7512: null;
7513: ELSE

Line 7524: IF OE_Globals.Equal(

7520: END IF;
7521: END IF; /* PRIOR */
7522: /****************************/
7523: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
7524: IF OE_Globals.Equal(
7525: p_curr_rec.ORDER_NUMBER,
7526: p_next_rec.ORDER_NUMBER) THEN
7527: IF prior_exists = 'Y' THEN
7528: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.ORDER_NUMBER;

Line 7550: IF OE_Globals.Equal(

7546: /* START RELEASED_AMOUNT*/
7547:
7548: prior_exists := 'N';
7549: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
7550: IF OE_Globals.Equal(
7551: p_curr_rec.RELEASED_AMOUNT,
7552: p_prior_rec.RELEASED_AMOUNT) THEN
7553: null;
7554: ELSE

Line 7565: IF OE_Globals.Equal(

7561: END IF;
7562: END IF; /* PRIOR */
7563: /****************************/
7564: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
7565: IF OE_Globals.Equal(
7566: p_curr_rec.RELEASED_AMOUNT,
7567: p_next_rec.RELEASED_AMOUNT) THEN
7568: IF prior_exists = 'Y' THEN
7569: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.RELEASED_AMOUNT;

Line 7591: IF OE_Globals.Equal(

7587: /* START FULFILLED_AMOUNT*/
7588:
7589: prior_exists := 'N';
7590: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
7591: IF OE_Globals.Equal(
7592: p_curr_rec.FULFILLED_AMOUNT,
7593: p_prior_rec.FULFILLED_AMOUNT) THEN
7594: null;
7595: ELSE

Line 7606: IF OE_Globals.Equal(

7602: END IF;
7603: END IF; /* PRIOR */
7604: /****************************/
7605: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
7606: IF OE_Globals.Equal(
7607: p_curr_rec.FULFILLED_AMOUNT,
7608: p_next_rec.FULFILLED_AMOUNT) THEN
7609: IF prior_exists = 'Y' THEN
7610: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.FULFILLED_AMOUNT;

Line 7632: IF OE_Globals.Equal(

7628: /* START RETURNED_AMOUNT*/
7629:
7630: prior_exists := 'N';
7631: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
7632: IF OE_Globals.Equal(
7633: p_curr_rec.RETURNED_AMOUNT,
7634: p_prior_rec.RETURNED_AMOUNT) THEN
7635: null;
7636: ELSE

Line 7647: IF OE_Globals.Equal(

7643: END IF;
7644: END IF; /* PRIOR */
7645: /****************************/
7646: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
7647: IF OE_Globals.Equal(
7648: p_curr_rec.RETURNED_AMOUNT,
7649: p_next_rec.RETURNED_AMOUNT) THEN
7650: IF prior_exists = 'Y' THEN
7651: x_line_changed_attr_tbl(ind).next_value := p_curr_rec.RETURNED_AMOUNT;