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.82.12010000.2 2008/11/19 07:02:56 spasala 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 1232: p_fsc_cat_rec IN OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_CATEGORY_CODE_INFO_REC,

1228: END GET_FISCAL_CLASSIFICATION;
1229:
1230:
1231: Procedure GET_PROD_TRX_CATE_VALUE (
1232: p_fsc_cat_rec IN OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_CATEGORY_CODE_INFO_REC,
1233: p_return_status OUT NOCOPY VARCHAR2)
1234: IS
1235:
1236: cursor c_classification_code is

Line 1511: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,

1507: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1508: p_tax IN ZX_TAXES_B.TAX%TYPE,
1509: p_jurisdiction_code IN ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE,
1510: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1511: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
1512: x_return_status OUT NOCOPY VARCHAR2,
1513: x_ret_record_level OUT NOCOPY VARCHAR2,
1514: p_getone OUT NOCOPY NUMBER);
1515:

Line 1528: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,

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

Line 1545: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,

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,
1547: x_ret_record_level OUT NOCOPY VARCHAR2,
1548: p_getone OUT NOCOPY NUMBER);
1549:

Line 1560: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,

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

Line 1574: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,

1570: ********************************************************************************/
1571: PROCEDURE Do_Get_Registration_Party
1572: (p_party_tax_profile_id IN NUMBER,
1573: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1574: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
1575: x_return_status OUT NOCOPY VARCHAR2,
1576: x_ret_record_level OUT NOCOPY VARCHAR2,
1577: p_getone OUT NOCOPY NUMBER);
1578:

Line 1596: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,

1592: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1593: p_tax IN ZX_TAXES_B.TAX%TYPE,
1594: p_jurisdiction_code IN ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE,
1595: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1596: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
1597: x_return_status OUT NOCOPY VARCHAR2,
1598: x_ret_record_level OUT NOCOPY VARCHAR2,
1599: p_getone OUT NOCOPY NUMBER)
1600: IS

Line 1717: DUMMY_REGISTRATION_REC ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC;

1713: L_TAX_REGIME_CODE ZX_REGIMES_B.TAX_REGIME_CODE%TYPE;
1714: L_TAX ZX_TAXES_B.TAX%TYPE;
1715: L_JURISDICTION_CODE ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE;
1716: L_INDEX BINARY_INTEGER;
1717: DUMMY_REGISTRATION_REC ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC;
1718:
1719: BEGIN
1720:
1721: -- Logging Infra: Setting up runtime level

Line 1926: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,

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

Line 2080: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,

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,
2082: x_ret_record_level OUT NOCOPY VARCHAR2,
2083: p_getone OUT NOCOPY NUMBER)
2084: IS

Line 2214: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,

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

Line 2326: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,

2322: ********************************************************************************/
2323: PROCEDURE Do_Get_Registration_Party
2324: (p_party_tax_profile_id IN NUMBER,
2325: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2326: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
2327: x_return_status OUT NOCOPY VARCHAR2,
2328: x_ret_record_level OUT NOCOPY VARCHAR2,
2329: p_getone OUT NOCOPY NUMBER)
2330: IS

Line 2452: p_zx_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,

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
2455:
2456: l_ptp_id NUMBER;

Line 2781: END ZX_TCM_CONTROL_PKG;

2777: -- Logging Infra: Statement level
2778:
2779: END INITIALIZE_LTE;
2780:
2781: END ZX_TCM_CONTROL_PKG;