eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TPI_SERVICES_PKG dependencies on ZX_REGIMES_B

Line 157: FROM ZX_REGIMES_B

153: INTO x_migrated_tax_regime_id
154: , x_migrated_effective_from -- Bug 5557565
155: , x_migrated_effective_to -- Bug 5557565
156: , x_migrated_country_code
157: FROM ZX_REGIMES_B
158: WHERE tax_regime_code = x_migrated_tax_regime_code;
159: END IF; --- bug6024643
160: END IF;
161:

Line 258: prev_tax_regime_code zx_regimes_b.tax_regime_code%type;

254: ) IS
255: l_api_name CONSTANT VARCHAR2(30) := 'SET_DETAIL_TAX_LINE_VALUES';
256: l_count NUMBER;
257:
258: prev_tax_regime_code zx_regimes_b.tax_regime_code%type;
259: l_tax_regime_id zx_regimes_b.tax_regime_id%type;
260:
261: prev_application_id zx_lines_det_factors.application_id%type;
262: prev_entity_code zx_lines_det_factors.entity_code%type;

Line 259: l_tax_regime_id zx_regimes_b.tax_regime_id%type;

255: l_api_name CONSTANT VARCHAR2(30) := 'SET_DETAIL_TAX_LINE_VALUES';
256: l_count NUMBER;
257:
258: prev_tax_regime_code zx_regimes_b.tax_regime_code%type;
259: l_tax_regime_id zx_regimes_b.tax_regime_id%type;
260:
261: prev_application_id zx_lines_det_factors.application_id%type;
262: prev_entity_code zx_lines_det_factors.entity_code%type;
263: prev_event_class_code zx_lines_det_factors.event_class_code%type;

Line 507: FROM zx_regimes_b

503: OR prev_tax_regime_code <> ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.country_code(p_ptnr_tax_line_ind) THEN
504: BEGIN
505: SELECT tax_regime_id
506: INTO l_tax_regime_id
507: FROM zx_regimes_b
508: WHERE tax_regime_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.country_code(p_ptnr_tax_line_ind);
509: END;
510: prev_tax_regime_code := ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.country_code(p_ptnr_tax_line_ind);
511: END IF;

Line 905: l_migrated_country_code ZX_REGIMES_B.country_code%TYPE;

901: l_migrated_effective_from DATE;
902: l_migrated_effective_to DATE;
903: l_return_status VARCHAR2(1);
904: l_tax_regime_id NUMBER;
905: l_migrated_country_code ZX_REGIMES_B.country_code%TYPE;
906: l_context_info_rec ZX_API_PUB.context_info_rec_type;
907:
908: /* Bug 5557565 */
909:

Line 918: , zx_regimes_b regimes

914: regimes.effective_from,
915: regimes.effective_to,
916: regimes.country_code
917: FROM ZX_TRX_LINE_APP_REGIMES ztlar
918: , zx_regimes_b regimes
919: WHERE ztlar.application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(l_index)
920: AND ztlar.entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(l_index)
921: AND ztlar.event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(l_index)
922: AND ztlar.trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(l_index)

Line 935: , zx_regimes_b regimes

931: regimes.effective_from,
932: regimes.effective_to,
933: regimes.country_code
934: FROM ZX_TRX_LINE_APP_REGIMES ztlar
935: , zx_regimes_b regimes
936: WHERE ztlar.application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(l_index)
937: AND ztlar.entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(l_index)
938: AND ztlar.event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(l_index)
939: AND ztlar.trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(l_index)

Line 2340: c_tax ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

2336: -- Bug#5417753
2337: --
2338: CURSOR get_def_tax_rate_csr
2339: (c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
2340: c_tax ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2341: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2342: c_tax_class ZX_RATES_B.TAX_CLASS%TYPE,
2343: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE)
2344: IS

Line 2341: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

2337: --
2338: CURSOR get_def_tax_rate_csr
2339: (c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
2340: c_tax ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2341: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2342: c_tax_class ZX_RATES_B.TAX_CLASS%TYPE,
2343: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE)
2344: IS
2345: SELECT rate.tax_rate_code,