DBA Data[Home] [Help]

APPS.ZX_TPI_SERVICES_PKG dependencies on ZX_TRX_PRE_PROC_OPTIONS_GT

Line 1566: -- partner services. It sets attributes in ZX_TRX_PRE_PROC_OPTIONS_GT so that

1562: -- partner_pre_processing
1563: --
1564: -- DESCRIPTION
1565: -- This procedure is used to prepare the information to be passed to the tax
1566: -- partner services. It sets attributes in ZX_TRX_PRE_PROC_OPTIONS_GT so that
1567: -- partner interface views pick the correct data for the transaction and
1568: -- partner under consideration
1569: --
1570: -- CALLED BY

Line 1593: l_legal_entity_number ZX_TRX_PRE_PROC_OPTIONS_GT.legal_entity_number%type;

1589: l_return_status VARCHAR2(1);
1590: l_line_level_action VARCHAR2(30);
1591: l_context_info_rec ZX_API_PUB.context_info_rec_type;
1592: -- Bug# 4769082
1593: l_legal_entity_number ZX_TRX_PRE_PROC_OPTIONS_GT.legal_entity_number%type;
1594: l_establishment_number ZX_TRX_PRE_PROC_OPTIONS_GT.establishment_number%type; -- Bug 5139731
1595: l_application_short_name FND_APPLICATION.application_short_name%type;
1596: -- Bug# 4769082
1597: l_cnt_of_options_gt NUMBER;

Line 1594: l_establishment_number ZX_TRX_PRE_PROC_OPTIONS_GT.establishment_number%type; -- Bug 5139731

1590: l_line_level_action VARCHAR2(30);
1591: l_context_info_rec ZX_API_PUB.context_info_rec_type;
1592: -- Bug# 4769082
1593: l_legal_entity_number ZX_TRX_PRE_PROC_OPTIONS_GT.legal_entity_number%type;
1594: l_establishment_number ZX_TRX_PRE_PROC_OPTIONS_GT.establishment_number%type; -- Bug 5139731
1595: l_application_short_name FND_APPLICATION.application_short_name%type;
1596: -- Bug# 4769082
1597: l_cnt_of_options_gt NUMBER;
1598: l_hq_estb_ptp_id ZX_LINES_DET_FACTORS.hq_estb_party_tax_prof_id%type; -- Bug 5090593

Line 1641: DELETE from ZX_TRX_PRE_PROC_OPTIONS_GT;

1637: l_tax_provider_id := p_tax_provider_id;
1638:
1639: END IF;
1640:
1641: DELETE from ZX_TRX_PRE_PROC_OPTIONS_GT;
1642:
1643: --Set the context for the partner interface views
1644: IF ZX_API_PUB.G_PUB_SRVC = 'SYNCHRONIZE_TAX_REPOSITORY' THEN
1645: BEGIN

Line 1646: INSERT into ZX_TRX_PRE_PROC_OPTIONS_GT (INTERNAL_ORGANIZATION_ID,

1642:
1643: --Set the context for the partner interface views
1644: IF ZX_API_PUB.G_PUB_SRVC = 'SYNCHRONIZE_TAX_REPOSITORY' THEN
1645: BEGIN
1646: INSERT into ZX_TRX_PRE_PROC_OPTIONS_GT (INTERNAL_ORGANIZATION_ID,
1647: APPLICATION_ID,
1648: ENTITY_CODE,
1649: EVENT_CLASS_CODE,
1650: EVNT_CLS_MAPPING_ID,

Line 1688: ' SYNCHRONIZE_TAX_REPOSITORY: Exception while inserting into ZX_TRX_PRE_PROC_OPTIONS_GT');

1684: AND clsmap.event_class_code = p_event_class_rec.event_class_code;
1685: EXCEPTION WHEN OTHERS THEN
1686: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1687: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1688: ' SYNCHRONIZE_TAX_REPOSITORY: Exception while inserting into ZX_TRX_PRE_PROC_OPTIONS_GT');
1689: END IF;
1690: END;
1691: ELSE
1692: SELECT line_level_action,

Line 1769: INSERT into ZX_TRX_PRE_PROC_OPTIONS_GT (INTERNAL_ORGANIZATION_ID,

1765: END IF;
1766: -- Bug# 4769082
1767:
1768: BEGIN
1769: INSERT into ZX_TRX_PRE_PROC_OPTIONS_GT (INTERNAL_ORGANIZATION_ID,
1770: APPLICATION_ID,
1771: ENTITY_CODE,
1772: EVENT_CLASS_CODE,
1773: EVNT_CLS_MAPPING_ID,

Line 1825: ' Exception while inserting into ZX_TRX_PRE_PROC_OPTIONS_GT');

1821: fnd_global.conc_login_id);
1822: EXCEPTION WHEN OTHERS THEN
1823: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1824: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1825: ' Exception while inserting into ZX_TRX_PRE_PROC_OPTIONS_GT');
1826: END IF;
1827: END;
1828:
1829: END IF; -- API is synchronize_tax

Line 1835: FROM ZX_TRX_PRE_PROC_OPTIONS_GT;

1831: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1832: BEGIN
1833: SELECT count(*)
1834: INTO l_cnt_of_options_gt
1835: FROM ZX_TRX_PRE_PROC_OPTIONS_GT;
1836: EXCEPTION WHEN OTHERS THEN
1837: l_cnt_of_options_gt := 0;
1838: END;
1839: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 1840: 'The record is inserted in ZX_TRX_PRE_PROC_OPTIONS_GT = ' || l_cnt_of_options_gt);

1836: EXCEPTION WHEN OTHERS THEN
1837: l_cnt_of_options_gt := 0;
1838: END;
1839: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1840: 'The record is inserted in ZX_TRX_PRE_PROC_OPTIONS_GT = ' || l_cnt_of_options_gt);
1841: END IF;
1842: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1843: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
1844: G_PKG_NAME ||': '||l_api_name||'(-)'||' RETURN_STATUS = ' || x_return_status);

Line 2075: l_allow_tax_calculation_flag ZX_TRX_PRE_PROC_OPTIONS_GT.allow_tax_calculation_flag%type;

2071: l_threshold_indicator_flag VARCHAR2(1);
2072: l_partner_migrated_flag VARCHAR2(1);
2073: l_ret_record_level VARCHAR2(30);
2074: l_registration_rec ZX_TCM_CONTROL_PKG.zx_registration_info_rec;
2075: l_allow_tax_calculation_flag ZX_TRX_PRE_PROC_OPTIONS_GT.allow_tax_calculation_flag%type;
2076:
2077: --Table to derive the apportionment number in case the transaction line has same taxes
2078: TYPE tax_tbl_type is table of VARCHAR2(30) index by VARCHAR2(240);
2079: tax_tbl tax_tbl_type;

Line 2141: FROM ZX_TRX_PRE_PROC_OPTIONS_GT

2137: */
2138: BEGIN
2139: SELECT allow_tax_calculation_flag
2140: INTO l_allow_tax_calculation_flag
2141: FROM ZX_TRX_PRE_PROC_OPTIONS_GT
2142: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID
2143: AND ENTITY_CODE = p_event_class_rec.ENTITY_CODE
2144: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE
2145: AND TRX_ID = p_event_class_rec.TRX_ID;