667: ,buff => 'Data in tables (before the report is run)');
668:
669: SELECT COUNT(detail_tax_line_id)
670: INTO l_count
671: FROM zx_rep_trx_detail_t;
672:
673: FND_FILE.put_line(which => FND_FILE.LOG
674: ,buff => 'zx_rep_trx_detail_t : '||l_count);
675:
670: INTO l_count
671: FROM zx_rep_trx_detail_t;
672:
673: FND_FILE.put_line(which => FND_FILE.LOG
674: ,buff => 'zx_rep_trx_detail_t : '||l_count);
675:
676: SELECT COUNT(actg_ext_line_id)
677: INTO l_count
678: FROM zx_rep_actg_ext_t;
2574: AND REQUEST_ID = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
2575:
2576: l_count := sql%rowcount; -- apai
2577:
2578: DELETE FROM zx_rep_trx_detail_t i
2579: WHERE request_id = P_TRL_GLOBAL_VARIABLES_REC.request_id
2580: AND rep_context_id is null;
2581: */
2582: NULL;
3491: END IF;
3492:
3493: IF (g_level_procedure >= g_current_runtime_level ) THEN
3494: select count(*) into num_rows_deleted
3495: from zx_rep_trx_detail_t
3496: where request_id = p_request_id;
3497: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',
3498: 'Num of Rows in zx_rep_trx_detail_t :'||num_rows_deleted);
3499: select count(*) into num_rows_deleted
3494: select count(*) into num_rows_deleted
3495: from zx_rep_trx_detail_t
3496: where request_id = p_request_id;
3497: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',
3498: 'Num of Rows in zx_rep_trx_detail_t :'||num_rows_deleted);
3499: select count(*) into num_rows_deleted
3500: from ZX_REP_ACTG_EXT_T
3501: where request_id = p_request_id;
3502: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',
3515:
3516: IF PG_DEBUG = 'N' THEN
3517: delete from ZX_REP_ACTG_EXT_T where request_id = p_request_id;
3518: delete from ZX_REP_TRX_JX_EXT_T where request_id = p_request_id;
3519: delete from ZX_REP_TRX_DETAIL_T where request_id = p_request_id;
3520: delete from ZX_REP_CONTEXT_T where request_id = p_request_id;
3521: IF (g_level_procedure >= g_current_runtime_level ) THEN
3522: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.PURGE.END',
3523: 'In Delete when PG_DEBUG = N ');
3574: --pg_debug_flag:= nvl(FND_PROFILE.value('TAX_DEBUG_FLAG'),'N');
3575:
3576:
3577: select count(*) into num_rows_deleted
3578: from zx_rep_trx_detail_t
3579: where request_id = p_request_id;
3580:
3581: PURGE(p_request_id);
3582: