APPS.CE_BANK_STATEMENT_LOADER dependencies on CE_STMT_INT_TMP

Line 258: UPDATE CE_STMT_INT_TMP

254: BEGIN
255: /* Bug 7445326 - Added Carraige return newline character (ascii 13) for
256: removal along with linefeed character(^M - ascii 10)*/
257:
258: UPDATE CE_STMT_INT_TMP
259: SET REC_NO = rtrim(REC_NO, '
260: '||fnd_global.local_chr(13)),
261: REC_ID_NO = rtrim(REC_ID_NO, '
262: '||fnd_global.local_chr(13)),

Line 1157: FROM ce_stmt_int_tmp

1153: BEGIN
1154: IF (X_pos = 1) THEN
1155: SELECT substrb(rtrim(ltrim(column1)),1,255) /*12617141*/
1156: INTO l_result
1157: FROM ce_stmt_int_tmp
1158: WHERE rec_no = X_rec_no;
1159: ELSIF (X_pos = 2) THEN
1160: SELECT rtrim(ltrim(column2))
1161: INTO l_result

Line 1162: FROM ce_stmt_int_tmp

1158: WHERE rec_no = X_rec_no;
1159: ELSIF (X_pos = 2) THEN
1160: SELECT rtrim(ltrim(column2))
1161: INTO l_result
1162: FROM ce_stmt_int_tmp
1163: WHERE rec_no = X_rec_no;
1164: ELSIF (X_pos = 3) THEN
1165: SELECT rtrim(ltrim(column3))
1166: INTO l_result

Line 1167: FROM ce_stmt_int_tmp

1163: WHERE rec_no = X_rec_no;
1164: ELSIF (X_pos = 3) THEN
1165: SELECT rtrim(ltrim(column3))
1166: INTO l_result
1167: FROM ce_stmt_int_tmp
1168: WHERE rec_no = X_rec_no;
1169: ELSIF (X_pos = 4) THEN
1170: SELECT rtrim(ltrim(column4))
1171: INTO l_result

Line 1172: FROM ce_stmt_int_tmp

1168: WHERE rec_no = X_rec_no;
1169: ELSIF (X_pos = 4) THEN
1170: SELECT rtrim(ltrim(column4))
1171: INTO l_result
1172: FROM ce_stmt_int_tmp
1173: WHERE rec_no = X_rec_no;
1174: ELSIF (X_pos = 5) THEN
1175: SELECT rtrim(ltrim(column5))
1176: INTO l_result

Line 1177: FROM ce_stmt_int_tmp

1173: WHERE rec_no = X_rec_no;
1174: ELSIF (X_pos = 5) THEN
1175: SELECT rtrim(ltrim(column5))
1176: INTO l_result
1177: FROM ce_stmt_int_tmp
1178: WHERE rec_no = X_rec_no;
1179: ELSIF (X_pos = 6) THEN
1180: SELECT rtrim(ltrim(column6))
1181: INTO l_result

Line 1182: FROM ce_stmt_int_tmp

1178: WHERE rec_no = X_rec_no;
1179: ELSIF (X_pos = 6) THEN
1180: SELECT rtrim(ltrim(column6))
1181: INTO l_result
1182: FROM ce_stmt_int_tmp
1183: WHERE rec_no = X_rec_no;
1184: ELSIF (X_pos = 7) THEN
1185: SELECT rtrim(ltrim(column7))
1186: INTO l_result

Line 1187: FROM ce_stmt_int_tmp

1183: WHERE rec_no = X_rec_no;
1184: ELSIF (X_pos = 7) THEN
1185: SELECT rtrim(ltrim(column7))
1186: INTO l_result
1187: FROM ce_stmt_int_tmp
1188: WHERE rec_no = X_rec_no;
1189: ELSIF (X_pos = 8) THEN
1190: SELECT rtrim(ltrim(column8))
1191: INTO l_result

Line 1192: FROM ce_stmt_int_tmp

1188: WHERE rec_no = X_rec_no;
1189: ELSIF (X_pos = 8) THEN
1190: SELECT rtrim(ltrim(column8))
1191: INTO l_result
1192: FROM ce_stmt_int_tmp
1193: WHERE rec_no = X_rec_no;
1194: ELSIF (X_pos = 9) THEN
1195: SELECT rtrim(ltrim(column9))
1196: INTO l_result

Line 1197: FROM ce_stmt_int_tmp

1193: WHERE rec_no = X_rec_no;
1194: ELSIF (X_pos = 9) THEN
1195: SELECT rtrim(ltrim(column9))
1196: INTO l_result
1197: FROM ce_stmt_int_tmp
1198: WHERE rec_no = X_rec_no;
1199: ELSIF (X_pos = 10) THEN
1200: SELECT rtrim(ltrim(column10))
1201: INTO l_result

Line 1202: FROM ce_stmt_int_tmp

1198: WHERE rec_no = X_rec_no;
1199: ELSIF (X_pos = 10) THEN
1200: SELECT rtrim(ltrim(column10))
1201: INTO l_result
1202: FROM ce_stmt_int_tmp
1203: WHERE rec_no = X_rec_no;
1204: ELSIF (X_pos = 11) THEN
1205: SELECT rtrim(ltrim(column11))
1206: INTO l_result

Line 1207: FROM ce_stmt_int_tmp

1203: WHERE rec_no = X_rec_no;
1204: ELSIF (X_pos = 11) THEN
1205: SELECT rtrim(ltrim(column11))
1206: INTO l_result
1207: FROM ce_stmt_int_tmp
1208: WHERE rec_no = X_rec_no;
1209: ELSIF (X_pos = 12) THEN
1210: SELECT rtrim(ltrim(column12))
1211: INTO l_result

Line 1212: FROM ce_stmt_int_tmp

1208: WHERE rec_no = X_rec_no;
1209: ELSIF (X_pos = 12) THEN
1210: SELECT rtrim(ltrim(column12))
1211: INTO l_result
1212: FROM ce_stmt_int_tmp
1213: WHERE rec_no = X_rec_no;
1214: ELSIF (X_pos = 13) THEN
1215: SELECT rtrim(ltrim(column13))
1216: INTO l_result

Line 1217: FROM ce_stmt_int_tmp

1213: WHERE rec_no = X_rec_no;
1214: ELSIF (X_pos = 13) THEN
1215: SELECT rtrim(ltrim(column13))
1216: INTO l_result
1217: FROM ce_stmt_int_tmp
1218: WHERE rec_no = X_rec_no;
1219: ELSIF (X_pos = 14) THEN
1220: SELECT rtrim(ltrim(column14))
1221: INTO l_result

Line 1222: FROM ce_stmt_int_tmp

1218: WHERE rec_no = X_rec_no;
1219: ELSIF (X_pos = 14) THEN
1220: SELECT rtrim(ltrim(column14))
1221: INTO l_result
1222: FROM ce_stmt_int_tmp
1223: WHERE rec_no = X_rec_no;
1224: ELSIF (X_pos = 15) THEN
1225: SELECT rtrim(ltrim(column15))
1226: INTO l_result

Line 1227: FROM ce_stmt_int_tmp

1223: WHERE rec_no = X_rec_no;
1224: ELSIF (X_pos = 15) THEN
1225: SELECT rtrim(ltrim(column15))
1226: INTO l_result
1227: FROM ce_stmt_int_tmp
1228: WHERE rec_no = X_rec_no;
1229: ELSIF (X_pos = 16) THEN
1230: SELECT rtrim(ltrim(column16))
1231: INTO l_result

Line 1232: FROM ce_stmt_int_tmp

1228: WHERE rec_no = X_rec_no;
1229: ELSIF (X_pos = 16) THEN
1230: SELECT rtrim(ltrim(column16))
1231: INTO l_result
1232: FROM ce_stmt_int_tmp
1233: WHERE rec_no = X_rec_no;
1234: ELSIF (X_pos = 17) THEN
1235: SELECT rtrim(ltrim(column17))
1236: INTO l_result

Line 1237: FROM ce_stmt_int_tmp

1233: WHERE rec_no = X_rec_no;
1234: ELSIF (X_pos = 17) THEN
1235: SELECT rtrim(ltrim(column17))
1236: INTO l_result
1237: FROM ce_stmt_int_tmp
1238: WHERE rec_no = X_rec_no;
1239: ELSIF (X_pos = 18) THEN
1240: SELECT rtrim(ltrim(column18))
1241: INTO l_result

Line 1242: FROM ce_stmt_int_tmp

1238: WHERE rec_no = X_rec_no;
1239: ELSIF (X_pos = 18) THEN
1240: SELECT rtrim(ltrim(column18))
1241: INTO l_result
1242: FROM ce_stmt_int_tmp
1243: WHERE rec_no = X_rec_no;
1244: ELSIF (X_pos = 19) THEN
1245: SELECT rtrim(ltrim(column19))
1246: INTO l_result

Line 1247: FROM ce_stmt_int_tmp

1243: WHERE rec_no = X_rec_no;
1244: ELSIF (X_pos = 19) THEN
1245: SELECT rtrim(ltrim(column19))
1246: INTO l_result
1247: FROM ce_stmt_int_tmp
1248: WHERE rec_no = X_rec_no;
1249: ELSIF (X_pos = 20) THEN
1250: SELECT rtrim(ltrim(column20))
1251: INTO l_result

Line 1252: FROM ce_stmt_int_tmp

1248: WHERE rec_no = X_rec_no;
1249: ELSIF (X_pos = 20) THEN
1250: SELECT rtrim(ltrim(column20))
1251: INTO l_result
1252: FROM ce_stmt_int_tmp
1253: WHERE rec_no = X_rec_no;
1254: ELSIF (X_pos = 21) THEN
1255: SELECT rtrim(ltrim(column21))
1256: INTO l_result

Line 1257: FROM ce_stmt_int_tmp

1253: WHERE rec_no = X_rec_no;
1254: ELSIF (X_pos = 21) THEN
1255: SELECT rtrim(ltrim(column21))
1256: INTO l_result
1257: FROM ce_stmt_int_tmp
1258: WHERE rec_no = X_rec_no;
1259: ELSIF (X_pos = 22) THEN
1260: SELECT rtrim(ltrim(column22))
1261: INTO l_result

Line 1262: FROM ce_stmt_int_tmp

1258: WHERE rec_no = X_rec_no;
1259: ELSIF (X_pos = 22) THEN
1260: SELECT rtrim(ltrim(column22))
1261: INTO l_result
1262: FROM ce_stmt_int_tmp
1263: WHERE rec_no = X_rec_no;
1264: ELSIF (X_pos = 23) THEN
1265: SELECT rtrim(ltrim(column23))
1266: INTO l_result

Line 1267: FROM ce_stmt_int_tmp

1263: WHERE rec_no = X_rec_no;
1264: ELSIF (X_pos = 23) THEN
1265: SELECT rtrim(ltrim(column23))
1266: INTO l_result
1267: FROM ce_stmt_int_tmp
1268: WHERE rec_no = X_rec_no;
1269: ELSIF (X_pos = 24) THEN
1270: SELECT rtrim(ltrim(column24))
1271: INTO l_result

Line 1272: FROM ce_stmt_int_tmp

1268: WHERE rec_no = X_rec_no;
1269: ELSIF (X_pos = 24) THEN
1270: SELECT rtrim(ltrim(column24))
1271: INTO l_result
1272: FROM ce_stmt_int_tmp
1273: WHERE rec_no = X_rec_no;
1274: ELSIF (X_pos = 25) THEN
1275: SELECT rtrim(ltrim(column25))
1276: INTO l_result

Line 1277: FROM ce_stmt_int_tmp

1273: WHERE rec_no = X_rec_no;
1274: ELSIF (X_pos = 25) THEN
1275: SELECT rtrim(ltrim(column25))
1276: INTO l_result
1277: FROM ce_stmt_int_tmp
1278: WHERE rec_no = X_rec_no;
1279: ELSIF (X_pos = 26) THEN
1280: SELECT rtrim(ltrim(column26))
1281: INTO l_result

Line 1282: FROM ce_stmt_int_tmp

1278: WHERE rec_no = X_rec_no;
1279: ELSIF (X_pos = 26) THEN
1280: SELECT rtrim(ltrim(column26))
1281: INTO l_result
1282: FROM ce_stmt_int_tmp
1283: WHERE rec_no = X_rec_no;
1284: ELSIF (X_pos = 27) THEN
1285: SELECT rtrim(ltrim(column27))
1286: INTO l_result

Line 1287: FROM ce_stmt_int_tmp

1283: WHERE rec_no = X_rec_no;
1284: ELSIF (X_pos = 27) THEN
1285: SELECT rtrim(ltrim(column27))
1286: INTO l_result
1287: FROM ce_stmt_int_tmp
1288: WHERE rec_no = X_rec_no;
1289: ELSIF (X_pos = 28) THEN
1290: SELECT rtrim(ltrim(column28))
1291: INTO l_result

Line 1292: FROM ce_stmt_int_tmp

1288: WHERE rec_no = X_rec_no;
1289: ELSIF (X_pos = 28) THEN
1290: SELECT rtrim(ltrim(column28))
1291: INTO l_result
1292: FROM ce_stmt_int_tmp
1293: WHERE rec_no = X_rec_no;
1294: ELSIF (X_pos = 29) THEN
1295: SELECT rtrim(ltrim(column29))
1296: INTO l_result

Line 1297: FROM ce_stmt_int_tmp

1293: WHERE rec_no = X_rec_no;
1294: ELSIF (X_pos = 29) THEN
1295: SELECT rtrim(ltrim(column29))
1296: INTO l_result
1297: FROM ce_stmt_int_tmp
1298: WHERE rec_no = X_rec_no;
1299: ELSIF (X_pos = 30) THEN
1300: SELECT rtrim(ltrim(column30))
1301: INTO l_result

Line 1302: FROM ce_stmt_int_tmp

1298: WHERE rec_no = X_rec_no;
1299: ELSIF (X_pos = 30) THEN
1300: SELECT rtrim(ltrim(column30))
1301: INTO l_result
1302: FROM ce_stmt_int_tmp
1303: WHERE rec_no = X_rec_no;
1304: ELSIF (X_pos = 31) THEN
1305: SELECT rtrim(ltrim(column31))
1306: INTO l_result

Line 1307: FROM ce_stmt_int_tmp

1303: WHERE rec_no = X_rec_no;
1304: ELSIF (X_pos = 31) THEN
1305: SELECT rtrim(ltrim(column31))
1306: INTO l_result
1307: FROM ce_stmt_int_tmp
1308: WHERE rec_no = X_rec_no;
1309: ELSIF (X_pos = 32) THEN
1310: SELECT rtrim(ltrim(column32))
1311: INTO l_result

Line 1312: FROM ce_stmt_int_tmp

1308: WHERE rec_no = X_rec_no;
1309: ELSIF (X_pos = 32) THEN
1310: SELECT rtrim(ltrim(column32))
1311: INTO l_result
1312: FROM ce_stmt_int_tmp
1313: WHERE rec_no = X_rec_no;
1314: ELSIF (X_pos = 33) THEN
1315: SELECT rtrim(ltrim(column33))
1316: INTO l_result

Line 1317: FROM ce_stmt_int_tmp

1313: WHERE rec_no = X_rec_no;
1314: ELSIF (X_pos = 33) THEN
1315: SELECT rtrim(ltrim(column33))
1316: INTO l_result
1317: FROM ce_stmt_int_tmp
1318: WHERE rec_no = X_rec_no;
1319: ELSIF (X_pos = 34) THEN
1320: SELECT rtrim(ltrim(column34))
1321: INTO l_result

Line 1322: FROM ce_stmt_int_tmp

1318: WHERE rec_no = X_rec_no;
1319: ELSIF (X_pos = 34) THEN
1320: SELECT rtrim(ltrim(column34))
1321: INTO l_result
1322: FROM ce_stmt_int_tmp
1323: WHERE rec_no = X_rec_no;
1324: ELSIF (X_pos = 35) THEN
1325: SELECT rtrim(ltrim(column35))
1326: INTO l_result

Line 1327: FROM ce_stmt_int_tmp

1323: WHERE rec_no = X_rec_no;
1324: ELSIF (X_pos = 35) THEN
1325: SELECT rtrim(ltrim(column35))
1326: INTO l_result
1327: FROM ce_stmt_int_tmp
1328: WHERE rec_no = X_rec_no;
1329: END IF;
1330:
1331: --

Line 1416: FROM ce_stmt_int_tmp

1412: substr(column21,1,1)||substr(column22,1,1)||substr(column23,1,1)||substr(column24,1,1)||substr(column25,1,1)||
1413: substr(column26,1,1)||substr(column27,1,1)||substr(column28,1,1)||substr(column29,1,1)||substr(column30,1,1)||
1414: substr(column31,1,1)||substr(column32,1,1)||substr(column33,1,1)||substr(column34,1,1)||substr(column35,1,1)
1415: INTO l_str
1416: FROM ce_stmt_int_tmp
1417: WHERE rec_no = X_rec_no;
1418:
1419: RETURN LENGTH(l_str);
1420: END Find_Last_Column_Pos;

Line 1628: FROM ce_stmt_int_tmp

1624: --------------------------------------------------------------------- */
1625: PROCEDURE Decode_Line_BAI(X_rec_no NUMBER) IS
1626: CURSOR C_rec IS
1627: SELECT column3, column4
1628: FROM ce_stmt_int_tmp
1629: WHERE rec_no = X_rec_no;
1630:
1631: l_val1 VARCHAR2(100);
1632: l_val2 VARCHAR2(100);

Line 1718: FROM ce_stmt_int_tmp

1714: BEGIN
1715: IF (X_cnt = 1) THEN
1716: SELECT column1, column2, column3, column4, column5
1717: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1718: FROM ce_stmt_int_tmp
1719: WHERE rec_no = X_rec_no;
1720: ELSIF (X_cnt = 2) THEN
1721: SELECT column2, column3, column4, column5, column6
1722: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1723: FROM ce_stmt_int_tmp

1719: WHERE rec_no = X_rec_no;
1720: ELSIF (X_cnt = 2) THEN
1721: SELECT column2, column3, column4, column5, column6
1722: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1723: FROM ce_stmt_int_tmp
1724: WHERE rec_no = X_rec_no;
1725: ELSIF (X_cnt = 3) THEN
1726: SELECT column3, column4, column5, column6, column7
1727: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1728: FROM ce_stmt_int_tmp

1724: WHERE rec_no = X_rec_no;
1725: ELSIF (X_cnt = 3) THEN
1726: SELECT column3, column4, column5, column6, column7
1727: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1728: FROM ce_stmt_int_tmp
1729: WHERE rec_no = X_rec_no;
1730: ELSIF (X_cnt = 4) THEN
1731: SELECT column4, column5, column6, column7, column8
1732: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1733: FROM ce_stmt_int_tmp

1729: WHERE rec_no = X_rec_no;
1730: ELSIF (X_cnt = 4) THEN
1731: SELECT column4, column5, column6, column7, column8
1732: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1733: FROM ce_stmt_int_tmp
1734: WHERE rec_no = X_rec_no;
1735: ELSIF (X_cnt = 5) THEN
1736: SELECT column5, column6, column7, column8, column9
1737: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1738: FROM ce_stmt_int_tmp

1734: WHERE rec_no = X_rec_no;
1735: ELSIF (X_cnt = 5) THEN
1736: SELECT column5, column6, column7, column8, column9
1737: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1738: FROM ce_stmt_int_tmp
1739: WHERE rec_no = X_rec_no;
1740: ELSIF (X_cnt = 6) THEN
1741: SELECT column6, column7, column8, column9, column10
1742: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1743: FROM ce_stmt_int_tmp

1739: WHERE rec_no = X_rec_no;
1740: ELSIF (X_cnt = 6) THEN
1741: SELECT column6, column7, column8, column9, column10
1742: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1743: FROM ce_stmt_int_tmp
1744: WHERE rec_no = X_rec_no;
1745: ELSIF (X_cnt = 7) THEN
1746: SELECT column7, column8, column9, column10, column11
1747: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1748: FROM ce_stmt_int_tmp

1744: WHERE rec_no = X_rec_no;
1745: ELSIF (X_cnt = 7) THEN
1746: SELECT column7, column8, column9, column10, column11
1747: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1748: FROM ce_stmt_int_tmp
1749: WHERE rec_no = X_rec_no;
1750: ELSIF (X_cnt = 8) THEN
1751: SELECT column8, column9, column10, column11, column12
1752: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1753: FROM ce_stmt_int_tmp

1749: WHERE rec_no = X_rec_no;
1750: ELSIF (X_cnt = 8) THEN
1751: SELECT column8, column9, column10, column11, column12
1752: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1753: FROM ce_stmt_int_tmp
1754: WHERE rec_no = X_rec_no;
1755: ELSIF (X_cnt = 9) THEN
1756: SELECT column9, column10, column11, column12, column13
1757: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1758: FROM ce_stmt_int_tmp

1754: WHERE rec_no = X_rec_no;
1755: ELSIF (X_cnt = 9) THEN
1756: SELECT column9, column10, column11, column12, column13
1757: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1758: FROM ce_stmt_int_tmp
1759: WHERE rec_no = X_rec_no;
1760: ELSIF (X_cnt = 10) THEN
1761: SELECT column10, column11, column12, column13, column14
1762: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1763: FROM ce_stmt_int_tmp

1759: WHERE rec_no = X_rec_no;
1760: ELSIF (X_cnt = 10) THEN
1761: SELECT column10, column11, column12, column13, column14
1762: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1763: FROM ce_stmt_int_tmp
1764: WHERE rec_no = X_rec_no;
1765: ELSIF (X_cnt = 11) THEN
1766: SELECT column11, column12, column13, column14, column15
1767: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1768: FROM ce_stmt_int_tmp

1764: WHERE rec_no = X_rec_no;
1765: ELSIF (X_cnt = 11) THEN
1766: SELECT column11, column12, column13, column14, column15
1767: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1768: FROM ce_stmt_int_tmp
1769: WHERE rec_no = X_rec_no;
1770: ELSIF (X_cnt = 12) THEN
1771: SELECT column12, column13, column14, column15, column16
1772: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1773: FROM ce_stmt_int_tmp

1769: WHERE rec_no = X_rec_no;
1770: ELSIF (X_cnt = 12) THEN
1771: SELECT column12, column13, column14, column15, column16
1772: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1773: FROM ce_stmt_int_tmp
1774: WHERE rec_no = X_rec_no;
1775: ELSIF (X_cnt = 13) THEN
1776: SELECT column13, column14, column15, column16, column17
1777: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1778: FROM ce_stmt_int_tmp

1774: WHERE rec_no = X_rec_no;
1775: ELSIF (X_cnt = 13) THEN
1776: SELECT column13, column14, column15, column16, column17
1777: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1778: FROM ce_stmt_int_tmp
1779: WHERE rec_no = X_rec_no;
1780: ELSIF (X_cnt = 14) THEN
1781: SELECT column14, column15, column16, column17, column18
1782: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1783: FROM ce_stmt_int_tmp

1779: WHERE rec_no = X_rec_no;
1780: ELSIF (X_cnt = 14) THEN
1781: SELECT column14, column15, column16, column17, column18
1782: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1783: FROM ce_stmt_int_tmp
1784: WHERE rec_no = X_rec_no;
1785: ELSIF (X_cnt = 15) THEN
1786: SELECT column15, column16, column17, column18, column19
1787: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1788: FROM ce_stmt_int_tmp

1784: WHERE rec_no = X_rec_no;
1785: ELSIF (X_cnt = 15) THEN
1786: SELECT column15, column16, column17, column18, column19
1787: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1788: FROM ce_stmt_int_tmp
1789: WHERE rec_no = X_rec_no;
1790: ELSIF (X_cnt = 16) THEN
1791: SELECT column16, column17, column18, column19, column20
1792: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1793: FROM ce_stmt_int_tmp

1789: WHERE rec_no = X_rec_no;
1790: ELSIF (X_cnt = 16) THEN
1791: SELECT column16, column17, column18, column19, column20
1792: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1793: FROM ce_stmt_int_tmp
1794: WHERE rec_no = X_rec_no;
1795: ELSIF (X_cnt = 17) THEN
1796: SELECT column17, column18, column19, column20, column21
1797: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1798: FROM ce_stmt_int_tmp

1794: WHERE rec_no = X_rec_no;
1795: ELSIF (X_cnt = 17) THEN
1796: SELECT column17, column18, column19, column20, column21
1797: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1798: FROM ce_stmt_int_tmp
1799: WHERE rec_no = X_rec_no;
1800: ELSIF (X_cnt = 18) THEN
1801: SELECT column18, column19, column20, column21, column22
1802: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1803: FROM ce_stmt_int_tmp

1799: WHERE rec_no = X_rec_no;
1800: ELSIF (X_cnt = 18) THEN
1801: SELECT column18, column19, column20, column21, column22
1802: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1803: FROM ce_stmt_int_tmp
1804: WHERE rec_no = X_rec_no;
1805: ELSIF (X_cnt = 19) THEN
1806: SELECT column19, column20, column21, column22, column23
1807: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1808: FROM ce_stmt_int_tmp

1804: WHERE rec_no = X_rec_no;
1805: ELSIF (X_cnt = 19) THEN
1806: SELECT column19, column20, column21, column22, column23
1807: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1808: FROM ce_stmt_int_tmp
1809: WHERE rec_no = X_rec_no;
1810: ELSIF (X_cnt = 20) THEN
1811: SELECT column20, column21, column22, column23, column24
1812: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1813: FROM ce_stmt_int_tmp

1809: WHERE rec_no = X_rec_no;
1810: ELSIF (X_cnt = 20) THEN
1811: SELECT column20, column21, column22, column23, column24
1812: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1813: FROM ce_stmt_int_tmp
1814: WHERE rec_no = X_rec_no;
1815: ELSIF (X_cnt = 21) THEN
1816: SELECT column21, column22, column23, column24, column25
1817: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1818: FROM ce_stmt_int_tmp

1814: WHERE rec_no = X_rec_no;
1815: ELSIF (X_cnt = 21) THEN
1816: SELECT column21, column22, column23, column24, column25
1817: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1818: FROM ce_stmt_int_tmp
1819: WHERE rec_no = X_rec_no;
1820: ELSIF (X_cnt = 22) THEN
1821: SELECT column22, column23, column24, column25, column26
1822: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1823: FROM ce_stmt_int_tmp

1819: WHERE rec_no = X_rec_no;
1820: ELSIF (X_cnt = 22) THEN
1821: SELECT column22, column23, column24, column25, column26
1822: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1823: FROM ce_stmt_int_tmp
1824: WHERE rec_no = X_rec_no;
1825: ELSIF (X_cnt = 23) THEN
1826: SELECT column23, column24, column25, column26, column27
1827: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1828: FROM ce_stmt_int_tmp

1824: WHERE rec_no = X_rec_no;
1825: ELSIF (X_cnt = 23) THEN
1826: SELECT column23, column24, column25, column26, column27
1827: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1828: FROM ce_stmt_int_tmp
1829: WHERE rec_no = X_rec_no;
1830: ELSIF (X_cnt = 24) THEN
1831: SELECT column24, column25, column26, column27, column28
1832: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1833: FROM ce_stmt_int_tmp

1829: WHERE rec_no = X_rec_no;
1830: ELSIF (X_cnt = 24) THEN
1831: SELECT column24, column25, column26, column27, column28
1832: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1833: FROM ce_stmt_int_tmp
1834: WHERE rec_no = X_rec_no;
1835: ELSIF (X_cnt = 25) THEN
1836: SELECT column25, column26, column27, column28, column29
1837: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1838: FROM ce_stmt_int_tmp

1834: WHERE rec_no = X_rec_no;
1835: ELSIF (X_cnt = 25) THEN
1836: SELECT column25, column26, column27, column28, column29
1837: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1838: FROM ce_stmt_int_tmp
1839: WHERE rec_no = X_rec_no;
1840: ELSIF (X_cnt = 26) THEN
1841: SELECT column26, column27, column28, column29, column30
1842: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1843: FROM ce_stmt_int_tmp

1839: WHERE rec_no = X_rec_no;
1840: ELSIF (X_cnt = 26) THEN
1841: SELECT column26, column27, column28, column29, column30
1842: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1843: FROM ce_stmt_int_tmp
1844: WHERE rec_no = X_rec_no;
1845: ELSIF (X_cnt = 27) THEN
1846: SELECT column27, column28, column29, column30, column31
1847: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1848: FROM ce_stmt_int_tmp

1844: WHERE rec_no = X_rec_no;
1845: ELSIF (X_cnt = 27) THEN
1846: SELECT column27, column28, column29, column30, column31
1847: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1848: FROM ce_stmt_int_tmp
1849: WHERE rec_no = X_rec_no;
1850: ELSIF (X_cnt = 28) THEN
1851: SELECT column28, column29, column30, column31, column32
1852: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1853: FROM ce_stmt_int_tmp

1849: WHERE rec_no = X_rec_no;
1850: ELSIF (X_cnt = 28) THEN
1851: SELECT column28, column29, column30, column31, column32
1852: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1853: FROM ce_stmt_int_tmp
1854: WHERE rec_no = X_rec_no;
1855: ELSIF (X_cnt = 29) THEN
1856: SELECT column29, column30, column31, column32, column33
1857: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1858: FROM ce_stmt_int_tmp

1854: WHERE rec_no = X_rec_no;
1855: ELSIF (X_cnt = 29) THEN
1856: SELECT column29, column30, column31, column32, column33
1857: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1858: FROM ce_stmt_int_tmp
1859: WHERE rec_no = X_rec_no;
1860: ELSIF (X_cnt = 30) THEN
1861: SELECT column30, column31, column32, column33, column34
1862: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1863: FROM ce_stmt_int_tmp

1859: WHERE rec_no = X_rec_no;
1860: ELSIF (X_cnt = 30) THEN
1861: SELECT column30, column31, column32, column33, column34
1862: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1863: FROM ce_stmt_int_tmp
1864: WHERE rec_no = X_rec_no;
1865: ELSIF (X_cnt = 31) THEN
1866: SELECT column31, column32, column33, column34, column35
1867: INTO X_col1, X_col2, X_col3, X_col4, X_col5

Line 1868: FROM ce_stmt_int_tmp

1864: WHERE rec_no = X_rec_no;
1865: ELSIF (X_cnt = 31) THEN
1866: SELECT column31, column32, column33, column34, column35
1867: INTO X_col1, X_col2, X_col3, X_col4, X_col5
1868: FROM ce_stmt_int_tmp
1869: WHERE rec_no = X_rec_no;
1870:
1871: ELSIF (X_cnt = 32) THEN
1872: SELECT column32, column33, column34, column35

Line 1874: FROM ce_stmt_int_tmp

1870:
1871: ELSIF (X_cnt = 32) THEN
1872: SELECT column32, column33, column34, column35
1873: INTO X_col1, X_col2, X_col3, X_col4
1874: FROM ce_stmt_int_tmp
1875: WHERE rec_no = X_rec_no;
1876:
1877: IF (X_str IS NOT NULL AND G_only_03='Y' ) THEN
1878: X_col5 :=get_value_with_pos(1,X_str);

Line 1884: FROM ce_stmt_int_tmp

1880:
1881: ELSIF (X_cnt = 33) THEN
1882: SELECT column33, column34, column35
1883: INTO X_col1, X_col2, X_col3
1884: FROM ce_stmt_int_tmp
1885: WHERE rec_no = X_rec_no;
1886:
1887: IF (X_str IS NOT NULL AND G_only_03='Y' ) THEN
1888: X_col4 :=get_value_with_pos(1,X_str);

Line 1895: FROM ce_stmt_int_tmp

1891:
1892: ELSIF (X_cnt = 34) THEN
1893: SELECT column34, column35
1894: INTO X_col1, X_col2
1895: FROM ce_stmt_int_tmp
1896: WHERE rec_no = X_rec_no;
1897:
1898: IF (X_str IS NOT NULL AND G_only_03='Y' ) THEN
1899:

Line 1910: FROM ce_stmt_int_tmp

1906:
1907: ELSIF (X_cnt = 35) THEN
1908: SELECT column35
1909: INTO X_col1
1910: FROM ce_stmt_int_tmp
1911: WHERE rec_no = X_rec_no;
1912:
1913: IF (X_str IS NOT NULL AND G_only_03='Y' ) THEN
1914:

Line 1985: FROM ce_stmt_int_tmp WHERE rec_no = X_rec_no;

1981: /*Start of 13324534*/
1982: IF(G_only_03 = 'Y') THEN
1983:
1984: SELECT column36 INTO l_str
1985: FROM ce_stmt_int_tmp WHERE rec_no = X_rec_no;
1986:
1987: l_str:= rtrim(l_str, '
1988: '||fnd_global.local_chr(13));
1989:

Line 2197: FROM ce_stmt_int_tmp

2193: PROCEDURE Load_BAI2 IS
2194:
2195: CURSOR C_tmp_tbl IS
2196: SELECT rec_no, rec_id_no, column1, rtrim(replace(column2,' '),'/') col2, column6, rtrim(replace(column8,' '),'/') col8
2197: FROM ce_stmt_int_tmp
2198: ORDER BY rec_no;
2199:
2200: CURSOR C_trx_text IS
2201: SELECT column_name,

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

2218: l_err NUMBER;
2219: l_statement_date DATE;
2220: l_bank_trx_num VARCHAR2(240);
2221: l_process_this_record BOOLEAN := TRUE; /* 2643505 */
2222: l_rec ce_stmt_int_tmp%rowtype; -- Bug 3228203
2223: l_hdr_precision NUMBER; -- OXY ER
2224: l_line_precision NUMBER; -- OXY ER
2225: l_exchange_rate VARCHAR2(250):=null; /* 13947921 */
2226: BEGIN

Line 2381: FROM ce_stmt_int_tmp

2377:
2378: BEGIN /* 13697994: Added EXCEPTION block */
2379: SELECT 'Y'
2380: INTO G_only_03
2381: FROM ce_stmt_int_tmp
2382: WHERE rec_id_no =C_rec.rec_id_no
2383: AND rec_no=C_rec.rec_no
2384: AND COLUMN36 IS NOT NULL; --G_only_03
2385: EXCEPTION

Line 2475: SELECT * INTO l_rec FROM ce_stmt_int_tmp

2471: /* 2643505 Added the IF Condition */
2472: IF l_process_this_record THEN
2473: /* Bug3228203 added the following select stmt and modified
2474: the next update stmt.*/
2475: SELECT * INTO l_rec FROM ce_stmt_int_tmp
2476: WHERE rec_id_no = C_rec.rec_id_no AND rec_no = C_rec.rec_no;
2477:
2478: /* Bug 6792668 Added rtrim */
2479: /*added substrb for bug 13831088 */

Line 2905: FROM ce_stmt_int_tmp

2901: IF X_hdr_or_Line = 'L' THEN
2902: FOR C_rec IN C_line_rec_id LOOP
2903: SELECT MIN(rec_no)
2904: INTO l_min_rec_no
2905: FROM ce_stmt_int_tmp
2906: WHERE rec_id_no = C_rec.recID;
2907:
2908: IF l_lowest_rec_no > l_min_rec_no THEN
2909: l_lowest_rec_no := l_min_rec_no;

Line 2917: FROM ce_stmt_int_tmp

2913: ELSE
2914: FOR C_rec IN C_hdr_rec_id LOOP
2915: SELECT MIN(rec_no)
2916: INTO l_min_rec_no
2917: FROM ce_stmt_int_tmp
2918: WHERE rec_id_no = C_rec.recID;
2919:
2920: IF l_lowest_rec_no > l_min_rec_no THEN
2921: l_lowest_rec_no := l_min_rec_no;

Line 2960: FROM CE_STMT_INT_TMP

2956: --------------------------------------------------------------------- */
2957: PROCEDURE Load_Others IS
2958: CURSOR C_tmp_tbl IS
2959: SELECT rec_no, rec_id_no
2960: FROM CE_STMT_INT_TMP
2961: ORDER BY rec_no;
2962:
2963: CURSOR C_hdr_tbl(p_rec_id VARCHAR2) IS
2964: SELECT column_name, position

Line 3185: FROM CE_STMT_INT_TMP

3181: IS
3182: CURSOR C_tmp_tbl IS
3183: SELECT rec_no,
3184: column35
3185: FROM CE_STMT_INT_TMP
3186: WHERE rec_id_no = '61'
3187: ORDER BY rec_no;
3188:
3189: l_col2 VARCHAR2(255);

Line 3286: UPDATE CE_STMT_INT_TMP

3282: ||',l_col6='||l_col6
3283: ||',l_col7='||l_col7
3284: ||',l_col8='||l_col8);
3285:
3286: UPDATE CE_STMT_INT_TMP
3287: SET column2 = l_col2,
3288: column3 = l_col3,
3289: column4 = l_col4,
3290: column5 = l_col5,

Line 3312: FROM CE_STMT_INT_TMP

3308: PROCEDURE Decode_Description
3309: IS
3310: CURSOR C_tmp_tbl IS
3311: SELECT rec_no, column1
3312: FROM CE_STMT_INT_TMP
3313: WHERE rec_id_no = '9'
3314: ORDER BY rec_no;
3315:
3316: CURSOR C_tmp_tbl2 IS

Line 3318: FROM CE_STMT_INT_TMP

3314: ORDER BY rec_no;
3315:
3316: CURSOR C_tmp_tbl2 IS
3317: SELECT rec_no,column1
3318: FROM CE_STMT_INT_TMP
3319: WHERE rec_id_no = '86'
3320: ORDER BY rec_no;
3321:
3322: l_rec_no NUMBER;

Line 3337: FROM CE_STMT_INT_TMP

3333: ||',C_rec.column1='||C_rec.column1);
3334:
3335: SELECT MAX(rec_no)
3336: INTO l_rec_no
3337: FROM CE_STMT_INT_TMP
3338: WHERE rec_no < C_rec.rec_no
3339: AND rec_id_no <> '9';
3340:
3341:

Line 3348: FROM CE_STMT_INT_TMP

3344: /* Bug 4041064 added the following IF */
3345: IF l_rec_no IS NOT NULL THEN
3346: SELECT rec_id_no
3347: INTO l_rec_id
3348: FROM CE_STMT_INT_TMP
3349: WHERE rec_no = l_rec_no;
3350:
3351: IF l_rec_id = '61' THEN
3352: UPDATE CE_STMT_INT_TMP

Line 3352: UPDATE CE_STMT_INT_TMP

3348: FROM CE_STMT_INT_TMP
3349: WHERE rec_no = l_rec_no;
3350:
3351: IF l_rec_id = '61' THEN
3352: UPDATE CE_STMT_INT_TMP
3353: SET rec_id_no = '61A'
3354: WHERE rec_no = C_rec.rec_no;
3355: ELSIF l_rec_id = '86' THEN
3356: UPDATE CE_STMT_INT_TMP

Line 3356: UPDATE CE_STMT_INT_TMP

3352: UPDATE CE_STMT_INT_TMP
3353: SET rec_id_no = '61A'
3354: WHERE rec_no = C_rec.rec_no;
3355: ELSIF l_rec_id = '86' THEN
3356: UPDATE CE_STMT_INT_TMP
3357: SET column1 = column1 || ' ' || C_rec.column1
3358: WHERE rec_no = l_rec_no;
3359:
3360: DELETE FROM CE_STMT_INT_TMP

Line 3360: DELETE FROM CE_STMT_INT_TMP

3356: UPDATE CE_STMT_INT_TMP
3357: SET column1 = column1 || ' ' || C_rec.column1
3358: WHERE rec_no = l_rec_no;
3359:
3360: DELETE FROM CE_STMT_INT_TMP
3361: WHERE rec_no = C_rec.rec_no;
3362: END IF;
3363: END IF; --4041064
3364: END LOOP;

Line 3374: FROM CE_STMT_INT_TMP

3370: ||',C_rec.column1='||C_rec.column1);
3371:
3372: /* SELECT rec_id_no
3373: INTO l_rec_id
3374: FROM CE_STMT_INT_TMP
3375: WHERE rec_no = C_rec.rec_no - 1; */ /*commented for 14578532*/
3376:
3377: SELECT rec_id_no, rec_no /* 14578532 */
3378: INTO l_rec_id , l_rec_id_no

Line 3379: FROM CE_STMT_INT_TMP

3375: WHERE rec_no = C_rec.rec_no - 1; */ /*commented for 14578532*/
3376:
3377: SELECT rec_id_no, rec_no /* 14578532 */
3378: INTO l_rec_id , l_rec_id_no
3379: FROM CE_STMT_INT_TMP
3380: WHERE rec_no = (SELECT Max(rec_no) FROM
3381: CE_STMT_INT_TMP WHERE rec_id_no IN ( '61', '61A')
3382: AND rec_no < C_rec.rec_no);
3383:

Line 3381: CE_STMT_INT_TMP WHERE rec_id_no IN ( '61', '61A')

3377: SELECT rec_id_no, rec_no /* 14578532 */
3378: INTO l_rec_id , l_rec_id_no
3379: FROM CE_STMT_INT_TMP
3380: WHERE rec_no = (SELECT Max(rec_no) FROM
3381: CE_STMT_INT_TMP WHERE rec_id_no IN ( '61', '61A')
3382: AND rec_no < C_rec.rec_no);
3383:
3384:
3385: cep_standard.debug('l_rec_id='||l_rec_id||' l_rec_id_no:'||l_rec_id_no);

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

3384:
3385: cep_standard.debug('l_rec_id='||l_rec_id||' l_rec_id_no:'||l_rec_id_no);
3386:
3387: IF l_rec_id = '61' THEN
3388: UPDATE CE_STMT_INT_TMP -- This 86 record comes after 61.
3389: SET rec_id_no = '61A' -- Marks it as 61A.
3390: WHERE rec_no = C_rec.rec_no;
3391: ELSIF l_rec_id = '61A' THEN
3392: UPDATE CE_STMT_INT_TMP -- Comes after supplementary details (61A).

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

3388: UPDATE CE_STMT_INT_TMP -- This 86 record comes after 61.
3389: SET rec_id_no = '61A' -- Marks it as 61A.
3390: WHERE rec_no = C_rec.rec_no;
3391: ELSIF l_rec_id = '61A' THEN
3392: UPDATE CE_STMT_INT_TMP -- Comes after supplementary details (61A).
3393: SET column1 = column1 || ' ' -- Concatinate 86 to 61A.
3394: || C_rec.column1
3395: WHERE rec_no = l_rec_id_no; /*Bug 14578532 Replaced C_rec.rec_no - 1 with l_rec_id_no*/
3396:

Line 3398: DELETE FROM CE_STMT_INT_TMP -- Delete 86.

3394: || C_rec.column1
3395: WHERE rec_no = l_rec_id_no; /*Bug 14578532 Replaced C_rec.rec_no - 1 with l_rec_id_no*/
3396:
3397:
3398: DELETE FROM CE_STMT_INT_TMP -- Delete 86.
3399: WHERE rec_no = C_rec.rec_no;
3400: END IF;
3401: END LOOP;
3402:

Line 3531: FROM CE_STMT_INT_TMP;

3527: -- Check if the CE_STAT_INT_TMP was populated by SQL*Loader.
3528: --
3529: SELECT count(*)
3530: INTO l_cnt
3531: FROM CE_STMT_INT_TMP;
3532: IF l_cnt = 0 THEN
3533: RAISE INVALID_DATA_FILE;
3534: END IF;
3535: