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

APPS.CE_BANK_STATEMENT_LOADER dependencies on CE_STMT_INT_TMP

Line 134: UPDATE CE_STMT_INT_TMP

130: END Init_Line_Rec;
131:
132: PROCEDURE Remove_Return_Char IS
133: BEGIN
134: UPDATE CE_STMT_INT_TMP
135: SET REC_NO = rtrim(REC_NO, '
'),
136: REC_ID_NO = rtrim(REC_ID_NO, '
'),
137: COLUMN1 = rtrim(COLUMN1, '
'),
138: COLUMN2 = rtrim(COLUMN2, '
'),

Line 1024: FROM ce_stmt_int_tmp

1020: BEGIN
1021: IF (X_pos = 1) THEN
1022: SELECT substr(rtrim(ltrim(column1)),1,255)
1023: INTO l_result
1024: FROM ce_stmt_int_tmp
1025: WHERE rec_no = X_rec_no;
1026: ELSIF (X_pos = 2) THEN
1027: SELECT rtrim(ltrim(column2))
1028: INTO l_result

Line 1029: FROM ce_stmt_int_tmp

1025: WHERE rec_no = X_rec_no;
1026: ELSIF (X_pos = 2) THEN
1027: SELECT rtrim(ltrim(column2))
1028: INTO l_result
1029: FROM ce_stmt_int_tmp
1030: WHERE rec_no = X_rec_no;
1031: ELSIF (X_pos = 3) THEN
1032: SELECT rtrim(ltrim(column3))
1033: INTO l_result

Line 1034: FROM ce_stmt_int_tmp

1030: WHERE rec_no = X_rec_no;
1031: ELSIF (X_pos = 3) THEN
1032: SELECT rtrim(ltrim(column3))
1033: INTO l_result
1034: FROM ce_stmt_int_tmp
1035: WHERE rec_no = X_rec_no;
1036: ELSIF (X_pos = 4) THEN
1037: SELECT rtrim(ltrim(column4))
1038: INTO l_result

Line 1039: FROM ce_stmt_int_tmp

1035: WHERE rec_no = X_rec_no;
1036: ELSIF (X_pos = 4) THEN
1037: SELECT rtrim(ltrim(column4))
1038: INTO l_result
1039: FROM ce_stmt_int_tmp
1040: WHERE rec_no = X_rec_no;
1041: ELSIF (X_pos = 5) THEN
1042: SELECT rtrim(ltrim(column5))
1043: INTO l_result

Line 1044: FROM ce_stmt_int_tmp

1040: WHERE rec_no = X_rec_no;
1041: ELSIF (X_pos = 5) THEN
1042: SELECT rtrim(ltrim(column5))
1043: INTO l_result
1044: FROM ce_stmt_int_tmp
1045: WHERE rec_no = X_rec_no;
1046: ELSIF (X_pos = 6) THEN
1047: SELECT rtrim(ltrim(column6))
1048: INTO l_result

Line 1049: FROM ce_stmt_int_tmp

1045: WHERE rec_no = X_rec_no;
1046: ELSIF (X_pos = 6) THEN
1047: SELECT rtrim(ltrim(column6))
1048: INTO l_result
1049: FROM ce_stmt_int_tmp
1050: WHERE rec_no = X_rec_no;
1051: ELSIF (X_pos = 7) THEN
1052: SELECT rtrim(ltrim(column7))
1053: INTO l_result

Line 1054: FROM ce_stmt_int_tmp

1050: WHERE rec_no = X_rec_no;
1051: ELSIF (X_pos = 7) THEN
1052: SELECT rtrim(ltrim(column7))
1053: INTO l_result
1054: FROM ce_stmt_int_tmp
1055: WHERE rec_no = X_rec_no;
1056: ELSIF (X_pos = 8) THEN
1057: SELECT rtrim(ltrim(column8))
1058: INTO l_result

Line 1059: FROM ce_stmt_int_tmp

1055: WHERE rec_no = X_rec_no;
1056: ELSIF (X_pos = 8) THEN
1057: SELECT rtrim(ltrim(column8))
1058: INTO l_result
1059: FROM ce_stmt_int_tmp
1060: WHERE rec_no = X_rec_no;
1061: ELSIF (X_pos = 9) THEN
1062: SELECT rtrim(ltrim(column9))
1063: INTO l_result

Line 1064: FROM ce_stmt_int_tmp

1060: WHERE rec_no = X_rec_no;
1061: ELSIF (X_pos = 9) THEN
1062: SELECT rtrim(ltrim(column9))
1063: INTO l_result
1064: FROM ce_stmt_int_tmp
1065: WHERE rec_no = X_rec_no;
1066: ELSIF (X_pos = 10) THEN
1067: SELECT rtrim(ltrim(column10))
1068: INTO l_result

Line 1069: FROM ce_stmt_int_tmp

1065: WHERE rec_no = X_rec_no;
1066: ELSIF (X_pos = 10) THEN
1067: SELECT rtrim(ltrim(column10))
1068: INTO l_result
1069: FROM ce_stmt_int_tmp
1070: WHERE rec_no = X_rec_no;
1071: ELSIF (X_pos = 11) THEN
1072: SELECT rtrim(ltrim(column11))
1073: INTO l_result

Line 1074: FROM ce_stmt_int_tmp

1070: WHERE rec_no = X_rec_no;
1071: ELSIF (X_pos = 11) THEN
1072: SELECT rtrim(ltrim(column11))
1073: INTO l_result
1074: FROM ce_stmt_int_tmp
1075: WHERE rec_no = X_rec_no;
1076: ELSIF (X_pos = 12) THEN
1077: SELECT rtrim(ltrim(column12))
1078: INTO l_result

Line 1079: FROM ce_stmt_int_tmp

1075: WHERE rec_no = X_rec_no;
1076: ELSIF (X_pos = 12) THEN
1077: SELECT rtrim(ltrim(column12))
1078: INTO l_result
1079: FROM ce_stmt_int_tmp
1080: WHERE rec_no = X_rec_no;
1081: ELSIF (X_pos = 13) THEN
1082: SELECT rtrim(ltrim(column13))
1083: INTO l_result

Line 1084: FROM ce_stmt_int_tmp

1080: WHERE rec_no = X_rec_no;
1081: ELSIF (X_pos = 13) THEN
1082: SELECT rtrim(ltrim(column13))
1083: INTO l_result
1084: FROM ce_stmt_int_tmp
1085: WHERE rec_no = X_rec_no;
1086: ELSIF (X_pos = 14) THEN
1087: SELECT rtrim(ltrim(column14))
1088: INTO l_result

Line 1089: FROM ce_stmt_int_tmp

1085: WHERE rec_no = X_rec_no;
1086: ELSIF (X_pos = 14) THEN
1087: SELECT rtrim(ltrim(column14))
1088: INTO l_result
1089: FROM ce_stmt_int_tmp
1090: WHERE rec_no = X_rec_no;
1091: ELSIF (X_pos = 15) THEN
1092: SELECT rtrim(ltrim(column15))
1093: INTO l_result

Line 1094: FROM ce_stmt_int_tmp

1090: WHERE rec_no = X_rec_no;
1091: ELSIF (X_pos = 15) THEN
1092: SELECT rtrim(ltrim(column15))
1093: INTO l_result
1094: FROM ce_stmt_int_tmp
1095: WHERE rec_no = X_rec_no;
1096: ELSIF (X_pos = 16) THEN
1097: SELECT rtrim(ltrim(column16))
1098: INTO l_result

Line 1099: FROM ce_stmt_int_tmp

1095: WHERE rec_no = X_rec_no;
1096: ELSIF (X_pos = 16) THEN
1097: SELECT rtrim(ltrim(column16))
1098: INTO l_result
1099: FROM ce_stmt_int_tmp
1100: WHERE rec_no = X_rec_no;
1101: ELSIF (X_pos = 17) THEN
1102: SELECT rtrim(ltrim(column17))
1103: INTO l_result

Line 1104: FROM ce_stmt_int_tmp

1100: WHERE rec_no = X_rec_no;
1101: ELSIF (X_pos = 17) THEN
1102: SELECT rtrim(ltrim(column17))
1103: INTO l_result
1104: FROM ce_stmt_int_tmp
1105: WHERE rec_no = X_rec_no;
1106: ELSIF (X_pos = 18) THEN
1107: SELECT rtrim(ltrim(column18))
1108: INTO l_result

Line 1109: FROM ce_stmt_int_tmp

1105: WHERE rec_no = X_rec_no;
1106: ELSIF (X_pos = 18) THEN
1107: SELECT rtrim(ltrim(column18))
1108: INTO l_result
1109: FROM ce_stmt_int_tmp
1110: WHERE rec_no = X_rec_no;
1111: ELSIF (X_pos = 19) THEN
1112: SELECT rtrim(ltrim(column19))
1113: INTO l_result

Line 1114: FROM ce_stmt_int_tmp

1110: WHERE rec_no = X_rec_no;
1111: ELSIF (X_pos = 19) THEN
1112: SELECT rtrim(ltrim(column19))
1113: INTO l_result
1114: FROM ce_stmt_int_tmp
1115: WHERE rec_no = X_rec_no;
1116: ELSIF (X_pos = 20) THEN
1117: SELECT rtrim(ltrim(column20))
1118: INTO l_result

Line 1119: FROM ce_stmt_int_tmp

1115: WHERE rec_no = X_rec_no;
1116: ELSIF (X_pos = 20) THEN
1117: SELECT rtrim(ltrim(column20))
1118: INTO l_result
1119: FROM ce_stmt_int_tmp
1120: WHERE rec_no = X_rec_no;
1121: ELSIF (X_pos = 21) THEN
1122: SELECT rtrim(ltrim(column21))
1123: INTO l_result

Line 1124: FROM ce_stmt_int_tmp

1120: WHERE rec_no = X_rec_no;
1121: ELSIF (X_pos = 21) THEN
1122: SELECT rtrim(ltrim(column21))
1123: INTO l_result
1124: FROM ce_stmt_int_tmp
1125: WHERE rec_no = X_rec_no;
1126: ELSIF (X_pos = 22) THEN
1127: SELECT rtrim(ltrim(column22))
1128: INTO l_result

Line 1129: FROM ce_stmt_int_tmp

1125: WHERE rec_no = X_rec_no;
1126: ELSIF (X_pos = 22) THEN
1127: SELECT rtrim(ltrim(column22))
1128: INTO l_result
1129: FROM ce_stmt_int_tmp
1130: WHERE rec_no = X_rec_no;
1131: ELSIF (X_pos = 23) THEN
1132: SELECT rtrim(ltrim(column23))
1133: INTO l_result

Line 1134: FROM ce_stmt_int_tmp

1130: WHERE rec_no = X_rec_no;
1131: ELSIF (X_pos = 23) THEN
1132: SELECT rtrim(ltrim(column23))
1133: INTO l_result
1134: FROM ce_stmt_int_tmp
1135: WHERE rec_no = X_rec_no;
1136: ELSIF (X_pos = 24) THEN
1137: SELECT rtrim(ltrim(column24))
1138: INTO l_result

Line 1139: FROM ce_stmt_int_tmp

1135: WHERE rec_no = X_rec_no;
1136: ELSIF (X_pos = 24) THEN
1137: SELECT rtrim(ltrim(column24))
1138: INTO l_result
1139: FROM ce_stmt_int_tmp
1140: WHERE rec_no = X_rec_no;
1141: ELSIF (X_pos = 25) THEN
1142: SELECT rtrim(ltrim(column25))
1143: INTO l_result

Line 1144: FROM ce_stmt_int_tmp

1140: WHERE rec_no = X_rec_no;
1141: ELSIF (X_pos = 25) THEN
1142: SELECT rtrim(ltrim(column25))
1143: INTO l_result
1144: FROM ce_stmt_int_tmp
1145: WHERE rec_no = X_rec_no;
1146: ELSIF (X_pos = 26) THEN
1147: SELECT rtrim(ltrim(column26))
1148: INTO l_result

Line 1149: FROM ce_stmt_int_tmp

1145: WHERE rec_no = X_rec_no;
1146: ELSIF (X_pos = 26) THEN
1147: SELECT rtrim(ltrim(column26))
1148: INTO l_result
1149: FROM ce_stmt_int_tmp
1150: WHERE rec_no = X_rec_no;
1151: ELSIF (X_pos = 27) THEN
1152: SELECT rtrim(ltrim(column27))
1153: INTO l_result

Line 1154: FROM ce_stmt_int_tmp

1150: WHERE rec_no = X_rec_no;
1151: ELSIF (X_pos = 27) THEN
1152: SELECT rtrim(ltrim(column27))
1153: INTO l_result
1154: FROM ce_stmt_int_tmp
1155: WHERE rec_no = X_rec_no;
1156: ELSIF (X_pos = 28) THEN
1157: SELECT rtrim(ltrim(column28))
1158: INTO l_result

Line 1159: FROM ce_stmt_int_tmp

1155: WHERE rec_no = X_rec_no;
1156: ELSIF (X_pos = 28) THEN
1157: SELECT rtrim(ltrim(column28))
1158: INTO l_result
1159: FROM ce_stmt_int_tmp
1160: WHERE rec_no = X_rec_no;
1161: ELSIF (X_pos = 29) THEN
1162: SELECT rtrim(ltrim(column29))
1163: INTO l_result

Line 1164: FROM ce_stmt_int_tmp

1160: WHERE rec_no = X_rec_no;
1161: ELSIF (X_pos = 29) THEN
1162: SELECT rtrim(ltrim(column29))
1163: INTO l_result
1164: FROM ce_stmt_int_tmp
1165: WHERE rec_no = X_rec_no;
1166: ELSIF (X_pos = 30) THEN
1167: SELECT rtrim(ltrim(column30))
1168: INTO l_result

Line 1169: FROM ce_stmt_int_tmp

1165: WHERE rec_no = X_rec_no;
1166: ELSIF (X_pos = 30) THEN
1167: SELECT rtrim(ltrim(column30))
1168: INTO l_result
1169: FROM ce_stmt_int_tmp
1170: WHERE rec_no = X_rec_no;
1171: ELSIF (X_pos = 31) THEN
1172: SELECT rtrim(ltrim(column31))
1173: INTO l_result

Line 1174: FROM ce_stmt_int_tmp

1170: WHERE rec_no = X_rec_no;
1171: ELSIF (X_pos = 31) THEN
1172: SELECT rtrim(ltrim(column31))
1173: INTO l_result
1174: FROM ce_stmt_int_tmp
1175: WHERE rec_no = X_rec_no;
1176: ELSIF (X_pos = 32) THEN
1177: SELECT rtrim(ltrim(column32))
1178: INTO l_result

Line 1179: FROM ce_stmt_int_tmp

1175: WHERE rec_no = X_rec_no;
1176: ELSIF (X_pos = 32) THEN
1177: SELECT rtrim(ltrim(column32))
1178: INTO l_result
1179: FROM ce_stmt_int_tmp
1180: WHERE rec_no = X_rec_no;
1181: ELSIF (X_pos = 33) THEN
1182: SELECT rtrim(ltrim(column33))
1183: INTO l_result

Line 1184: FROM ce_stmt_int_tmp

1180: WHERE rec_no = X_rec_no;
1181: ELSIF (X_pos = 33) THEN
1182: SELECT rtrim(ltrim(column33))
1183: INTO l_result
1184: FROM ce_stmt_int_tmp
1185: WHERE rec_no = X_rec_no;
1186: ELSIF (X_pos = 34) THEN
1187: SELECT rtrim(ltrim(column34))
1188: INTO l_result

Line 1189: FROM ce_stmt_int_tmp

1185: WHERE rec_no = X_rec_no;
1186: ELSIF (X_pos = 34) THEN
1187: SELECT rtrim(ltrim(column34))
1188: INTO l_result
1189: FROM ce_stmt_int_tmp
1190: WHERE rec_no = X_rec_no;
1191: ELSIF (X_pos = 35) THEN
1192: SELECT rtrim(ltrim(column35))
1193: INTO l_result

Line 1194: FROM ce_stmt_int_tmp

1190: WHERE rec_no = X_rec_no;
1191: ELSIF (X_pos = 35) THEN
1192: SELECT rtrim(ltrim(column35))
1193: INTO l_result
1194: FROM ce_stmt_int_tmp
1195: WHERE rec_no = X_rec_no;
1196: END IF;
1197:
1198: --

Line 1283: FROM ce_stmt_int_tmp

1279: substr(column21,1,1)||substr(column22,1,1)||substr(column23,1,1)||substr(column24,1,1)||substr(column25,1,1)||
1280: substr(column26,1,1)||substr(column27,1,1)||substr(column28,1,1)||substr(column29,1,1)||substr(column30,1,1)||
1281: substr(column31,1,1)||substr(column32,1,1)||substr(column33,1,1)||substr(column34,1,1)||substr(column35,1,1)
1282: INTO l_str
1283: FROM ce_stmt_int_tmp
1284: WHERE rec_no = X_rec_no;
1285:
1286: RETURN LENGTH(l_str);
1287: END Find_Last_Column_Pos;

Line 1454: FROM ce_stmt_int_tmp

1450: --------------------------------------------------------------------- */
1451: PROCEDURE Decode_Line_BAI(X_rec_no NUMBER) IS
1452: CURSOR C_rec IS
1453: SELECT column3, column4
1454: FROM ce_stmt_int_tmp
1455: WHERE rec_no = X_rec_no;
1456:
1457: l_val1 VARCHAR2(100);
1458: l_val2 VARCHAR2(100);

Line 1541: FROM ce_stmt_int_tmp

1537: BEGIN
1538: IF (X_cnt = 1) THEN
1539: SELECT column1, column2, column3, column4, column5
1540: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1541: FROM ce_stmt_int_tmp
1542: WHERE rec_no = X_rec_no;
1543: ELSIF (X_cnt = 2) THEN
1544: SELECT column2, column3, column4, column5, column6
1545: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1546: FROM ce_stmt_int_tmp

1542: WHERE rec_no = X_rec_no;
1543: ELSIF (X_cnt = 2) THEN
1544: SELECT column2, column3, column4, column5, column6
1545: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1546: FROM ce_stmt_int_tmp
1547: WHERE rec_no = X_rec_no;
1548: ELSIF (X_cnt = 3) THEN
1549: SELECT column3, column4, column5, column6, column7
1550: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1551: FROM ce_stmt_int_tmp

1547: WHERE rec_no = X_rec_no;
1548: ELSIF (X_cnt = 3) THEN
1549: SELECT column3, column4, column5, column6, column7
1550: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1551: FROM ce_stmt_int_tmp
1552: WHERE rec_no = X_rec_no;
1553: ELSIF (X_cnt = 4) THEN
1554: SELECT column4, column5, column6, column7, column8
1555: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1556: FROM ce_stmt_int_tmp

1552: WHERE rec_no = X_rec_no;
1553: ELSIF (X_cnt = 4) THEN
1554: SELECT column4, column5, column6, column7, column8
1555: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1556: FROM ce_stmt_int_tmp
1557: WHERE rec_no = X_rec_no;
1558: ELSIF (X_cnt = 5) THEN
1559: SELECT column5, column6, column7, column8, column9
1560: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1561: FROM ce_stmt_int_tmp

1557: WHERE rec_no = X_rec_no;
1558: ELSIF (X_cnt = 5) THEN
1559: SELECT column5, column6, column7, column8, column9
1560: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1561: FROM ce_stmt_int_tmp
1562: WHERE rec_no = X_rec_no;
1563: ELSIF (X_cnt = 6) THEN
1564: SELECT column6, column7, column8, column9, column10
1565: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1566: FROM ce_stmt_int_tmp

1562: WHERE rec_no = X_rec_no;
1563: ELSIF (X_cnt = 6) THEN
1564: SELECT column6, column7, column8, column9, column10
1565: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1566: FROM ce_stmt_int_tmp
1567: WHERE rec_no = X_rec_no;
1568: ELSIF (X_cnt = 7) THEN
1569: SELECT column7, column8, column9, column10, column11
1570: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1571: FROM ce_stmt_int_tmp

1567: WHERE rec_no = X_rec_no;
1568: ELSIF (X_cnt = 7) THEN
1569: SELECT column7, column8, column9, column10, column11
1570: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1571: FROM ce_stmt_int_tmp
1572: WHERE rec_no = X_rec_no;
1573: ELSIF (X_cnt = 8) THEN
1574: SELECT column8, column9, column10, column11, column12
1575: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1576: FROM ce_stmt_int_tmp

1572: WHERE rec_no = X_rec_no;
1573: ELSIF (X_cnt = 8) THEN
1574: SELECT column8, column9, column10, column11, column12
1575: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1576: FROM ce_stmt_int_tmp
1577: WHERE rec_no = X_rec_no;
1578: ELSIF (X_cnt = 9) THEN
1579: SELECT column9, column10, column11, column12, column13
1580: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1581: FROM ce_stmt_int_tmp

1577: WHERE rec_no = X_rec_no;
1578: ELSIF (X_cnt = 9) THEN
1579: SELECT column9, column10, column11, column12, column13
1580: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1581: FROM ce_stmt_int_tmp
1582: WHERE rec_no = X_rec_no;
1583: ELSIF (X_cnt = 10) THEN
1584: SELECT column10, column11, column12, column13, column14
1585: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1586: FROM ce_stmt_int_tmp

1582: WHERE rec_no = X_rec_no;
1583: ELSIF (X_cnt = 10) THEN
1584: SELECT column10, column11, column12, column13, column14
1585: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1586: FROM ce_stmt_int_tmp
1587: WHERE rec_no = X_rec_no;
1588: ELSIF (X_cnt = 11) THEN
1589: SELECT column11, column12, column13, column14, column15
1590: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1591: FROM ce_stmt_int_tmp

1587: WHERE rec_no = X_rec_no;
1588: ELSIF (X_cnt = 11) THEN
1589: SELECT column11, column12, column13, column14, column15
1590: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1591: FROM ce_stmt_int_tmp
1592: WHERE rec_no = X_rec_no;
1593: ELSIF (X_cnt = 12) THEN
1594: SELECT column12, column13, column14, column15, column16
1595: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1596: FROM ce_stmt_int_tmp

1592: WHERE rec_no = X_rec_no;
1593: ELSIF (X_cnt = 12) THEN
1594: SELECT column12, column13, column14, column15, column16
1595: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1596: FROM ce_stmt_int_tmp
1597: WHERE rec_no = X_rec_no;
1598: ELSIF (X_cnt = 13) THEN
1599: SELECT column13, column14, column15, column16, column17
1600: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1601: FROM ce_stmt_int_tmp

1597: WHERE rec_no = X_rec_no;
1598: ELSIF (X_cnt = 13) THEN
1599: SELECT column13, column14, column15, column16, column17
1600: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1601: FROM ce_stmt_int_tmp
1602: WHERE rec_no = X_rec_no;
1603: ELSIF (X_cnt = 14) THEN
1604: SELECT column14, column15, column16, column17, column18
1605: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1606: FROM ce_stmt_int_tmp

1602: WHERE rec_no = X_rec_no;
1603: ELSIF (X_cnt = 14) THEN
1604: SELECT column14, column15, column16, column17, column18
1605: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1606: FROM ce_stmt_int_tmp
1607: WHERE rec_no = X_rec_no;
1608: ELSIF (X_cnt = 15) THEN
1609: SELECT column15, column16, column17, column18, column19
1610: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1611: FROM ce_stmt_int_tmp

1607: WHERE rec_no = X_rec_no;
1608: ELSIF (X_cnt = 15) THEN
1609: SELECT column15, column16, column17, column18, column19
1610: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1611: FROM ce_stmt_int_tmp
1612: WHERE rec_no = X_rec_no;
1613: ELSIF (X_cnt = 16) THEN
1614: SELECT column16, column17, column18, column19, column20
1615: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1616: FROM ce_stmt_int_tmp

1612: WHERE rec_no = X_rec_no;
1613: ELSIF (X_cnt = 16) THEN
1614: SELECT column16, column17, column18, column19, column20
1615: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1616: FROM ce_stmt_int_tmp
1617: WHERE rec_no = X_rec_no;
1618: ELSIF (X_cnt = 17) THEN
1619: SELECT column17, column18, column19, column20, column21
1620: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1621: FROM ce_stmt_int_tmp

1617: WHERE rec_no = X_rec_no;
1618: ELSIF (X_cnt = 17) THEN
1619: SELECT column17, column18, column19, column20, column21
1620: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1621: FROM ce_stmt_int_tmp
1622: WHERE rec_no = X_rec_no;
1623: ELSIF (X_cnt = 18) THEN
1624: SELECT column18, column19, column20, column21, column22
1625: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1626: FROM ce_stmt_int_tmp

1622: WHERE rec_no = X_rec_no;
1623: ELSIF (X_cnt = 18) THEN
1624: SELECT column18, column19, column20, column21, column22
1625: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1626: FROM ce_stmt_int_tmp
1627: WHERE rec_no = X_rec_no;
1628: ELSIF (X_cnt = 19) THEN
1629: SELECT column19, column20, column21, column22, column23
1630: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1631: FROM ce_stmt_int_tmp

1627: WHERE rec_no = X_rec_no;
1628: ELSIF (X_cnt = 19) THEN
1629: SELECT column19, column20, column21, column22, column23
1630: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1631: FROM ce_stmt_int_tmp
1632: WHERE rec_no = X_rec_no;
1633: ELSIF (X_cnt = 20) THEN
1634: SELECT column20, column21, column22, column23, column24
1635: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1636: FROM ce_stmt_int_tmp

1632: WHERE rec_no = X_rec_no;
1633: ELSIF (X_cnt = 20) THEN
1634: SELECT column20, column21, column22, column23, column24
1635: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1636: FROM ce_stmt_int_tmp
1637: WHERE rec_no = X_rec_no;
1638: ELSIF (X_cnt = 21) THEN
1639: SELECT column21, column22, column23, column24, column25
1640: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1641: FROM ce_stmt_int_tmp

1637: WHERE rec_no = X_rec_no;
1638: ELSIF (X_cnt = 21) THEN
1639: SELECT column21, column22, column23, column24, column25
1640: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1641: FROM ce_stmt_int_tmp
1642: WHERE rec_no = X_rec_no;
1643: ELSIF (X_cnt = 22) THEN
1644: SELECT column22, column23, column24, column25, column26
1645: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1646: FROM ce_stmt_int_tmp

1642: WHERE rec_no = X_rec_no;
1643: ELSIF (X_cnt = 22) THEN
1644: SELECT column22, column23, column24, column25, column26
1645: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1646: FROM ce_stmt_int_tmp
1647: WHERE rec_no = X_rec_no;
1648: ELSIF (X_cnt = 23) THEN
1649: SELECT column23, column24, column25, column26, column27
1650: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1651: FROM ce_stmt_int_tmp

1647: WHERE rec_no = X_rec_no;
1648: ELSIF (X_cnt = 23) THEN
1649: SELECT column23, column24, column25, column26, column27
1650: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1651: FROM ce_stmt_int_tmp
1652: WHERE rec_no = X_rec_no;
1653: ELSIF (X_cnt = 24) THEN
1654: SELECT column24, column25, column26, column27, column28
1655: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1656: FROM ce_stmt_int_tmp

1652: WHERE rec_no = X_rec_no;
1653: ELSIF (X_cnt = 24) THEN
1654: SELECT column24, column25, column26, column27, column28
1655: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1656: FROM ce_stmt_int_tmp
1657: WHERE rec_no = X_rec_no;
1658: ELSIF (X_cnt = 25) THEN
1659: SELECT column25, column26, column27, column28, column29
1660: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1661: FROM ce_stmt_int_tmp

1657: WHERE rec_no = X_rec_no;
1658: ELSIF (X_cnt = 25) THEN
1659: SELECT column25, column26, column27, column28, column29
1660: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1661: FROM ce_stmt_int_tmp
1662: WHERE rec_no = X_rec_no;
1663: ELSIF (X_cnt = 26) THEN
1664: SELECT column26, column27, column28, column29, column30
1665: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1666: FROM ce_stmt_int_tmp

1662: WHERE rec_no = X_rec_no;
1663: ELSIF (X_cnt = 26) THEN
1664: SELECT column26, column27, column28, column29, column30
1665: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1666: FROM ce_stmt_int_tmp
1667: WHERE rec_no = X_rec_no;
1668: ELSIF (X_cnt = 27) THEN
1669: SELECT column27, column28, column29, column30, column31
1670: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1671: FROM ce_stmt_int_tmp

1667: WHERE rec_no = X_rec_no;
1668: ELSIF (X_cnt = 27) THEN
1669: SELECT column27, column28, column29, column30, column31
1670: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1671: FROM ce_stmt_int_tmp
1672: WHERE rec_no = X_rec_no;
1673: ELSIF (X_cnt = 28) THEN
1674: SELECT column28, column29, column30, column31, column32
1675: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1676: FROM ce_stmt_int_tmp

1672: WHERE rec_no = X_rec_no;
1673: ELSIF (X_cnt = 28) THEN
1674: SELECT column28, column29, column30, column31, column32
1675: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1676: FROM ce_stmt_int_tmp
1677: WHERE rec_no = X_rec_no;
1678: ELSIF (X_cnt = 29) THEN
1679: SELECT column29, column30, column31, column32, column33
1680: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1681: FROM ce_stmt_int_tmp

1677: WHERE rec_no = X_rec_no;
1678: ELSIF (X_cnt = 29) THEN
1679: SELECT column29, column30, column31, column32, column33
1680: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1681: FROM ce_stmt_int_tmp
1682: WHERE rec_no = X_rec_no;
1683: ELSIF (X_cnt = 30) THEN
1684: SELECT column30, column31, column32, column33, column34
1685: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1686: FROM ce_stmt_int_tmp

1682: WHERE rec_no = X_rec_no;
1683: ELSIF (X_cnt = 30) THEN
1684: SELECT column30, column31, column32, column33, column34
1685: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1686: FROM ce_stmt_int_tmp
1687: WHERE rec_no = X_rec_no;
1688: ELSIF (X_cnt = 31) THEN
1689: SELECT column31, column32, column33, column34, column35
1690: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1691: FROM ce_stmt_int_tmp

1687: WHERE rec_no = X_rec_no;
1688: ELSIF (X_cnt = 31) THEN
1689: SELECT column31, column32, column33, column34, column35
1690: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1691: FROM ce_stmt_int_tmp
1692: WHERE rec_no = X_rec_no;
1693: ELSIF (X_cnt = 32) THEN
1694: SELECT column32, column33, column34, column35
1695: INTO X_col1, X_col2, X_col3, X_col4

Line 1696: FROM ce_stmt_int_tmp

1692: WHERE rec_no = X_rec_no;
1693: ELSIF (X_cnt = 32) THEN
1694: SELECT column32, column33, column34, column35
1695: INTO X_col1, X_col2, X_col3, X_col4
1696: FROM ce_stmt_int_tmp
1697: WHERE rec_no = X_rec_no;
1698: END IF;
1699:
1700: EXCEPTION

Line 1902: FROM ce_stmt_int_tmp

1898: PROCEDURE Load_BAI2 IS
1899:
1900: CURSOR C_tmp_tbl IS
1901: SELECT rec_no, rec_id_no, column1, rtrim(replace(column2,' '),'/') col2, column6, rtrim(replace(column8,' '),'/') col8
1902: FROM ce_stmt_int_tmp
1903: ORDER BY rec_no;
1904:
1905: CURSOR C_trx_text IS
1906: SELECT column_name,

Line 1927: l_rec ce_stmt_int_tmp%rowtype; -- Bug 3228203

1923: l_err NUMBER;
1924: l_statement_date DATE;
1925: l_bank_trx_num VARCHAR2(240);
1926: l_process_this_record BOOLEAN := TRUE; /* 2643505 */
1927: l_rec ce_stmt_int_tmp%rowtype; -- Bug 3228203
1928:
1929: BEGIN
1930: IF l_DEBUG in ('Y', 'C') THEN
1931: cep_standard.debug('>>CE_BANK_STATEMENT_LOADER.Load_BAI');

Line 2077: SELECT * INTO l_rec FROM ce_stmt_int_tmp

2073: /* 2643505 Added the IF Condition */
2074: IF l_process_this_record THEN
2075: /* Bug3228203 added the following select stmt and modified
2076: the next update stmt.*/
2077: SELECT * INTO l_rec FROM ce_stmt_int_tmp
2078: WHERE rec_id_no = C_rec.rec_id_no AND rec_no = C_rec.rec_no;
2079:
2080: /* Bug 6792668 Added rtrim */
2081:

Line 2434: FROM ce_stmt_int_tmp

2430: IF X_hdr_or_Line = 'L' THEN
2431: FOR C_rec IN C_line_rec_id LOOP
2432: SELECT MIN(rec_no)
2433: INTO l_min_rec_no
2434: FROM ce_stmt_int_tmp
2435: WHERE rec_id_no = C_rec.recID;
2436:
2437: IF l_lowest_rec_no > l_min_rec_no THEN
2438: l_lowest_rec_no := l_min_rec_no;

Line 2446: FROM ce_stmt_int_tmp

2442: ELSE
2443: FOR C_rec IN C_hdr_rec_id LOOP
2444: SELECT MIN(rec_no)
2445: INTO l_min_rec_no
2446: FROM ce_stmt_int_tmp
2447: WHERE rec_id_no = C_rec.recID;
2448:
2449: IF l_lowest_rec_no > l_min_rec_no THEN
2450: l_lowest_rec_no := l_min_rec_no;

Line 2479: FROM CE_STMT_INT_TMP

2475:
2476: PROCEDURE Load_Others IS
2477: CURSOR C_tmp_tbl IS
2478: SELECT rec_no, rec_id_no
2479: FROM CE_STMT_INT_TMP
2480: ORDER BY rec_no;
2481:
2482: CURSOR C_hdr_tbl(p_rec_id VARCHAR2) IS
2483: SELECT column_name, position

Line 2645: FROM CE_STMT_INT_TMP

2641: PROCEDURE Decode_Line_SWIFT IS
2642: CURSOR C_tmp_tbl IS
2643: SELECT rec_no,
2644: column35
2645: FROM CE_STMT_INT_TMP
2646: WHERE rec_id_no = '61'
2647: ORDER BY rec_no;
2648:
2649: l_col2 VARCHAR2(255);

Line 2737: UPDATE CE_STMT_INT_TMP

2733: l_col7 := SUBSTR(l_str, 1, l_pos - 1);
2734: l_col8 := SUBSTR(l_str, l_pos + 2);
2735: END IF;
2736:
2737: UPDATE CE_STMT_INT_TMP
2738: SET column2 = l_col2,
2739: column3 = l_col3,
2740: column4 = l_col4,
2741: column5 = l_col5,

Line 2753: FROM CE_STMT_INT_TMP

2749: PROCEDURE Decode_Description IS
2750: CURSOR C_tmp_tbl IS
2751: SELECT rec_no,
2752: column1
2753: FROM CE_STMT_INT_TMP
2754: WHERE rec_id_no = '9'
2755: ORDER BY rec_no;
2756:
2757: CURSOR C_tmp_tbl2 IS

Line 2760: FROM CE_STMT_INT_TMP

2756:
2757: CURSOR C_tmp_tbl2 IS
2758: SELECT rec_no,
2759: column1
2760: FROM CE_STMT_INT_TMP
2761: WHERE rec_id_no = '86'
2762: ORDER BY rec_no;
2763:
2764: l_rec_no NUMBER;

Line 2770: FROM CE_STMT_INT_TMP

2766: BEGIN
2767: FOR C_rec IN C_tmp_tbl LOOP
2768: SELECT MAX(rec_no)
2769: INTO l_rec_no
2770: FROM CE_STMT_INT_TMP
2771: WHERE rec_no < C_rec.rec_no
2772: AND rec_id_no <> '9';
2773:
2774: /* Bug 4041064 added the following IF */

Line 2778: FROM CE_STMT_INT_TMP

2774: /* Bug 4041064 added the following IF */
2775: IF l_rec_no IS NOT NULL THEN
2776: SELECT rec_id_no
2777: INTO l_rec_id
2778: FROM CE_STMT_INT_TMP
2779: WHERE rec_no = l_rec_no;
2780:
2781: IF l_rec_id = '61' THEN
2782: UPDATE CE_STMT_INT_TMP

Line 2782: UPDATE CE_STMT_INT_TMP

2778: FROM CE_STMT_INT_TMP
2779: WHERE rec_no = l_rec_no;
2780:
2781: IF l_rec_id = '61' THEN
2782: UPDATE CE_STMT_INT_TMP
2783: SET rec_id_no = '61A'
2784: WHERE rec_no = C_rec.rec_no;
2785: ELSIF l_rec_id = '86' THEN
2786: UPDATE CE_STMT_INT_TMP

Line 2786: UPDATE CE_STMT_INT_TMP

2782: UPDATE CE_STMT_INT_TMP
2783: SET rec_id_no = '61A'
2784: WHERE rec_no = C_rec.rec_no;
2785: ELSIF l_rec_id = '86' THEN
2786: UPDATE CE_STMT_INT_TMP
2787: SET column1 = column1 || ' ' || C_rec.column1
2788: WHERE rec_no = l_rec_no;
2789:
2790: DELETE FROM CE_STMT_INT_TMP

Line 2790: DELETE FROM CE_STMT_INT_TMP

2786: UPDATE CE_STMT_INT_TMP
2787: SET column1 = column1 || ' ' || C_rec.column1
2788: WHERE rec_no = l_rec_no;
2789:
2790: DELETE FROM CE_STMT_INT_TMP
2791: WHERE rec_no = C_rec.rec_no;
2792: END IF;
2793: END IF; --4041064
2794: END LOOP;

Line 2799: FROM CE_STMT_INT_TMP

2795:
2796: FOR C_rec IN C_tmp_tbl2 LOOP
2797: SELECT rec_id_no
2798: INTO l_rec_id
2799: FROM CE_STMT_INT_TMP
2800: WHERE rec_no = C_rec.rec_no - 1;
2801:
2802: IF l_rec_id = '61' THEN
2803: UPDATE CE_STMT_INT_TMP -- This 86 record comes after 61.

Line 2803: UPDATE CE_STMT_INT_TMP -- This 86 record comes after 61.

2799: FROM CE_STMT_INT_TMP
2800: WHERE rec_no = C_rec.rec_no - 1;
2801:
2802: IF l_rec_id = '61' THEN
2803: UPDATE CE_STMT_INT_TMP -- This 86 record comes after 61.
2804: SET rec_id_no = '61A' -- Marks it as 61A.
2805: WHERE rec_no = C_rec.rec_no;
2806: ELSIF l_rec_id = '61A' THEN
2807: UPDATE CE_STMT_INT_TMP -- Comes after supplementary details (61A).

Line 2807: UPDATE CE_STMT_INT_TMP -- Comes after supplementary details (61A).

2803: UPDATE CE_STMT_INT_TMP -- This 86 record comes after 61.
2804: SET rec_id_no = '61A' -- Marks it as 61A.
2805: WHERE rec_no = C_rec.rec_no;
2806: ELSIF l_rec_id = '61A' THEN
2807: UPDATE CE_STMT_INT_TMP -- Comes after supplementary details (61A).
2808: SET column1 = column1 || ' ' -- Concatinate 86 to 61A.
2809: || C_rec.column1
2810: WHERE rec_no = C_rec.rec_no - 1;
2811:

Line 2812: DELETE FROM CE_STMT_INT_TMP -- Delete 86.

2808: SET column1 = column1 || ' ' -- Concatinate 86 to 61A.
2809: || C_rec.column1
2810: WHERE rec_no = C_rec.rec_no - 1;
2811:
2812: DELETE FROM CE_STMT_INT_TMP -- Delete 86.
2813: WHERE rec_no = C_rec.rec_no;
2814: END IF;
2815: END LOOP;
2816:

Line 2932: FROM CE_STMT_INT_TMP;

2928: -- Check if the CE_STAT_INT_TMP was populated by SQL*Loader.
2929: --
2930: SELECT count(*)
2931: INTO l_cnt
2932: FROM CE_STMT_INT_TMP;
2933: IF l_cnt = 0 THEN
2934: RAISE INVALID_DATA_FILE;
2935: END IF;
2936: