APPS.ZX_EXTRACT_PKG dependencies on ZX_REP_ACTG_EXT_T

Line 678: FROM zx_rep_actg_ext_t;

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;
679:
680: FND_FILE.put_line(which => FND_FILE.LOG
681: ,buff => 'zx_rep_actg_ext_t : '||l_count);
682:

Line 681: ,buff => 'zx_rep_actg_ext_t : '||l_count);

677: INTO l_count
678: FROM zx_rep_actg_ext_t;
679:
680: FND_FILE.put_line(which => FND_FILE.LOG
681: ,buff => 'zx_rep_actg_ext_t : '||l_count);
682:
683: SELECT COUNT(detail_tax_line_ext_id)
684: INTO l_count
685: FROM zx_rep_trx_jx_ext_t;

Line 3500: from ZX_REP_ACTG_EXT_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',
3503: 'Num of Rows in ZX_REP_ACTG_EXT_T :'||num_rows_deleted);
3504: select count(*) into num_rows_deleted

Line 3503: 'Num of Rows in ZX_REP_ACTG_EXT_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',
3503: 'Num of Rows in ZX_REP_ACTG_EXT_T :'||num_rows_deleted);
3504: select count(*) into num_rows_deleted
3505: from ZX_REP_TRX_JX_EXT_T
3506: where request_id = p_request_id;
3507: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',

Line 3517: delete from ZX_REP_ACTG_EXT_T where request_id = p_request_id;

3513: 'Num of Rows in ZX_REP_CONTEXT_T :'||num_rows_deleted);
3514: END IF;
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