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 4702: l_jurisdiction_id zx_jurisdictions_b.tax_jurisdiction_id%TYPE;

4698: l_location_id NUMBER;
4699: l_tax_service_type_code zx_rules_b.service_type_code%TYPE;
4700:
4701: l_reg_party VARCHAR2(256);
4702: l_jurisdiction_id zx_jurisdictions_b.tax_jurisdiction_id%TYPE;
4703: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
4704: l_tax_param_code VARCHAR2(30);
4705: l_error_buffer VARCHAR2(256);
4706: l_structure_name varchar2(30);

Line 4703: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;

4699: l_tax_service_type_code zx_rules_b.service_type_code%TYPE;
4700:
4701: l_reg_party VARCHAR2(256);
4702: l_jurisdiction_id zx_jurisdictions_b.tax_jurisdiction_id%TYPE;
4703: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
4704: l_tax_param_code VARCHAR2(30);
4705: l_error_buffer VARCHAR2(256);
4706: l_structure_name varchar2(30);
4707: l_msg_count NUMBER;

Line 5239: p_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,

5235: p_event_class_rec IN zx_api_pub.event_class_rec_type,
5236: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
5237: p_tax IN zx_taxes_b.tax%TYPE,
5238: p_tax_determine_date IN zx_lines.tax_determine_date%TYPE,
5239: p_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
5240: p_reg_party_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
5241: x_registration_rec OUT NOCOPY zx_tcm_control_pkg.zx_registration_info_rec,
5242: x_return_status OUT NOCOPY VARCHAR2
5243: ) IS

Line 5259: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;

5255: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
5256: l_account_type_code VARCHAR2(30);
5257: l_first_party_flag BOOLEAN;
5258: l_hq_estb_ptp_id zx_lines.hq_estb_party_tax_prof_id%TYPE;
5259: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
5260:
5261: -- Bug#5395227
5262: l_tax_rec ZX_TDS_UTILITIES_PKG.ZX_TAX_INFO_CACHE_REC;
5263: l_has_other_jurisdictions_flag VARCHAR2(1);

Line 5507: FROM zx_jurisdictions_b jur

5503: IF l_has_other_jurisdictions_flag = 'N' THEN
5504: BEGIN
5505: SELECT tax_jurisdiction_code
5506: INTO l_jurisdiction_code
5507: FROM zx_jurisdictions_b jur
5508: WHERE jur.tax_regime_code = p_tax_regime_code
5509: AND jur.tax = p_tax
5510: AND jur.default_jurisdiction_flag = 'Y'
5511: AND p_tax_determine_date between jur.default_flg_effective_from

Line 5618: p_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,

5614: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
5615: p_tax_id IN zx_taxes_b.tax_id%TYPE,
5616: p_tax IN zx_taxes_b.tax%TYPE,
5617: p_tax_determine_date IN DATE,
5618: p_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
5619: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
5620: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,
5621: p_trx_line_index IN BINARY_INTEGER,
5622: x_registration_number IN OUT NOCOPY zx_registrations.registration_number%TYPE,

Line 5932: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;

5928: i BINARY_INTEGER;
5929: l_tax_id BINARY_INTEGER;
5930: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;
5931: l_ret_record_level VARCHAR2(30);
5932: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
5933: l_party_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
5934:
5935: BEGIN
5936: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 6184: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;

6180: l_reg_rule_flg zx_taxes_b.registration_type_rule_flag%TYPE;
6181:
6182: l_tax_id NUMBER;
6183: l_error_buffer VARCHAR2(200);
6184: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
6185: l_self_assessed_flag zx_lines.self_assessed_flag%TYPE;
6186:
6187: BEGIN
6188:

Line 6346: FROM zx_jurisdictions_b

6342:
6343: CURSOR get_default_jurisdiction_csr(c_tax_regime_code VARCHAR2, c_tax VARCHAR2) IS
6344: SELECT tax_jurisdiction_id,
6345: tax_jurisdiction_code
6346: FROM zx_jurisdictions_b
6347: WHERE tax_regime_code = c_tax_regime_code
6348: AND tax = c_tax
6349: AND default_jurisdiction_flag = 'Y'
6350: AND (p_tax_determine_date >= default_flg_effective_from AND

Line 6444: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;

6440: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
6441: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
6442:
6443: l_jurisdiction_id NUMBER;
6444: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
6445:
6446: l_tax_class zx_rates_b.tax_class%TYPE;
6447:
6448: BEGIN

Line 7124: l_tax_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;

7120: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
7121: l_rownum BINARY_INTEGER;
7122: l_error_buffer VARCHAR2(200);
7123: l_tax_regime_code zx_regimes_b.tax_regime_code%TYPE;
7124: l_tax_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
7125: l_tax zx_taxes_b.tax%TYPE;
7126: l_tax_status_code zx_status_b.tax_status_code%TYPE;
7127: l_record_type_code zx_rates_b.record_type_code%TYPE;
7128: l_offset_tax_rate_code zx_rates_b.offset_tax_rate_code%TYPE;