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_TAX_ROUNDING_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 92: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,

88:
89: PROCEDURE Get_Reg_Site_Uses (
90: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
91: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
92: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,
93: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
94: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
95: p_return_status OUT NOCOPY VARCHAR2);
96:

Line 117: p_site_use_id IN HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE,

113: p_site_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
114: p_account_Type_Code IN zx_registrations.account_type_code%TYPE,
115: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
116: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
117: p_site_use_id IN HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE,
118: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
119: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
120: p_return_status OUT NOCOPY VARCHAR2,
121: p_error_buffer OUT NOCOPY VARCHAR2

Line 1443: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;

1439: IS
1440: l_tax_prof_name VARCHAR(30);
1441: l_rounding_level_basis VARCHAR(8);
1442: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
1443: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
1444: l_account_id hz_cust_accounts.cust_account_id%TYPE;
1445: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1446: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1447: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;

Line 1674: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;

1670: l_tax_prof_name VARCHAR(30);
1671: l_rounding_level_basis VARCHAR(8);
1672:
1673: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
1674: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
1675: l_account_id hz_cust_accounts.cust_account_id%TYPE;
1676: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1677: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1678: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;

Line 7877: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,

7873:
7874: PROCEDURE Get_Reg_Site_Uses (
7875: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
7876: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
7877: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,
7878: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
7879: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
7880: p_return_status OUT NOCOPY VARCHAR2)
7881: IS

Line 7883: c_site_use_id HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,

7879: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
7880: p_return_status OUT NOCOPY VARCHAR2)
7881: IS
7882: CURSOR c_site_uses (
7883: c_site_use_id HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,
7884: c_account_site_id ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
7885: c_account_id ZX_REGISTRATIONS.ACCOUNT_ID%TYPE)
7886: IS
7887: SELECT

Line 7893: FROM hz_cust_site_uses_all csu

7889: nvl(csu.Tax_Code,caa.tax_code) tax_code,
7890: nvl(csu.Tax_Rounding_rule,caa.tax_rounding_rule) tax_rounding_rule,
7891: nvl(csu.tax_header_level_flag, caa.tax_header_level_flag) tax_header_level_flag,
7892: csu.Tax_Classification
7893: FROM hz_cust_site_uses_all csu
7894: ,hz_cust_acct_sites cas
7895: ,hz_cust_accounts caa
7896: WHERE csu.site_use_id = c_site_use_id
7897: AND csu.cust_acct_site_id = c_account_site_id

Line 7902: l_tax_rounding_rule hz_cust_site_uses_all.Tax_Rounding_rule%TYPE;

7898: AND csu.cust_acct_site_id = cas.cust_acct_site_id
7899: AND cas.cust_account_id = caa.cust_account_id
7900: AND caa.cust_account_id = c_account_id;
7901:
7902: l_tax_rounding_rule hz_cust_site_uses_all.Tax_Rounding_rule%TYPE;
7903: l_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
7904: l_tax_code hz_cust_site_uses_all.Tax_Code%TYPE;
7905: l_Tax_Classification hz_cust_site_uses_all.Tax_Classification%TYPE;
7906: l_tax_reference hz_cust_site_uses_all.Tax_Reference%TYPE;

Line 7903: l_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;

7899: AND cas.cust_account_id = caa.cust_account_id
7900: AND caa.cust_account_id = c_account_id;
7901:
7902: l_tax_rounding_rule hz_cust_site_uses_all.Tax_Rounding_rule%TYPE;
7903: l_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
7904: l_tax_code hz_cust_site_uses_all.Tax_Code%TYPE;
7905: l_Tax_Classification hz_cust_site_uses_all.Tax_Classification%TYPE;
7906: l_tax_reference hz_cust_site_uses_all.Tax_Reference%TYPE;
7907:

Line 7904: l_tax_code hz_cust_site_uses_all.Tax_Code%TYPE;

7900: AND caa.cust_account_id = c_account_id;
7901:
7902: l_tax_rounding_rule hz_cust_site_uses_all.Tax_Rounding_rule%TYPE;
7903: l_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
7904: l_tax_code hz_cust_site_uses_all.Tax_Code%TYPE;
7905: l_Tax_Classification hz_cust_site_uses_all.Tax_Classification%TYPE;
7906: l_tax_reference hz_cust_site_uses_all.Tax_Reference%TYPE;
7907:
7908:

Line 7905: l_Tax_Classification hz_cust_site_uses_all.Tax_Classification%TYPE;

7901:
7902: l_tax_rounding_rule hz_cust_site_uses_all.Tax_Rounding_rule%TYPE;
7903: l_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
7904: l_tax_code hz_cust_site_uses_all.Tax_Code%TYPE;
7905: l_Tax_Classification hz_cust_site_uses_all.Tax_Classification%TYPE;
7906: l_tax_reference hz_cust_site_uses_all.Tax_Reference%TYPE;
7907:
7908:
7909: BEGIN

Line 7906: l_tax_reference hz_cust_site_uses_all.Tax_Reference%TYPE;

7902: l_tax_rounding_rule hz_cust_site_uses_all.Tax_Rounding_rule%TYPE;
7903: l_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
7904: l_tax_code hz_cust_site_uses_all.Tax_Code%TYPE;
7905: l_Tax_Classification hz_cust_site_uses_all.Tax_Classification%TYPE;
7906: l_tax_reference hz_cust_site_uses_all.Tax_Reference%TYPE;
7907:
7908:
7909: BEGIN
7910: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 8020: l_tax_code hz_cust_site_uses_all.Tax_Code%TYPE;

8016: tax_rounding_rule
8017: FROM hz_cust_accounts
8018: WHERE cust_account_id = c_account_id;
8019:
8020: l_tax_code hz_cust_site_uses_all.Tax_Code%TYPE;
8021: l_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
8022: l_tax_rounding_rule hz_cust_site_uses_all.Tax_Rounding_rule%TYPE;
8023:
8024:

Line 8021: l_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;

8017: FROM hz_cust_accounts
8018: WHERE cust_account_id = c_account_id;
8019:
8020: l_tax_code hz_cust_site_uses_all.Tax_Code%TYPE;
8021: l_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
8022: l_tax_rounding_rule hz_cust_site_uses_all.Tax_Rounding_rule%TYPE;
8023:
8024:
8025: BEGIN

Line 8022: l_tax_rounding_rule hz_cust_site_uses_all.Tax_Rounding_rule%TYPE;

8018: WHERE cust_account_id = c_account_id;
8019:
8020: l_tax_code hz_cust_site_uses_all.Tax_Code%TYPE;
8021: l_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
8022: l_tax_rounding_rule hz_cust_site_uses_all.Tax_Rounding_rule%TYPE;
8023:
8024:
8025: BEGIN
8026:

Line 8188: p_site_use_id IN HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE,

8184: p_site_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
8185: p_account_Type_Code IN zx_registrations.account_type_code%TYPE,
8186: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
8187: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
8188: p_site_use_id IN HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE,
8189: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
8190: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
8191: p_return_status OUT NOCOPY VARCHAR2,
8192: p_error_buffer OUT NOCOPY VARCHAR2