456: EXIT WHEN l_cursor%NOTFOUND;
457:
458: SELECT count (1)
459: INTO h_rec_cnt
460: FROM ce_statement_headers_int
461: WHERE bank_account_num = l_bank_account_num
462: AND statement_number = l_statement_number;
463:
464: IF h_rec_cnt = 0 THEN
602: --
603: -- bug 3676745 MO and BA uptake
604: SELECT count(1)
605: INTO l_rec_cnt
606: FROM ce_statement_headers_int
607: WHERE bank_account_num = G_bank_account_num
608: AND statement_number = l_statement_number;
609:
610: IF l_rec_cnt > 0 THEN
607: WHERE bank_account_num = G_bank_account_num
608: AND statement_number = l_statement_number;
609:
610: IF l_rec_cnt > 0 THEN
611: DELETE FROM ce_statement_headers_int
612: WHERE bank_account_num = G_bank_account_num
613: AND statement_number = l_statement_number;
614:
615: G_total_hdr_deleted := G_total_hdr_deleted + l_rec_cnt;
617:
618: -- bug 4337623 added for subsidiary bank accounts
619: validate_subsidiary_account();
620:
621: INSERT INTO ce_statement_headers_int(
622: STATEMENT_NUMBER,
623: BANK_ACCOUNT_NUM,
624: STATEMENT_DATE,
625: BANK_NAME,