[Home] [Help]
664: null;
665: ELSE
666: ind := ind+1;
667: prior_exists := 'Y';
668: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
669: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute1';
670: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute1;
671: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute1;
672: END IF;
682: ELSE
683: IF prior_exists = 'N' THEN
684: ind := ind+1;
685: END IF;
686: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
687: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute1';
688: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute1;
689: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute1;
690: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute1;
705: null;
706: ELSE
707: ind := ind+1;
708: prior_exists := 'Y';
709: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
710: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute2';
711: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute2;
712: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute2;
713: END IF;
723: ELSE
724: IF prior_exists = 'N' THEN
725: ind := ind+1;
726: END IF;
727: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
728: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute2';
729: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute2;
730: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute2;
731: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute2;
745: null;
746: ELSE
747: ind := ind+1;
748: prior_exists := 'Y';
749: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
750: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute3';
751: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute3;
752: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute3;
753: END IF;
763: ELSE
764: IF prior_exists = 'N' THEN
765: ind := ind+1;
766: END IF;
767: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
768: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute3';
769: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute3;
770: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute3;
771: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute3;
786: null;
787: ELSE
788: ind := ind+1;
789: prior_exists := 'Y';
790: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
791: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute4';
792: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute4;
793: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute4;
794: END IF;
804: ELSE
805: IF prior_exists = 'N' THEN
806: ind := ind+1;
807: END IF;
808: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
809: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute4';
810: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute4;
811: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute4;
812: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute4;
826: null;
827: ELSE
828: ind := ind+1;
829: prior_exists := 'Y';
830: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
831: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute5';
832: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute5;
833: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute5;
834: END IF;
844: ELSE
845: IF prior_exists = 'N' THEN
846: ind := ind+1;
847: END IF;
848: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
849: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute5';
850: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute5;
851: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute5;
852: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute5;
867: null;
868: ELSE
869: ind := ind+1;
870: prior_exists := 'Y';
871: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
872: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute6';
873: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute6;
874: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute6;
875: END IF;
886: IF prior_exists = 'N' THEN
887: ind := ind+1;
888: END IF;
889: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute6';
890: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
891: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute6;
892: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute6;
893: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute6;
894: END IF;
907: null;
908: ELSE
909: ind := ind+1;
910: prior_exists := 'Y';
911: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
912: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute7';
913: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute7;
914: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute7;
915: END IF;
925: ELSE
926: IF prior_exists = 'N' THEN
927: ind := ind+1;
928: END IF;
929: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
930: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute7';
931: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute7;
932: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute7;
933: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute7;
948: null;
949: ELSE
950: ind := ind+1;
951: prior_exists := 'Y';
952: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
953: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute8';
954: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute8;
955: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute8;
956: END IF;
966: ELSE
967: IF prior_exists = 'N' THEN
968: ind := ind+1;
969: END IF;
970: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
971: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute8';
972: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute8;
973: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute8;
974: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute8;
988: null;
989: ELSE
990: ind := ind+1;
991: prior_exists := 'Y';
992: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
993: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute9';
994: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute9;
995: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute9;
996: END IF;
1006: ELSE
1007: IF prior_exists = 'N' THEN
1008: ind := ind+1;
1009: END IF;
1010: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1011: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute9';
1012: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute9;
1013: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute9;
1014: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute9;
1029: null;
1030: ELSE
1031: ind := ind+1;
1032: prior_exists := 'Y';
1033: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1034: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute10';
1035: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute10;
1036: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute10;
1037: END IF;
1047: ELSE
1048: IF prior_exists = 'N' THEN
1049: ind := ind+1;
1050: END IF;
1051: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1052: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute10';
1053: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute10;
1054: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute10;
1055: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute10;
1070: null;
1071: ELSE
1072: ind := ind+1;
1073: prior_exists := 'Y';
1074: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1075: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute11';
1076: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute11;
1077: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute11;
1078: END IF;
1088: ELSE
1089: IF prior_exists = 'N' THEN
1090: ind := ind+1;
1091: END IF;
1092: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1093: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute11';
1094: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute11;
1095: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute11;
1096: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute11;
1111: null;
1112: ELSE
1113: ind := ind+1;
1114: prior_exists := 'Y';
1115: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1116: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute12';
1117: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute12;
1118: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute12;
1119: END IF;
1129: ELSE
1130: IF prior_exists = 'N' THEN
1131: ind := ind+1;
1132: END IF;
1133: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1134: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute12';
1135: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute12;
1136: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute12;
1137: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute12;
1152: null;
1153: ELSE
1154: ind := ind+1;
1155: prior_exists := 'Y';
1156: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1157: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute13';
1158: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute13;
1159: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute13;
1160: END IF;
1170: ELSE
1171: IF prior_exists = 'N' THEN
1172: ind := ind+1;
1173: END IF;
1174: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1175: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute13';
1176: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute13;
1177: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute13;
1178: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute13;
1193: null;
1194: ELSE
1195: ind := ind+1;
1196: prior_exists := 'Y';
1197: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1198: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute14';
1199: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute14;
1200: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute14;
1201: END IF;
1211: ELSE
1212: IF prior_exists = 'N' THEN
1213: ind := ind+1;
1214: END IF;
1215: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1216: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute14';
1217: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute14;
1218: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute14;
1219: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute14;
1234: null;
1235: ELSE
1236: ind := ind+1;
1237: prior_exists := 'Y';
1238: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1239: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute15';
1240: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute15;
1241: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute15;
1242: END IF;
1252: ELSE
1253: IF prior_exists = 'N' THEN
1254: ind := ind+1;
1255: END IF;
1256: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1257: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute15';
1258: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute15;
1259: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute15;
1260: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute15;
1274: null;
1275: ELSE
1276: ind := ind+1;
1277: prior_exists := 'Y';
1278: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1279: x_header_adj_changed_attr_tbl(ind).attribute_name := 'context';
1280: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.context;
1281: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.context;
1282: END IF;
1292: ELSE
1293: IF prior_exists = 'N' THEN
1294: ind := ind+1;
1295: END IF;
1296: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1297: x_header_adj_changed_attr_tbl(ind).attribute_name := 'context';
1298: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.context;
1299: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.context;
1300: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.context;
1316: null;
1317: ELSE
1318: ind := ind+1;
1319: prior_exists := 'Y';
1320: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1321: x_header_adj_changed_attr_tbl(ind).attribute_name := 'AUTOMATIC_FLAG';
1322: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.AUTOMATIC_FLAG;
1323: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.AUTOMATIC_FLAG;
1324: END IF;
1334: ELSE
1335: IF prior_exists = 'N' THEN
1336: ind := ind+1;
1337: END IF;
1338: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1339: x_header_adj_changed_attr_tbl(ind).attribute_name := 'AUTOMATIC_FLAG';
1340: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.AUTOMATIC_FLAG;
1341: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.AUTOMATIC_FLAG;
1342: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.AUTOMATIC_FLAG;
1357: null;
1358: ELSE
1359: ind := ind+1;
1360: prior_exists := 'Y';
1361: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1362: x_header_adj_changed_attr_tbl(ind).attribute_name := 'LIST_LINE_TYPE';
1363: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.LIST_LINE_TYPE_CODE;
1364: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.LIST_LINE_TYPE_CODE;
1365: END IF;
1375: ELSE
1376: IF prior_exists = 'N' THEN
1377: ind := ind+1;
1378: END IF;
1379: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1380: x_header_adj_changed_attr_tbl(ind).attribute_name := 'LIST_LINE_TYPE';
1381: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.LIST_LINE_TYPE_CODE;
1382: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.LIST_LINE_TYPE_CODE;
1383: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.LIST_LINE_TYPE_CODE;
1399: null;
1400: ELSE
1401: ind := ind+1;
1402: prior_exists := 'Y';
1403: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1404: x_header_adj_changed_attr_tbl(ind).attribute_name := 'CHANGE_REASON_CODE';
1405: x_header_adj_changed_attr_tbl(ind).prior_id := p_prior_rec.CHANGE_REASON_CODE;
1406: x_header_adj_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.change_reason(p_prior_rec.CHANGE_REASON_CODE);
1407: x_header_adj_changed_attr_tbl(ind).current_id := p_curr_rec.CHANGE_REASON_CODE;
1402: prior_exists := 'Y';
1403: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1404: x_header_adj_changed_attr_tbl(ind).attribute_name := 'CHANGE_REASON_CODE';
1405: x_header_adj_changed_attr_tbl(ind).prior_id := p_prior_rec.CHANGE_REASON_CODE;
1406: x_header_adj_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.change_reason(p_prior_rec.CHANGE_REASON_CODE);
1407: x_header_adj_changed_attr_tbl(ind).current_id := p_curr_rec.CHANGE_REASON_CODE;
1408: x_header_adj_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.change_reason(p_curr_rec.CHANGE_REASON_CODE);
1409: END IF;
1410: END IF; /* PRIOR */
1404: x_header_adj_changed_attr_tbl(ind).attribute_name := 'CHANGE_REASON_CODE';
1405: x_header_adj_changed_attr_tbl(ind).prior_id := p_prior_rec.CHANGE_REASON_CODE;
1406: x_header_adj_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.change_reason(p_prior_rec.CHANGE_REASON_CODE);
1407: x_header_adj_changed_attr_tbl(ind).current_id := p_curr_rec.CHANGE_REASON_CODE;
1408: x_header_adj_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.change_reason(p_curr_rec.CHANGE_REASON_CODE);
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);
1418: END IF;
1419: ELSE
1420: IF prior_exists = 'N' THEN
1421: ind := ind+1;
1419: ELSE
1420: IF prior_exists = 'N' THEN
1421: ind := ind+1;
1422: END IF;
1423: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1424: x_header_adj_changed_attr_tbl(ind).attribute_name := 'CHANGE_REASON_CODE';
1425: x_header_adj_changed_attr_tbl(ind).prior_id := p_prior_rec.CHANGE_REASON_CODE;
1426: x_header_adj_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.change_reason(p_prior_rec.CHANGE_REASON_CODE);
1427: x_header_adj_changed_attr_tbl(ind).current_id := p_curr_rec.CHANGE_REASON_CODE;
1422: END IF;
1423: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1424: x_header_adj_changed_attr_tbl(ind).attribute_name := 'CHANGE_REASON_CODE';
1425: x_header_adj_changed_attr_tbl(ind).prior_id := p_prior_rec.CHANGE_REASON_CODE;
1426: x_header_adj_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.change_reason(p_prior_rec.CHANGE_REASON_CODE);
1427: x_header_adj_changed_attr_tbl(ind).current_id := p_curr_rec.CHANGE_REASON_CODE;
1428: x_header_adj_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.change_reason(p_curr_rec.CHANGE_REASON_CODE);
1429: x_header_adj_changed_attr_tbl(ind).next_id := p_next_rec.CHANGE_REASON_CODE;
1430: x_header_adj_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.change_reason(p_next_rec.CHANGE_REASON_CODE);
1424: x_header_adj_changed_attr_tbl(ind).attribute_name := 'CHANGE_REASON_CODE';
1425: x_header_adj_changed_attr_tbl(ind).prior_id := p_prior_rec.CHANGE_REASON_CODE;
1426: x_header_adj_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.change_reason(p_prior_rec.CHANGE_REASON_CODE);
1427: x_header_adj_changed_attr_tbl(ind).current_id := p_curr_rec.CHANGE_REASON_CODE;
1428: x_header_adj_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.change_reason(p_curr_rec.CHANGE_REASON_CODE);
1429: x_header_adj_changed_attr_tbl(ind).next_id := p_next_rec.CHANGE_REASON_CODE;
1430: x_header_adj_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.change_reason(p_next_rec.CHANGE_REASON_CODE);
1431: END IF;
1432: END IF; /* NEXT */
1426: x_header_adj_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.change_reason(p_prior_rec.CHANGE_REASON_CODE);
1427: x_header_adj_changed_attr_tbl(ind).current_id := p_curr_rec.CHANGE_REASON_CODE;
1428: x_header_adj_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.change_reason(p_curr_rec.CHANGE_REASON_CODE);
1429: x_header_adj_changed_attr_tbl(ind).next_id := p_next_rec.CHANGE_REASON_CODE;
1430: x_header_adj_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.change_reason(p_next_rec.CHANGE_REASON_CODE);
1431: END IF;
1432: END IF; /* NEXT */
1433:
1434: /* END CHANGE_REASON_CODE*/
1445: null;
1446: ELSE
1447: ind := ind+1;
1448: prior_exists := 'Y';
1449: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1450: x_header_adj_changed_attr_tbl(ind).attribute_name := 'CHANGE_REASON_TEXT';
1451: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.CHANGE_REASON_TEXT;
1452: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.CHANGE_REASON_TEXT;
1453: END IF;
1463: ELSE
1464: IF prior_exists = 'N' THEN
1465: ind := ind+1;
1466: END IF;
1467: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1468: x_header_adj_changed_attr_tbl(ind).attribute_name := 'CHANGE_REASON_TEXT';
1469: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.CHANGE_REASON_TEXT;
1470: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.CHANGE_REASON_TEXT;
1471: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.CHANGE_REASON_TEXT;
1487: null;
1488: ELSE
1489: ind := ind+1;
1490: prior_exists := 'Y';
1491: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1492: x_header_adj_changed_attr_tbl(ind).attribute_name := 'list_line_no';
1493: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.list_line_no;
1494: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.list_line_no;
1495: END IF;
1505: ELSE
1506: IF prior_exists = 'N' THEN
1507: ind := ind+1;
1508: END IF;
1509: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1510: x_header_adj_changed_attr_tbl(ind).attribute_name := 'list_line_no';
1511: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.list_line_no;
1512: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.list_line_no;
1513: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.list_line_no;
1527: null;
1528: ELSE
1529: ind := ind+1;
1530: prior_exists := 'Y';
1531: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1532: x_header_adj_changed_attr_tbl(ind).attribute_name := 'source_system_code';
1533: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.source_system_code;
1534: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.source_system_code;
1535: END IF;
1545: ELSE
1546: IF prior_exists = 'N' THEN
1547: ind := ind+1;
1548: END IF;
1549: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1550: x_header_adj_changed_attr_tbl(ind).attribute_name := 'source_system_code';
1551: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.source_system_code;
1552: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.source_system_code;
1553: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.source_system_code;
1568: null;
1569: ELSE
1570: ind := ind+1;
1571: prior_exists := 'Y';
1572: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1573: x_header_adj_changed_attr_tbl(ind).attribute_name := 'benefit_qty';
1574: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.benefit_qty;
1575: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.benefit_qty;
1576: END IF;
1586: ELSE
1587: IF prior_exists = 'N' THEN
1588: ind := ind+1;
1589: END IF;
1590: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1591: x_header_adj_changed_attr_tbl(ind).attribute_name := 'benefit_qty';
1592: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.benefit_qty;
1593: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.benefit_qty;
1594: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.benefit_qty;
1609: null;
1610: ELSE
1611: ind := ind+1;
1612: prior_exists := 'Y';
1613: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1614: x_header_adj_changed_attr_tbl(ind).attribute_name := 'benefit_uom_code';
1615: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.benefit_uom_code;
1616: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.benefit_uom_code;
1617: END IF;
1627: ELSE
1628: IF prior_exists = 'N' THEN
1629: ind := ind+1;
1630: END IF;
1631: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1632: x_header_adj_changed_attr_tbl(ind).attribute_name := 'benefit_uom_code';
1633: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.benefit_uom_code;
1634: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.benefit_uom_code;
1635: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.benefit_uom_code;
1650: null;
1651: ELSE
1652: ind := ind+1;
1653: prior_exists := 'Y';
1654: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1655: x_header_adj_changed_attr_tbl(ind).attribute_name := 'expiration_date';
1656: x_header_adj_changed_attr_tbl(ind).current_value := to_char(p_curr_rec.expiration_date,'DD-MON-YYYY HH24:MI:SS');
1657: x_header_adj_changed_attr_tbl(ind).prior_value := to_char(p_prior_rec.expiration_date,'DD-MON-YYYY HH24:MI:SS');
1658: END IF;
1668: ELSE
1669: IF prior_exists = 'N' THEN
1670: ind := ind+1;
1671: END IF;
1672: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1673: x_header_adj_changed_attr_tbl(ind).attribute_name := 'expiration_date';
1674: x_header_adj_changed_attr_tbl(ind).prior_value := to_char(p_prior_rec.expiration_date,'DD-MON-YYYY HH24:MI:SS');
1675: x_header_adj_changed_attr_tbl(ind).current_value := to_char(p_curr_rec.expiration_date,'DD-MON-YYYY HH24:MI:SS');
1676: x_header_adj_changed_attr_tbl(ind).next_value := to_char(p_next_rec.expiration_date,'DD-MON-YYYY HH24:MI:SS');
1691: null;
1692: ELSE
1693: ind := ind+1;
1694: prior_exists := 'Y';
1695: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1696: x_header_adj_changed_attr_tbl(ind).attribute_name := 'rebate_transaction_type_code';
1697: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.rebate_transaction_type_code;
1698: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.rebate_transaction_type_code;
1699: END IF;
1709: ELSE
1710: IF prior_exists = 'N' THEN
1711: ind := ind+1;
1712: END IF;
1713: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1714: x_header_adj_changed_attr_tbl(ind).attribute_name := 'rebate_transaction_type_code';
1715: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.rebate_transaction_type_code;
1716: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.rebate_transaction_type_code;
1717: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.rebate_transaction_type_code;
1732: null;
1733: ELSE
1734: ind := ind+1;
1735: prior_exists := 'Y';
1736: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1737: x_header_adj_changed_attr_tbl(ind).attribute_name := 'rebate_transaction_reference';
1738: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.rebate_transaction_reference;
1739: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.rebate_transaction_reference;
1740: END IF;
1750: ELSE
1751: IF prior_exists = 'N' THEN
1752: ind := ind+1;
1753: END IF;
1754: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1755: x_header_adj_changed_attr_tbl(ind).attribute_name := 'rebate_transaction_reference';
1756: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.rebate_transaction_reference;
1757: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.rebate_transaction_reference;
1758: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.rebate_transaction_reference;
1773: null;
1774: ELSE
1775: ind := ind+1;
1776: prior_exists := 'Y';
1777: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1778: x_header_adj_changed_attr_tbl(ind).attribute_name := 'rebate_payment_system_code';
1779: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.rebate_payment_system_code;
1780: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.rebate_payment_system_code;
1781: END IF;
1791: ELSE
1792: IF prior_exists = 'N' THEN
1793: ind := ind+1;
1794: END IF;
1795: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1796: x_header_adj_changed_attr_tbl(ind).attribute_name := 'rebate_payment_system_code';
1797: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.rebate_payment_system_code;
1798: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.rebate_payment_system_code;
1799: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.rebate_payment_system_code;
1814: null;
1815: ELSE
1816: ind := ind+1;
1817: prior_exists := 'Y';
1818: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1819: x_header_adj_changed_attr_tbl(ind).attribute_name := 'redeemed_date';
1820: x_header_adj_changed_attr_tbl(ind).current_value := to_char(p_curr_rec.redeemed_date,'DD-MON-YYYY HH24:MI:SS');
1821: x_header_adj_changed_attr_tbl(ind).prior_value := to_char(p_prior_rec.redeemed_date,'DD-MON-YYYY HH24:MI:SS');
1822: END IF;
1832: ELSE
1833: IF prior_exists = 'N' THEN
1834: ind := ind+1;
1835: END IF;
1836: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1837: x_header_adj_changed_attr_tbl(ind).attribute_name := 'redeemed_date';
1838: x_header_adj_changed_attr_tbl(ind).prior_value := to_char(p_prior_rec.redeemed_date,'DD-MON-YYYY HH24:MI:SS');
1839: x_header_adj_changed_attr_tbl(ind).current_value := to_char(p_curr_rec.redeemed_date,'DD-MON-YYYY HH24:MI:SS');
1840: x_header_adj_changed_attr_tbl(ind).next_value := to_char(p_next_rec.redeemed_date,'DD-MON-YYYY HH24:MI:SS');
1855: null;
1856: ELSE
1857: ind := ind+1;
1858: prior_exists := 'Y';
1859: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1860: x_header_adj_changed_attr_tbl(ind).attribute_name := 'redeemed_flag';
1861: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.redeemed_flag;
1862: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.redeemed_flag;
1863: END IF;
1873: ELSE
1874: IF prior_exists = 'N' THEN
1875: ind := ind+1;
1876: END IF;
1877: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1878: x_header_adj_changed_attr_tbl(ind).attribute_name := 'redeemed_flag';
1879: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.redeemed_flag;
1880: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.redeemed_flag;
1881: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.redeemed_flag;
1896: null;
1897: ELSE
1898: ind := ind+1;
1899: prior_exists := 'Y';
1900: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1901: x_header_adj_changed_attr_tbl(ind).attribute_name := 'accrual_flag';
1902: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.accrual_flag;
1903: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.accrual_flag;
1904: END IF;
1914: ELSE
1915: IF prior_exists = 'N' THEN
1916: ind := ind+1;
1917: END IF;
1918: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1919: x_header_adj_changed_attr_tbl(ind).attribute_name := 'accrual_flag';
1920: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.accrual_flag;
1921: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.accrual_flag;
1922: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.accrual_flag;
1937: null;
1938: ELSE
1939: ind := ind+1;
1940: prior_exists := 'Y';
1941: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1942: x_header_adj_changed_attr_tbl(ind).attribute_name := 'range_break_quantity';
1943: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.range_break_quantity;
1944: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.range_break_quantity;
1945: END IF;
1955: ELSE
1956: IF prior_exists = 'N' THEN
1957: ind := ind+1;
1958: END IF;
1959: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1960: x_header_adj_changed_attr_tbl(ind).attribute_name := 'range_break_quantity';
1961: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.range_break_quantity;
1962: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.range_break_quantity;
1963: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.range_break_quantity;
1978: null;
1979: ELSE
1980: ind := ind+1;
1981: prior_exists := 'Y';
1982: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
1983: x_header_adj_changed_attr_tbl(ind).attribute_name := 'accrual_conversion_rate';
1984: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.accrual_conversion_rate;
1985: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.accrual_conversion_rate;
1986: END IF;
1996: ELSE
1997: IF prior_exists = 'N' THEN
1998: ind := ind+1;
1999: END IF;
2000: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2001: x_header_adj_changed_attr_tbl(ind).attribute_name := 'accrual_conversion_rate';
2002: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.accrual_conversion_rate;
2003: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.accrual_conversion_rate;
2004: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.accrual_conversion_rate;
2019: null;
2020: ELSE
2021: ind := ind+1;
2022: prior_exists := 'Y';
2023: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2024: x_header_adj_changed_attr_tbl(ind).attribute_name := 'modifier_level_code';
2025: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.modifier_level_code;
2026: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.modifier_level_code;
2027: END IF;
2037: ELSE
2038: IF prior_exists = 'N' THEN
2039: ind := ind+1;
2040: END IF;
2041: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2042: x_header_adj_changed_attr_tbl(ind).attribute_name := 'modifier_level_code';
2043: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.modifier_level_code;
2044: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.modifier_level_code;
2045: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.modifier_level_code;
2060: null;
2061: ELSE
2062: ind := ind+1;
2063: prior_exists := 'Y';
2064: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2065: x_header_adj_changed_attr_tbl(ind).attribute_name := 'price_break_type_code';
2066: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.price_break_type_code;
2067: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.price_break_type_code;
2068: END IF;
2078: ELSE
2079: IF prior_exists = 'N' THEN
2080: ind := ind+1;
2081: END IF;
2082: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2083: x_header_adj_changed_attr_tbl(ind).attribute_name := 'price_break_type_code';
2084: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.price_break_type_code;
2085: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.price_break_type_code;
2086: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.price_break_type_code;
2101: null;
2102: ELSE
2103: ind := ind+1;
2104: prior_exists := 'Y';
2105: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2106: x_header_adj_changed_attr_tbl(ind).attribute_name := 'substitution_attribute';
2107: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.substitution_attribute;
2108: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.substitution_attribute;
2109: END IF;
2119: ELSE
2120: IF prior_exists = 'N' THEN
2121: ind := ind+1;
2122: END IF;
2123: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2124: x_header_adj_changed_attr_tbl(ind).attribute_name := 'substitution_attribute';
2125: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.substitution_attribute;
2126: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.substitution_attribute;
2127: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.substitution_attribute;
2142: null;
2143: ELSE
2144: ind := ind+1;
2145: prior_exists := 'Y';
2146: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2147: x_header_adj_changed_attr_tbl(ind).attribute_name := 'proration_type_code';
2148: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.proration_type_code;
2149: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.proration_type_code;
2150: END IF;
2160: ELSE
2161: IF prior_exists = 'N' THEN
2162: ind := ind+1;
2163: END IF;
2164: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2165: x_header_adj_changed_attr_tbl(ind).attribute_name := 'proration_type_code';
2166: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.proration_type_code;
2167: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.proration_type_code;
2168: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.proration_type_code;
2200: ELSE
2201: IF prior_exists = 'N' THEN
2202: ind := ind+1;
2203: END IF;
2204: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2205: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute1';
2206: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute1;
2207: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute1;
2208: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute1;
2222: p_prior_rec.ac_attribute2) THEN
2223: null;
2224: ELSE
2225: ind := ind+1;
2226: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2227: prior_exists := 'Y';
2228: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute2';
2229: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute2;
2230: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute2;
2241: ELSE
2242: IF prior_exists = 'N' THEN
2243: ind := ind+1;
2244: END IF;
2245: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2246: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute2';
2247: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute2;
2248: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute2;
2249: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute2;
2263: null;
2264: ELSE
2265: ind := ind+1;
2266: prior_exists := 'Y';
2267: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2268: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute3';
2269: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute3;
2270: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute3;
2271: END IF;
2281: ELSE
2282: IF prior_exists = 'N' THEN
2283: ind := ind+1;
2284: END IF;
2285: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2286: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute3';
2287: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute3;
2288: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute3;
2289: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute3;
2304: null;
2305: ELSE
2306: ind := ind+1;
2307: prior_exists := 'Y';
2308: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2309: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute4';
2310: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute4;
2311: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute4;
2312: END IF;
2322: ELSE
2323: IF prior_exists = 'N' THEN
2324: ind := ind+1;
2325: END IF;
2326: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2327: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute4';
2328: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute4;
2329: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute4;
2330: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute4;
2344: null;
2345: ELSE
2346: ind := ind+1;
2347: prior_exists := 'Y';
2348: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2349: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute5';
2350: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute5;
2351: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute5;
2352: END IF;
2362: ELSE
2363: IF prior_exists = 'N' THEN
2364: ind := ind+1;
2365: END IF;
2366: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2367: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute5';
2368: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute5;
2369: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute5;
2370: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute5;
2385: null;
2386: ELSE
2387: ind := ind+1;
2388: prior_exists := 'Y';
2389: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2390: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute6';
2391: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute6;
2392: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute6;
2393: END IF;
2403: ELSE
2404: IF prior_exists = 'N' THEN
2405: ind := ind+1;
2406: END IF;
2407: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2408: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute6';
2409: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute6;
2410: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute6;
2411: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute6;
2425: null;
2426: ELSE
2427: ind := ind+1;
2428: prior_exists := 'Y';
2429: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2430: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute7';
2431: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute7;
2432: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute7;
2433: END IF;
2443: ELSE
2444: IF prior_exists = 'N' THEN
2445: ind := ind+1;
2446: END IF;
2447: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2448: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute7;
2449: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute7';
2450: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute7;
2451: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute7;
2466: null;
2467: ELSE
2468: ind := ind+1;
2469: prior_exists := 'Y';
2470: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2471: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute8';
2472: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute8;
2473: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute8;
2474: END IF;
2484: ELSE
2485: IF prior_exists = 'N' THEN
2486: ind := ind+1;
2487: END IF;
2488: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2489: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute8';
2490: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute8;
2491: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute8;
2492: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute8;
2506: null;
2507: ELSE
2508: ind := ind+1;
2509: prior_exists := 'Y';
2510: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2511: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute9';
2512: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute9;
2513: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute9;
2514: END IF;
2524: ELSE
2525: IF prior_exists = 'N' THEN
2526: ind := ind+1;
2527: END IF;
2528: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2529: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute9';
2530: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute9;
2531: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute9;
2532: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute9;
2547: null;
2548: ELSE
2549: ind := ind+1;
2550: prior_exists := 'Y';
2551: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2552: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute10';
2553: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute10;
2554: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute10;
2555: END IF;
2565: ELSE
2566: IF prior_exists = 'N' THEN
2567: ind := ind+1;
2568: END IF;
2569: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2570: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute10';
2571: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute10;
2572: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute10;
2573: END IF;
2587: null;
2588: ELSE
2589: ind := ind+1;
2590: prior_exists := 'Y';
2591: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2592: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute11';
2593: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute11;
2594: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute11;
2595: END IF;
2605: ELSE
2606: IF prior_exists = 'N' THEN
2607: ind := ind+1;
2608: END IF;
2609: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2610: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute11';
2611: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute10;
2612: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute11;
2613: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute11;
2628: null;
2629: ELSE
2630: ind := ind+1;
2631: prior_exists := 'Y';
2632: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2633: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute12';
2634: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute12;
2635: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute12;
2636: END IF;
2646: ELSE
2647: IF prior_exists = 'N' THEN
2648: ind := ind+1;
2649: END IF;
2650: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2651: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute12';
2652: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute12;
2653: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute12;
2654: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute12;
2669: null;
2670: ELSE
2671: ind := ind+1;
2672: prior_exists := 'Y';
2673: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2674: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute13';
2675: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute13;
2676: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute13;
2677: END IF;
2687: ELSE
2688: IF prior_exists = 'N' THEN
2689: ind := ind+1;
2690: END IF;
2691: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2692: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute13';
2693: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute13;
2694: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute13;
2695: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute13;
2710: null;
2711: ELSE
2712: ind := ind+1;
2713: prior_exists := 'Y';
2714: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2715: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute14';
2716: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute14;
2717: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute14;
2718: END IF;
2728: ELSE
2729: IF prior_exists = 'N' THEN
2730: ind := ind+1;
2731: END IF;
2732: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2733: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute14';
2734: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute14;
2735: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute14;
2736: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute14;
2751: null;
2752: ELSE
2753: ind := ind+1;
2754: prior_exists := 'Y';
2755: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2756: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute15';
2757: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute15;
2758: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute15;
2759: END IF;
2769: ELSE
2770: IF prior_exists = 'N' THEN
2771: ind := ind+1;
2772: END IF;
2773: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2774: x_header_adj_changed_attr_tbl(ind).attribute_name := 'attribute15';
2775: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute15;
2776: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute15;
2777: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute15;
2792: null;
2793: ELSE
2794: ind := ind+1;
2795: prior_exists := 'Y';
2796: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2797: x_header_adj_changed_attr_tbl(ind).attribute_name := 'ac_context';
2798: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_context;
2799: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_context;
2800: END IF;
2810: ELSE
2811: IF prior_exists = 'N' THEN
2812: ind := ind+1;
2813: END IF;
2814: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2815: x_header_adj_changed_attr_tbl(ind).attribute_name := 'ac_context';
2816: x_header_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_context;
2817: x_header_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_context;
2818: x_header_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_context;
2839: IF l_debug_level > 0 THEN
2840: oe_debug_pub.add(' Prior is not there - current is there');
2841: END IF;
2842: ind := ind+1;
2843: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2844: x_header_adj_changed_attr_tbl(ind).prior_value := null;
2845: x_header_adj_changed_attr_tbl(ind).current_value := 'ADD';
2846: x_header_adj_changed_attr_tbl(ind).next_value := null;
2847: ELSIF (p_curr_rec_exists = 'N' and p_next_rec_exists = 'Y') THEN
2848: IF l_debug_level > 0 THEN
2849: oe_debug_pub.add(' Current is not there - next is there');
2850: END IF;
2851: ind := ind+1;
2852: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_next_rec.list_header_id);
2853: x_header_adj_changed_attr_tbl(ind).prior_value := null;
2854: x_header_adj_changed_attr_tbl(ind).current_value := null;
2855: x_header_adj_changed_attr_tbl(ind).next_value := 'ADD';
2856: end if;
2869: IF l_debug_level > 0 THEN
2870: oe_debug_pub.add(' Prior is there - current is not there');
2871: END IF;
2872: ind := ind+1;
2873: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_prior_rec.list_header_id);
2874: x_header_adj_changed_attr_tbl(ind).prior_value := null;
2875: x_header_adj_changed_attr_tbl(ind).current_value := 'DELETE';
2876: x_header_adj_changed_attr_tbl(ind).next_value := null;
2877: ELSIF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'N' THEN
2883: IF l_debug_level > 0 THEN
2884: oe_debug_pub.add(' Current is there - next is not there');
2885: END IF;
2886: ind := ind+1;
2887: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2888: x_header_adj_changed_attr_tbl(ind).prior_value := null;
2889: x_header_adj_changed_attr_tbl(ind).current_value := null;
2890: x_header_adj_changed_attr_tbl(ind).next_value := 'DELETE';
2891: --end if;
3714: ELSE
3715: ind := ind+1;
3716: prior_exists := 'Y';
3717: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
3718: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
3719: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute1';
3720: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute1;
3721: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute1;
3722: END IF;
3733: IF prior_exists = 'N' THEN
3734: ind := ind+1;
3735: END IF;
3736: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
3737: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
3738: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute1';
3739: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute1;
3740: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute1;
3741: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute1;
3757: ELSE
3758: ind := ind+1;
3759: prior_exists := 'Y';
3760: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
3761: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
3762: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute2';
3763: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute2;
3764: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute2;
3765: END IF;
3776: IF prior_exists = 'N' THEN
3777: ind := ind+1;
3778: END IF;
3779: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
3780: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
3781: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute2';
3782: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute2;
3783: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute2;
3784: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute2;
3799: ELSE
3800: ind := ind+1;
3801: prior_exists := 'Y';
3802: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
3803: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
3804: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute3';
3805: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute3;
3806: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute3;
3807: END IF;
3818: IF prior_exists = 'N' THEN
3819: ind := ind+1;
3820: END IF;
3821: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
3822: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
3823: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute3';
3824: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute3;
3825: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute3;
3826: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute3;
3842: ELSE
3843: ind := ind+1;
3844: prior_exists := 'Y';
3845: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
3846: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
3847: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute4';
3848: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute4;
3849: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute4;
3850: END IF;
3861: IF prior_exists = 'N' THEN
3862: ind := ind+1;
3863: END IF;
3864: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
3865: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
3866: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute4';
3867: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute4;
3868: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute4;
3869: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute4;
3884: ELSE
3885: ind := ind+1;
3886: prior_exists := 'Y';
3887: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
3888: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
3889: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute5';
3890: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute5;
3891: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute5;
3892: END IF;
3903: IF prior_exists = 'N' THEN
3904: ind := ind+1;
3905: END IF;
3906: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
3907: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
3908: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute5';
3909: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute5;
3910: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute5;
3911: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute5;
3927: ELSE
3928: ind := ind+1;
3929: prior_exists := 'Y';
3930: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
3931: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
3932: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute6';
3933: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute6;
3934: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute6;
3935: END IF;
3947: ind := ind+1;
3948: END IF;
3949: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
3950: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute6';
3951: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
3952: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute6;
3953: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute6;
3954: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute6;
3955: END IF;
3969: ELSE
3970: ind := ind+1;
3971: prior_exists := 'Y';
3972: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
3973: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
3974: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute7';
3975: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute7;
3976: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute7;
3977: END IF;
3988: IF prior_exists = 'N' THEN
3989: ind := ind+1;
3990: END IF;
3991: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
3992: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
3993: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute7';
3994: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute7;
3995: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute7;
3996: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute7;
4012: ELSE
4013: ind := ind+1;
4014: prior_exists := 'Y';
4015: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4016: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4017: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute8';
4018: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute8;
4019: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute8;
4020: END IF;
4031: IF prior_exists = 'N' THEN
4032: ind := ind+1;
4033: END IF;
4034: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4035: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4036: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute8';
4037: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute8;
4038: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute8;
4039: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute8;
4054: ELSE
4055: ind := ind+1;
4056: prior_exists := 'Y';
4057: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4058: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4059: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute9';
4060: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute9;
4061: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute9;
4062: END IF;
4073: IF prior_exists = 'N' THEN
4074: ind := ind+1;
4075: END IF;
4076: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4077: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4078: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute9';
4079: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute9;
4080: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute9;
4081: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute9;
4097: ELSE
4098: ind := ind+1;
4099: prior_exists := 'Y';
4100: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4101: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4102: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute10';
4103: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute10;
4104: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute10;
4105: END IF;
4116: IF prior_exists = 'N' THEN
4117: ind := ind+1;
4118: END IF;
4119: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4120: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4121: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute10';
4122: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute10;
4123: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute10;
4124: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute10;
4140: ELSE
4141: ind := ind+1;
4142: prior_exists := 'Y';
4143: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4144: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4145: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute11';
4146: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute11;
4147: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute11;
4148: END IF;
4159: IF prior_exists = 'N' THEN
4160: ind := ind+1;
4161: END IF;
4162: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4163: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4164: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute11';
4165: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute11;
4166: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute11;
4167: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute11;
4183: ELSE
4184: ind := ind+1;
4185: prior_exists := 'Y';
4186: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4187: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4188: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute12';
4189: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute12;
4190: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute12;
4191: END IF;
4202: IF prior_exists = 'N' THEN
4203: ind := ind+1;
4204: END IF;
4205: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4206: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4207: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute12';
4208: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute12;
4209: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute12;
4210: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute12;
4226: ELSE
4227: ind := ind+1;
4228: prior_exists := 'Y';
4229: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4230: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4231: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute13';
4232: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute13;
4233: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute13;
4234: END IF;
4245: IF prior_exists = 'N' THEN
4246: ind := ind+1;
4247: END IF;
4248: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4249: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4250: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute13';
4251: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute13;
4252: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute13;
4253: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute13;
4269: ELSE
4270: ind := ind+1;
4271: prior_exists := 'Y';
4272: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4273: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4274: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute14';
4275: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute14;
4276: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute14;
4277: END IF;
4288: IF prior_exists = 'N' THEN
4289: ind := ind+1;
4290: END IF;
4291: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4292: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4293: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute14';
4294: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute14;
4295: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute14;
4296: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute14;
4312: ELSE
4313: ind := ind+1;
4314: prior_exists := 'Y';
4315: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4316: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4317: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute15';
4318: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute15;
4319: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute15;
4320: END IF;
4331: IF prior_exists = 'N' THEN
4332: ind := ind+1;
4333: END IF;
4334: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4335: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4336: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute15';
4337: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.attribute15;
4338: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.attribute15;
4339: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.attribute15;
4354: ELSE
4355: ind := ind+1;
4356: prior_exists := 'Y';
4357: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4358: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4359: x_line_adj_changed_attr_tbl(ind).attribute_name := 'context';
4360: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.context;
4361: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.context;
4362: END IF;
4373: IF prior_exists = 'N' THEN
4374: ind := ind+1;
4375: END IF;
4376: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4377: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4378: x_line_adj_changed_attr_tbl(ind).attribute_name := 'context';
4379: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.context;
4380: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.context;
4381: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.context;
4398: ELSE
4399: ind := ind+1;
4400: prior_exists := 'Y';
4401: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4402: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4403: x_line_adj_changed_attr_tbl(ind).attribute_name := 'AUTOMATIC_FLAG';
4404: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.AUTOMATIC_FLAG;
4405: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.AUTOMATIC_FLAG;
4406: END IF;
4417: IF prior_exists = 'N' THEN
4418: ind := ind+1;
4419: END IF;
4420: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4421: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4422: x_line_adj_changed_attr_tbl(ind).attribute_name := 'AUTOMATIC_FLAG';
4423: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.AUTOMATIC_FLAG;
4424: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.AUTOMATIC_FLAG;
4425: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.AUTOMATIC_FLAG;
4441: ELSE
4442: ind := ind+1;
4443: prior_exists := 'Y';
4444: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4445: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4446: x_line_adj_changed_attr_tbl(ind).attribute_name := 'LIST_LINE_TYPE';
4447: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.LIST_LINE_TYPE_CODE;
4448: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.LIST_LINE_TYPE_CODE;
4449: END IF;
4460: IF prior_exists = 'N' THEN
4461: ind := ind+1;
4462: END IF;
4463: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4464: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4465: x_line_adj_changed_attr_tbl(ind).attribute_name := 'LIST_LINE_TYPE';
4466: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.LIST_LINE_TYPE_CODE;
4467: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.LIST_LINE_TYPE_CODE;
4468: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.LIST_LINE_TYPE_CODE;
4485: ELSE
4486: ind := ind+1;
4487: prior_exists := 'Y';
4488: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4489: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4490: x_line_adj_changed_attr_tbl(ind).attribute_name := 'CHANGE_REASON_CODE';
4491: x_line_adj_changed_attr_tbl(ind).prior_id := p_prior_rec.CHANGE_REASON_CODE;
4492: x_line_adj_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.change_reason(p_prior_rec.CHANGE_REASON_CODE);
4493: x_line_adj_changed_attr_tbl(ind).current_id := p_curr_rec.CHANGE_REASON_CODE;
4488: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4489: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4490: x_line_adj_changed_attr_tbl(ind).attribute_name := 'CHANGE_REASON_CODE';
4491: x_line_adj_changed_attr_tbl(ind).prior_id := p_prior_rec.CHANGE_REASON_CODE;
4492: x_line_adj_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.change_reason(p_prior_rec.CHANGE_REASON_CODE);
4493: x_line_adj_changed_attr_tbl(ind).current_id := p_curr_rec.CHANGE_REASON_CODE;
4494: x_line_adj_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.change_reason(p_curr_rec.CHANGE_REASON_CODE);
4495: END IF;
4496: END IF; /* PRIOR */
4490: x_line_adj_changed_attr_tbl(ind).attribute_name := 'CHANGE_REASON_CODE';
4491: x_line_adj_changed_attr_tbl(ind).prior_id := p_prior_rec.CHANGE_REASON_CODE;
4492: x_line_adj_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.change_reason(p_prior_rec.CHANGE_REASON_CODE);
4493: x_line_adj_changed_attr_tbl(ind).current_id := p_curr_rec.CHANGE_REASON_CODE;
4494: x_line_adj_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.change_reason(p_curr_rec.CHANGE_REASON_CODE);
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);
4504: END IF;
4505: ELSE
4506: IF prior_exists = 'N' THEN
4507: ind := ind+1;
4506: IF prior_exists = 'N' THEN
4507: ind := ind+1;
4508: END IF;
4509: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4510: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4511: x_line_adj_changed_attr_tbl(ind).attribute_name := 'CHANGE_REASON_CODE';
4512: x_line_adj_changed_attr_tbl(ind).prior_id := p_prior_rec.CHANGE_REASON_CODE;
4513: x_line_adj_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.change_reason(p_prior_rec.CHANGE_REASON_CODE);
4514: x_line_adj_changed_attr_tbl(ind).current_id := p_curr_rec.CHANGE_REASON_CODE;
4509: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4510: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4511: x_line_adj_changed_attr_tbl(ind).attribute_name := 'CHANGE_REASON_CODE';
4512: x_line_adj_changed_attr_tbl(ind).prior_id := p_prior_rec.CHANGE_REASON_CODE;
4513: x_line_adj_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.change_reason(p_prior_rec.CHANGE_REASON_CODE);
4514: x_line_adj_changed_attr_tbl(ind).current_id := p_curr_rec.CHANGE_REASON_CODE;
4515: x_line_adj_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.change_reason(p_curr_rec.CHANGE_REASON_CODE);
4516: x_line_adj_changed_attr_tbl(ind).next_id := p_next_rec.CHANGE_REASON_CODE;
4517: x_line_adj_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.change_reason(p_next_rec.CHANGE_REASON_CODE);
4511: x_line_adj_changed_attr_tbl(ind).attribute_name := 'CHANGE_REASON_CODE';
4512: x_line_adj_changed_attr_tbl(ind).prior_id := p_prior_rec.CHANGE_REASON_CODE;
4513: x_line_adj_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.change_reason(p_prior_rec.CHANGE_REASON_CODE);
4514: x_line_adj_changed_attr_tbl(ind).current_id := p_curr_rec.CHANGE_REASON_CODE;
4515: x_line_adj_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.change_reason(p_curr_rec.CHANGE_REASON_CODE);
4516: x_line_adj_changed_attr_tbl(ind).next_id := p_next_rec.CHANGE_REASON_CODE;
4517: x_line_adj_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.change_reason(p_next_rec.CHANGE_REASON_CODE);
4518: END IF;
4519: END IF; /* NEXT */
4513: x_line_adj_changed_attr_tbl(ind).prior_value := OE_ID_TO_VALUE.change_reason(p_prior_rec.CHANGE_REASON_CODE);
4514: x_line_adj_changed_attr_tbl(ind).current_id := p_curr_rec.CHANGE_REASON_CODE;
4515: x_line_adj_changed_attr_tbl(ind).current_value := OE_ID_TO_VALUE.change_reason(p_curr_rec.CHANGE_REASON_CODE);
4516: x_line_adj_changed_attr_tbl(ind).next_id := p_next_rec.CHANGE_REASON_CODE;
4517: x_line_adj_changed_attr_tbl(ind).next_value := OE_ID_TO_VALUE.change_reason(p_next_rec.CHANGE_REASON_CODE);
4518: END IF;
4519: END IF; /* NEXT */
4520:
4521: /* END CHANGE_REASON_CODE*/
4533: ELSE
4534: ind := ind+1;
4535: prior_exists := 'Y';
4536: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4537: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4538: x_line_adj_changed_attr_tbl(ind).attribute_name := 'CHANGE_REASON_TEXT';
4539: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.CHANGE_REASON_TEXT;
4540: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.CHANGE_REASON_TEXT;
4541: END IF;
4552: IF prior_exists = 'N' THEN
4553: ind := ind+1;
4554: END IF;
4555: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4556: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4557: x_line_adj_changed_attr_tbl(ind).attribute_name := 'CHANGE_REASON_TEXT';
4558: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.CHANGE_REASON_TEXT;
4559: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.CHANGE_REASON_TEXT;
4560: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.CHANGE_REASON_TEXT;
4576: ELSE
4577: ind := ind+1;
4578: prior_exists := 'Y';
4579: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4580: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4581: x_line_adj_changed_attr_tbl(ind).attribute_name := 'ADJUSTED_AMOUNT';
4582: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ADJUSTED_AMOUNT;
4583: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ADJUSTED_AMOUNT;
4584: END IF;
4595: IF prior_exists = 'N' THEN
4596: ind := ind+1;
4597: END IF;
4598: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4599: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4600: x_line_adj_changed_attr_tbl(ind).attribute_name := 'ADJUSTED_AMOUNT';
4601: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ADJUSTED_AMOUNT;
4602: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ADJUSTED_AMOUNT;
4603: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.ADJUSTED_AMOUNT;
4620: ELSE
4621: ind := ind+1;
4622: prior_exists := 'Y';
4623: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4624: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4625: x_line_adj_changed_attr_tbl(ind).attribute_name := 'list_line_no';
4626: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.list_line_no;
4627: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.list_line_no;
4628: END IF;
4639: IF prior_exists = 'N' THEN
4640: ind := ind+1;
4641: END IF;
4642: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4643: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4644: x_line_adj_changed_attr_tbl(ind).attribute_name := 'list_line_no';
4645: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.list_line_no;
4646: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.list_line_no;
4647: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.list_line_no;
4662: ELSE
4663: ind := ind+1;
4664: prior_exists := 'Y';
4665: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4666: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4667: x_line_adj_changed_attr_tbl(ind).attribute_name := 'source_system_code';
4668: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.source_system_code;
4669: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.source_system_code;
4670: END IF;
4681: IF prior_exists = 'N' THEN
4682: ind := ind+1;
4683: END IF;
4684: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4685: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4686: x_line_adj_changed_attr_tbl(ind).attribute_name := 'source_system_code';
4687: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.source_system_code;
4688: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.source_system_code;
4689: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.source_system_code;
4705: ELSE
4706: ind := ind+1;
4707: prior_exists := 'Y';
4708: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4709: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4710: x_line_adj_changed_attr_tbl(ind).attribute_name := 'benefit_qty';
4711: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.benefit_qty;
4712: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.benefit_qty;
4713: END IF;
4724: IF prior_exists = 'N' THEN
4725: ind := ind+1;
4726: END IF;
4727: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4728: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4729: x_line_adj_changed_attr_tbl(ind).attribute_name := 'benefit_qty';
4730: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.benefit_qty;
4731: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.benefit_qty;
4732: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.benefit_qty;
4748: ELSE
4749: ind := ind+1;
4750: prior_exists := 'Y';
4751: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4752: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4753: x_line_adj_changed_attr_tbl(ind).attribute_name := 'benefit_uom_code';
4754: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.benefit_uom_code;
4755: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.benefit_uom_code;
4756: END IF;
4767: IF prior_exists = 'N' THEN
4768: ind := ind+1;
4769: END IF;
4770: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4771: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4772: x_line_adj_changed_attr_tbl(ind).attribute_name := 'benefit_uom_code';
4773: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.benefit_uom_code;
4774: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.benefit_uom_code;
4775: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.benefit_uom_code;
4791: ELSE
4792: ind := ind+1;
4793: prior_exists := 'Y';
4794: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4795: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4796: x_line_adj_changed_attr_tbl(ind).attribute_name := 'expiration_date';
4797: x_line_adj_changed_attr_tbl(ind).current_value := to_char(p_curr_rec.expiration_date,'DD-MON-YYYY HH24:MI:SS');
4798: x_line_adj_changed_attr_tbl(ind).prior_value := to_char(p_prior_rec.expiration_date,'DD-MON-YYYY HH24:MI:SS');
4799: END IF;
4810: IF prior_exists = 'N' THEN
4811: ind := ind+1;
4812: END IF;
4813: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4814: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4815: x_line_adj_changed_attr_tbl(ind).attribute_name := 'expiration_date';
4816: x_line_adj_changed_attr_tbl(ind).prior_value := to_char(p_prior_rec.expiration_date,'DD-MON-YYYY HH24:MI:SS');
4817: x_line_adj_changed_attr_tbl(ind).current_value := to_char(p_curr_rec.expiration_date,'DD-MON-YYYY HH24:MI:SS');
4818: x_line_adj_changed_attr_tbl(ind).next_value := to_char(p_next_rec.expiration_date,'DD-MON-YYYY HH24:MI:SS');
4834: ELSE
4835: ind := ind+1;
4836: prior_exists := 'Y';
4837: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4838: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4839: x_line_adj_changed_attr_tbl(ind).attribute_name := 'rebate_transaction_type_code';
4840: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.rebate_transaction_type_code;
4841: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.rebate_transaction_type_code;
4842: END IF;
4853: IF prior_exists = 'N' THEN
4854: ind := ind+1;
4855: END IF;
4856: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4857: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4858: x_line_adj_changed_attr_tbl(ind).attribute_name := 'rebate_transaction_type_code';
4859: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.rebate_transaction_type_code;
4860: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.rebate_transaction_type_code;
4861: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.rebate_transaction_type_code;
4877: ELSE
4878: ind := ind+1;
4879: prior_exists := 'Y';
4880: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4881: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4882: x_line_adj_changed_attr_tbl(ind).attribute_name := 'rebate_transaction_reference';
4883: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.rebate_transaction_reference;
4884: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.rebate_transaction_reference;
4885: END IF;
4896: IF prior_exists = 'N' THEN
4897: ind := ind+1;
4898: END IF;
4899: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4900: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4901: x_line_adj_changed_attr_tbl(ind).attribute_name := 'rebate_transaction_reference';
4902: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.rebate_transaction_reference;
4903: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.rebate_transaction_reference;
4904: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.rebate_transaction_reference;
4920: ELSE
4921: ind := ind+1;
4922: prior_exists := 'Y';
4923: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4924: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4925: x_line_adj_changed_attr_tbl(ind).attribute_name := 'rebate_payment_system_code';
4926: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.rebate_payment_system_code;
4927: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.rebate_payment_system_code;
4928: END IF;
4939: IF prior_exists = 'N' THEN
4940: ind := ind+1;
4941: END IF;
4942: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4943: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4944: x_line_adj_changed_attr_tbl(ind).attribute_name := 'rebate_payment_system_code';
4945: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.rebate_payment_system_code;
4946: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.rebate_payment_system_code;
4947: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.rebate_payment_system_code;
4963: ELSE
4964: ind := ind+1;
4965: prior_exists := 'Y';
4966: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4967: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4968: x_line_adj_changed_attr_tbl(ind).attribute_name := 'redeemed_date';
4969: x_line_adj_changed_attr_tbl(ind).current_value := to_char(p_curr_rec.redeemed_date,'DD-MON-YYYY HH24:MI:SS');
4970: x_line_adj_changed_attr_tbl(ind).prior_value := to_char(p_prior_rec.redeemed_date,'DD-MON-YYYY HH24:MI:SS');
4971: END IF;
4982: IF prior_exists = 'N' THEN
4983: ind := ind+1;
4984: END IF;
4985: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
4986: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
4987: x_line_adj_changed_attr_tbl(ind).attribute_name := 'redeemed_date';
4988: x_line_adj_changed_attr_tbl(ind).prior_value := to_char(p_prior_rec.redeemed_date,'DD-MON-YYYY HH24:MI:SS');
4989: x_line_adj_changed_attr_tbl(ind).current_value := to_char(p_curr_rec.redeemed_date,'DD-MON-YYYY HH24:MI:SS');
4990: x_line_adj_changed_attr_tbl(ind).next_value := to_char(p_next_rec.redeemed_date,'DD-MON-YYYY HH24:MI:SS');
5006: ELSE
5007: ind := ind+1;
5008: prior_exists := 'Y';
5009: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5010: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5011: x_line_adj_changed_attr_tbl(ind).attribute_name := 'redeemed_flag';
5012: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.redeemed_flag;
5013: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.redeemed_flag;
5014: END IF;
5025: IF prior_exists = 'N' THEN
5026: ind := ind+1;
5027: END IF;
5028: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5029: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5030: x_line_adj_changed_attr_tbl(ind).attribute_name := 'redeemed_flag';
5031: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.redeemed_flag;
5032: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.redeemed_flag;
5033: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.redeemed_flag;
5049: ELSE
5050: ind := ind+1;
5051: prior_exists := 'Y';
5052: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5053: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5054: x_line_adj_changed_attr_tbl(ind).attribute_name := 'accrual_flag';
5055: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.accrual_flag;
5056: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.accrual_flag;
5057: END IF;
5068: IF prior_exists = 'N' THEN
5069: ind := ind+1;
5070: END IF;
5071: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5072: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5073: x_line_adj_changed_attr_tbl(ind).attribute_name := 'accrual_flag';
5074: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.accrual_flag;
5075: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.accrual_flag;
5076: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.accrual_flag;
5092: ELSE
5093: ind := ind+1;
5094: prior_exists := 'Y';
5095: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5096: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5097: x_line_adj_changed_attr_tbl(ind).attribute_name := 'range_break_quantity';
5098: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.range_break_quantity;
5099: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.range_break_quantity;
5100: END IF;
5111: IF prior_exists = 'N' THEN
5112: ind := ind+1;
5113: END IF;
5114: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5115: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5116: x_line_adj_changed_attr_tbl(ind).attribute_name := 'range_break_quantity';
5117: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.range_break_quantity;
5118: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.range_break_quantity;
5119: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.range_break_quantity;
5135: ELSE
5136: ind := ind+1;
5137: prior_exists := 'Y';
5138: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5139: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5140: x_line_adj_changed_attr_tbl(ind).attribute_name := 'accrual_conversion_rate';
5141: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.accrual_conversion_rate;
5142: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.accrual_conversion_rate;
5143: END IF;
5154: IF prior_exists = 'N' THEN
5155: ind := ind+1;
5156: END IF;
5157: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5158: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5159: x_line_adj_changed_attr_tbl(ind).attribute_name := 'accrual_conversion_rate';
5160: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.accrual_conversion_rate;
5161: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.accrual_conversion_rate;
5162: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.accrual_conversion_rate;
5178: ELSE
5179: ind := ind+1;
5180: prior_exists := 'Y';
5181: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5182: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5183: x_line_adj_changed_attr_tbl(ind).attribute_name := 'modifier_level_code';
5184: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.modifier_level_code;
5185: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.modifier_level_code;
5186: END IF;
5197: IF prior_exists = 'N' THEN
5198: ind := ind+1;
5199: END IF;
5200: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5201: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5202: x_line_adj_changed_attr_tbl(ind).attribute_name := 'modifier_level_code';
5203: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.modifier_level_code;
5204: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.modifier_level_code;
5205: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.modifier_level_code;
5221: ELSE
5222: ind := ind+1;
5223: prior_exists := 'Y';
5224: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5225: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5226: x_line_adj_changed_attr_tbl(ind).attribute_name := 'price_break_type_code';
5227: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.price_break_type_code;
5228: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.price_break_type_code;
5229: END IF;
5240: IF prior_exists = 'N' THEN
5241: ind := ind+1;
5242: END IF;
5243: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5244: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5245: x_line_adj_changed_attr_tbl(ind).attribute_name := 'price_break_type_code';
5246: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.price_break_type_code;
5247: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.price_break_type_code;
5248: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.price_break_type_code;
5264: ELSE
5265: ind := ind+1;
5266: prior_exists := 'Y';
5267: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5268: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5269: x_line_adj_changed_attr_tbl(ind).attribute_name := 'substitution_attribute';
5270: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.substitution_attribute;
5271: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.substitution_attribute;
5272: END IF;
5283: IF prior_exists = 'N' THEN
5284: ind := ind+1;
5285: END IF;
5286: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5287: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5288: x_line_adj_changed_attr_tbl(ind).attribute_name := 'substitution_attribute';
5289: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.substitution_attribute;
5290: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.substitution_attribute;
5291: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.substitution_attribute;
5307: ELSE
5308: ind := ind+1;
5309: prior_exists := 'Y';
5310: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5311: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5312: x_line_adj_changed_attr_tbl(ind).attribute_name := 'proration_type_code';
5313: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.proration_type_code;
5314: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.proration_type_code;
5315: END IF;
5326: IF prior_exists = 'N' THEN
5327: ind := ind+1;
5328: END IF;
5329: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5330: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5331: x_line_adj_changed_attr_tbl(ind).attribute_name := 'proration_type_code';
5332: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.proration_type_code;
5333: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.proration_type_code;
5334: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.proration_type_code;
5350: ELSE
5351: ind := ind+1;
5352: prior_exists := 'Y';
5353: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5354: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5355: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute1';
5356: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute1;
5357: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute1;
5358: END IF;
5369: IF prior_exists = 'N' THEN
5370: ind := ind+1;
5371: END IF;
5372: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5373: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5374: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute1';
5375: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute1;
5376: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute1;
5377: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute1;
5393: ELSE
5394: ind := ind+1;
5395: prior_exists := 'Y';
5396: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5397: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5398: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute2';
5399: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute2;
5400: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute2;
5401: END IF;
5412: IF prior_exists = 'N' THEN
5413: ind := ind+1;
5414: END IF;
5415: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5416: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5417: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute2';
5418: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute2;
5419: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute2;
5420: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute2;
5435: ELSE
5436: ind := ind+1;
5437: prior_exists := 'Y';
5438: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5439: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5440: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute3';
5441: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute3;
5442: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute3;
5443: END IF;
5454: IF prior_exists = 'N' THEN
5455: ind := ind+1;
5456: END IF;
5457: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5458: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5459: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute3';
5460: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute3;
5461: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute3;
5462: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute3;
5478: ELSE
5479: ind := ind+1;
5480: prior_exists := 'Y';
5481: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5482: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5483: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute4';
5484: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute4;
5485: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute4;
5486: END IF;
5497: IF prior_exists = 'N' THEN
5498: ind := ind+1;
5499: END IF;
5500: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5501: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5502: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute4';
5503: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute4;
5504: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute4;
5505: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute4;
5520: ELSE
5521: ind := ind+1;
5522: prior_exists := 'Y';
5523: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5524: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5525: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute5';
5526: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute5;
5527: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute5;
5528: END IF;
5539: IF prior_exists = 'N' THEN
5540: ind := ind+1;
5541: END IF;
5542: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5543: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5544: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute5';
5545: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute5;
5546: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute5;
5547: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute5;
5563: ELSE
5564: ind := ind+1;
5565: prior_exists := 'Y';
5566: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5567: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5568: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute6';
5569: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute6;
5570: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute6;
5571: END IF;
5582: IF prior_exists = 'N' THEN
5583: ind := ind+1;
5584: END IF;
5585: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5586: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5587: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute6';
5588: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute6;
5589: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute6;
5590: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute6;
5605: ELSE
5606: ind := ind+1;
5607: prior_exists := 'Y';
5608: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5609: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5610: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute7';
5611: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute7;
5612: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute7;
5613: END IF;
5624: IF prior_exists = 'N' THEN
5625: ind := ind+1;
5626: END IF;
5627: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5628: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5629: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute7;
5630: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute7';
5631: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute7;
5632: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute7;
5648: ELSE
5649: ind := ind+1;
5650: prior_exists := 'Y';
5651: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5652: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5653: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute8';
5654: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute8;
5655: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute8;
5656: END IF;
5667: IF prior_exists = 'N' THEN
5668: ind := ind+1;
5669: END IF;
5670: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5671: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5672: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute8';
5673: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute8;
5674: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute8;
5675: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute8;
5690: ELSE
5691: ind := ind+1;
5692: prior_exists := 'Y';
5693: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5694: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5695: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute9';
5696: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute9;
5697: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute9;
5698: END IF;
5709: IF prior_exists = 'N' THEN
5710: ind := ind+1;
5711: END IF;
5712: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5713: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5714: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute9';
5715: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute9;
5716: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute9;
5717: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute9;
5733: ELSE
5734: ind := ind+1;
5735: prior_exists := 'Y';
5736: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5737: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5738: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute10';
5739: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute10;
5740: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute10;
5741: END IF;
5752: IF prior_exists = 'N' THEN
5753: ind := ind+1;
5754: END IF;
5755: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5756: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5757: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute10';
5758: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute10;
5759: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute10;
5760: END IF;
5775: ELSE
5776: ind := ind+1;
5777: prior_exists := 'Y';
5778: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5779: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5780: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute11';
5781: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute11;
5782: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute11;
5783: END IF;
5794: IF prior_exists = 'N' THEN
5795: ind := ind+1;
5796: END IF;
5797: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5798: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5799: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute11';
5800: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute10;
5801: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute11;
5802: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute11;
5818: ELSE
5819: ind := ind+1;
5820: prior_exists := 'Y';
5821: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5822: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5823: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute12';
5824: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute12;
5825: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute12;
5826: END IF;
5837: IF prior_exists = 'N' THEN
5838: ind := ind+1;
5839: END IF;
5840: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5841: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5842: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute12';
5843: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute12;
5844: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute12;
5845: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute12;
5861: ELSE
5862: ind := ind+1;
5863: prior_exists := 'Y';
5864: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5865: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5866: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute13';
5867: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute13;
5868: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute13;
5869: END IF;
5880: IF prior_exists = 'N' THEN
5881: ind := ind+1;
5882: END IF;
5883: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5884: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5885: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute13';
5886: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute13;
5887: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute13;
5888: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute13;
5904: ELSE
5905: ind := ind+1;
5906: prior_exists := 'Y';
5907: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5908: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5909: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute14';
5910: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute14;
5911: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute14;
5912: END IF;
5923: IF prior_exists = 'N' THEN
5924: ind := ind+1;
5925: END IF;
5926: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5927: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5928: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute14';
5929: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute14;
5930: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute14;
5931: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute14;
5947: ELSE
5948: ind := ind+1;
5949: prior_exists := 'Y';
5950: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5951: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5952: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute15';
5953: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute15;
5954: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute15;
5955: END IF;
5966: IF prior_exists = 'N' THEN
5967: ind := ind+1;
5968: END IF;
5969: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5970: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5971: x_line_adj_changed_attr_tbl(ind).attribute_name := 'attribute15';
5972: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_attribute15;
5973: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_attribute15;
5974: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_attribute15;
5990: ELSE
5991: ind := ind+1;
5992: prior_exists := 'Y';
5993: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
5994: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
5995: x_line_adj_changed_attr_tbl(ind).attribute_name := 'ac_context';
5996: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_context;
5997: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_context;
5998: END IF;
6009: IF prior_exists = 'N' THEN
6010: ind := ind+1;
6011: END IF;
6012: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
6013: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
6014: x_line_adj_changed_attr_tbl(ind).attribute_name := 'ac_context';
6015: x_line_adj_changed_attr_tbl(ind).prior_value := p_prior_rec.ac_context;
6016: x_line_adj_changed_attr_tbl(ind).current_value := p_curr_rec.ac_context;
6017: x_line_adj_changed_attr_tbl(ind).next_value := p_next_rec.ac_context;
6039: oe_debug_pub.add(' Prior is not there - current is there');
6040: END IF;
6041: ind := ind+1;
6042: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
6043: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
6044: x_line_adj_changed_attr_tbl(ind).prior_value := null;
6045: x_line_adj_changed_attr_tbl(ind).current_value := 'ADD';
6046: x_line_adj_changed_attr_tbl(ind).next_value := null;
6047: ELSIF (p_curr_rec_exists = 'N' and p_next_rec_exists = 'Y') THEN
6050: oe_debug_pub.add(' new mod' ||p_next_rec.list_header_id);
6051: END IF;
6052: ind := ind+1;
6053: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
6054: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_next_rec.list_header_id);
6055: x_line_adj_changed_attr_tbl(ind).prior_value := null;
6056: x_line_adj_changed_attr_tbl(ind).current_value := null;
6057: x_line_adj_changed_attr_tbl(ind).next_value := 'ADD';
6058: end if;
6072: oe_debug_pub.add(' Prior is there - current is not there');
6073: END IF;
6074: ind := ind+1;
6075: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
6076: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_prior_rec.list_header_id);
6077: x_line_adj_changed_attr_tbl(ind).prior_value := null;
6078: x_line_adj_changed_attr_tbl(ind).current_value := 'DELETE';
6079: x_line_adj_changed_attr_tbl(ind).next_value := null;
6080: ELSIF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'N' THEN
6087: oe_debug_pub.add(' Current is there - next is not there');
6088: END IF;
6089: ind := ind+1;
6090: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
6091: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
6092: x_line_adj_changed_attr_tbl(ind).prior_value := null;
6093: x_line_adj_changed_attr_tbl(ind).current_value := null;
6094: x_line_adj_changed_attr_tbl(ind).next_value := 'DELETE';
6095: --end if;