DBA Data[Home] [Help]

APPS.ZX_TCM_CONTROL_PKG dependencies on ZX_REGISTRATIONS

Line 1525: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

1521: *******************************************************************************/
1522:
1523: PROCEDURE Do_Get_Sup_Site
1524: (p_party_tax_profile_id IN NUMBER,
1525: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
1526: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
1527: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1528: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
1529: x_return_status OUT NOCOPY VARCHAR2,

Line 1526: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,

1522:
1523: PROCEDURE Do_Get_Sup_Site
1524: (p_party_tax_profile_id IN NUMBER,
1525: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
1526: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
1527: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1528: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
1529: x_return_status OUT NOCOPY VARCHAR2,
1530: x_ret_record_level OUT NOCOPY VARCHAR2,

Line 1541: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

1537: * *
1538: ********************************************************************************/
1539: PROCEDURE Do_Get_Reg_Site_Uses
1540: (p_party_tax_profile_id IN NUMBER,
1541: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
1542: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
1543: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,
1544: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1545: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,

Line 1542: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,

1538: ********************************************************************************/
1539: PROCEDURE Do_Get_Reg_Site_Uses
1540: (p_party_tax_profile_id IN NUMBER,
1541: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
1542: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
1543: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,
1544: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1545: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
1546: x_return_status OUT NOCOPY VARCHAR2,

Line 1558: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

1554: * *
1555: ********************************************************************************/
1556: PROCEDURE Do_Get_Registration_Accts
1557: (p_party_tax_profile_id IN NUMBER,
1558: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
1559: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1560: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
1561: x_return_status OUT NOCOPY VARCHAR2,
1562: x_ret_record_level OUT NOCOPY VARCHAR2,

Line 1696: FROM zx_registrations reg,

1692: ptp.allow_offset_tax_flag,
1693: ptp.effective_from_use_le,
1694: ptp.party_id,
1695: ptp.rep_registration_number
1696: FROM zx_registrations reg,
1697: zx_party_tax_profile ptp
1698: WHERE reg.party_tax_profile_id = c_party_tax_profile_id
1699: AND reg.party_tax_profile_id = ptp.party_tax_profile_id
1700: AND nvl(reg.tax_regime_code,1) = nvl(c_tax_regime_code,1)

Line 1923: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

1919: * *
1920: *******************************************************************************/
1921: PROCEDURE Do_Get_Sup_Site
1922: (p_party_tax_profile_id IN NUMBER,
1923: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
1924: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
1925: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1926: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
1927: x_return_status OUT NOCOPY VARCHAR2,

Line 1924: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,

1920: *******************************************************************************/
1921: PROCEDURE Do_Get_Sup_Site
1922: (p_party_tax_profile_id IN NUMBER,
1923: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
1924: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
1925: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1926: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
1927: x_return_status OUT NOCOPY VARCHAR2,
1928: x_ret_record_level OUT NOCOPY VARCHAR2,

Line 2076: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

2072: * *
2073: ********************************************************************************/
2074: PROCEDURE Do_Get_Reg_Site_Uses
2075: (p_party_tax_profile_id IN NUMBER,
2076: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
2077: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
2078: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,
2079: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2080: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,

Line 2077: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,

2073: ********************************************************************************/
2074: PROCEDURE Do_Get_Reg_Site_Uses
2075: (p_party_tax_profile_id IN NUMBER,
2076: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
2077: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
2078: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,
2079: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2080: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
2081: x_return_status OUT NOCOPY VARCHAR2,

Line 2212: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

2208: * *
2209: ********************************************************************************/
2210: PROCEDURE Do_Get_Registration_Accts
2211: (p_party_tax_profile_id IN NUMBER,
2212: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
2213: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2214: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
2215: x_return_status OUT NOCOPY VARCHAR2,
2216: x_ret_record_level OUT NOCOPY VARCHAR2,

Line 2444: p_account_Type_Code IN zx_registrations.account_type_code%TYPE,

2440:
2441: Procedure Get_Tax_Registration(
2442: p_parent_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
2443: p_site_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
2444: p_account_Type_Code IN zx_registrations.account_type_code%TYPE,
2445: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2446: p_tax IN ZX_TAXES_B.TAX%TYPE,
2447: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2448: p_jurisdiction_code IN ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE,

Line 2449: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

2445: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2446: p_tax IN ZX_TAXES_B.TAX%TYPE,
2447: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2448: p_jurisdiction_code IN ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE,
2449: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
2450: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
2451: p_site_use_id IN HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE,
2452: p_zx_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
2453: p_ret_record_level OUT NOCOPY VARCHAR2,

Line 2450: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,

2446: p_tax IN ZX_TAXES_B.TAX%TYPE,
2447: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2448: p_jurisdiction_code IN ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE,
2449: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
2450: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
2451: p_site_use_id IN HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE,
2452: p_zx_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
2453: p_ret_record_level OUT NOCOPY VARCHAR2,
2454: p_return_status OUT NOCOPY VARCHAR2) IS