DBA Data[Home] [Help]

APPS.CE_PURGE_TRX_CODES_XML dependencies on FND_GLOBAL

Line 106: l_conc_request_id := FND_GLOBAL.conc_request_id;

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,

Line 201: WHERE GT.request_id = FND_GLOBAL.conc_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('<