102: debug_log('p_bank_branch_id::'||p_bank_branch_id);
103: debug_log('p_bank_id::'||p_bank_id);
104: debug_log('p_acct_type::'||p_acct_type);
105:
106: l_conc_request_id := FND_GLOBAL.conc_request_id;
107: --fetch transaction codes which can be deleted and insert into tmp table
108: INSERT INTO ce_trx_codes_util_gt (
109: status,
110: request_id,
197: --store deleted codes
198: SELECT count(*)
199: INTO G_DELETE_COUNT
200: FROM ce_trx_codes_util_gt GT
201: WHERE GT.request_id = FND_GLOBAL.conc_request_id;
202:
203: debug_log('g_delete_count::'||g_delete_count);
204:
205: debug_log('<