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 1451: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;

1447: IS
1448: l_tax_prof_name VARCHAR(30);
1449: l_rounding_level_basis VARCHAR(8);
1450: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
1451: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
1452: l_account_id hz_cust_accounts.cust_account_id%TYPE;
1453: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1454: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1455: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;

Line 1682: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;

1678: l_tax_prof_name VARCHAR(30);
1679: l_rounding_level_basis VARCHAR(8);
1680:
1681: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
1682: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
1683: l_account_id hz_cust_accounts.cust_account_id%TYPE;
1684: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1685: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1686: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;

Line 8144: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,

8140:
8141: PROCEDURE Get_Reg_Site_Uses (
8142: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
8143: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
8144: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,
8145: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
8146: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
8147: p_return_status OUT NOCOPY VARCHAR2)
8148: IS

Line 8150: c_site_use_id HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,

8146: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
8147: p_return_status OUT NOCOPY VARCHAR2)
8148: IS
8149: CURSOR c_site_uses (
8150: c_site_use_id HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,
8151: c_account_site_id ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
8152: c_account_id ZX_REGISTRATIONS.ACCOUNT_ID%TYPE)
8153: IS
8154: SELECT

Line 8160: FROM hz_cust_site_uses_all csu

8156: nvl(csu.Tax_Code,caa.tax_code) tax_code,
8157: nvl(csu.Tax_Rounding_rule,caa.tax_rounding_rule) tax_rounding_rule,
8158: nvl(csu.tax_header_level_flag, caa.tax_header_level_flag) tax_header_level_flag,
8159: csu.Tax_Classification
8160: FROM hz_cust_site_uses_all csu
8161: ,hz_cust_acct_sites cas
8162: ,hz_cust_accounts caa
8163: WHERE csu.site_use_id = c_site_use_id
8164: AND csu.cust_acct_site_id = c_account_site_id

Line 8169: l_tax_rounding_rule hz_cust_site_uses_all.Tax_Rounding_rule%TYPE;

8165: AND csu.cust_acct_site_id = cas.cust_acct_site_id
8166: AND cas.cust_account_id = caa.cust_account_id
8167: AND caa.cust_account_id = c_account_id;
8168:
8169: l_tax_rounding_rule hz_cust_site_uses_all.Tax_Rounding_rule%TYPE;
8170: l_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
8171: l_tax_code hz_cust_site_uses_all.Tax_Code%TYPE;
8172: l_Tax_Classification hz_cust_site_uses_all.Tax_Classification%TYPE;
8173: l_tax_reference hz_cust_site_uses_all.Tax_Reference%TYPE;

Line 8170: l_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;

8166: AND cas.cust_account_id = caa.cust_account_id
8167: AND caa.cust_account_id = c_account_id;
8168:
8169: l_tax_rounding_rule hz_cust_site_uses_all.Tax_Rounding_rule%TYPE;
8170: l_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
8171: l_tax_code hz_cust_site_uses_all.Tax_Code%TYPE;
8172: l_Tax_Classification hz_cust_site_uses_all.Tax_Classification%TYPE;
8173: l_tax_reference hz_cust_site_uses_all.Tax_Reference%TYPE;
8174:

Line 8171: l_tax_code hz_cust_site_uses_all.Tax_Code%TYPE;

8167: AND caa.cust_account_id = c_account_id;
8168:
8169: l_tax_rounding_rule hz_cust_site_uses_all.Tax_Rounding_rule%TYPE;
8170: l_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
8171: l_tax_code hz_cust_site_uses_all.Tax_Code%TYPE;
8172: l_Tax_Classification hz_cust_site_uses_all.Tax_Classification%TYPE;
8173: l_tax_reference hz_cust_site_uses_all.Tax_Reference%TYPE;
8174:
8175:

Line 8172: l_Tax_Classification hz_cust_site_uses_all.Tax_Classification%TYPE;

8168:
8169: l_tax_rounding_rule hz_cust_site_uses_all.Tax_Rounding_rule%TYPE;
8170: l_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
8171: l_tax_code hz_cust_site_uses_all.Tax_Code%TYPE;
8172: l_Tax_Classification hz_cust_site_uses_all.Tax_Classification%TYPE;
8173: l_tax_reference hz_cust_site_uses_all.Tax_Reference%TYPE;
8174:
8175:
8176: BEGIN

Line 8173: l_tax_reference hz_cust_site_uses_all.Tax_Reference%TYPE;

8169: l_tax_rounding_rule hz_cust_site_uses_all.Tax_Rounding_rule%TYPE;
8170: l_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
8171: l_tax_code hz_cust_site_uses_all.Tax_Code%TYPE;
8172: l_Tax_Classification hz_cust_site_uses_all.Tax_Classification%TYPE;
8173: l_tax_reference hz_cust_site_uses_all.Tax_Reference%TYPE;
8174:
8175:
8176: BEGIN
8177: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 8287: l_tax_code hz_cust_site_uses_all.Tax_Code%TYPE;

8283: tax_rounding_rule
8284: FROM hz_cust_accounts
8285: WHERE cust_account_id = c_account_id;
8286:
8287: l_tax_code hz_cust_site_uses_all.Tax_Code%TYPE;
8288: l_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
8289: l_tax_rounding_rule hz_cust_site_uses_all.Tax_Rounding_rule%TYPE;
8290:
8291:

Line 8288: l_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;

8284: FROM hz_cust_accounts
8285: WHERE cust_account_id = c_account_id;
8286:
8287: l_tax_code hz_cust_site_uses_all.Tax_Code%TYPE;
8288: l_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
8289: l_tax_rounding_rule hz_cust_site_uses_all.Tax_Rounding_rule%TYPE;
8290:
8291:
8292: BEGIN

Line 8289: l_tax_rounding_rule hz_cust_site_uses_all.Tax_Rounding_rule%TYPE;

8285: WHERE cust_account_id = c_account_id;
8286:
8287: l_tax_code hz_cust_site_uses_all.Tax_Code%TYPE;
8288: l_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
8289: l_tax_rounding_rule hz_cust_site_uses_all.Tax_Rounding_rule%TYPE;
8290:
8291:
8292: BEGIN
8293:

Line 8455: p_site_use_id IN HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE,

8451: p_site_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
8452: p_account_Type_Code IN zx_registrations.account_type_code%TYPE,
8453: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
8454: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
8455: p_site_use_id IN HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE,
8456: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
8457: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
8458: p_return_status OUT NOCOPY VARCHAR2,
8459: p_error_buffer OUT NOCOPY VARCHAR2