APPS.CE_BANK_STATEMENT_LOADER dependencies on CE_STATEMENT_LINES_INTERFACE

Line 444: l_bank_account_num ce_statement_lines_interface.bank_account_num%TYPE;

440: | HISTORY |
441: | 12-12-2001 Created HEHAN |
442: --------------------------------------------------------------------- */
443: PROCEDURE Delete_Orphaned_Lines IS
444: l_bank_account_num ce_statement_lines_interface.bank_account_num%TYPE;
445: l_statement_number ce_statement_lines_interface.statement_number%TYPE;
446: h_rec_cnt NUMBER;
447:
448: CURSOR l_cursor IS

Line 445: l_statement_number ce_statement_lines_interface.statement_number%TYPE;

441: | 12-12-2001 Created HEHAN |
442: --------------------------------------------------------------------- */
443: PROCEDURE Delete_Orphaned_Lines IS
444: l_bank_account_num ce_statement_lines_interface.bank_account_num%TYPE;
445: l_statement_number ce_statement_lines_interface.statement_number%TYPE;
446: h_rec_cnt NUMBER;
447:
448: CURSOR l_cursor IS
449: SELECT bank_account_num, statement_number

Line 450: FROM ce_statement_lines_interface;

446: h_rec_cnt NUMBER;
447:
448: CURSOR l_cursor IS
449: SELECT bank_account_num, statement_number
450: FROM ce_statement_lines_interface;
451:
452: BEGIN
453: OPEN l_cursor;
454: LOOP

Line 465: DELETE FROM ce_statement_lines_interface

461: WHERE bank_account_num = l_bank_account_num
462: AND statement_number = l_statement_number;
463:
464: IF h_rec_cnt = 0 THEN
465: DELETE FROM ce_statement_lines_interface
466: WHERE bank_account_num = l_bank_account_num
467: AND statement_number = l_statement_number;
468:
469: END IF;

Line 582: FROM ce_statement_lines_interface

578: IF (trunc(sysdate) <> trunc(G_statement_date))
579: THEN
580: SELECT count(1)
581: INTO G_total_line_deleted
582: FROM ce_statement_lines_interface
583: WHERE statement_number = l_statement_number
584: AND bank_account_num = G_bank_account_num;
585:
586: DELETE ce_statement_lines_interface

Line 586: DELETE ce_statement_lines_interface

582: FROM ce_statement_lines_interface
583: WHERE statement_number = l_statement_number
584: AND bank_account_num = G_bank_account_num;
585:
586: DELETE ce_statement_lines_interface
587: WHERE statement_number = l_statement_number
588: AND bank_account_num = G_bank_account_num;
589:
590: UPDATE ce_statement_lines_interface

Line 590: UPDATE ce_statement_lines_interface

586: DELETE ce_statement_lines_interface
587: WHERE statement_number = l_statement_number
588: AND bank_account_num = G_bank_account_num;
589:
590: UPDATE ce_statement_lines_interface
591: SET statement_number = l_statement_number
592: WHERE statement_number = G_statement_number || ' - ' || to_char(sysdate);
593: END IF;
594: /* Bug 3417789 - End code fix */

Line 1076: FROM ce_statement_lines_interface

1072: -- Overwrite the existing bank statement of the same bank account and statement number.
1073: --
1074: SELECT count(*)
1075: INTO l_rec_cnt
1076: FROM ce_statement_lines_interface
1077: WHERE bank_account_num = G_bank_account_num
1078: AND statement_number = l_statement_number
1079: AND line_number = G_line_number;
1080:

Line 1082: DELETE FROM ce_statement_lines_interface

1078: AND statement_number = l_statement_number
1079: AND line_number = G_line_number;
1080:
1081: IF l_rec_cnt > 0 THEN
1082: DELETE FROM ce_statement_lines_interface
1083: WHERE bank_account_num = G_bank_account_num
1084: AND statement_number = l_statement_number
1085: AND line_number = G_line_number;
1086: G_total_line_deleted := G_total_line_deleted + l_rec_cnt;

Line 2480: UPDATE ce_statement_lines_interface

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 */
2480: UPDATE ce_statement_lines_interface
2481: SET trx_text = rtrim(rtrim(substrb(ltrim(rtrim(trx_text ||' '|| C_rec.column1)) ||
2482: decode(l_rec.column2,null,null,','||ltrim(rtrim(l_rec.column2))) ||
2483: decode(l_rec.column3,null,null,','||ltrim(rtrim(l_rec.column3))) ||
2484: decode(l_rec.column4,null,null,','||ltrim(rtrim(l_rec.column4))) ||

Line 2539: FROM ce_statement_lines_interface

2535: ELSIF(G_predefined_format IS NULL) THEN
2536: BEGIN
2537:
2538: select SubStr(trx_text,1,240) INTO G_bank_trx_number
2539: FROM ce_statement_lines_interface
2540: WHERE bank_account_num = G_bank_account_num
2541: AND statement_number = G_statement_number
2542: AND line_number = l_line_cnt;
2543:

Line 2611: UPDATE ce_statement_lines_interface

2607: cep_standard.debug('G_original_amount = '||G_original_amount ||'.');
2608: cep_standard.debug('G_charges_amount = '||G_charges_amount||'.');
2609: END IF;
2610:
2611: UPDATE ce_statement_lines_interface
2612: SET bank_trx_number = G_bank_trx_number,
2613: invoice_text = G_invoice_text,
2614: customer_text = G_customer_text,
2615: bank_account_text = G_bank_account_text,