APPS.CE_BANK_STATEMENT_LOADER dependencies on CE_STATEMENT_LINES_INTERFACE

Line 283: l_bank_account_num ce_statement_lines_interface.bank_account_num%TYPE;

279: | HISTORY |
280: | 12-12-2001 Created HEHAN |
281: --------------------------------------------------------------------- */
282: PROCEDURE Delete_Orphaned_Lines IS
283: l_bank_account_num ce_statement_lines_interface.bank_account_num%TYPE;
284: l_statement_number ce_statement_lines_interface.statement_number%TYPE;
285: h_rec_cnt NUMBER;
286:
287: CURSOR l_cursor IS

Line 284: l_statement_number ce_statement_lines_interface.statement_number%TYPE;

280: | 12-12-2001 Created HEHAN |
281: --------------------------------------------------------------------- */
282: PROCEDURE Delete_Orphaned_Lines IS
283: l_bank_account_num ce_statement_lines_interface.bank_account_num%TYPE;
284: l_statement_number ce_statement_lines_interface.statement_number%TYPE;
285: h_rec_cnt NUMBER;
286:
287: CURSOR l_cursor IS
288: SELECT bank_account_num, statement_number

Line 289: FROM ce_statement_lines_interface;

285: h_rec_cnt NUMBER;
286:
287: CURSOR l_cursor IS
288: SELECT bank_account_num, statement_number
289: FROM ce_statement_lines_interface;
290:
291: BEGIN
292: OPEN l_cursor;
293: LOOP

Line 304: DELETE FROM ce_statement_lines_interface

300: WHERE bank_account_num = l_bank_account_num
301: AND statement_number = l_statement_number;
302:
303: IF h_rec_cnt = 0 THEN
304: DELETE FROM ce_statement_lines_interface
305: WHERE bank_account_num = l_bank_account_num
306: AND statement_number = l_statement_number;
307:
308: END IF;

Line 422: FROM ce_statement_lines_interface

418: /* Bug 3417789 added the IF condition - start code fix*/
419: IF (trunc(sysdate) <> trunc(G_statement_date)) THEN
420: SELECT count(1)
421: INTO G_total_line_deleted
422: FROM ce_statement_lines_interface
423: WHERE statement_number = l_statement_number
424: AND bank_account_num = G_bank_account_num;
425:
426: DELETE ce_statement_lines_interface

Line 426: DELETE ce_statement_lines_interface

422: FROM ce_statement_lines_interface
423: WHERE statement_number = l_statement_number
424: AND bank_account_num = G_bank_account_num;
425:
426: DELETE ce_statement_lines_interface
427: WHERE statement_number = l_statement_number
428: AND bank_account_num = G_bank_account_num;
429:
430: UPDATE ce_statement_lines_interface

Line 430: UPDATE ce_statement_lines_interface

426: DELETE ce_statement_lines_interface
427: WHERE statement_number = l_statement_number
428: AND bank_account_num = G_bank_account_num;
429:
430: UPDATE ce_statement_lines_interface
431: SET statement_number = l_statement_number
432: WHERE statement_number = G_statement_number || ' - ' || to_char(sysdate);
433: END IF;
434: /* Bug 3417789 - End code fix */

Line 943: FROM ce_statement_lines_interface

939: -- Overwrite the existing bank statement of the same bank account and statement number.
940: --
941: SELECT count(*)
942: INTO l_rec_cnt
943: FROM ce_statement_lines_interface
944: WHERE bank_account_num = G_bank_account_num
945: AND statement_number = l_statement_number
946: AND line_number = G_line_number;
947:

Line 949: DELETE FROM ce_statement_lines_interface

945: AND statement_number = l_statement_number
946: AND line_number = G_line_number;
947:
948: IF l_rec_cnt > 0 THEN
949: DELETE FROM ce_statement_lines_interface
950: WHERE bank_account_num = G_bank_account_num
951: AND statement_number = l_statement_number
952: AND line_number = G_line_number;
953: G_total_line_deleted := G_total_line_deleted + l_rec_cnt;

Line 2082: UPDATE ce_statement_lines_interface

2078: WHERE rec_id_no = C_rec.rec_id_no AND rec_no = C_rec.rec_no;
2079:
2080: /* Bug 6792668 Added rtrim */
2081:
2082: UPDATE ce_statement_lines_interface
2083: SET trx_text = rtrim(substr(ltrim(rtrim(trx_text ||' '|| C_rec.column1)) ||
2084: decode(l_rec.column2,null,null,','||ltrim(rtrim(l_rec.column2))) ||
2085: decode(l_rec.column3,null,null,','||ltrim(rtrim(l_rec.column3))) ||
2086: decode(l_rec.column4,null,null,','||ltrim(rtrim(l_rec.column4))) ||

Line 2181: UPDATE ce_statement_lines_interface

2177: cep_standard.debug('G_original_amount = '||G_original_amount ||'.');
2178: cep_standard.debug('G_charges_amount = '||G_charges_amount||'.');
2179: END IF;
2180:
2181: UPDATE ce_statement_lines_interface
2182: SET bank_trx_number = G_bank_trx_number,
2183: invoice_text = G_invoice_text,
2184: customer_text = G_customer_text,
2185: bank_account_text = G_bank_account_text,