DBA Data[Home] [Help]

APPS.ZX_TCM_CONTROL_PKG dependencies on ZX_TCM_CONTROL_PKG

Line 1: PACKAGE BODY ZX_TCM_CONTROL_PKG AS

1: PACKAGE BODY ZX_TCM_CONTROL_PKG AS
2: /* $Header: zxccontrolb.pls 120.93 2011/11/08 07:02:20 ssohal ship $ */
3:
4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL NUMBER;

Line 12: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_TCM_CONTROL_PKG.';

8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_TCM_CONTROL_PKG.';
13: -- Logging Infra
14:
15: C_TAX_REGIME_CODE_DUMMY CONSTANT VARCHAR2(30) := '@#$%^&';
16: C_TAX_DUMMY CONSTANT VARCHAR2(30) := '@#$%^&';

Line 20: p_fsc_rec IN OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_FISCAL_CLASS_INFO_REC,

16: C_TAX_DUMMY CONSTANT VARCHAR2(30) := '@#$%^&';
17: C_JURISDICTION_CODE_DUMMY CONSTANT VARCHAR2(30) := '@#$%^&';
18:
19: PROCEDURE GET_FISCAL_CLASSIFICATION(
20: p_fsc_rec IN OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_FISCAL_CLASS_INFO_REC,
21: p_return_status OUT NOCOPY VARCHAR2) IS
22:
23: /* ------------------------------------------------------------------------------
24:

Line 1263: p_fsc_cat_rec IN OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_CATEGORY_CODE_INFO_REC,

1259: END GET_FISCAL_CLASSIFICATION;
1260:
1261:
1262: Procedure GET_PROD_TRX_CATE_VALUE (
1263: p_fsc_cat_rec IN OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_CATEGORY_CODE_INFO_REC,
1264: p_return_status OUT NOCOPY VARCHAR2)
1265: IS
1266:
1267: cursor c_classification_code is

Line 1550: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,

1546: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1547: p_tax IN ZX_TAXES_B.TAX%TYPE,
1548: p_jurisdiction_code IN ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE,
1549: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1550: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
1551: x_return_status OUT NOCOPY VARCHAR2,
1552: x_ret_record_level OUT NOCOPY VARCHAR2,
1553: p_getone OUT NOCOPY NUMBER);
1554:

Line 1567: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,

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,
1570: p_getone OUT NOCOPY NUMBER);
1571:

Line 1584: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,

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,
1586: x_ret_record_level OUT NOCOPY VARCHAR2,
1587: p_getone OUT NOCOPY NUMBER);
1588:

Line 1599: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,

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,
1602: p_getone OUT NOCOPY NUMBER);
1603:

Line 1613: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,

1609: ********************************************************************************/
1610: PROCEDURE Do_Get_Registration_Party
1611: (p_party_tax_profile_id IN NUMBER,
1612: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1613: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
1614: x_return_status OUT NOCOPY VARCHAR2,
1615: x_ret_record_level OUT NOCOPY VARCHAR2,
1616: p_getone OUT NOCOPY NUMBER);
1617:

Line 1635: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,

1631: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1632: p_tax IN ZX_TAXES_B.TAX%TYPE,
1633: p_jurisdiction_code IN ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE,
1634: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1635: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
1636: x_return_status OUT NOCOPY VARCHAR2,
1637: x_ret_record_level OUT NOCOPY VARCHAR2,
1638: p_getone OUT NOCOPY NUMBER)
1639: IS

Line 1756: DUMMY_REGISTRATION_REC ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC;

1752: L_TAX_REGIME_CODE ZX_REGIMES_B.TAX_REGIME_CODE%TYPE;
1753: L_TAX ZX_TAXES_B.TAX%TYPE;
1754: L_JURISDICTION_CODE ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE;
1755: L_INDEX BINARY_INTEGER;
1756: DUMMY_REGISTRATION_REC ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC;
1757:
1758: BEGIN
1759:
1760: -- Logging Infra: Setting up runtime level

Line 1966: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,

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,
1969: p_getone OUT NOCOPY NUMBER)
1970: IS

Line 2136: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,

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,
2138: x_ret_record_level OUT NOCOPY VARCHAR2,
2139: p_getone OUT NOCOPY NUMBER)
2140: IS

Line 2277: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,

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,
2280: p_getone OUT NOCOPY NUMBER)
2281: IS

Line 2389: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,

2385: ********************************************************************************/
2386: PROCEDURE Do_Get_Registration_Party
2387: (p_party_tax_profile_id IN NUMBER,
2388: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2389: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
2390: x_return_status OUT NOCOPY VARCHAR2,
2391: x_ret_record_level OUT NOCOPY VARCHAR2,
2392: p_getone OUT NOCOPY NUMBER)
2393: IS

Line 2519: p_zx_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,

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
2522:
2523: l_ptp_id NUMBER;

Line 2848: END ZX_TCM_CONTROL_PKG;

2844: -- Logging Infra: Statement level
2845:
2846: END INITIALIZE_LTE;
2847:
2848: END ZX_TCM_CONTROL_PKG;