DBA Data[Home] [Help]

APPS.ZX_EXTRACT_PKG dependencies on ZX_REP_TRX_JX_EXT_T

Line 685: FROM zx_rep_trx_jx_ext_t;

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;
686:
687: FND_FILE.put_line(which => FND_FILE.LOG
688: ,buff => 'zx_rep_trx_jx_ext_t : '||l_count);
689:

Line 688: ,buff => 'zx_rep_trx_jx_ext_t : '||l_count);

684: INTO l_count
685: FROM zx_rep_trx_jx_ext_t;
686:
687: FND_FILE.put_line(which => FND_FILE.LOG
688: ,buff => 'zx_rep_trx_jx_ext_t : '||l_count);
689:
690: SELECT COUNT(rep_context_id)
691: INTO l_count
692: FROM zx_rep_context_t;

Line 3505: from ZX_REP_TRX_JX_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',
3508: 'Num of Rows in ZX_REP_TRX_JX_EXT_T :'||num_rows_deleted);
3509: select count(*) into num_rows_deleted

Line 3508: 'Num of Rows in ZX_REP_TRX_JX_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',
3508: 'Num of Rows in ZX_REP_TRX_JX_EXT_T :'||num_rows_deleted);
3509: select count(*) into num_rows_deleted
3510: from ZX_REP_CONTEXT_T
3511: where request_id = p_request_id;
3512: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',

Line 3518: delete from ZX_REP_TRX_JX_EXT_T where request_id = p_request_id;

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
3522: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.PURGE.END',