DBA Data[Home] [Help]

APPS.ZX_TDS_TAX_ROUNDING_PKG dependencies on ZX_REGISTRATIONS

Line 82: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

78: p_return_status OUT NOCOPY VARCHAR2,
79: p_error_buffer OUT NOCOPY VARCHAR2);
80:
81: PROCEDURE Get_Supplier_Site(
82: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
83: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
84: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
85: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
86:

Line 83: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,

79: p_error_buffer OUT NOCOPY VARCHAR2);
80:
81: PROCEDURE Get_Supplier_Site(
82: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
83: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
84: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
85: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
86:
87: p_return_status OUT NOCOPY VARCHAR2);

Line 90: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

86:
87: p_return_status OUT NOCOPY VARCHAR2);
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,

Line 91: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,

87: p_return_status OUT NOCOPY VARCHAR2);
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);

Line 98: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

94: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
95: p_return_status OUT NOCOPY VARCHAR2);
96:
97: PROCEDURE Get_Registration_Accts(
98: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
99: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
100: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
101: p_return_status OUT NOCOPY VARCHAR2 );
102:

Line 114: p_account_Type_Code IN zx_registrations.account_type_code%TYPE,

110: PROCEDURE get_rounding_level(
111:
112: p_parent_ptp_id IN zx_party_tax_profile.party_tax_profile_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,

Line 115: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

111:
112: p_parent_ptp_id IN zx_party_tax_profile.party_tax_profile_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,

Line 116: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,

112: p_parent_ptp_id IN zx_party_tax_profile.party_tax_profile_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,

Line 7999: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

7995: --
7996:
7997:
7998: PROCEDURE Get_Supplier_Site(
7999: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
8000: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
8001: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
8002: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
8003:

Line 8000: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,

7996:
7997:
7998: PROCEDURE Get_Supplier_Site(
7999: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
8000: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
8001: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
8002: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
8003:
8004: p_return_status OUT NOCOPY VARCHAR2)

Line 8008: c_account_id ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

8004: p_return_status OUT NOCOPY VARCHAR2)
8005: IS
8006:
8007: CURSOR c_supplier_ptp (
8008: c_account_id ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
8009: c_account_site_id ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE)
8010: IS
8011: SELECT
8012: decode(povs.AP_Tax_Rounding_Rule,'U','UP','D','DOWN','N','NEAREST',NULL) tax_runding_rule

Line 8009: c_account_site_id ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE)

8005: IS
8006:
8007: CURSOR c_supplier_ptp (
8008: c_account_id ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
8009: c_account_site_id ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE)
8010: IS
8011: SELECT
8012: decode(povs.AP_Tax_Rounding_Rule,'U','UP','D','DOWN','N','NEAREST',NULL) tax_runding_rule
8013: ,decode(nvl(povs.Auto_Tax_Calc_Flag,'Y'),'N','N','Y') Auto_Tax_Calc_Flag

Line 8142: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

8138: -- DESCRIPTION
8139: --
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,

Line 8143: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,

8139: --
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)

Line 8151: c_account_site_id ZX_REGISTRATIONS.ACCOUNT_SITE_ID%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
8155: csu.Tax_Reference,

Line 8152: c_account_id ZX_REGISTRATIONS.ACCOUNT_ID%TYPE)

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
8155: csu.Tax_Reference,
8156: nvl(csu.Tax_Code,caa.tax_code) tax_code,

Line 8270: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

8266: --
8267: -- DESCRIPTION
8268:
8269: PROCEDURE Get_Registration_Accts(
8270: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
8271: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
8272: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
8273: p_return_status OUT NOCOPY VARCHAR2 )
8274:

Line 8278: c_account_id ZX_REGISTRATIONS.ACCOUNT_ID%TYPE)

8274:
8275: IS
8276:
8277: CURSOR c_customer_account (
8278: c_account_id ZX_REGISTRATIONS.ACCOUNT_ID%TYPE)
8279: IS
8280: SELECT
8281: tax_code,
8282: tax_header_level_flag,

Line 8452: p_account_Type_Code IN zx_registrations.account_type_code%TYPE,

8448: PROCEDURE get_rounding_level(
8449:
8450: p_parent_ptp_id IN zx_party_tax_profile.party_tax_profile_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,

Line 8453: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

8449:
8450: p_parent_ptp_id IN zx_party_tax_profile.party_tax_profile_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,

Line 8454: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,

8450: p_parent_ptp_id IN zx_party_tax_profile.party_tax_profile_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,