DBA Data[Home] [Help]

APPS.ZX_TCM_CONTROL_PKG dependencies on ZX_REGISTRATIONS

Line 1564: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

1560: *******************************************************************************/
1561:
1562: PROCEDURE Do_Get_Sup_Site
1563: (p_party_tax_profile_id IN NUMBER,
1564: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
1565: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
1566: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1567: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
1568: x_return_status OUT NOCOPY VARCHAR2,

Line 1565: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,

1561:
1562: PROCEDURE Do_Get_Sup_Site
1563: (p_party_tax_profile_id IN NUMBER,
1564: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
1565: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
1566: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1567: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
1568: x_return_status OUT NOCOPY VARCHAR2,
1569: x_ret_record_level OUT NOCOPY VARCHAR2,

Line 1580: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

1576: * *
1577: ********************************************************************************/
1578: PROCEDURE Do_Get_Reg_Site_Uses
1579: (p_party_tax_profile_id IN NUMBER,
1580: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
1581: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
1582: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,
1583: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1584: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,

Line 1581: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,

1577: ********************************************************************************/
1578: PROCEDURE Do_Get_Reg_Site_Uses
1579: (p_party_tax_profile_id IN NUMBER,
1580: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
1581: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
1582: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,
1583: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1584: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
1585: x_return_status OUT NOCOPY VARCHAR2,

Line 1597: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

1593: * *
1594: ********************************************************************************/
1595: PROCEDURE Do_Get_Registration_Accts
1596: (p_party_tax_profile_id IN NUMBER,
1597: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
1598: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1599: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
1600: x_return_status OUT NOCOPY VARCHAR2,
1601: x_ret_record_level OUT NOCOPY VARCHAR2,

Line 1735: FROM zx_registrations reg,

1731: ptp.allow_offset_tax_flag,
1732: ptp.effective_from_use_le,
1733: ptp.party_id,
1734: ptp.rep_registration_number
1735: FROM zx_registrations reg,
1736: zx_party_tax_profile ptp
1737: WHERE reg.party_tax_profile_id = c_party_tax_profile_id
1738: AND reg.party_tax_profile_id = ptp.party_tax_profile_id
1739: AND nvl(reg.tax_regime_code,1) = nvl(c_tax_regime_code,1)

Line 1963: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

1959: * *
1960: *******************************************************************************/
1961: PROCEDURE Do_Get_Sup_Site
1962: (p_party_tax_profile_id IN NUMBER,
1963: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
1964: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
1965: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1966: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
1967: x_return_status OUT NOCOPY VARCHAR2,

Line 1964: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,

1960: *******************************************************************************/
1961: PROCEDURE Do_Get_Sup_Site
1962: (p_party_tax_profile_id IN NUMBER,
1963: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
1964: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
1965: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1966: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
1967: x_return_status OUT NOCOPY VARCHAR2,
1968: x_ret_record_level OUT NOCOPY VARCHAR2,

Line 2132: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

2128: * *
2129: ********************************************************************************/
2130: PROCEDURE Do_Get_Reg_Site_Uses
2131: (p_party_tax_profile_id IN NUMBER,
2132: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
2133: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
2134: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,
2135: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2136: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,

Line 2133: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,

2129: ********************************************************************************/
2130: PROCEDURE Do_Get_Reg_Site_Uses
2131: (p_party_tax_profile_id IN NUMBER,
2132: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
2133: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
2134: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,
2135: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2136: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
2137: x_return_status OUT NOCOPY VARCHAR2,

Line 2275: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

2271: * *
2272: ********************************************************************************/
2273: PROCEDURE Do_Get_Registration_Accts
2274: (p_party_tax_profile_id IN NUMBER,
2275: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
2276: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2277: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
2278: x_return_status OUT NOCOPY VARCHAR2,
2279: x_ret_record_level OUT NOCOPY VARCHAR2,

Line 2511: p_account_Type_Code IN zx_registrations.account_type_code%TYPE,

2507:
2508: Procedure Get_Tax_Registration(
2509: p_parent_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
2510: p_site_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
2511: p_account_Type_Code IN zx_registrations.account_type_code%TYPE,
2512: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2513: p_tax IN ZX_TAXES_B.TAX%TYPE,
2514: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2515: p_jurisdiction_code IN ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE,

Line 2516: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

2512: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2513: p_tax IN ZX_TAXES_B.TAX%TYPE,
2514: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2515: p_jurisdiction_code IN ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE,
2516: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
2517: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
2518: p_site_use_id IN HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE,
2519: p_zx_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
2520: p_ret_record_level OUT NOCOPY VARCHAR2,

Line 2517: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,

2513: p_tax IN ZX_TAXES_B.TAX%TYPE,
2514: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2515: p_jurisdiction_code IN ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE,
2516: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
2517: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
2518: p_site_use_id IN HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE,
2519: p_zx_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
2520: p_ret_record_level OUT NOCOPY VARCHAR2,
2521: p_return_status OUT NOCOPY VARCHAR2) IS