APPS.CE_BANK_STATEMENT_LOADER SQL Statements

Line: 1130

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

Line: 1133

END Insert_Line;

Line: 1155

    SELECT substrb(rtrim(ltrim(column1)),1,255)  /*12617141*/
    INTO l_result
    FROM ce_stmt_int_tmp
    WHERE rec_no = X_rec_no;

Line: 1160

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

Line: 1165

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

Line: 1170

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

Line: 1175

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

Line: 1180

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

Line: 1185

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

Line: 1190

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

Line: 1195

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

Line: 1200

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

Line: 1205

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

Line: 1210

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

Line: 1215

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

Line: 1220

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

Line: 1225

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

Line: 1230

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

Line: 1235

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

Line: 1240

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

Line: 1245

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

Line: 1250

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

Line: 1255

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

Line: 1260

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

Line: 1265

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

Line: 1270

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

Line: 1275

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

Line: 1280

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

Line: 1285

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

Line: 1290

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

Line: 1295

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

Line: 1300

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

Line: 1305

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

Line: 1310

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

Line: 1315

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

Line: 1320

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

Line: 1325

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

Line: 1365

    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: 1374

    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: 1408

  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: 1481

  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: 1487

  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: 1526

        SELECT  BB.bank_name,
                BB.bank_branch_name,
                BB.branch_party_id,
                BA.bank_account_id,
                BA.currency_code
        FROM    CE_BANK_ACCOUNTS BA,
                CE_BANK_BRANCHES_V 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
         AND    NVL(G_Bank_Branch_id, BA.Bank_branch_id) = BA.bank_branch_id     -- Bug 8209720
         AND    NVL(G_bank_account_id, BA.bank_account_id) = BA.bank_account_id  -- Bug 8209720
         AND    NVL(G_hdr_currency_code,BA.currency_code) = BA.currency_code;    -- Bug 13688013

Line: 1548

        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: 1561

    SELECT count(*)
    INTO   l_cnt
    FROM   CE_BANK_ACCOUNTS
    WHERE  BANK_ACCOUNT_NUM = G_bank_account_num
     AND   NVL(ACCOUNT_CLASSIFICATION,'DUMMY') = 'INTERNAL'          -- Bug 6511845
     AND   NVL(G_Bank_Branch_id,Bank_branch_id) = Bank_branch_id     -- Bug 8209720
     AND   NVL(G_bank_account_id, bank_account_id) = bank_account_id -- Bug 8209720
	 AND   NVL(G_hdr_currency_code,currency_code) = currency_code;   -- Bug 13688013

Line: 1575

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

Line: 1585

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

Line: 1627

    SELECT column3, column4
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1682

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

Line: 1716

    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: 1721

    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: 1726

    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: 1731

    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: 1736

    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: 1741

    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: 1746

    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: 1751

    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: 1756

    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: 1761

    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: 1766

    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: 1771

    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: 1776

    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: 1781

    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: 1786

    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: 1791

    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: 1796

    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: 1801

    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: 1806

    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: 1811

    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: 1816

    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: 1821

    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: 1826

    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: 1831

    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: 1836

    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: 1841

    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: 1846

    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: 1851

    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: 1856

    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: 1861

    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: 1866

    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: 1872

    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: 1882

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

Line: 1893

    SELECT  column34, column35
    INTO   X_col1, X_col2
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1908

    SELECT column35
    INTO   X_col1
    FROM   ce_stmt_int_tmp
    WHERE  rec_no = X_rec_no;

Line: 1984

        SELECT column36 INTO l_str
        FROM ce_stmt_int_tmp WHERE rec_no = X_rec_no;

Line: 2112

	      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: 2122

		      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: 2175

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

Line: 2196

    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: 2201

    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: 2241

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

Line: 2250

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

Line: 2274

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

Line: 2282

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

Line: 2336

              SELECT PRECISION
              INTO l_hdr_precision
              FROM fnd_currencies
              WHERE CURRENCY_CODE=G_hdr_currency_code
              AND ( Nvl(G_statement_date,SYSDATE) >= Nvl(START_DATE_ACTIVE,Nvl(G_statement_date,SYSDATE))
                    AND
                    Nvl(G_statement_date,SYSDATE) <= Nvl(END_DATE_ACTIVE,nvl(G_statement_date,SYSDATE))
                    );

Line: 2379

          SELECT 'Y'
          INTO G_only_03
          FROM ce_stmt_int_tmp
          WHERE rec_id_no =C_rec.rec_id_no
          AND rec_no=C_rec.rec_no
          AND COLUMN36 IS NOT NULL;   --G_only_03

Line: 2462

      		Insert_Line;

Line: 2473

	/* 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: 2480

         UPDATE 	ce_statement_lines_interface
         SET  trx_text = rtrim(rtrim(substrb(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: 2538

		      select SubStr(trx_text,1,240) INTO G_bank_trx_number
                      FROM ce_statement_lines_interface
                      WHERE bank_account_num = G_bank_account_num
                      AND statement_number = G_statement_number
	                    AND	line_number = l_line_cnt;

Line: 2611

           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: 2636

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

Line: 2642

      		Insert_Hdr;

Line: 2651

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

Line: 2794

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

Line: 2879

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

Line: 2887

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

Line: 2892

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

Line: 2903

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

Line: 2915

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

Line: 2959

        SELECT rec_no, rec_id_no
        FROM   CE_STMT_INT_TMP
        ORDER BY rec_no;

Line: 2964

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

Line: 2970

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

Line: 3010

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

Line: 3017

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

Line: 3032

                    Insert_Line;

Line: 3042

                    Insert_Hdr;

Line: 3098

                    Insert_Line;

Line: 3130

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

Line: 3147

     		Insert_Line;

Line: 3154

            Insert_Hdr;

Line: 3183

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

Line: 3286

        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: 3311

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

Line: 3317

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

Line: 3335

        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: 3346

            SELECT rec_id_no
              INTO l_rec_id
              FROM CE_STMT_INT_TMP
             WHERE rec_no = l_rec_no;

Line: 3352

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

Line: 3356

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

Line: 3360

                DELETE FROM CE_STMT_INT_TMP
                WHERE  rec_no = C_rec.rec_no;

Line: 3372

       /* SELECT 	rec_id_no
        INTO	l_rec_id
        FROM	CE_STMT_INT_TMP
        WHERE   rec_no = C_rec.rec_no - 1;  */ /*commented for 14578532*/

Line: 3377

        SELECT 	rec_id_no, rec_no        /* 14578532  */
        INTO	l_rec_id , l_rec_id_no
        FROM	CE_STMT_INT_TMP
        WHERE   rec_no = (SELECT Max(rec_no) FROM
        CE_STMT_INT_TMP WHERE rec_id_no IN ( '61', '61A')
        AND rec_no < C_rec.rec_no);

Line: 3388

            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: 3392

            UPDATE CE_STMT_INT_TMP              -- Comes after supplementary details (61A).
               SET column1 = column1 || '   '   -- Concatinate 86 to 61A.
                       || C_rec.column1
             WHERE rec_no = l_rec_id_no;    /*Bug 14578532 Replaced  C_rec.rec_no - 1 with  l_rec_id_no*/

Line: 3398

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

Line: 3529

  SELECT 	count(*)
  INTO   	l_cnt
  FROM   	CE_STMT_INT_TMP;

Line: 3538

  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: 3576

  Delete_Orphaned_Lines;

Line: 3578

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

Line: 3580

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

Line: 3581

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

Line: 3583

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

Line: 3585

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

Line: 3586

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

Line: 3603

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

Line: 3608

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