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 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 61


|	Initialize Header variables after Insertion of the Header	|
|   	Record. 							|
|									|
|  CALLED BY								|
|	Load_BAI2, Load_Others						|
|  REQUIRES								|
|									|
|  HISTORY								|
|	19-MAY-1999	Created		BHCHUNG				|
 --------------------------------------------------------------------- */
PROCEDURE Init_Hdr_Rec IS
BEGIN
  G_bank_name 		:= NULL;

Line: 101


|	Initialize Line variables after Insertion of the Line		|
|   	Record. 							|
|									|
|  CALLED BY								|
|	Load_BAI2, Load_Others						|
|  REQUIRES								|
|									|
|  HISTORY								|
|	19-MAY-1999	Created		BHCHUNG				|
 --------------------------------------------------------------------- */
PROCEDURE Init_Line_Rec IS
BEGIN
  G_line_number		:= NULL;

Line: 134


  UPDATE CE_STMT_INT_TMP
  SET    REC_NO = rtrim(REC_NO, '
'),
 	 REC_ID_NO = rtrim(REC_ID_NO, '
'),
         COLUMN1 = rtrim(COLUMN1, '
'),
         COLUMN2 = rtrim(COLUMN2, '
'),
         COLUMN3 = rtrim(COLUMN3, '
'),
         COLUMN4 = rtrim(COLUMN4, '
'),
         COLUMN5 = rtrim(COLUMN5, '
'),
         COLUMN6 = rtrim(COLUMN6, '
'),
         COLUMN7 = rtrim(COLUMN7, '
'),
         COLUMN8 = rtrim(COLUMN8, '
'),
         COLUMN9 = rtrim(COLUMN9, '
'),
         COLUMN10 = rtrim(COLUMN10, '
'),
         COLUMN11 = rtrim(COLUMN11, '
'),
         COLUMN12 = rtrim(COLUMN12, '
'),
         COLUMN13 = rtrim(COLUMN13, '
'),
         COLUMN14 = rtrim(COLUMN14, '
'),
         COLUMN15 = rtrim(COLUMN15, '
'),
         COLUMN16 = rtrim(COLUMN16, '
'),
         COLUMN17 = rtrim(COLUMN17, '
'),
         COLUMN18 = rtrim(COLUMN18, '
'),
         COLUMN19 = rtrim(COLUMN19, '
'),
         COLUMN20 = rtrim(COLUMN20, '
'),
         COLUMN21 = rtrim(COLUMN21, '
'),
         COLUMN22 = rtrim(COLUMN22, '
'),
         COLUMN23 = rtrim(COLUMN23, '
'),
         COLUMN24 = rtrim(COLUMN24, '
'),
         COLUMN25 = rtrim(COLUMN25, '
'),
         COLUMN26 = rtrim(COLUMN26, '
'),
         COLUMN27 = rtrim(COLUMN27, '
'),
         COLUMN28 = rtrim(COLUMN28, '
'),
         COLUMN29 = rtrim(COLUMN29, '
'),
         COLUMN30 = rtrim(COLUMN30, '
'),
         COLUMN31 = rtrim(COLUMN31, '
'),
         COLUMN32 = rtrim(COLUMN32, '
'),
         COLUMN33 = rtrim(COLUMN33, '
'),
         COLUMN34 = rtrim(COLUMN34, '
'),
         COLUMN35 = rtrim(COLUMN35, '
');

Line: 198


    CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(G_rec_no, 0), fnd_message.get, 'E');

Line: 210


    CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(G_rec_no, 0), fnd_message.get, 'E');

Line: 234


|	Insert_Hdr, Insert_Line						|
|  REQUIRES								|
|									|
|  HISTORY								|
|	19-MAY-1999	Created		BHCHUNG				|
 --------------------------------------------------------------------- */
FUNCTION Valid_Statement RETURN BOOLEAN IS
  l_cnt			NUMBER := 1;

Line: 247


    SELECT count(*)
    INTO   l_cnt
    FROM   CE_BANK_ACCOUNTS --FROM   AP_BANK_ACCOUNTS_ALL
    WHERE  bank_account_id  = G_bank_account_id
    AND    bank_account_num = G_bank_account_num;

Line: 253


    SELECT count(*)
    INTO   l_cnt
    FROM   CE_BANK_BRANCHES_V --FROM   AP_BANK_BRANCHES
    WHERE  branch_party_id   = G_bank_branch_id
    AND    bank_branch_name = G_bank_branch_name;

Line: 270


|       Delete_Orphaned_Lines 						|
|									|
|  DESCRIPTION								|
|	Delete Orphaned Lines.			                        |
|									|
|  CALLED BY								|
|	Load_Others						        |
|  REQUIRES								|
|									|
|  HISTORY								|
|	12-12-2001	Created		HEHAN				|
 --------------------------------------------------------------------- */
PROCEDURE Delete_Orphaned_Lines IS
  l_bank_account_num  ce_statement_lines_interface.bank_account_num%TYPE;

Line: 288


    SELECT bank_account_num, statement_number
    FROM ce_statement_lines_interface;

Line: 297


         SELECT count (1)
         INTO h_rec_cnt
         FROM ce_statement_headers_int
         WHERE bank_account_num = l_bank_account_num
         AND statement_number = l_statement_number;

Line: 304


         DELETE FROM ce_statement_lines_interface
         WHERE bank_account_num = l_bank_account_num
         AND statement_number = l_statement_number;

Line: 311


END Delete_Orphaned_Lines;

Line: 321


|	Insert_Hdr   						|
|  REQUIRES								|
|									|
|  HISTORY								|
|	25-MAY-2005	Created		JIKUMAR				|
 --------------------------------------------------------------------- */
PROCEDURE Validate_Subsidiary_Account IS
  l_rec_cnt		NUMBER;

Line: 331


	SELECT count(1)
	INTO l_rec_cnt
	FROM CE_BANK_ACCOUNTS BA,
	     CE_BANK_BRANCHES_V BB
	WHERE BA.ACCOUNT_CLASSIFICATION = 'SUBSIDIARY' AND
	      BB.branch_party_id   = BA.bank_branch_id AND
              BA.bank_account_num = G_bank_account_num AND
	      BB.BANK_BRANCH_NAME 		 = nvl(G_bank_branch_name,BB.BANK_BRANCH_NAME);

Line: 353


|	Insert_Hdr 							|
|									|
|  DESCRIPTION								|
|	Insert Header Record to Interface Table.			|
|									|
|  CALLED BY								|
|	Load_BAI2, Load_Others						|
|  REQUIRES								|
|									|
|  HISTORY								|
|	19-MAY-1999	Created		BHCHUNG				|
 --------------------------------------------------------------------- */
PROCEDURE Insert_Hdr IS
  l_rec_cnt		NUMBER;

Line: 380


    SELECT count(*)
    FROM   CE_SQLLDR_ERRORS
    WHERE  statement_number = G_statement_number
    AND    bank_account_num = G_bank_account_num;

Line: 386


    cep_standard.debug('>>CE_BANK_STATEMENT_LOADER.Insert_Hdr');

Line: 420


    SELECT count(1)
    INTO   G_total_line_deleted
    FROM   ce_statement_lines_interface
    WHERE  statement_number = l_statement_number
    AND    bank_account_num = G_bank_account_num;

Line: 426


    DELETE ce_statement_lines_interface
    WHERE  statement_number = l_statement_number
    AND    bank_account_num = G_bank_account_num;

Line: 430


    UPDATE ce_statement_lines_interface
    SET    statement_number = l_statement_number
    WHERE  statement_number = G_statement_number || ' - ' || to_char(sysdate);

Line: 446


      SELECT count(1)
      INTO   l_rec_cnt
      FROM   ce_statement_headers_int
      WHERE  bank_account_num = G_bank_account_num
      AND	 statement_number = l_statement_number
      AND  nvl(org_id,G_org_id) = G_org_id;

Line: 453


      SELECT count(1)
      INTO   l_rec_cnt
      FROM   ce_statement_headers_int
      WHERE  bank_account_num = G_bank_account_num
      AND	 statement_number = l_statement_number;

Line: 461


        DELETE FROM ce_statement_headers_int
        WHERE  bank_account_num = G_bank_account_num
        AND	 statement_number = l_statement_number
        AND  nvl(org_id,G_org_id) = G_org_id;

Line: 466


        DELETE FROM ce_statement_headers_int
        WHERE  bank_account_num = G_bank_account_num
        AND	 statement_number = l_statement_number;

Line: 470


      G_total_hdr_deleted := G_total_hdr_deleted + l_rec_cnt;

Line: 476


    INSERT INTO ce_statement_headers_int(
   	STATEMENT_NUMBER,
 	BANK_ACCOUNT_NUM,
 	STATEMENT_DATE,
 	BANK_NAME,
 	BANK_BRANCH_NAME,
 	CONTROL_BEGIN_BALANCE,
 	CONTROL_END_BALANCE,
 	CASHFLOW_BALANCE,
 	INT_CALC_BALANCE,
	AVERAGE_CLOSE_LEDGER_MTD,
	AVERAGE_CLOSE_LEDGER_YTD,
	AVERAGE_CLOSE_AVAILABLE_MTD,
	AVERAGE_CLOSE_AVAILABLE_YTD,
	ONE_DAY_FLOAT,
	TWO_DAY_FLOAT,
 	CONTROL_TOTAL_DR,
 	CONTROL_TOTAL_CR,
 	CONTROL_DR_LINE_COUNT,
 	CONTROL_CR_LINE_COUNT,
 	CONTROL_LINE_COUNT,
	CHECK_DIGITS,
 	RECORD_STATUS_FLAG,
 	CURRENCY_CODE,
 	CREATED_BY,
 	CREATION_DATE ,
	LAST_UPDATED_BY,
 	LAST_UPDATE_DATE,
 	--ORG_ID,
	INTRA_DAY_FLAG,
	SUBSIDIARY_FLAG)
    VALUES(
  	rtrim(l_statement_number),
  	rtrim(G_bank_account_num),
  	G_statement_date,
  	rtrim(G_bank_name),
  	rtrim(G_bank_branch_name),
  	G_control_begin_balance,
  	G_control_end_balance,
  	G_cashflow_balance,
  	G_int_calc_balance,
	G_average_close_ledger_mtd,
	G_average_close_ledger_ytd,
	G_average_close_available_mtd,
	G_average_close_available_ytd,
	G_one_day_float,
	G_two_day_float,
  	G_control_total_dr,
  	G_control_total_cr,
  	G_control_dr_line_count,
  	G_control_cr_line_count,
	G_control_line_count,
        G_check_digits,
      	'N',
  	rtrim(rtrim(G_hdr_currency_code),'/'),
	G_user_id,
 	SYSDATE,
 	G_user_id,
	SYSDATE,
	--G_org_id,
	G_intra_day_flag,
	G_subsidiary_flag);

Line: 612


        CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get, 'W');

Line: 619


    cep_standard.debug('<


Line: 627

      cep_standard.debug('EXCEPTION: CE_BANK_STATEMENT_LOADER.Insert_Hdr - '|| to_char(l_err));

Line: 630

END Insert_Hdr;

Line: 676

|	Insert Line, Get_Formatted_Sting				|
|  REQUIRES								|
|									|
|  HISTORY								|
|	19-MAY-1999	Created		BHCHUNG				|
 --------------------------------------------------------------------- */
FUNCTION Find_Formatted_String(X_format VARCHAR2,
			       X_trx_text varchar2) RETURN VARCHAR2 IS
  l_str		VARCHAR2(150);

Line: 886

|	Insert_Line 							|
|									|
|  DESCRIPTION								|
|	Insert Line Record to Interface Table.				|
|									|
|  CALLED BY								|
|	Load_BAI2, Load_Others						|
|  REQUIRES								|
|									|
|  HISTORY								|
|	19-MAY-1999	Created		BHCHUNG				|
 --------------------------------------------------------------------- */
PROCEDURE Insert_Line IS
  l_rec_cnt	NUMBER;

Line: 905

  cep_standard.debug('>>CE_BANK_STATEMENT_LOADER.Insert_Line');

Line: 928

  cep_standard.debug('Insert Line'||to_char(G_line_number));

Line: 941

    SELECT count(*)
    INTO   l_rec_cnt
    FROM   ce_statement_lines_interface
    WHERE  bank_account_num = G_bank_account_num
    AND	   statement_number = l_statement_number
    AND    line_number      = G_line_number;

Line: 949

      DELETE FROM ce_statement_lines_interface
      WHERE  bank_account_num = G_bank_account_num
      AND    statement_number = l_statement_number
      AND    line_number      = G_line_number;

Line: 953

      G_total_line_deleted := G_total_line_deleted + l_rec_cnt;

Line: 962

    CE_STAT_LINES_INF_PKG.Insert_Row(l_row_id,
                       rtrim(G_bank_account_num),
                       rtrim(l_statement_number),
                       to_number(rtrim(G_line_number)),
                       rtrim(G_trx_date),
                       rtrim(G_trx_code),
                       rtrim(G_effective_date),
                       G_trx_text,
                       G_invoice_text,
		       G_bank_account_text,
                       to_number(G_amount),
                       to_number(rtrim(G_charges_amount)),
		       rtrim(G_line_currency_code),
                       to_number(G_exchange_rate),
                       rtrim(G_user_exchange_rate_type),
                       rtrim(G_exchange_rate_date),
		       to_number(rtrim(G_original_amount)),
                       G_bank_trx_number,
                       G_customer_text,
                       to_number(G_user_id),
                       SYSDATE,
                       to_number(G_user_id),
                       SYSDATE,
                       NULL,
                       NULL, NULL, NULL, NULL, NULL,
                       NULL, NULL, NULL, NULL, NULL,
                       NULL, NULL, NULL, NULL, NULL);

Line: 991

    cep_standard.debug('<

Line: 997

      cep_standard.debug('EXCEPTION: CE_BANK_STATEMENT_LOADER.Insert_Line - '|| to_char(l_err));

Line: 1000

END Insert_Line;

Line: 1022

    SELECT substr(rtrim(ltrim(column1)),1,255)
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1027

    SELECT rtrim(ltrim(column2))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1032

    SELECT rtrim(ltrim(column3))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1037

    SELECT rtrim(ltrim(column4))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1042

    SELECT rtrim(ltrim(column5))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1047

    SELECT rtrim(ltrim(column6))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1052

    SELECT rtrim(ltrim(column7))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1057

    SELECT rtrim(ltrim(column8))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1062

    SELECT rtrim(ltrim(column9))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1067

    SELECT rtrim(ltrim(column10))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1072

    SELECT rtrim(ltrim(column11))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1077

    SELECT rtrim(ltrim(column12))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1082

    SELECT rtrim(ltrim(column13))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1087

    SELECT rtrim(ltrim(column14))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1092

    SELECT rtrim(ltrim(column15))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1097

    SELECT rtrim(ltrim(column16))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1102

    SELECT rtrim(ltrim(column17))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1107

    SELECT rtrim(ltrim(column18))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1112

    SELECT rtrim(ltrim(column19))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1117

    SELECT rtrim(ltrim(column20))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1122

    SELECT rtrim(ltrim(column21))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1127

    SELECT rtrim(ltrim(column22))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1132

    SELECT rtrim(ltrim(column23))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1137

    SELECT rtrim(ltrim(column24))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1142

    SELECT rtrim(ltrim(column25))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1147

    SELECT rtrim(ltrim(column26))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1152

    SELECT rtrim(ltrim(column27))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1157

    SELECT rtrim(ltrim(column28))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1162

    SELECT rtrim(ltrim(column29))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1167

    SELECT rtrim(ltrim(column30))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1172

    SELECT rtrim(ltrim(column31))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1177

    SELECT rtrim(ltrim(column32))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1182

    SELECT rtrim(ltrim(column33))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1187

    SELECT rtrim(ltrim(column34))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1192

    SELECT rtrim(ltrim(column35))
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1232

    SELECT nvl(position,0),
	   format,
	   include_format_ind,
	   concatenate_format_flag
    FROM   ce_bank_stmt_map_hdr_v
    WHERE  map_id	= G_map_id
    AND	   column_name 	= X_column;

Line: 1241

    SELECT nvl(position,0),
	   format,
	   include_format_ind,
	   concatenate_format_flag
    FROM   ce_bank_stmt_map_line_v
    WHERE  map_id 	= G_map_id
    AND	   column_name 	= X_column;

Line: 1275

  SELECT substr(column1,1,1)||substr(column2,1,1)||substr(column3,1,1)||substr(column4,1,1)||substr(column5,1,1)||
         substr(column6,1,1)||substr(column7,1,1)||substr(column8,1,1)||substr(column9,1,1)||substr(column10,1,1)||
 	 substr(column11,1,1)||substr(column12,1,1)||substr(column13,1,1)||substr(column14,1,1)||substr(column15,1,1)||
         substr(column16,1,1)||substr(column17,1,1)||substr(column18,1,1)||substr(column19,1,1)||substr(column20,1,1)||
 	 substr(column21,1,1)||substr(column22,1,1)||substr(column23,1,1)||substr(column24,1,1)||substr(column25,1,1)||
         substr(column26,1,1)||substr(column27,1,1)||substr(column28,1,1)||substr(column29,1,1)||substr(column30,1,1)||
 	 substr(column31,1,1)||substr(column32,1,1)||substr(column33,1,1)||substr(column34,1,1)||substr(column35,1,1)
  INTO   l_str
  FROM   ce_stmt_int_tmp
  WHERE  rec_no = X_rec_no;

Line: 1346

  SELECT count(*)
  INTO   l_hdr
  FROM   CE_BANK_STMT_MAP_HDR
  WHERE  map_id = G_map_id
  AND    rec_id_no = X_rec_id;

Line: 1352

  SELECT count(*)
  INTO   l_line
  FROM   CE_BANK_STMT_MAP_LINE
  WHERE  map_id = G_map_id
  AND    rec_id_no = X_rec_id;

Line: 1386

    SELECT BB.bank_name,
	   BB.bank_branch_name,
	   BB.branch_party_id,
           BA.bank_account_id,
           BA.currency_code
	   --BA.org_id
    FROM   CE_BANK_ACCOUNTS BA, --FROM   AP_BANK_ACCOUNTS_ALL BA,
           CE_BANK_BRANCHES_V BB    --AP_BANK_BRANCHES BB
    WHERE  BB.branch_party_id   = BA.bank_branch_id
    AND    BA.bank_account_num = G_bank_account_num
    AND    NVL(BA.account_classification,'DUMMY') = 'INTERNAL'; --bug 6511845

Line: 1404

    CE_SQLLDR_ERRORS_PKG.insert_row(NVL(G_statement_number, 'XXXXXXXXXXX'), NVL(G_bank_account_num, 'XXXXXXXXXXX'),
				G_rec_no, fnd_message.get, 'E');

Line: 1409

  SELECT count(*)
  INTO   l_cnt
  FROM   CE_BANK_ACCOUNTS --FROM   AP_BANK_ACCOUNTS_ALL
  WHERE  BANK_ACCOUNT_NUM = G_bank_account_num
  and NVL(ACCOUNT_CLASSIFICATION,'DUMMY') = 'INTERNAL'; -- Bug 6511845

Line: 1419

    CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, G_rec_no, fnd_message.get, 'E');

Line: 1424

    CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, G_rec_no, fnd_message.get, 'W');

Line: 1453

    SELECT column3, column4
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1508

    CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(X_rec_no, 0), fnd_message.get);

Line: 1539

    SELECT column1, column2, column3, column4, column5
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1544

    SELECT column2, column3, column4, column5, column6
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1549

    SELECT column3, column4, column5, column6, column7
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1554

    SELECT column4, column5, column6, column7, column8
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1559

    SELECT column5, column6, column7, column8, column9
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1564

    SELECT column6, column7, column8, column9, column10
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1569

    SELECT column7, column8, column9, column10, column11
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1574

    SELECT column8, column9, column10, column11, column12
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1579

    SELECT column9, column10, column11, column12, column13
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1584

    SELECT column10, column11, column12, column13, column14
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1589

    SELECT column11, column12, column13, column14, column15
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1594

    SELECT column12, column13, column14, column15, column16
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1599

    SELECT column13, column14, column15, column16, column17
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1604

    SELECT column14, column15, column16, column17, column18
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1609

    SELECT column15, column16, column17, column18, column19
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1614

    SELECT column16, column17, column18, column19, column20
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1619

    SELECT column17, column18, column19, column20, column21
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1624

    SELECT column18, column19, column20, column21, column22
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1629

    SELECT column19, column20, column21, column22, column23
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1634

    SELECT column20, column21, column22, column23, column24
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1639

    SELECT column21, column22, column23, column24, column25
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1644

    SELECT column22, column23, column24, column25, column26
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1649

    SELECT column23, column24, column25, column26, column27
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1654

    SELECT column24, column25, column26, column27, column28
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1659

    SELECT column25, column26, column27, column28, column29
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1664

    SELECT column26, column27, column28, column29, column30
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1669

    SELECT column27, column28, column29, column30, column31
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1674

    SELECT column28, column29, column30, column31, column32
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1679

    SELECT column29, column30, column31, column32, column33
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1684

    SELECT column30, column31, column32, column33, column34
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1689

    SELECT column31, column32, column33, column34, column35
    INTO   X_col1, X_col2, X_col3, X_col4, X_col5
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1694

    SELECT column32, column33, column34, column35
    INTO   X_col1, X_col2, X_col3, X_col4
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1836

      select decode(G_control_dr_line_count,null,
                    G_control_line_count,
			nvl(G_control_line_count,0)+G_control_dr_line_count)
	     into G_control_line_count from dual;

Line: 1844

      select decode(G_control_cr_line_count,null,
                    G_control_line_count,
			nvl(G_control_line_count,0)+G_control_cr_line_count)
	     into G_control_line_count from dual;

Line: 1880

    CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(X_rec_no, 0), fnd_message.get);

Line: 1901

    SELECT rec_no, rec_id_no, column1, rtrim(replace(column2,' '),'/') col2, column6, rtrim(replace(column8,' '),'/') col8
    FROM   ce_stmt_int_tmp
    ORDER BY rec_no;

Line: 1906

    SELECT  column_name,
            format,
            include_format_ind,
	    concatenate_format_flag
    FROM    ce_bank_stmt_map_line
    WHERE   map_id = G_map_id
    AND     position = -1;

Line: 1944

      CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, C_rec.rec_no, fnd_message.get, 'E');

Line: 1953

        CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, C_rec.rec_no, fnd_message.get, 'E');

Line: 1977

        CE_SQLLDR_ERRORS_PKG.insert_row('XXXXXXXXXXX' , NVL(G_bank_account_num, 'XXXXXXXXXXX'),
				C_rec.rec_no, fnd_message.get);

Line: 1985

        CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, NVL(G_bank_account_num, 'XXXXXXXXXXX'),
				C_rec.rec_no, fnd_message.get);

Line: 2064

      		Insert_Line;

Line: 2075

	/* Bug3228203 added the following select stmt and modified
	   the next update stmt.*/
 	SELECT * INTO l_rec FROM ce_stmt_int_tmp
	WHERE rec_id_no = C_rec.rec_id_no AND rec_no = C_rec.rec_no;

Line: 2082

         UPDATE 	ce_statement_lines_interface
         SET  trx_text = rtrim(substr(ltrim(rtrim(trx_text ||' '|| C_rec.column1)) ||
	 decode(l_rec.column2,null,null,','||ltrim(rtrim(l_rec.column2))) ||
	 decode(l_rec.column3,null,null,','||ltrim(rtrim(l_rec.column3))) ||
	 decode(l_rec.column4,null,null,','||ltrim(rtrim(l_rec.column4))) ||
	 decode(l_rec.column5,null,null,','||ltrim(rtrim(l_rec.column5))) ||
	 decode(l_rec.column6,null,null,','||ltrim(rtrim(l_rec.column6))) ||
	 decode(l_rec.column7,null,null,','||ltrim(rtrim(l_rec.column7))) ||
	 decode(l_rec.column8,null,null,','||ltrim(rtrim(l_rec.column8))) ||
	 decode(l_rec.column9,null,null,','||ltrim(rtrim(l_rec.column9))) ||
	 decode(l_rec.column10,null,null,','||ltrim(rtrim(l_rec.column10))) ||
	 decode(l_rec.column11,null,null,','||ltrim(rtrim(l_rec.column11))) ||
	 decode(l_rec.column12,null,null,','||ltrim(rtrim(l_rec.column12))) ||
	 decode(l_rec.column13,null,null,','||ltrim(rtrim(l_rec.column13))) ||
	 decode(l_rec.column14,null,null,','||ltrim(rtrim(l_rec.column14))) ||
	 decode(l_rec.column15,null,null,','||ltrim(rtrim(l_rec.column15))) ||
	 decode(l_rec.column16,null,null,','||ltrim(rtrim(l_rec.column16))) ||
	 decode(l_rec.column17,null,null,','||ltrim(rtrim(l_rec.column17))) ||
	 decode(l_rec.column18,null,null,','||ltrim(rtrim(l_rec.column18))) ||
	 decode(l_rec.column19,null,null,','||ltrim(rtrim(l_rec.column19))) ||
	 decode(l_rec.column20,null,null,','||ltrim(rtrim(l_rec.column20))) ||
	 decode(l_rec.column21,null,null,','||ltrim(rtrim(l_rec.column21))) ||
	 decode(l_rec.column22,null,null,','||ltrim(rtrim(l_rec.column22))) ||
	 decode(l_rec.column23,null,null,','||ltrim(rtrim(l_rec.column23))) ||
	 decode(l_rec.column24,null,null,','||ltrim(rtrim(l_rec.column24))) ||
	 decode(l_rec.column25,null,null,','||ltrim(rtrim(l_rec.column25))) ||
	 decode(l_rec.column26,null,null,','||ltrim(rtrim(l_rec.column26))) ||
	 decode(l_rec.column27,null,null,','||ltrim(rtrim(l_rec.column27))) ||
	 decode(l_rec.column28,null,null,','||ltrim(rtrim(l_rec.column28))) ||
	 decode(l_rec.column29,null,null,','||ltrim(rtrim(l_rec.column29))) ||
	 decode(l_rec.column30,null,null,','||ltrim(rtrim(l_rec.column30))) ||
	 decode(l_rec.column31,null,null,','||ltrim(rtrim(l_rec.column31))) ||
	 decode(l_rec.column32,null,null,','||ltrim(rtrim(l_rec.column32))) ||
	 decode(l_rec.column33,null,null,','||ltrim(rtrim(l_rec.column33))) ||
	 decode(l_rec.column34,null,null,','||ltrim(rtrim(l_rec.column34))) ||
	 decode(l_rec.column35,null,null,','||ltrim(rtrim(l_rec.column35)))
	 ,1,255))
         WHERE   bank_account_num = G_bank_account_num
         AND     statement_number = G_statement_number
	 AND	line_number   	 = l_line_cnt;

Line: 2181

           UPDATE  ce_statement_lines_interface
           SET	   bank_trx_number         = G_bank_trx_number,
		   invoice_text            = G_invoice_text,
		   customer_text           = G_customer_text,
                   bank_account_text       = G_bank_account_text,
		   currency_code           = G_line_currency_code,
		   user_exchange_rate_type = G_user_exchange_rate_type,
		   exchange_rate_date      = G_exchange_rate_date,
		   exchange_rate           = G_exchange_rate,
	           original_amount         = G_original_amount,
	 	   charges_amount          = G_charges_amount
           WHERE   bank_account_num   = G_bank_account_num
           AND     statement_number   = G_statement_number
  	   AND	  line_number        = l_line_cnt;

Line: 2206

        CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, C_rec.rec_no, fnd_message.get);

Line: 2212

      		Insert_Hdr;

Line: 2221

      CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, C_rec.rec_no, fnd_message.get, 'E');

Line: 2338

    CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(X_rec_no, 0), fnd_message.get);

Line: 2408

    CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(X_rec_no, 0), fnd_message.get);

Line: 2416

    SELECT distinct(rec_id_no) recID
    FROM   ce_bank_stmt_map_line
    WHERE  map_id = G_map_id;

Line: 2421

    SELECT distinct(rec_id_no) recID
    FROM   ce_bank_stmt_map_hdr
    WHERE  map_id = G_map_id;

Line: 2432

      SELECT MIN(rec_no)
      INTO   l_min_rec_no
      FROM   ce_stmt_int_tmp
      WHERE  rec_id_no = C_rec.recID;

Line: 2444

      SELECT MIN(rec_no)
      INTO   l_min_rec_no
      FROM   ce_stmt_int_tmp
      WHERE  rec_id_no = C_rec.recID;

Line: 2478

    SELECT rec_no, rec_id_no
    FROM   CE_STMT_INT_TMP
    ORDER BY rec_no;

Line: 2483

    SELECT column_name, position
    FROM   CE_BANK_STMT_MAP_HDR
    WHERE  map_id = G_map_id
    AND    rec_id_no = p_rec_id;

Line: 2489

    SELECT column_name, position
    FROM   CE_BANK_STMT_MAP_LINE
    WHERE  map_id = G_map_id
    AND    rec_id_no = p_rec_id;

Line: 2524

         	Insert_Line;

Line: 2533

         	Insert_Hdr;

Line: 2575

           		Insert_Line;

Line: 2605

 	CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, G_rec_no, fnd_message.get, 'E');

Line: 2616

     		Insert_Line;

Line: 2623

     		Insert_Hdr;

Line: 2643

  SELECT rec_no,
	 column35
  FROM   CE_STMT_INT_TMP
  WHERE  rec_id_no = '61'
  ORDER BY rec_no;

Line: 2737

    UPDATE	CE_STMT_INT_TMP
    SET   	column2 = l_col2,
		column3 = l_col3,
		column4 = l_col4,
		column5 = l_col5,
		column6 = l_col6,
		column7 = l_col7,
		column8 = l_col8
    WHERE	rec_no = C_rec.rec_no;

Line: 2751

  SELECT rec_no,
         column1
  FROM   CE_STMT_INT_TMP
  WHERE  rec_id_no = '9'
  ORDER BY rec_no;

Line: 2758

  SELECT rec_no,
         column1
  FROM   CE_STMT_INT_TMP
  WHERE  rec_id_no = '86'
  ORDER BY rec_no;

Line: 2768

    SELECT	MAX(rec_no)
    INTO	l_rec_no
    FROM    	CE_STMT_INT_TMP
    WHERE	rec_no < C_rec.rec_no
    AND         rec_id_no <> '9';

Line: 2776

    SELECT 	rec_id_no
    INTO	l_rec_id
    FROM	CE_STMT_INT_TMP
    WHERE       rec_no = l_rec_no;

Line: 2782

      UPDATE 	CE_STMT_INT_TMP
      SET	rec_id_no = '61A'
      WHERE     rec_no = C_rec.rec_no;

Line: 2786

      UPDATE 	CE_STMT_INT_TMP
      SET	column1 = column1 || '   ' || C_rec.column1
      WHERE     rec_no = l_rec_no;

Line: 2790

      DELETE FROM CE_STMT_INT_TMP
      WHERE  rec_no = C_rec.rec_no;

Line: 2797

    SELECT 	rec_id_no
    INTO	l_rec_id
    FROM	CE_STMT_INT_TMP
    WHERE       rec_no = C_rec.rec_no - 1;

Line: 2803

      UPDATE 	CE_STMT_INT_TMP         -- This 86 record comes after 61.
      SET	rec_id_no = '61A'         	-- Marks it as 61A.
      WHERE     rec_no = C_rec.rec_no;

Line: 2807

      UPDATE 	CE_STMT_INT_TMP			-- Comes after supplementary details (61A).
      SET	column1 = column1 || '   '      -- Concatinate 86 to 61A.
			  || C_rec.column1
      WHERE     rec_no = C_rec.rec_no - 1;

Line: 2812

      DELETE FROM CE_STMT_INT_TMP		-- Delete 86.
      WHERE  rec_no = C_rec.rec_no;

Line: 2930

  SELECT 	count(*)
  INTO   	l_cnt
  FROM   	CE_STMT_INT_TMP;

Line: 2939

  SELECT 	format_type,
		precision,
		date_format,
		timestamp_format
  INTO   	G_format_type,
		l_precision,
		G_date_format,
		G_timestamp_format
  FROM   	ce_bank_stmt_int_map_v
  WHERE  	map_id = X_MAP_ID;

Line: 2977

  Delete_Orphaned_Lines;

Line: 2979

  IF ( nvl(G_total_hdr_deleted, 0) <> 0 ) THEN
    FND_MESSAGE.set_name('CE', 'CE_EXIST_HDR_DELETED');

Line: 2981

    FND_MESSAGE.set_token('CNT', to_char(G_total_hdr_deleted));

Line: 2982

    CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get);

Line: 2984

  IF ( nvl(G_total_line_deleted, 0) <> 0 ) THEN
    FND_MESSAGE.set_name('CE', 'CE_EXIST_LINE_DELETED');

Line: 2986

    FND_MESSAGE.set_token('CNT', to_char(G_total_line_deleted));

Line: 2987

    CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get);

Line: 3004

  CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get, 'E');

Line: 3009

  CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get, 'E');