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_PRICE_ADJUST_COMP dependencies on OE_GLOBALS

Line 23: l_org_id := OE_GLOBALS.G_ORG_ID;

19: oe_debug_pub.add('price adjust' ||p_price_adjustment_id);
20: oe_debug_pub.add('version' ||p_version);
21: END IF;
22:
23: l_org_id := OE_GLOBALS.G_ORG_ID;
24:
25: IF l_org_id IS NULL THEN
26: OE_GLOBALS.Set_Context;
27: l_org_id := OE_GLOBALS.G_ORG_ID;

Line 26: OE_GLOBALS.Set_Context;

22:
23: l_org_id := OE_GLOBALS.G_ORG_ID;
24:
25: IF l_org_id IS NULL THEN
26: OE_GLOBALS.Set_Context;
27: l_org_id := OE_GLOBALS.G_ORG_ID;
28: END IF;
29:
30: SELECT distinct ATTRIBUTE1

Line 27: l_org_id := OE_GLOBALS.G_ORG_ID;

23: l_org_id := OE_GLOBALS.G_ORG_ID;
24:
25: IF l_org_id IS NULL THEN
26: OE_GLOBALS.Set_Context;
27: l_org_id := OE_GLOBALS.G_ORG_ID;
28: END IF;
29:
30: SELECT distinct ATTRIBUTE1
31: , ATTRIBUTE10

Line 276: l_org_id := OE_GLOBALS.G_ORG_ID;

272: oe_debug_pub.add('hprice' ||p_price_adjustment_id);
273: oe_debug_pub.add('version' ||p_version);
274: END IF;
275:
276: l_org_id := OE_GLOBALS.G_ORG_ID;
277:
278: IF l_org_id IS NULL THEN
279: OE_GLOBALS.Set_Context;
280: l_org_id := OE_GLOBALS.G_ORG_ID;

Line 279: OE_GLOBALS.Set_Context;

275:
276: l_org_id := OE_GLOBALS.G_ORG_ID;
277:
278: IF l_org_id IS NULL THEN
279: OE_GLOBALS.Set_Context;
280: l_org_id := OE_GLOBALS.G_ORG_ID;
281: END IF;
282:
283: SELECT distinct ATTRIBUTE1

Line 280: l_org_id := OE_GLOBALS.G_ORG_ID;

276: l_org_id := OE_GLOBALS.G_ORG_ID;
277:
278: IF l_org_id IS NULL THEN
279: OE_GLOBALS.Set_Context;
280: l_org_id := OE_GLOBALS.G_ORG_ID;
281: END IF;
282:
283: SELECT distinct ATTRIBUTE1
284: , ATTRIBUTE10

Line 652: IF OE_Globals.Equal(p_prior_rec.list_header_id,p_curr_rec.list_header_id) OR

648: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='Y') THEN
649: IF l_debug_level > 0 THEN
650: oe_debug_pub.add(' both exists - checking if both are same');
651: END IF;
652: IF OE_Globals.Equal(p_prior_rec.list_header_id,p_curr_rec.list_header_id) OR
653: OE_Globals.Equal( p_curr_rec.list_header_id, p_next_rec.list_header_id) THEN
654: /****************************/
655:
656: /****************************/

Line 653: OE_Globals.Equal( p_curr_rec.list_header_id, p_next_rec.list_header_id) THEN

649: IF l_debug_level > 0 THEN
650: oe_debug_pub.add(' both exists - checking if both are same');
651: END IF;
652: IF OE_Globals.Equal(p_prior_rec.list_header_id,p_curr_rec.list_header_id) OR
653: OE_Globals.Equal( p_curr_rec.list_header_id, p_next_rec.list_header_id) THEN
654: /****************************/
655:
656: /****************************/
657: /* START attribute1*/

Line 661: IF OE_Globals.Equal(

657: /* START attribute1*/
658:
659: prior_exists := 'N';
660: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
661: IF OE_Globals.Equal(
662: p_curr_rec.attribute1,
663: p_prior_rec.attribute1) THEN
664: null;
665: ELSE

Line 676: IF OE_Globals.Equal(

672: END IF;
673: END IF; /* PRIOR */
674: /****************************/
675: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
676: IF OE_Globals.Equal(
677: p_curr_rec.attribute1,
678: p_next_rec.attribute1) THEN
679: IF prior_exists = 'Y' THEN
680: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute1;

Line 702: IF OE_Globals.Equal(

698: /* START attribute2*/
699:
700: prior_exists := 'N';
701: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
702: IF OE_Globals.Equal(
703: p_curr_rec.attribute2,
704: p_prior_rec.attribute2) THEN
705: null;
706: ELSE

Line 717: IF OE_Globals.Equal(

713: END IF;
714: END IF; /* PRIOR */
715: /****************************/
716: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
717: IF OE_Globals.Equal(
718: p_curr_rec.attribute2,
719: p_next_rec.attribute2) THEN
720: IF prior_exists = 'Y' THEN
721: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute2;

Line 742: IF OE_Globals.Equal(

738: /* START attribute3*/
739:
740: prior_exists := 'N';
741: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
742: IF OE_Globals.Equal(
743: p_curr_rec.attribute3,
744: p_prior_rec.attribute3) THEN
745: null;
746: ELSE

Line 757: IF OE_Globals.Equal(

753: END IF;
754: END IF; /* PRIOR */
755: /****************************/
756: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
757: IF OE_Globals.Equal(
758: p_curr_rec.attribute3,
759: p_next_rec.attribute3) THEN
760: IF prior_exists = 'Y' THEN
761: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute3;

Line 783: IF OE_Globals.Equal(

779: /* START attribute4*/
780:
781: prior_exists := 'N';
782: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
783: IF OE_Globals.Equal(
784: p_curr_rec.attribute4,
785: p_prior_rec.attribute4) THEN
786: null;
787: ELSE

Line 798: IF OE_Globals.Equal(

794: END IF;
795: END IF; /* PRIOR */
796: /****************************/
797: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
798: IF OE_Globals.Equal(
799: p_curr_rec.attribute4,
800: p_next_rec.attribute4) THEN
801: IF prior_exists = 'Y' THEN
802: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute4;

Line 823: IF OE_Globals.Equal(

819: /* START attribute5*/
820:
821: prior_exists := 'N';
822: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
823: IF OE_Globals.Equal(
824: p_curr_rec.attribute5,
825: p_prior_rec.attribute5) THEN
826: null;
827: ELSE

Line 838: IF OE_Globals.Equal(

834: END IF;
835: END IF; /* PRIOR */
836: /****************************/
837: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
838: IF OE_Globals.Equal(
839: p_curr_rec.attribute5,
840: p_next_rec.attribute5) THEN
841: IF prior_exists = 'Y' THEN
842: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute5;

Line 864: IF OE_Globals.Equal(

860: /* START attribute6*/
861:
862: prior_exists := 'N';
863: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
864: IF OE_Globals.Equal(
865: p_curr_rec.attribute6,
866: p_prior_rec.attribute6) THEN
867: null;
868: ELSE

Line 879: IF OE_Globals.Equal(

875: END IF;
876: END IF; /* PRIOR */
877: /****************************/
878: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
879: IF OE_Globals.Equal(
880: p_curr_rec.attribute6,
881: p_next_rec.attribute6) THEN
882: IF prior_exists = 'Y' THEN
883: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute6;

Line 904: IF OE_Globals.Equal(

900: /* START attribute7*/
901:
902: prior_exists := 'N';
903: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
904: IF OE_Globals.Equal(
905: p_curr_rec.attribute7,
906: p_prior_rec.attribute7) THEN
907: null;
908: ELSE

Line 919: IF OE_Globals.Equal(

915: END IF;
916: END IF; /* PRIOR */
917: /****************************/
918: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
919: IF OE_Globals.Equal(
920: p_curr_rec.attribute7,
921: p_next_rec.attribute7) THEN
922: IF prior_exists = 'Y' THEN
923: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute7;

Line 945: IF OE_Globals.Equal(

941: /* START attribute8*/
942:
943: prior_exists := 'N';
944: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
945: IF OE_Globals.Equal(
946: p_curr_rec.attribute8,
947: p_prior_rec.attribute8) THEN
948: null;
949: ELSE

Line 960: IF OE_Globals.Equal(

956: END IF;
957: END IF; /* PRIOR */
958: /****************************/
959: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
960: IF OE_Globals.Equal(
961: p_curr_rec.attribute8,
962: p_next_rec.attribute8) THEN
963: IF prior_exists = 'Y' THEN
964: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute8;

Line 985: IF OE_Globals.Equal(

981: /* START attribute9*/
982:
983: prior_exists := 'N';
984: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
985: IF OE_Globals.Equal(
986: p_curr_rec.attribute9,
987: p_prior_rec.attribute9) THEN
988: null;
989: ELSE

Line 1000: IF OE_Globals.Equal(

996: END IF;
997: END IF; /* PRIOR */
998: /****************************/
999: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
1000: IF OE_Globals.Equal(
1001: p_curr_rec.attribute9,
1002: p_next_rec.attribute9) THEN
1003: IF prior_exists = 'Y' THEN
1004: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute9;

Line 1026: IF OE_Globals.Equal(

1022: /* START attribute10*/
1023:
1024: prior_exists := 'N';
1025: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
1026: IF OE_Globals.Equal(
1027: p_curr_rec.attribute10,
1028: p_prior_rec.attribute10) THEN
1029: null;
1030: ELSE

Line 1041: IF OE_Globals.Equal(

1037: END IF;
1038: END IF; /* PRIOR */
1039: /****************************/
1040: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
1041: IF OE_Globals.Equal(
1042: p_curr_rec.attribute10,
1043: p_next_rec.attribute10) THEN
1044: IF prior_exists = 'Y' THEN
1045: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute10;

Line 1067: IF OE_Globals.Equal(

1063: /* START attribute11*/
1064:
1065: prior_exists := 'N';
1066: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
1067: IF OE_Globals.Equal(
1068: p_curr_rec.attribute11,
1069: p_prior_rec.attribute11) THEN
1070: null;
1071: ELSE

Line 1082: IF OE_Globals.Equal(

1078: END IF;
1079: END IF; /* PRIOR */
1080: /****************************/
1081: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
1082: IF OE_Globals.Equal(
1083: p_curr_rec.attribute11,
1084: p_next_rec.attribute11) THEN
1085: IF prior_exists = 'Y' THEN
1086: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute11;

Line 1108: IF OE_Globals.Equal(

1104: /* START attribute12*/
1105:
1106: prior_exists := 'N';
1107: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
1108: IF OE_Globals.Equal(
1109: p_curr_rec.attribute12,
1110: p_prior_rec.attribute12) THEN
1111: null;
1112: ELSE

Line 1123: IF OE_Globals.Equal(

1119: END IF;
1120: END IF; /* PRIOR */
1121: /****************************/
1122: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
1123: IF OE_Globals.Equal(
1124: p_curr_rec.attribute12,
1125: p_next_rec.attribute12) THEN
1126: IF prior_exists = 'Y' THEN
1127: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute12;

Line 1149: IF OE_Globals.Equal(

1145: /* START attribute13*/
1146:
1147: prior_exists := 'N';
1148: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
1149: IF OE_Globals.Equal(
1150: p_curr_rec.attribute13,
1151: p_prior_rec.attribute13) THEN
1152: null;
1153: ELSE

Line 1164: IF OE_Globals.Equal(

1160: END IF;
1161: END IF; /* PRIOR */
1162: /****************************/
1163: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
1164: IF OE_Globals.Equal(
1165: p_curr_rec.attribute13,
1166: p_next_rec.attribute13) THEN
1167: IF prior_exists = 'Y' THEN
1168: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute13;

Line 1190: IF OE_Globals.Equal(

1186: /* START attribute14*/
1187:
1188: prior_exists := 'N';
1189: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
1190: IF OE_Globals.Equal(
1191: p_curr_rec.attribute14,
1192: p_prior_rec.attribute14) THEN
1193: null;
1194: ELSE

Line 1205: IF OE_Globals.Equal(

1201: END IF;
1202: END IF; /* PRIOR */
1203: /****************************/
1204: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
1205: IF OE_Globals.Equal(
1206: p_curr_rec.attribute14,
1207: p_next_rec.attribute14) THEN
1208: IF prior_exists = 'Y' THEN
1209: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute14;

Line 1231: IF OE_Globals.Equal(

1227: /* START attribute15*/
1228:
1229: prior_exists := 'N';
1230: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
1231: IF OE_Globals.Equal(
1232: p_curr_rec.attribute15,
1233: p_prior_rec.attribute15) THEN
1234: null;
1235: ELSE

Line 1246: IF OE_Globals.Equal(

1242: END IF;
1243: END IF; /* PRIOR */
1244: /****************************/
1245: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
1246: IF OE_Globals.Equal(
1247: p_curr_rec.attribute15,
1248: p_next_rec.attribute15) THEN
1249: IF prior_exists = 'Y' THEN
1250: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute15;

Line 1271: IF OE_Globals.Equal(

1267: /* START context*/
1268:
1269: prior_exists := 'N';
1270: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
1271: IF OE_Globals.Equal(
1272: p_curr_rec.context,
1273: p_prior_rec.context) THEN
1274: null;
1275: ELSE

Line 1286: IF OE_Globals.Equal(

1282: END IF;
1283: END IF; /* PRIOR */
1284: /****************************/
1285: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
1286: IF OE_Globals.Equal(
1287: p_curr_rec.context,
1288: p_next_rec.context) THEN
1289: IF prior_exists = 'Y' THEN
1290: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.context;

Line 1313: IF OE_Globals.Equal(

1309: /* START AUTOMATIC_FLAG*/
1310:
1311: prior_exists := 'N';
1312: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
1313: IF OE_Globals.Equal(
1314: p_curr_rec.AUTOMATIC_FLAG,
1315: p_prior_rec.AUTOMATIC_FLAG) THEN
1316: null;
1317: ELSE

Line 1328: IF OE_Globals.Equal(

1324: END IF;
1325: END IF; /* PRIOR */
1326: /****************************/
1327: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
1328: IF OE_Globals.Equal(
1329: p_curr_rec.AUTOMATIC_FLAG,
1330: p_next_rec.AUTOMATIC_FLAG) THEN
1331: IF prior_exists = 'Y' THEN
1332: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.AUTOMATIC_FLAG;

Line 1354: IF OE_Globals.Equal(

1350: /* START LIST_LINE_TYPE_CODE*/
1351:
1352: prior_exists := 'N';
1353: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
1354: IF OE_Globals.Equal(
1355: p_curr_rec.LIST_LINE_TYPE_CODE,
1356: p_prior_rec.LIST_LINE_TYPE_CODE) THEN
1357: null;
1358: ELSE

Line 1369: IF OE_Globals.Equal(

1365: END IF;
1366: END IF; /* PRIOR */
1367: /****************************/
1368: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
1369: IF OE_Globals.Equal(
1370: p_curr_rec.LIST_LINE_TYPE_CODE,
1371: p_next_rec.LIST_LINE_TYPE_CODE) THEN
1372: IF prior_exists = 'Y' THEN
1373: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.LIST_LINE_TYPE_CODE;

Line 1396: IF OE_Globals.Equal(

1392: /* START CHANGE_REASON_CODE*/
1393:
1394: prior_exists := 'N';
1395: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
1396: IF OE_Globals.Equal(
1397: p_curr_rec.CHANGE_REASON_CODE,
1398: p_prior_rec.CHANGE_REASON_CODE) THEN
1399: null;
1400: ELSE

Line 1413: IF OE_Globals.Equal(

1409: END IF;
1410: END IF; /* PRIOR */
1411: /****************************/
1412: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
1413: IF OE_Globals.Equal(
1414: p_curr_rec.CHANGE_REASON_CODE,
1415: p_next_rec.CHANGE_REASON_CODE) THEN
1416: IF prior_exists = 'Y' THEN
1417: x_header_adj_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.change_reason(p_curr_rec.CHANGE_REASON_CODE);

Line 1442: IF OE_Globals.Equal(

1438: /* START CHANGE_REASON_TEXT*/
1439:
1440: prior_exists := 'N';
1441: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
1442: IF OE_Globals.Equal(
1443: p_curr_rec.CHANGE_REASON_TEXT,
1444: p_prior_rec.CHANGE_REASON_TEXT) THEN
1445: null;
1446: ELSE

Line 1457: IF OE_Globals.Equal(

1453: END IF;
1454: END IF; /* PRIOR */
1455: /****************************/
1456: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
1457: IF OE_Globals.Equal(
1458: p_curr_rec.CHANGE_REASON_TEXT,
1459: p_next_rec.CHANGE_REASON_TEXT) THEN
1460: IF prior_exists = 'Y' THEN
1461: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.CHANGE_REASON_TEXT;

Line 1484: IF OE_Globals.Equal(

1480: /* START list_line_no*/
1481:
1482: prior_exists := 'N';
1483: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
1484: IF OE_Globals.Equal(
1485: p_curr_rec.list_line_no,
1486: p_prior_rec.list_line_no) THEN
1487: null;
1488: ELSE

Line 1499: IF OE_Globals.Equal(

1495: END IF;
1496: END IF; /* PRIOR */
1497: /****************************/
1498: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
1499: IF OE_Globals.Equal(
1500: p_curr_rec.list_line_no,
1501: p_next_rec.list_line_no) THEN
1502: IF prior_exists = 'Y' THEN
1503: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.list_line_no;

Line 1524: IF OE_Globals.Equal(

1520: /* START source_system_code*/
1521:
1522: prior_exists := 'N';
1523: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
1524: IF OE_Globals.Equal(
1525: p_curr_rec.source_system_code,
1526: p_prior_rec.source_system_code) THEN
1527: null;
1528: ELSE

Line 1539: IF OE_Globals.Equal(

1535: END IF;
1536: END IF; /* PRIOR */
1537: /****************************/
1538: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
1539: IF OE_Globals.Equal(
1540: p_curr_rec.source_system_code,
1541: p_next_rec.source_system_code) THEN
1542: IF prior_exists = 'Y' THEN
1543: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.source_system_code;

Line 1565: IF OE_Globals.Equal(

1561: /* START benefit_qty*/
1562:
1563: prior_exists := 'N';
1564: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
1565: IF OE_Globals.Equal(
1566: p_curr_rec.benefit_qty,
1567: p_prior_rec.benefit_qty) THEN
1568: null;
1569: ELSE

Line 1580: IF OE_Globals.Equal(

1576: END IF;
1577: END IF; /* PRIOR */
1578: /****************************/
1579: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
1580: IF OE_Globals.Equal(
1581: p_curr_rec.benefit_qty,
1582: p_next_rec.benefit_qty) THEN
1583: IF prior_exists = 'Y' THEN
1584: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.benefit_qty;

Line 1606: IF OE_Globals.Equal(

1602: /* START benefit_uom_code*/
1603:
1604: prior_exists := 'N';
1605: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
1606: IF OE_Globals.Equal(
1607: p_curr_rec.benefit_uom_code,
1608: p_prior_rec.benefit_uom_code) THEN
1609: null;
1610: ELSE

Line 1621: IF OE_Globals.Equal(

1617: END IF;
1618: END IF; /* PRIOR */
1619: /****************************/
1620: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
1621: IF OE_Globals.Equal(
1622: p_curr_rec.benefit_uom_code,
1623: p_next_rec.benefit_uom_code) THEN
1624: IF prior_exists = 'Y' THEN
1625: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.benefit_uom_code;

Line 1647: IF OE_Globals.Equal(

1643: /* START expiration_date*/
1644:
1645: prior_exists := 'N';
1646: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
1647: IF OE_Globals.Equal(
1648: p_curr_rec.expiration_date,
1649: p_prior_rec.expiration_date) THEN
1650: null;
1651: ELSE

Line 1662: IF OE_Globals.Equal(

1658: END IF;
1659: END IF; /* PRIOR */
1660: /****************************/
1661: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
1662: IF OE_Globals.Equal(
1663: p_curr_rec.expiration_date,
1664: p_next_rec.expiration_date) THEN
1665: IF prior_exists = 'Y' THEN
1666: x_header_adj_changed_attr_tbl(ind).next_value := to_char(p_curr_rec.expiration_date,'DD-MON-YYYY HH24:MI:SS');

Line 1688: IF OE_Globals.Equal(

1684: /* START rebate_transaction_type_code*/
1685:
1686: prior_exists := 'N';
1687: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
1688: IF OE_Globals.Equal(
1689: p_curr_rec.rebate_transaction_type_code,
1690: p_prior_rec.rebate_transaction_type_code) THEN
1691: null;
1692: ELSE

Line 1703: IF OE_Globals.Equal(

1699: END IF;
1700: END IF; /* PRIOR */
1701: /****************************/
1702: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
1703: IF OE_Globals.Equal(
1704: p_curr_rec.rebate_transaction_type_code,
1705: p_next_rec.rebate_transaction_type_code) THEN
1706: IF prior_exists = 'Y' THEN
1707: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.rebate_transaction_type_code;

Line 1729: IF OE_Globals.Equal(

1725: /* START rebate_transaction_reference*/
1726:
1727: prior_exists := 'N';
1728: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
1729: IF OE_Globals.Equal(
1730: p_curr_rec.rebate_transaction_reference,
1731: p_prior_rec.rebate_transaction_reference) THEN
1732: null;
1733: ELSE

Line 1744: IF OE_Globals.Equal(

1740: END IF;
1741: END IF; /* PRIOR */
1742: /****************************/
1743: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
1744: IF OE_Globals.Equal(
1745: p_curr_rec.rebate_transaction_reference,
1746: p_next_rec.rebate_transaction_reference) THEN
1747: IF prior_exists = 'Y' THEN
1748: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.rebate_transaction_reference;

Line 1770: IF OE_Globals.Equal(

1766: /* START rebate_payment_system_code*/
1767:
1768: prior_exists := 'N';
1769: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
1770: IF OE_Globals.Equal(
1771: p_curr_rec.rebate_payment_system_code,
1772: p_prior_rec.rebate_payment_system_code) THEN
1773: null;
1774: ELSE

Line 1785: IF OE_Globals.Equal(

1781: END IF;
1782: END IF; /* PRIOR */
1783: /****************************/
1784: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
1785: IF OE_Globals.Equal(
1786: p_curr_rec.rebate_payment_system_code,
1787: p_next_rec.rebate_payment_system_code) THEN
1788: IF prior_exists = 'Y' THEN
1789: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.rebate_payment_system_code;

Line 1811: IF OE_Globals.Equal(

1807: /* START redeemed_date*/
1808:
1809: prior_exists := 'N';
1810: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
1811: IF OE_Globals.Equal(
1812: p_curr_rec.redeemed_date,
1813: p_prior_rec.redeemed_date) THEN
1814: null;
1815: ELSE

Line 1826: IF OE_Globals.Equal(

1822: END IF;
1823: END IF; /* PRIOR */
1824: /****************************/
1825: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
1826: IF OE_Globals.Equal(
1827: p_curr_rec.redeemed_date,
1828: p_next_rec.redeemed_date) THEN
1829: IF prior_exists = 'Y' THEN
1830: x_header_adj_changed_attr_tbl(ind).next_value := to_char(p_curr_rec.redeemed_date,'DD-MON-YYYY HH24:MI:SS');

Line 1852: IF OE_Globals.Equal(

1848: /* START redeemed_flag*/
1849:
1850: prior_exists := 'N';
1851: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
1852: IF OE_Globals.Equal(
1853: p_curr_rec.redeemed_flag,
1854: p_prior_rec.redeemed_flag) THEN
1855: null;
1856: ELSE

Line 1867: IF OE_Globals.Equal(

1863: END IF;
1864: END IF; /* PRIOR */
1865: /****************************/
1866: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
1867: IF OE_Globals.Equal(
1868: p_curr_rec.redeemed_flag,
1869: p_next_rec.redeemed_flag) THEN
1870: IF prior_exists = 'Y' THEN
1871: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.redeemed_flag;

Line 1893: IF OE_Globals.Equal(

1889: /* START accrual_flag*/
1890:
1891: prior_exists := 'N';
1892: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
1893: IF OE_Globals.Equal(
1894: p_curr_rec.accrual_flag,
1895: p_prior_rec.accrual_flag) THEN
1896: null;
1897: ELSE

Line 1908: IF OE_Globals.Equal(

1904: END IF;
1905: END IF; /* PRIOR */
1906: /****************************/
1907: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
1908: IF OE_Globals.Equal(
1909: p_curr_rec.accrual_flag,
1910: p_next_rec.accrual_flag) THEN
1911: IF prior_exists = 'Y' THEN
1912: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.accrual_flag;

Line 1934: IF OE_Globals.Equal(

1930: /* START range_break_quantity*/
1931:
1932: prior_exists := 'N';
1933: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
1934: IF OE_Globals.Equal(
1935: p_curr_rec.range_break_quantity,
1936: p_prior_rec.range_break_quantity) THEN
1937: null;
1938: ELSE

Line 1949: IF OE_Globals.Equal(

1945: END IF;
1946: END IF; /* PRIOR */
1947: /****************************/
1948: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
1949: IF OE_Globals.Equal(
1950: p_curr_rec.range_break_quantity,
1951: p_next_rec.range_break_quantity) THEN
1952: IF prior_exists = 'Y' THEN
1953: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.range_break_quantity;

Line 1975: IF OE_Globals.Equal(

1971: /* START accrual_conversion_rate*/
1972:
1973: prior_exists := 'N';
1974: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
1975: IF OE_Globals.Equal(
1976: p_curr_rec.accrual_conversion_rate,
1977: p_prior_rec.accrual_conversion_rate) THEN
1978: null;
1979: ELSE

Line 1990: IF OE_Globals.Equal(

1986: END IF;
1987: END IF; /* PRIOR */
1988: /****************************/
1989: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
1990: IF OE_Globals.Equal(
1991: p_curr_rec.accrual_conversion_rate,
1992: p_next_rec.accrual_conversion_rate) THEN
1993: IF prior_exists = 'Y' THEN
1994: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.accrual_conversion_rate;

Line 2016: IF OE_Globals.Equal(

2012: /* START modifier_level_code*/
2013:
2014: prior_exists := 'N';
2015: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
2016: IF OE_Globals.Equal(
2017: p_curr_rec.modifier_level_code,
2018: p_prior_rec.modifier_level_code) THEN
2019: null;
2020: ELSE

Line 2031: IF OE_Globals.Equal(

2027: END IF;
2028: END IF; /* PRIOR */
2029: /****************************/
2030: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
2031: IF OE_Globals.Equal(
2032: p_curr_rec.modifier_level_code,
2033: p_next_rec.modifier_level_code) THEN
2034: IF prior_exists = 'Y' THEN
2035: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.modifier_level_code;

Line 2057: IF OE_Globals.Equal(

2053: /* START price_break_type_code*/
2054:
2055: prior_exists := 'N';
2056: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
2057: IF OE_Globals.Equal(
2058: p_curr_rec.price_break_type_code,
2059: p_prior_rec.price_break_type_code) THEN
2060: null;
2061: ELSE

Line 2072: IF OE_Globals.Equal(

2068: END IF;
2069: END IF; /* PRIOR */
2070: /****************************/
2071: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
2072: IF OE_Globals.Equal(
2073: p_curr_rec.price_break_type_code,
2074: p_next_rec.price_break_type_code) THEN
2075: IF prior_exists = 'Y' THEN
2076: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.price_break_type_code;

Line 2098: IF OE_Globals.Equal(

2094: /* START substitution_attribute*/
2095:
2096: prior_exists := 'N';
2097: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
2098: IF OE_Globals.Equal(
2099: p_curr_rec.substitution_attribute,
2100: p_prior_rec.substitution_attribute) THEN
2101: null;
2102: ELSE

Line 2113: IF OE_Globals.Equal(

2109: END IF;
2110: END IF; /* PRIOR */
2111: /****************************/
2112: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
2113: IF OE_Globals.Equal(
2114: p_curr_rec.substitution_attribute,
2115: p_next_rec.substitution_attribute) THEN
2116: IF prior_exists = 'Y' THEN
2117: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.substitution_attribute;

Line 2139: IF OE_Globals.Equal(

2135: /* START proration_type_code*/
2136:
2137: prior_exists := 'N';
2138: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
2139: IF OE_Globals.Equal(
2140: p_curr_rec.proration_type_code,
2141: p_prior_rec.proration_type_code) THEN
2142: null;
2143: ELSE

Line 2154: IF OE_Globals.Equal(

2150: END IF;
2151: END IF; /* PRIOR */
2152: /****************************/
2153: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
2154: IF OE_Globals.Equal(
2155: p_curr_rec.proration_type_code,
2156: p_next_rec.proration_type_code) THEN
2157: IF prior_exists = 'Y' THEN
2158: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.proration_type_code;

Line 2180: IF OE_Globals.Equal(

2176: /* START ac_attribute1*/
2177:
2178: prior_exists := 'N';
2179: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
2180: IF OE_Globals.Equal(
2181: p_curr_rec.ac_attribute1,
2182: p_prior_rec.ac_attribute1) THEN
2183: null;
2184: ELSE

Line 2194: IF OE_Globals.Equal(

2190: END IF;
2191: END IF; /* PRIOR */
2192: /****************************/
2193: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
2194: IF OE_Globals.Equal(
2195: p_curr_rec.ac_attribute1,
2196: p_next_rec.ac_attribute1) THEN
2197: IF prior_exists = 'Y' THEN
2198: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute1;

Line 2220: IF OE_Globals.Equal(

2216: /* START ac_attribute2*/
2217:
2218: prior_exists := 'N';
2219: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
2220: IF OE_Globals.Equal(
2221: p_curr_rec.ac_attribute2,
2222: p_prior_rec.ac_attribute2) THEN
2223: null;
2224: ELSE

Line 2235: IF OE_Globals.Equal(

2231: END IF;
2232: END IF; /* PRIOR */
2233: /****************************/
2234: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
2235: IF OE_Globals.Equal(
2236: p_curr_rec.ac_attribute2,
2237: p_next_rec.ac_attribute2) THEN
2238: IF prior_exists = 'Y' THEN
2239: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute2;

Line 2260: IF OE_Globals.Equal(

2256: /* START ac_attribute3*/
2257:
2258: prior_exists := 'N';
2259: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
2260: IF OE_Globals.Equal(
2261: p_curr_rec.ac_attribute3,
2262: p_prior_rec.ac_attribute3) THEN
2263: null;
2264: ELSE

Line 2275: IF OE_Globals.Equal(

2271: END IF;
2272: END IF; /* PRIOR */
2273: /****************************/
2274: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
2275: IF OE_Globals.Equal(
2276: p_curr_rec.ac_attribute3,
2277: p_next_rec.ac_attribute3) THEN
2278: IF prior_exists = 'Y' THEN
2279: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute3;

Line 2301: IF OE_Globals.Equal(

2297: /* START ac_attribute4*/
2298:
2299: prior_exists := 'N';
2300: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
2301: IF OE_Globals.Equal(
2302: p_curr_rec.ac_attribute4,
2303: p_prior_rec.ac_attribute4) THEN
2304: null;
2305: ELSE

Line 2316: IF OE_Globals.Equal(

2312: END IF;
2313: END IF; /* PRIOR */
2314: /****************************/
2315: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
2316: IF OE_Globals.Equal(
2317: p_curr_rec.ac_attribute4,
2318: p_next_rec.ac_attribute4) THEN
2319: IF prior_exists = 'Y' THEN
2320: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute4;

Line 2341: IF OE_Globals.Equal(

2337: /* START ac_attribute5*/
2338:
2339: prior_exists := 'N';
2340: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
2341: IF OE_Globals.Equal(
2342: p_curr_rec.ac_attribute5,
2343: p_prior_rec.ac_attribute5) THEN
2344: null;
2345: ELSE

Line 2356: IF OE_Globals.Equal(

2352: END IF;
2353: END IF; /* PRIOR */
2354: /****************************/
2355: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
2356: IF OE_Globals.Equal(
2357: p_curr_rec.ac_attribute5,
2358: p_next_rec.ac_attribute5) THEN
2359: IF prior_exists = 'Y' THEN
2360: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute5;

Line 2382: IF OE_Globals.Equal(

2378: /* START ac_attribute6*/
2379:
2380: prior_exists := 'N';
2381: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
2382: IF OE_Globals.Equal(
2383: p_curr_rec.ac_attribute6,
2384: p_prior_rec.ac_attribute6) THEN
2385: null;
2386: ELSE

Line 2397: IF OE_Globals.Equal(

2393: END IF;
2394: END IF; /* PRIOR */
2395: /****************************/
2396: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
2397: IF OE_Globals.Equal(
2398: p_curr_rec.ac_attribute6,
2399: p_next_rec.ac_attribute6) THEN
2400: IF prior_exists = 'Y' THEN
2401: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute6;

Line 2422: IF OE_Globals.Equal(

2418: /* START ac_attribute7*/
2419:
2420: prior_exists := 'N';
2421: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
2422: IF OE_Globals.Equal(
2423: p_curr_rec.ac_attribute7,
2424: p_prior_rec.ac_attribute7) THEN
2425: null;
2426: ELSE

Line 2437: IF OE_Globals.Equal(

2433: END IF;
2434: END IF; /* PRIOR */
2435: /****************************/
2436: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
2437: IF OE_Globals.Equal(
2438: p_curr_rec.ac_attribute7,
2439: p_next_rec.ac_attribute7) THEN
2440: IF prior_exists = 'Y' THEN
2441: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute7;

Line 2463: IF OE_Globals.Equal(

2459: /* START ac_attribute8*/
2460:
2461: prior_exists := 'N';
2462: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
2463: IF OE_Globals.Equal(
2464: p_curr_rec.ac_attribute8,
2465: p_prior_rec.ac_attribute8) THEN
2466: null;
2467: ELSE

Line 2478: IF OE_Globals.Equal(

2474: END IF;
2475: END IF; /* PRIOR */
2476: /****************************/
2477: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
2478: IF OE_Globals.Equal(
2479: p_curr_rec.ac_attribute8,
2480: p_next_rec.ac_attribute8) THEN
2481: IF prior_exists = 'Y' THEN
2482: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute8;

Line 2503: IF OE_Globals.Equal(

2499: /* START ac_attribute9*/
2500:
2501: prior_exists := 'N';
2502: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
2503: IF OE_Globals.Equal(
2504: p_curr_rec.ac_attribute9,
2505: p_prior_rec.ac_attribute9) THEN
2506: null;
2507: ELSE

Line 2518: IF OE_Globals.Equal(

2514: END IF;
2515: END IF; /* PRIOR */
2516: /****************************/
2517: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
2518: IF OE_Globals.Equal(
2519: p_curr_rec.ac_attribute9,
2520: p_next_rec.ac_attribute9) THEN
2521: IF prior_exists = 'Y' THEN
2522: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute9;

Line 2544: IF OE_Globals.Equal(

2540: /* START ac_attribute10*/
2541:
2542: prior_exists := 'N';
2543: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
2544: IF OE_Globals.Equal(
2545: p_curr_rec.ac_attribute10,
2546: p_prior_rec.ac_attribute10) THEN
2547: null;
2548: ELSE

Line 2559: IF OE_Globals.Equal(

2555: END IF;
2556: END IF; /* PRIOR */
2557: /****************************/
2558: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
2559: IF OE_Globals.Equal(
2560: p_curr_rec.ac_attribute10,
2561: p_next_rec.ac_attribute10) THEN
2562: IF prior_exists = 'Y' THEN
2563: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute10;

Line 2584: IF OE_Globals.Equal(

2580: /* START ac_attribute11*/
2581:
2582: prior_exists := 'N';
2583: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
2584: IF OE_Globals.Equal(
2585: p_curr_rec.ac_attribute11,
2586: p_prior_rec.ac_attribute11) THEN
2587: null;
2588: ELSE

Line 2599: IF OE_Globals.Equal(

2595: END IF;
2596: END IF; /* PRIOR */
2597: /****************************/
2598: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
2599: IF OE_Globals.Equal(
2600: p_curr_rec.ac_attribute11,
2601: p_next_rec.ac_attribute11) THEN
2602: IF prior_exists = 'Y' THEN
2603: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute11;

Line 2625: IF OE_Globals.Equal(

2621: /* START ac_attribute12*/
2622:
2623: prior_exists := 'N';
2624: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
2625: IF OE_Globals.Equal(
2626: p_curr_rec.ac_attribute12,
2627: p_prior_rec.ac_attribute12) THEN
2628: null;
2629: ELSE

Line 2640: IF OE_Globals.Equal(

2636: END IF;
2637: END IF; /* PRIOR */
2638: /****************************/
2639: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
2640: IF OE_Globals.Equal(
2641: p_curr_rec.ac_attribute12,
2642: p_next_rec.ac_attribute12) THEN
2643: IF prior_exists = 'Y' THEN
2644: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute12;

Line 2666: IF OE_Globals.Equal(

2662: /* START ac_attribute13*/
2663:
2664: prior_exists := 'N';
2665: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
2666: IF OE_Globals.Equal(
2667: p_curr_rec.ac_attribute13,
2668: p_prior_rec.ac_attribute13) THEN
2669: null;
2670: ELSE

Line 2681: IF OE_Globals.Equal(

2677: END IF;
2678: END IF; /* PRIOR */
2679: /****************************/
2680: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
2681: IF OE_Globals.Equal(
2682: p_curr_rec.ac_attribute13,
2683: p_next_rec.ac_attribute13) THEN
2684: IF prior_exists = 'Y' THEN
2685: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute13;

Line 2707: IF OE_Globals.Equal(

2703: /* START ac_attribute14*/
2704:
2705: prior_exists := 'N';
2706: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
2707: IF OE_Globals.Equal(
2708: p_curr_rec.ac_attribute14,
2709: p_prior_rec.ac_attribute14) THEN
2710: null;
2711: ELSE

Line 2722: IF OE_Globals.Equal(

2718: END IF;
2719: END IF; /* PRIOR */
2720: /****************************/
2721: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
2722: IF OE_Globals.Equal(
2723: p_curr_rec.ac_attribute14,
2724: p_next_rec.ac_attribute14) THEN
2725: IF prior_exists = 'Y' THEN
2726: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute14;

Line 2748: IF OE_Globals.Equal(

2744: /* START ac_attribute15*/
2745:
2746: prior_exists := 'N';
2747: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
2748: IF OE_Globals.Equal(
2749: p_curr_rec.ac_attribute15,
2750: p_prior_rec.ac_attribute15) THEN
2751: null;
2752: ELSE

Line 2763: IF OE_Globals.Equal(

2759: END IF;
2760: END IF; /* PRIOR */
2761: /****************************/
2762: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
2763: IF OE_Globals.Equal(
2764: p_curr_rec.ac_attribute15,
2765: p_next_rec.ac_attribute15) THEN
2766: IF prior_exists = 'Y' THEN
2767: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute15;

Line 2789: IF OE_Globals.Equal(

2785: /* START ac_context*/
2786:
2787: prior_exists := 'N';
2788: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
2789: IF OE_Globals.Equal(
2790: p_curr_rec.ac_context,
2791: p_prior_rec.ac_context) THEN
2792: null;
2793: ELSE

Line 2804: IF OE_Globals.Equal(

2800: END IF;
2801: END IF; /* PRIOR */
2802: /****************************/
2803: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
2804: IF OE_Globals.Equal(
2805: p_curr_rec.ac_context,
2806: p_next_rec.ac_context) THEN
2807: IF prior_exists = 'Y' THEN
2808: x_header_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_context;

Line 3072: l_org_id := OE_GLOBALS.G_ORG_ID;

3068: oe_debug_pub.add('header' ||p_price_adjustment_id);
3069: oe_debug_pub.add('version' ||p_version);
3070: END IF;
3071:
3072: l_org_id := OE_GLOBALS.G_ORG_ID;
3073:
3074: IF l_org_id IS NULL THEN
3075: OE_GLOBALS.Set_Context;
3076: l_org_id := OE_GLOBALS.G_ORG_ID;

Line 3075: OE_GLOBALS.Set_Context;

3071:
3072: l_org_id := OE_GLOBALS.G_ORG_ID;
3073:
3074: IF l_org_id IS NULL THEN
3075: OE_GLOBALS.Set_Context;
3076: l_org_id := OE_GLOBALS.G_ORG_ID;
3077: END IF;
3078:
3079:

Line 3076: l_org_id := OE_GLOBALS.G_ORG_ID;

3072: l_org_id := OE_GLOBALS.G_ORG_ID;
3073:
3074: IF l_org_id IS NULL THEN
3075: OE_GLOBALS.Set_Context;
3076: l_org_id := OE_GLOBALS.G_ORG_ID;
3077: END IF;
3078:
3079:
3080: SELECT ATTRIBUTE1

Line 3326: l_org_id := OE_GLOBALS.G_ORG_ID;

3322: oe_debug_pub.add('price' ||p_price_adjustment_id);
3323: oe_debug_pub.add('version' ||p_version);
3324: END IF;
3325:
3326: l_org_id := OE_GLOBALS.G_ORG_ID;
3327:
3328: IF l_org_id IS NULL THEN
3329: OE_GLOBALS.Set_Context;
3330: l_org_id := OE_GLOBALS.G_ORG_ID;

Line 3329: OE_GLOBALS.Set_Context;

3325:
3326: l_org_id := OE_GLOBALS.G_ORG_ID;
3327:
3328: IF l_org_id IS NULL THEN
3329: OE_GLOBALS.Set_Context;
3330: l_org_id := OE_GLOBALS.G_ORG_ID;
3331: END IF;
3332:
3333:

Line 3330: l_org_id := OE_GLOBALS.G_ORG_ID;

3326: l_org_id := OE_GLOBALS.G_ORG_ID;
3327:
3328: IF l_org_id IS NULL THEN
3329: OE_GLOBALS.Set_Context;
3330: l_org_id := OE_GLOBALS.G_ORG_ID;
3331: END IF;
3332:
3333:
3334: SELECT ATTRIBUTE1

Line 3701: IF OE_Globals.Equal(p_prior_rec.list_header_id,p_curr_rec.list_header_id) OR

3697: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='Y') THEN
3698: IF l_debug_level > 0 THEN
3699: oe_debug_pub.add(' both exists - checking if both are same');
3700: END IF;
3701: IF OE_Globals.Equal(p_prior_rec.list_header_id,p_curr_rec.list_header_id) OR
3702: OE_Globals.Equal( p_curr_rec.list_header_id, p_next_rec.list_header_id) THEN
3703: /****************************/
3704:
3705: /****************************/

Line 3702: OE_Globals.Equal( p_curr_rec.list_header_id, p_next_rec.list_header_id) THEN

3698: IF l_debug_level > 0 THEN
3699: oe_debug_pub.add(' both exists - checking if both are same');
3700: END IF;
3701: IF OE_Globals.Equal(p_prior_rec.list_header_id,p_curr_rec.list_header_id) OR
3702: OE_Globals.Equal( p_curr_rec.list_header_id, p_next_rec.list_header_id) THEN
3703: /****************************/
3704:
3705: /****************************/
3706: /* START attribute1*/

Line 3710: IF OE_Globals.Equal(

3706: /* START attribute1*/
3707:
3708: prior_exists := 'N';
3709: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
3710: IF OE_Globals.Equal(
3711: p_curr_rec.attribute1,
3712: p_prior_rec.attribute1) THEN
3713: null;
3714: ELSE

Line 3726: IF OE_Globals.Equal(

3722: END IF;
3723: END IF; /* PRIOR */
3724: /****************************/
3725: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
3726: IF OE_Globals.Equal(
3727: p_curr_rec.attribute1,
3728: p_next_rec.attribute1) THEN
3729: IF prior_exists = 'Y' THEN
3730: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute1;

Line 3753: IF OE_Globals.Equal(

3749: /* START attribute2*/
3750:
3751: prior_exists := 'N';
3752: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
3753: IF OE_Globals.Equal(
3754: p_curr_rec.attribute2,
3755: p_prior_rec.attribute2) THEN
3756: null;
3757: ELSE

Line 3769: IF OE_Globals.Equal(

3765: END IF;
3766: END IF; /* PRIOR */
3767: /****************************/
3768: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
3769: IF OE_Globals.Equal(
3770: p_curr_rec.attribute2,
3771: p_next_rec.attribute2) THEN
3772: IF prior_exists = 'Y' THEN
3773: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute2;

Line 3795: IF OE_Globals.Equal(

3791: /* START attribute3*/
3792:
3793: prior_exists := 'N';
3794: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
3795: IF OE_Globals.Equal(
3796: p_curr_rec.attribute3,
3797: p_prior_rec.attribute3) THEN
3798: null;
3799: ELSE

Line 3811: IF OE_Globals.Equal(

3807: END IF;
3808: END IF; /* PRIOR */
3809: /****************************/
3810: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
3811: IF OE_Globals.Equal(
3812: p_curr_rec.attribute3,
3813: p_next_rec.attribute3) THEN
3814: IF prior_exists = 'Y' THEN
3815: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute3;

Line 3838: IF OE_Globals.Equal(

3834: /* START attribute4*/
3835:
3836: prior_exists := 'N';
3837: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
3838: IF OE_Globals.Equal(
3839: p_curr_rec.attribute4,
3840: p_prior_rec.attribute4) THEN
3841: null;
3842: ELSE

Line 3854: IF OE_Globals.Equal(

3850: END IF;
3851: END IF; /* PRIOR */
3852: /****************************/
3853: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
3854: IF OE_Globals.Equal(
3855: p_curr_rec.attribute4,
3856: p_next_rec.attribute4) THEN
3857: IF prior_exists = 'Y' THEN
3858: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute4;

Line 3880: IF OE_Globals.Equal(

3876: /* START attribute5*/
3877:
3878: prior_exists := 'N';
3879: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
3880: IF OE_Globals.Equal(
3881: p_curr_rec.attribute5,
3882: p_prior_rec.attribute5) THEN
3883: null;
3884: ELSE

Line 3896: IF OE_Globals.Equal(

3892: END IF;
3893: END IF; /* PRIOR */
3894: /****************************/
3895: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
3896: IF OE_Globals.Equal(
3897: p_curr_rec.attribute5,
3898: p_next_rec.attribute5) THEN
3899: IF prior_exists = 'Y' THEN
3900: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute5;

Line 3923: IF OE_Globals.Equal(

3919: /* START attribute6*/
3920:
3921: prior_exists := 'N';
3922: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
3923: IF OE_Globals.Equal(
3924: p_curr_rec.attribute6,
3925: p_prior_rec.attribute6) THEN
3926: null;
3927: ELSE

Line 3939: IF OE_Globals.Equal(

3935: END IF;
3936: END IF; /* PRIOR */
3937: /****************************/
3938: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
3939: IF OE_Globals.Equal(
3940: p_curr_rec.attribute6,
3941: p_next_rec.attribute6) THEN
3942: IF prior_exists = 'Y' THEN
3943: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute6;

Line 3965: IF OE_Globals.Equal(

3961: /* START attribute7*/
3962:
3963: prior_exists := 'N';
3964: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
3965: IF OE_Globals.Equal(
3966: p_curr_rec.attribute7,
3967: p_prior_rec.attribute7) THEN
3968: null;
3969: ELSE

Line 3981: IF OE_Globals.Equal(

3977: END IF;
3978: END IF; /* PRIOR */
3979: /****************************/
3980: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
3981: IF OE_Globals.Equal(
3982: p_curr_rec.attribute7,
3983: p_next_rec.attribute7) THEN
3984: IF prior_exists = 'Y' THEN
3985: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute7;

Line 4008: IF OE_Globals.Equal(

4004: /* START attribute8*/
4005:
4006: prior_exists := 'N';
4007: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4008: IF OE_Globals.Equal(
4009: p_curr_rec.attribute8,
4010: p_prior_rec.attribute8) THEN
4011: null;
4012: ELSE

Line 4024: IF OE_Globals.Equal(

4020: END IF;
4021: END IF; /* PRIOR */
4022: /****************************/
4023: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4024: IF OE_Globals.Equal(
4025: p_curr_rec.attribute8,
4026: p_next_rec.attribute8) THEN
4027: IF prior_exists = 'Y' THEN
4028: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute8;

Line 4050: IF OE_Globals.Equal(

4046: /* START attribute9*/
4047:
4048: prior_exists := 'N';
4049: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4050: IF OE_Globals.Equal(
4051: p_curr_rec.attribute9,
4052: p_prior_rec.attribute9) THEN
4053: null;
4054: ELSE

Line 4066: IF OE_Globals.Equal(

4062: END IF;
4063: END IF; /* PRIOR */
4064: /****************************/
4065: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4066: IF OE_Globals.Equal(
4067: p_curr_rec.attribute9,
4068: p_next_rec.attribute9) THEN
4069: IF prior_exists = 'Y' THEN
4070: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute9;

Line 4093: IF OE_Globals.Equal(

4089: /* START attribute10*/
4090:
4091: prior_exists := 'N';
4092: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4093: IF OE_Globals.Equal(
4094: p_curr_rec.attribute10,
4095: p_prior_rec.attribute10) THEN
4096: null;
4097: ELSE

Line 4109: IF OE_Globals.Equal(

4105: END IF;
4106: END IF; /* PRIOR */
4107: /****************************/
4108: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4109: IF OE_Globals.Equal(
4110: p_curr_rec.attribute10,
4111: p_next_rec.attribute10) THEN
4112: IF prior_exists = 'Y' THEN
4113: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute10;

Line 4136: IF OE_Globals.Equal(

4132: /* START attribute11*/
4133:
4134: prior_exists := 'N';
4135: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4136: IF OE_Globals.Equal(
4137: p_curr_rec.attribute11,
4138: p_prior_rec.attribute11) THEN
4139: null;
4140: ELSE

Line 4152: IF OE_Globals.Equal(

4148: END IF;
4149: END IF; /* PRIOR */
4150: /****************************/
4151: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4152: IF OE_Globals.Equal(
4153: p_curr_rec.attribute11,
4154: p_next_rec.attribute11) THEN
4155: IF prior_exists = 'Y' THEN
4156: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute11;

Line 4179: IF OE_Globals.Equal(

4175: /* START attribute12*/
4176:
4177: prior_exists := 'N';
4178: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4179: IF OE_Globals.Equal(
4180: p_curr_rec.attribute12,
4181: p_prior_rec.attribute12) THEN
4182: null;
4183: ELSE

Line 4195: IF OE_Globals.Equal(

4191: END IF;
4192: END IF; /* PRIOR */
4193: /****************************/
4194: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4195: IF OE_Globals.Equal(
4196: p_curr_rec.attribute12,
4197: p_next_rec.attribute12) THEN
4198: IF prior_exists = 'Y' THEN
4199: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute12;

Line 4222: IF OE_Globals.Equal(

4218: /* START attribute13*/
4219:
4220: prior_exists := 'N';
4221: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4222: IF OE_Globals.Equal(
4223: p_curr_rec.attribute13,
4224: p_prior_rec.attribute13) THEN
4225: null;
4226: ELSE

Line 4238: IF OE_Globals.Equal(

4234: END IF;
4235: END IF; /* PRIOR */
4236: /****************************/
4237: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4238: IF OE_Globals.Equal(
4239: p_curr_rec.attribute13,
4240: p_next_rec.attribute13) THEN
4241: IF prior_exists = 'Y' THEN
4242: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute13;

Line 4265: IF OE_Globals.Equal(

4261: /* START attribute14*/
4262:
4263: prior_exists := 'N';
4264: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4265: IF OE_Globals.Equal(
4266: p_curr_rec.attribute14,
4267: p_prior_rec.attribute14) THEN
4268: null;
4269: ELSE

Line 4281: IF OE_Globals.Equal(

4277: END IF;
4278: END IF; /* PRIOR */
4279: /****************************/
4280: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4281: IF OE_Globals.Equal(
4282: p_curr_rec.attribute14,
4283: p_next_rec.attribute14) THEN
4284: IF prior_exists = 'Y' THEN
4285: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute14;

Line 4308: IF OE_Globals.Equal(

4304: /* START attribute15*/
4305:
4306: prior_exists := 'N';
4307: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4308: IF OE_Globals.Equal(
4309: p_curr_rec.attribute15,
4310: p_prior_rec.attribute15) THEN
4311: null;
4312: ELSE

Line 4324: IF OE_Globals.Equal(

4320: END IF;
4321: END IF; /* PRIOR */
4322: /****************************/
4323: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4324: IF OE_Globals.Equal(
4325: p_curr_rec.attribute15,
4326: p_next_rec.attribute15) THEN
4327: IF prior_exists = 'Y' THEN
4328: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.attribute15;

Line 4350: IF OE_Globals.Equal(

4346: /* START context*/
4347:
4348: prior_exists := 'N';
4349: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4350: IF OE_Globals.Equal(
4351: p_curr_rec.context,
4352: p_prior_rec.context) THEN
4353: null;
4354: ELSE

Line 4366: IF OE_Globals.Equal(

4362: END IF;
4363: END IF; /* PRIOR */
4364: /****************************/
4365: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4366: IF OE_Globals.Equal(
4367: p_curr_rec.context,
4368: p_next_rec.context) THEN
4369: IF prior_exists = 'Y' THEN
4370: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.context;

Line 4394: IF OE_Globals.Equal(

4390: /* START AUTOMATIC_FLAG*/
4391:
4392: prior_exists := 'N';
4393: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4394: IF OE_Globals.Equal(
4395: p_curr_rec.AUTOMATIC_FLAG,
4396: p_prior_rec.AUTOMATIC_FLAG) THEN
4397: null;
4398: ELSE

Line 4410: IF OE_Globals.Equal(

4406: END IF;
4407: END IF; /* PRIOR */
4408: /****************************/
4409: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4410: IF OE_Globals.Equal(
4411: p_curr_rec.AUTOMATIC_FLAG,
4412: p_next_rec.AUTOMATIC_FLAG) THEN
4413: IF prior_exists = 'Y' THEN
4414: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.AUTOMATIC_FLAG;

Line 4437: IF OE_Globals.Equal(

4433: /* START LIST_LINE_TYPE_CODE*/
4434:
4435: prior_exists := 'N';
4436: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4437: IF OE_Globals.Equal(
4438: p_curr_rec.LIST_LINE_TYPE_CODE,
4439: p_prior_rec.LIST_LINE_TYPE_CODE) THEN
4440: null;
4441: ELSE

Line 4453: IF OE_Globals.Equal(

4449: END IF;
4450: END IF; /* PRIOR */
4451: /****************************/
4452: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4453: IF OE_Globals.Equal(
4454: p_curr_rec.LIST_LINE_TYPE_CODE,
4455: p_next_rec.LIST_LINE_TYPE_CODE) THEN
4456: IF prior_exists = 'Y' THEN
4457: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.LIST_LINE_TYPE_CODE;

Line 4481: IF OE_Globals.Equal(

4477: /* START CHANGE_REASON_CODE*/
4478:
4479: prior_exists := 'N';
4480: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4481: IF OE_Globals.Equal(
4482: p_curr_rec.CHANGE_REASON_CODE,
4483: p_prior_rec.CHANGE_REASON_CODE) THEN
4484: null;
4485: ELSE

Line 4499: IF OE_Globals.Equal(

4495: END IF;
4496: END IF; /* PRIOR */
4497: /****************************/
4498: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4499: IF OE_Globals.Equal(
4500: p_curr_rec.CHANGE_REASON_CODE,
4501: p_next_rec.CHANGE_REASON_CODE) THEN
4502: IF prior_exists = 'Y' THEN
4503: x_line_adj_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.change_reason(p_curr_rec.CHANGE_REASON_CODE);

Line 4529: IF OE_Globals.Equal(

4525: /* START CHANGE_REASON_TEXT*/
4526:
4527: prior_exists := 'N';
4528: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4529: IF OE_Globals.Equal(
4530: p_curr_rec.CHANGE_REASON_TEXT,
4531: p_prior_rec.CHANGE_REASON_TEXT) THEN
4532: null;
4533: ELSE

Line 4545: IF OE_Globals.Equal(

4541: END IF;
4542: END IF; /* PRIOR */
4543: /****************************/
4544: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4545: IF OE_Globals.Equal(
4546: p_curr_rec.CHANGE_REASON_TEXT,
4547: p_next_rec.CHANGE_REASON_TEXT) THEN
4548: IF prior_exists = 'Y' THEN
4549: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.CHANGE_REASON_TEXT;

Line 4572: IF OE_Globals.Equal(

4568: /* START ADJUSTED_AMOUNT*/
4569:
4570: prior_exists := 'N';
4571: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4572: IF OE_Globals.Equal(
4573: p_curr_rec.ADJUSTED_AMOUNT,
4574: p_prior_rec.ADJUSTED_AMOUNT) THEN
4575: null;
4576: ELSE

Line 4588: IF OE_Globals.Equal(

4584: END IF;
4585: END IF; /* PRIOR */
4586: /****************************/
4587: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4588: IF OE_Globals.Equal(
4589: p_curr_rec.ADJUSTED_AMOUNT,
4590: p_next_rec.ADJUSTED_AMOUNT) THEN
4591: IF prior_exists = 'Y' THEN
4592: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ADJUSTED_AMOUNT;

Line 4616: IF OE_Globals.Equal(

4612: /* START list_line_no*/
4613:
4614: prior_exists := 'N';
4615: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4616: IF OE_Globals.Equal(
4617: p_curr_rec.list_line_no,
4618: p_prior_rec.list_line_no) THEN
4619: null;
4620: ELSE

Line 4632: IF OE_Globals.Equal(

4628: END IF;
4629: END IF; /* PRIOR */
4630: /****************************/
4631: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4632: IF OE_Globals.Equal(
4633: p_curr_rec.list_line_no,
4634: p_next_rec.list_line_no) THEN
4635: IF prior_exists = 'Y' THEN
4636: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.list_line_no;

Line 4658: IF OE_Globals.Equal(

4654: /* START source_system_code*/
4655:
4656: prior_exists := 'N';
4657: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4658: IF OE_Globals.Equal(
4659: p_curr_rec.source_system_code,
4660: p_prior_rec.source_system_code) THEN
4661: null;
4662: ELSE

Line 4674: IF OE_Globals.Equal(

4670: END IF;
4671: END IF; /* PRIOR */
4672: /****************************/
4673: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4674: IF OE_Globals.Equal(
4675: p_curr_rec.source_system_code,
4676: p_next_rec.source_system_code) THEN
4677: IF prior_exists = 'Y' THEN
4678: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.source_system_code;

Line 4701: IF OE_Globals.Equal(

4697: /* START benefit_qty*/
4698:
4699: prior_exists := 'N';
4700: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4701: IF OE_Globals.Equal(
4702: p_curr_rec.benefit_qty,
4703: p_prior_rec.benefit_qty) THEN
4704: null;
4705: ELSE

Line 4717: IF OE_Globals.Equal(

4713: END IF;
4714: END IF; /* PRIOR */
4715: /****************************/
4716: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4717: IF OE_Globals.Equal(
4718: p_curr_rec.benefit_qty,
4719: p_next_rec.benefit_qty) THEN
4720: IF prior_exists = 'Y' THEN
4721: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.benefit_qty;

Line 4744: IF OE_Globals.Equal(

4740: /* START benefit_uom_code*/
4741:
4742: prior_exists := 'N';
4743: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4744: IF OE_Globals.Equal(
4745: p_curr_rec.benefit_uom_code,
4746: p_prior_rec.benefit_uom_code) THEN
4747: null;
4748: ELSE

Line 4760: IF OE_Globals.Equal(

4756: END IF;
4757: END IF; /* PRIOR */
4758: /****************************/
4759: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4760: IF OE_Globals.Equal(
4761: p_curr_rec.benefit_uom_code,
4762: p_next_rec.benefit_uom_code) THEN
4763: IF prior_exists = 'Y' THEN
4764: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.benefit_uom_code;

Line 4787: IF OE_Globals.Equal(

4783: /* START expiration_date*/
4784:
4785: prior_exists := 'N';
4786: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4787: IF OE_Globals.Equal(
4788: p_curr_rec.expiration_date,
4789: p_prior_rec.expiration_date) THEN
4790: null;
4791: ELSE

Line 4803: IF OE_Globals.Equal(

4799: END IF;
4800: END IF; /* PRIOR */
4801: /****************************/
4802: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4803: IF OE_Globals.Equal(
4804: p_curr_rec.expiration_date,
4805: p_next_rec.expiration_date) THEN
4806: IF prior_exists = 'Y' THEN
4807: x_line_adj_changed_attr_tbl(ind).next_value := to_char(p_curr_rec.expiration_date,'DD-MON-YYYY HH24:MI:SS');

Line 4830: IF OE_Globals.Equal(

4826: /* START rebate_transaction_type_code*/
4827:
4828: prior_exists := 'N';
4829: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4830: IF OE_Globals.Equal(
4831: p_curr_rec.rebate_transaction_type_code,
4832: p_prior_rec.rebate_transaction_type_code) THEN
4833: null;
4834: ELSE

Line 4846: IF OE_Globals.Equal(

4842: END IF;
4843: END IF; /* PRIOR */
4844: /****************************/
4845: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4846: IF OE_Globals.Equal(
4847: p_curr_rec.rebate_transaction_type_code,
4848: p_next_rec.rebate_transaction_type_code) THEN
4849: IF prior_exists = 'Y' THEN
4850: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.rebate_transaction_type_code;

Line 4873: IF OE_Globals.Equal(

4869: /* START rebate_transaction_reference*/
4870:
4871: prior_exists := 'N';
4872: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4873: IF OE_Globals.Equal(
4874: p_curr_rec.rebate_transaction_reference,
4875: p_prior_rec.rebate_transaction_reference) THEN
4876: null;
4877: ELSE

Line 4889: IF OE_Globals.Equal(

4885: END IF;
4886: END IF; /* PRIOR */
4887: /****************************/
4888: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4889: IF OE_Globals.Equal(
4890: p_curr_rec.rebate_transaction_reference,
4891: p_next_rec.rebate_transaction_reference) THEN
4892: IF prior_exists = 'Y' THEN
4893: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.rebate_transaction_reference;

Line 4916: IF OE_Globals.Equal(

4912: /* START rebate_payment_system_code*/
4913:
4914: prior_exists := 'N';
4915: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4916: IF OE_Globals.Equal(
4917: p_curr_rec.rebate_payment_system_code,
4918: p_prior_rec.rebate_payment_system_code) THEN
4919: null;
4920: ELSE

Line 4932: IF OE_Globals.Equal(

4928: END IF;
4929: END IF; /* PRIOR */
4930: /****************************/
4931: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4932: IF OE_Globals.Equal(
4933: p_curr_rec.rebate_payment_system_code,
4934: p_next_rec.rebate_payment_system_code) THEN
4935: IF prior_exists = 'Y' THEN
4936: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.rebate_payment_system_code;

Line 4959: IF OE_Globals.Equal(

4955: /* START redeemed_date*/
4956:
4957: prior_exists := 'N';
4958: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
4959: IF OE_Globals.Equal(
4960: p_curr_rec.redeemed_date,
4961: p_prior_rec.redeemed_date) THEN
4962: null;
4963: ELSE

Line 4975: IF OE_Globals.Equal(

4971: END IF;
4972: END IF; /* PRIOR */
4973: /****************************/
4974: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
4975: IF OE_Globals.Equal(
4976: p_curr_rec.redeemed_date,
4977: p_next_rec.redeemed_date) THEN
4978: IF prior_exists = 'Y' THEN
4979: x_line_adj_changed_attr_tbl(ind).next_value := to_char(p_curr_rec.redeemed_date,'DD-MON-YYYY HH24:MI:SS');

Line 5002: IF OE_Globals.Equal(

4998: /* START redeemed_flag*/
4999:
5000: prior_exists := 'N';
5001: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5002: IF OE_Globals.Equal(
5003: p_curr_rec.redeemed_flag,
5004: p_prior_rec.redeemed_flag) THEN
5005: null;
5006: ELSE

Line 5018: IF OE_Globals.Equal(

5014: END IF;
5015: END IF; /* PRIOR */
5016: /****************************/
5017: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5018: IF OE_Globals.Equal(
5019: p_curr_rec.redeemed_flag,
5020: p_next_rec.redeemed_flag) THEN
5021: IF prior_exists = 'Y' THEN
5022: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.redeemed_flag;

Line 5045: IF OE_Globals.Equal(

5041: /* START accrual_flag*/
5042:
5043: prior_exists := 'N';
5044: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5045: IF OE_Globals.Equal(
5046: p_curr_rec.accrual_flag,
5047: p_prior_rec.accrual_flag) THEN
5048: null;
5049: ELSE

Line 5061: IF OE_Globals.Equal(

5057: END IF;
5058: END IF; /* PRIOR */
5059: /****************************/
5060: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5061: IF OE_Globals.Equal(
5062: p_curr_rec.accrual_flag,
5063: p_next_rec.accrual_flag) THEN
5064: IF prior_exists = 'Y' THEN
5065: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.accrual_flag;

Line 5088: IF OE_Globals.Equal(

5084: /* START range_break_quantity*/
5085:
5086: prior_exists := 'N';
5087: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5088: IF OE_Globals.Equal(
5089: p_curr_rec.range_break_quantity,
5090: p_prior_rec.range_break_quantity) THEN
5091: null;
5092: ELSE

Line 5104: IF OE_Globals.Equal(

5100: END IF;
5101: END IF; /* PRIOR */
5102: /****************************/
5103: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5104: IF OE_Globals.Equal(
5105: p_curr_rec.range_break_quantity,
5106: p_next_rec.range_break_quantity) THEN
5107: IF prior_exists = 'Y' THEN
5108: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.range_break_quantity;

Line 5131: IF OE_Globals.Equal(

5127: /* START accrual_conversion_rate*/
5128:
5129: prior_exists := 'N';
5130: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5131: IF OE_Globals.Equal(
5132: p_curr_rec.accrual_conversion_rate,
5133: p_prior_rec.accrual_conversion_rate) THEN
5134: null;
5135: ELSE

Line 5147: IF OE_Globals.Equal(

5143: END IF;
5144: END IF; /* PRIOR */
5145: /****************************/
5146: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5147: IF OE_Globals.Equal(
5148: p_curr_rec.accrual_conversion_rate,
5149: p_next_rec.accrual_conversion_rate) THEN
5150: IF prior_exists = 'Y' THEN
5151: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.accrual_conversion_rate;

Line 5174: IF OE_Globals.Equal(

5170: /* START modifier_level_code*/
5171:
5172: prior_exists := 'N';
5173: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5174: IF OE_Globals.Equal(
5175: p_curr_rec.modifier_level_code,
5176: p_prior_rec.modifier_level_code) THEN
5177: null;
5178: ELSE

Line 5190: IF OE_Globals.Equal(

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

Line 5217: IF OE_Globals.Equal(

5213: /* START price_break_type_code*/
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.price_break_type_code,
5219: p_prior_rec.price_break_type_code) THEN
5220: null;
5221: ELSE

Line 5233: IF OE_Globals.Equal(

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

Line 5260: IF OE_Globals.Equal(

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

Line 5276: IF OE_Globals.Equal(

5272: END IF;
5273: END IF; /* PRIOR */
5274: /****************************/
5275: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5276: IF OE_Globals.Equal(
5277: p_curr_rec.substitution_attribute,
5278: p_next_rec.substitution_attribute) THEN
5279: IF prior_exists = 'Y' THEN
5280: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.substitution_attribute;

Line 5303: IF OE_Globals.Equal(

5299: /* START proration_type_code*/
5300:
5301: prior_exists := 'N';
5302: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5303: IF OE_Globals.Equal(
5304: p_curr_rec.proration_type_code,
5305: p_prior_rec.proration_type_code) THEN
5306: null;
5307: ELSE

Line 5319: IF OE_Globals.Equal(

5315: END IF;
5316: END IF; /* PRIOR */
5317: /****************************/
5318: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5319: IF OE_Globals.Equal(
5320: p_curr_rec.proration_type_code,
5321: p_next_rec.proration_type_code) THEN
5322: IF prior_exists = 'Y' THEN
5323: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.proration_type_code;

Line 5346: IF OE_Globals.Equal(

5342: /* START ac_attribute1*/
5343:
5344: prior_exists := 'N';
5345: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5346: IF OE_Globals.Equal(
5347: p_curr_rec.ac_attribute1,
5348: p_prior_rec.ac_attribute1) THEN
5349: null;
5350: ELSE

Line 5362: IF OE_Globals.Equal(

5358: END IF;
5359: END IF; /* PRIOR */
5360: /****************************/
5361: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5362: IF OE_Globals.Equal(
5363: p_curr_rec.ac_attribute1,
5364: p_next_rec.ac_attribute1) THEN
5365: IF prior_exists = 'Y' THEN
5366: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute1;

Line 5389: IF OE_Globals.Equal(

5385: /* START ac_attribute2*/
5386:
5387: prior_exists := 'N';
5388: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5389: IF OE_Globals.Equal(
5390: p_curr_rec.ac_attribute2,
5391: p_prior_rec.ac_attribute2) THEN
5392: null;
5393: ELSE

Line 5405: IF OE_Globals.Equal(

5401: END IF;
5402: END IF; /* PRIOR */
5403: /****************************/
5404: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5405: IF OE_Globals.Equal(
5406: p_curr_rec.ac_attribute2,
5407: p_next_rec.ac_attribute2) THEN
5408: IF prior_exists = 'Y' THEN
5409: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute2;

Line 5431: IF OE_Globals.Equal(

5427: /* START ac_attribute3*/
5428:
5429: prior_exists := 'N';
5430: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5431: IF OE_Globals.Equal(
5432: p_curr_rec.ac_attribute3,
5433: p_prior_rec.ac_attribute3) THEN
5434: null;
5435: ELSE

Line 5447: IF OE_Globals.Equal(

5443: END IF;
5444: END IF; /* PRIOR */
5445: /****************************/
5446: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5447: IF OE_Globals.Equal(
5448: p_curr_rec.ac_attribute3,
5449: p_next_rec.ac_attribute3) THEN
5450: IF prior_exists = 'Y' THEN
5451: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute3;

Line 5474: IF OE_Globals.Equal(

5470: /* START ac_attribute4*/
5471:
5472: prior_exists := 'N';
5473: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5474: IF OE_Globals.Equal(
5475: p_curr_rec.ac_attribute4,
5476: p_prior_rec.ac_attribute4) THEN
5477: null;
5478: ELSE

Line 5490: IF OE_Globals.Equal(

5486: END IF;
5487: END IF; /* PRIOR */
5488: /****************************/
5489: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5490: IF OE_Globals.Equal(
5491: p_curr_rec.ac_attribute4,
5492: p_next_rec.ac_attribute4) THEN
5493: IF prior_exists = 'Y' THEN
5494: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute4;

Line 5516: IF OE_Globals.Equal(

5512: /* START ac_attribute5*/
5513:
5514: prior_exists := 'N';
5515: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5516: IF OE_Globals.Equal(
5517: p_curr_rec.ac_attribute5,
5518: p_prior_rec.ac_attribute5) THEN
5519: null;
5520: ELSE

Line 5532: IF OE_Globals.Equal(

5528: END IF;
5529: END IF; /* PRIOR */
5530: /****************************/
5531: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5532: IF OE_Globals.Equal(
5533: p_curr_rec.ac_attribute5,
5534: p_next_rec.ac_attribute5) THEN
5535: IF prior_exists = 'Y' THEN
5536: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute5;

Line 5559: IF OE_Globals.Equal(

5555: /* START ac_attribute6*/
5556:
5557: prior_exists := 'N';
5558: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5559: IF OE_Globals.Equal(
5560: p_curr_rec.ac_attribute6,
5561: p_prior_rec.ac_attribute6) THEN
5562: null;
5563: ELSE

Line 5575: IF OE_Globals.Equal(

5571: END IF;
5572: END IF; /* PRIOR */
5573: /****************************/
5574: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5575: IF OE_Globals.Equal(
5576: p_curr_rec.ac_attribute6,
5577: p_next_rec.ac_attribute6) THEN
5578: IF prior_exists = 'Y' THEN
5579: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute6;

Line 5601: IF OE_Globals.Equal(

5597: /* START ac_attribute7*/
5598:
5599: prior_exists := 'N';
5600: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5601: IF OE_Globals.Equal(
5602: p_curr_rec.ac_attribute7,
5603: p_prior_rec.ac_attribute7) THEN
5604: null;
5605: ELSE

Line 5617: IF OE_Globals.Equal(

5613: END IF;
5614: END IF; /* PRIOR */
5615: /****************************/
5616: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5617: IF OE_Globals.Equal(
5618: p_curr_rec.ac_attribute7,
5619: p_next_rec.ac_attribute7) THEN
5620: IF prior_exists = 'Y' THEN
5621: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute7;

Line 5644: IF OE_Globals.Equal(

5640: /* START ac_attribute8*/
5641:
5642: prior_exists := 'N';
5643: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5644: IF OE_Globals.Equal(
5645: p_curr_rec.ac_attribute8,
5646: p_prior_rec.ac_attribute8) THEN
5647: null;
5648: ELSE

Line 5660: IF OE_Globals.Equal(

5656: END IF;
5657: END IF; /* PRIOR */
5658: /****************************/
5659: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5660: IF OE_Globals.Equal(
5661: p_curr_rec.ac_attribute8,
5662: p_next_rec.ac_attribute8) THEN
5663: IF prior_exists = 'Y' THEN
5664: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute8;

Line 5686: IF OE_Globals.Equal(

5682: /* START ac_attribute9*/
5683:
5684: prior_exists := 'N';
5685: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5686: IF OE_Globals.Equal(
5687: p_curr_rec.ac_attribute9,
5688: p_prior_rec.ac_attribute9) THEN
5689: null;
5690: ELSE

Line 5702: IF OE_Globals.Equal(

5698: END IF;
5699: END IF; /* PRIOR */
5700: /****************************/
5701: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5702: IF OE_Globals.Equal(
5703: p_curr_rec.ac_attribute9,
5704: p_next_rec.ac_attribute9) THEN
5705: IF prior_exists = 'Y' THEN
5706: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute9;

Line 5729: IF OE_Globals.Equal(

5725: /* START ac_attribute10*/
5726:
5727: prior_exists := 'N';
5728: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5729: IF OE_Globals.Equal(
5730: p_curr_rec.ac_attribute10,
5731: p_prior_rec.ac_attribute10) THEN
5732: null;
5733: ELSE

Line 5745: IF OE_Globals.Equal(

5741: END IF;
5742: END IF; /* PRIOR */
5743: /****************************/
5744: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5745: IF OE_Globals.Equal(
5746: p_curr_rec.ac_attribute10,
5747: p_next_rec.ac_attribute10) THEN
5748: IF prior_exists = 'Y' THEN
5749: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute10;

Line 5771: IF OE_Globals.Equal(

5767: /* START ac_attribute11*/
5768:
5769: prior_exists := 'N';
5770: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5771: IF OE_Globals.Equal(
5772: p_curr_rec.ac_attribute11,
5773: p_prior_rec.ac_attribute11) THEN
5774: null;
5775: ELSE

Line 5787: IF OE_Globals.Equal(

5783: END IF;
5784: END IF; /* PRIOR */
5785: /****************************/
5786: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5787: IF OE_Globals.Equal(
5788: p_curr_rec.ac_attribute11,
5789: p_next_rec.ac_attribute11) THEN
5790: IF prior_exists = 'Y' THEN
5791: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute11;

Line 5814: IF OE_Globals.Equal(

5810: /* START ac_attribute12*/
5811:
5812: prior_exists := 'N';
5813: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5814: IF OE_Globals.Equal(
5815: p_curr_rec.ac_attribute12,
5816: p_prior_rec.ac_attribute12) THEN
5817: null;
5818: ELSE

Line 5830: IF OE_Globals.Equal(

5826: END IF;
5827: END IF; /* PRIOR */
5828: /****************************/
5829: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5830: IF OE_Globals.Equal(
5831: p_curr_rec.ac_attribute12,
5832: p_next_rec.ac_attribute12) THEN
5833: IF prior_exists = 'Y' THEN
5834: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute12;

Line 5857: IF OE_Globals.Equal(

5853: /* START ac_attribute13*/
5854:
5855: prior_exists := 'N';
5856: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5857: IF OE_Globals.Equal(
5858: p_curr_rec.ac_attribute13,
5859: p_prior_rec.ac_attribute13) THEN
5860: null;
5861: ELSE

Line 5873: IF OE_Globals.Equal(

5869: END IF;
5870: END IF; /* PRIOR */
5871: /****************************/
5872: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5873: IF OE_Globals.Equal(
5874: p_curr_rec.ac_attribute13,
5875: p_next_rec.ac_attribute13) THEN
5876: IF prior_exists = 'Y' THEN
5877: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute13;

Line 5900: IF OE_Globals.Equal(

5896: /* START ac_attribute14*/
5897:
5898: prior_exists := 'N';
5899: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5900: IF OE_Globals.Equal(
5901: p_curr_rec.ac_attribute14,
5902: p_prior_rec.ac_attribute14) THEN
5903: null;
5904: ELSE

Line 5916: IF OE_Globals.Equal(

5912: END IF;
5913: END IF; /* PRIOR */
5914: /****************************/
5915: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5916: IF OE_Globals.Equal(
5917: p_curr_rec.ac_attribute14,
5918: p_next_rec.ac_attribute14) THEN
5919: IF prior_exists = 'Y' THEN
5920: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute14;

Line 5943: IF OE_Globals.Equal(

5939: /* START ac_attribute15*/
5940:
5941: prior_exists := 'N';
5942: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5943: IF OE_Globals.Equal(
5944: p_curr_rec.ac_attribute15,
5945: p_prior_rec.ac_attribute15) THEN
5946: null;
5947: ELSE

Line 5959: IF OE_Globals.Equal(

5955: END IF;
5956: END IF; /* PRIOR */
5957: /****************************/
5958: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
5959: IF OE_Globals.Equal(
5960: p_curr_rec.ac_attribute15,
5961: p_next_rec.ac_attribute15) THEN
5962: IF prior_exists = 'Y' THEN
5963: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_attribute15;

Line 5986: IF OE_Globals.Equal(

5982: /* START ac_context*/
5983:
5984: prior_exists := 'N';
5985: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'Y' THEN
5986: IF OE_Globals.Equal(
5987: p_curr_rec.ac_context,
5988: p_prior_rec.ac_context) THEN
5989: null;
5990: ELSE

Line 6002: IF OE_Globals.Equal(

5998: END IF;
5999: END IF; /* PRIOR */
6000: /****************************/
6001: IF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'Y' THEN
6002: IF OE_Globals.Equal(
6003: p_curr_rec.ac_context,
6004: p_next_rec.ac_context) THEN
6005: IF prior_exists = 'Y' THEN
6006: x_line_adj_changed_attr_tbl(ind).next_value := p_curr_rec.ac_context;