APPS.CE_PURGE_TRX_CODES_XML dependencies on CE_TRX_CODES_UTIL_GT

Line 108: INSERT INTO ce_trx_codes_util_gt (

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,
111: trx_code_id,
112: trx_code,

Line 170: FROM ce_trx_codes_util_gt GT

166: debug_log('Deleting transaction codes');
167: DELETE ce_transaction_codes CTC
168: WHERE EXISTS(
169: SELECT 1
170: FROM ce_trx_codes_util_gt GT
171: WHERE GT.trx_code_id = CTC.transaction_code_id);
172:
173: debug_log('< 174:

Line 200: FROM ce_trx_codes_util_gt GT

196:
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:

Line 227: DELETE ce_trx_codes_util_gt;

223: +========================================================================*/
224: FUNCTION afterReport RETURN BOOLEAN IS
225: BEGIN
226: debug_log('>>CE_PURGE_TRX_CODES_XML.afterReport');
227: DELETE ce_trx_codes_util_gt;
228: COMMIT;
229: debug_log('< 230: RETURN (TRUE);
231: END afterReport;