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_TDS_APPLICABILITY_DETM_PKG dependencies on ZX_JURISDICTIONS_B

Line 87: g_inner_jurisdiction_code ZX_JURISDICTIONS_B.tax_jurisdiction_code%TYPE;

83: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
84: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
85:
86: -- cache the most inner and outer jurisdiction
87: g_inner_jurisdiction_code ZX_JURISDICTIONS_B.tax_jurisdiction_code%TYPE;
88: g_inner_jurisdiction_id ZX_JURISDICTIONS_B.tax_jurisdiction_id%TYPE;
89: g_outer_jurisdiction_code ZX_JURISDICTIONS_B.tax_jurisdiction_code%TYPE;
90: g_outer_jurisdiction_id ZX_JURISDICTIONS_B.tax_jurisdiction_id%TYPE;
91:

Line 88: g_inner_jurisdiction_id ZX_JURISDICTIONS_B.tax_jurisdiction_id%TYPE;

84: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
85:
86: -- cache the most inner and outer jurisdiction
87: g_inner_jurisdiction_code ZX_JURISDICTIONS_B.tax_jurisdiction_code%TYPE;
88: g_inner_jurisdiction_id ZX_JURISDICTIONS_B.tax_jurisdiction_id%TYPE;
89: g_outer_jurisdiction_code ZX_JURISDICTIONS_B.tax_jurisdiction_code%TYPE;
90: g_outer_jurisdiction_id ZX_JURISDICTIONS_B.tax_jurisdiction_id%TYPE;
91:
92: g_trx_line_id ZX_LINES.trx_line_id%TYPE;

Line 89: g_outer_jurisdiction_code ZX_JURISDICTIONS_B.tax_jurisdiction_code%TYPE;

85:
86: -- cache the most inner and outer jurisdiction
87: g_inner_jurisdiction_code ZX_JURISDICTIONS_B.tax_jurisdiction_code%TYPE;
88: g_inner_jurisdiction_id ZX_JURISDICTIONS_B.tax_jurisdiction_id%TYPE;
89: g_outer_jurisdiction_code ZX_JURISDICTIONS_B.tax_jurisdiction_code%TYPE;
90: g_outer_jurisdiction_id ZX_JURISDICTIONS_B.tax_jurisdiction_id%TYPE;
91:
92: g_trx_line_id ZX_LINES.trx_line_id%TYPE;
93:

Line 90: g_outer_jurisdiction_id ZX_JURISDICTIONS_B.tax_jurisdiction_id%TYPE;

86: -- cache the most inner and outer jurisdiction
87: g_inner_jurisdiction_code ZX_JURISDICTIONS_B.tax_jurisdiction_code%TYPE;
88: g_inner_jurisdiction_id ZX_JURISDICTIONS_B.tax_jurisdiction_id%TYPE;
89: g_outer_jurisdiction_code ZX_JURISDICTIONS_B.tax_jurisdiction_code%TYPE;
90: g_outer_jurisdiction_id ZX_JURISDICTIONS_B.tax_jurisdiction_id%TYPE;
91:
92: g_trx_line_id ZX_LINES.trx_line_id%TYPE;
93:
94: -------------------------------------------------------------------------------

Line 5200: l_jurisdiction_id zx_jurisdictions_b.tax_jurisdiction_id%TYPE;

5196: l_location_id NUMBER;
5197: l_tax_service_type_code zx_rules_b.service_type_code%TYPE;
5198:
5199: l_reg_party VARCHAR2(256);
5200: l_jurisdiction_id zx_jurisdictions_b.tax_jurisdiction_id%TYPE;
5201: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
5202: l_tax_param_code VARCHAR2(30);
5203: l_error_buffer VARCHAR2(256);
5204: l_structure_name varchar2(30);

Line 5201: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;

5197: l_tax_service_type_code zx_rules_b.service_type_code%TYPE;
5198:
5199: l_reg_party VARCHAR2(256);
5200: l_jurisdiction_id zx_jurisdictions_b.tax_jurisdiction_id%TYPE;
5201: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
5202: l_tax_param_code VARCHAR2(30);
5203: l_error_buffer VARCHAR2(256);
5204: l_structure_name varchar2(30);
5205: l_msg_count NUMBER;

Line 5737: p_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,

5733: p_event_class_rec IN zx_api_pub.event_class_rec_type,
5734: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
5735: p_tax IN zx_taxes_b.tax%TYPE,
5736: p_tax_determine_date IN zx_lines.tax_determine_date%TYPE,
5737: p_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
5738: p_reg_party_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
5739: x_registration_rec OUT NOCOPY zx_tcm_control_pkg.zx_registration_info_rec,
5740: x_return_status OUT NOCOPY VARCHAR2
5741: ) IS

Line 5757: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;

5753: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
5754: l_account_type_code VARCHAR2(30);
5755: l_first_party_flag BOOLEAN;
5756: l_hq_estb_ptp_id zx_lines.hq_estb_party_tax_prof_id%TYPE;
5757: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
5758:
5759: -- Bug#5395227
5760: l_tax_rec ZX_TDS_UTILITIES_PKG.ZX_TAX_INFO_CACHE_REC;
5761: l_has_other_jurisdictions_flag VARCHAR2(1);

Line 6004: FROM zx_jurisdictions_b jur

6000: IF l_has_other_jurisdictions_flag = 'N' THEN
6001: BEGIN
6002: SELECT tax_jurisdiction_code
6003: INTO l_jurisdiction_code
6004: FROM zx_jurisdictions_b jur
6005: WHERE jur.tax_regime_code = p_tax_regime_code
6006: AND jur.tax = p_tax
6007: AND jur.default_jurisdiction_flag = 'Y'
6008: AND p_tax_determine_date between jur.default_flg_effective_from

Line 6116: p_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,

6112: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
6113: p_tax_id IN zx_taxes_b.tax_id%TYPE,
6114: p_tax IN zx_taxes_b.tax%TYPE,
6115: p_tax_determine_date IN DATE,
6116: p_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
6117: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
6118: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,
6119: p_trx_line_index IN BINARY_INTEGER,
6120: x_registration_number IN OUT NOCOPY zx_registrations.registration_number%TYPE,

Line 6430: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;

6426: i BINARY_INTEGER;
6427: l_tax_id BINARY_INTEGER;
6428: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;
6429: l_ret_record_level VARCHAR2(30);
6430: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
6431: l_party_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
6432:
6433: BEGIN
6434: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 6682: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;

6678: l_reg_rule_flg zx_taxes_b.registration_type_rule_flag%TYPE;
6679:
6680: l_tax_id NUMBER;
6681: l_error_buffer VARCHAR2(200);
6682: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
6683: l_self_assessed_flag zx_lines.self_assessed_flag%TYPE;
6684: BEGIN
6685:
6686: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6848: FROM zx_jurisdictions_b

6844:
6845: CURSOR get_default_jurisdiction_csr(c_tax_regime_code VARCHAR2, c_tax VARCHAR2) IS
6846: SELECT tax_jurisdiction_id,
6847: tax_jurisdiction_code
6848: FROM zx_jurisdictions_b
6849: WHERE tax_regime_code = c_tax_regime_code
6850: AND tax = c_tax
6851: AND default_jurisdiction_flag = 'Y'
6852: AND (p_tax_determine_date >= default_flg_effective_from AND

Line 6946: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;

6942: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
6943: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
6944:
6945: l_jurisdiction_id NUMBER;
6946: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
6947:
6948: l_tax_class zx_rates_b.tax_class%TYPE;
6949: l_tmp_tax_apportionmt_ln_num NUMBER; -- Added for Bug 10184087
6950:

Line 7667: l_tax_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;

7663: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
7664: l_rownum BINARY_INTEGER;
7665: l_error_buffer VARCHAR2(200);
7666: l_tax_regime_code zx_regimes_b.tax_regime_code%TYPE;
7667: l_tax_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
7668: l_tax zx_taxes_b.tax%TYPE;
7669: l_tax_status_code zx_status_b.tax_status_code%TYPE;
7670: l_record_type_code zx_rates_b.record_type_code%TYPE;
7671: l_offset_tax_rate_code zx_rates_b.offset_tax_rate_code%TYPE;