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 7740: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

7736: --
7737:
7738:
7739: PROCEDURE Get_Supplier_Site(
7740: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
7741: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
7742: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
7743: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
7744:

Line 7741: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,

7737:
7738:
7739: PROCEDURE Get_Supplier_Site(
7740: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
7741: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
7742: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
7743: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
7744:
7745: p_return_status OUT NOCOPY VARCHAR2)

Line 7749: c_account_id ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

7745: p_return_status OUT NOCOPY VARCHAR2)
7746: IS
7747:
7748: CURSOR c_supplier_ptp (
7749: c_account_id ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
7750: c_account_site_id ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE)
7751: IS
7752: SELECT
7753: decode(povs.AP_Tax_Rounding_Rule,'U','UP','D','DOWN','N','NEAREST',NULL) tax_runding_rule

Line 7750: c_account_site_id ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE)

7746: IS
7747:
7748: CURSOR c_supplier_ptp (
7749: c_account_id ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
7750: c_account_site_id ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE)
7751: IS
7752: SELECT
7753: decode(povs.AP_Tax_Rounding_Rule,'U','UP','D','DOWN','N','NEAREST',NULL) tax_runding_rule
7754: ,decode(nvl(povs.Auto_Tax_Calc_Flag,'Y'),'N','N','Y') Auto_Tax_Calc_Flag

Line 7875: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

7871: -- DESCRIPTION
7872: --
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,

Line 7876: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,

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

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

Line 7885: c_account_id ZX_REGISTRATIONS.ACCOUNT_ID%TYPE)

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

Line 8003: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

7999: --
8000: -- DESCRIPTION
8001:
8002: PROCEDURE Get_Registration_Accts(
8003: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
8004: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
8005: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
8006: p_return_status OUT NOCOPY VARCHAR2 )
8007:

Line 8011: c_account_id ZX_REGISTRATIONS.ACCOUNT_ID%TYPE)

8007:
8008: IS
8009:
8010: CURSOR c_customer_account (
8011: c_account_id ZX_REGISTRATIONS.ACCOUNT_ID%TYPE)
8012: IS
8013: SELECT
8014: tax_code,
8015: tax_header_level_flag,

Line 8185: p_account_Type_Code IN zx_registrations.account_type_code%TYPE,

8181: PROCEDURE get_rounding_level(
8182:
8183: p_parent_ptp_id IN zx_party_tax_profile.party_tax_profile_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,

Line 8186: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

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

Line 8187: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,

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