DBA Data[Home] [Help]

APPS.ZX_TPI_SERVICES_PKG dependencies on ZX_API_PUB

Line 53: l_context_info_rec ZX_API_PUB.context_info_rec_type;

49: x_migrated_country_code OUT NOCOPY VARCHAR2,
50: x_return_status OUT NOCOPY VARCHAR2
51: ) IS
52: l_api_name CONSTANT VARCHAR2(30) := 'GET_MIGRATED_DOC_INFO';
53: l_context_info_rec ZX_API_PUB.context_info_rec_type;
54: BEGIN
55: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
56: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
57: END IF;

Line 63: IF ZX_API_PUB.G_PUB_SRVC in ('CALCULATE_TAX','IMPORT_DOCUMENT_WITH_TAX') THEN

59: /*Set the return status to Success */
60: x_return_status := FND_API.G_RET_STS_SUCCESS;
61:
62:
63: IF ZX_API_PUB.G_PUB_SRVC in ('CALCULATE_TAX','IMPORT_DOCUMENT_WITH_TAX') THEN
64:
65: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index) is not NULL THEN
66: BEGIN --- bug6024643
67: SELECT tax_provider_id,

Line 148: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,

144: -- CALLED BY
145: -- popl_pvrdr_info_tax_reg_tbl
146: -----------------------------------------------------------------------
147: PROCEDURE popl_all_regimes_tbl (
148: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
149: p_trx_line_id IN NUMBER,
150: p_trx_level_type IN VARCHAR2,
151: p_tax_regime_id IN NUMBER,
152: p_tax_regime_code IN VARCHAR2,

Line 208: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,

204: -- CALLED BY
205: -- ptnr_post_processing_calc_tax
206: -----------------------------------------------------------------------
207: PROCEDURE set_detail_tax_line_values (
208: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
209: p_ptnr_tax_line_ind IN NUMBER,
210: p_tax_provider_id IN NUMBER,
211: x_return_status OUT NOCOPY VARCHAR2
212: ) IS

Line 525: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,

521: -- CALLED BY
522: -----------------------------------------------------------------------
523: /*****************TBD*************************************************
524: PROCEDURE exemption_handling (
525: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
526: p_trx_line_id IN NUMBER,
527: p_trx_level_type IN VARCHAR2,
528: p_tax_regime_id IN NUMBER,
529: p_tax_regime_code IN VARCHAR2,

Line 617: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,

613: -----------------------------------------------------------------------
614:
615:
616: PROCEDURE trx_line_app_regimes_tbl_hdl(
617: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
618: p_event IN VARCHAR2,
619: p_tax_regime_code IN VARCHAR2,
620: p_provider_id IN NUMBER,
621: p_trx_line_id IN NUMBER,

Line 627: l_context_info_rec ZX_API_PUB.context_info_rec_type;

623: x_return_status OUT NOCOPY VARCHAR2
624: )IS
625: l_api_name CONSTANT VARCHAR2(30):= 'TRX_LINE_APP_REGIMES_TBL_HDL';
626: l_dummy NUMBER;
627: l_context_info_rec ZX_API_PUB.context_info_rec_type;
628:
629: BEGIN
630: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
631: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

Line 772: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,

768: -----------------------------------------------------------------------
769:
770:
771: PROCEDURE popl_pvrdr_info_tax_reg_tbl (
772: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
773: p_trx_line_index IN BINARY_INTEGER,
774: x_return_status OUT NOCOPY VARCHAR2
775: ) IS
776: l_api_name CONSTANT VARCHAR2(30) := 'POPL_PVRDR_INFO_TAX_REG_TBL';

Line 787: l_context_info_rec ZX_API_PUB.context_info_rec_type;

783: l_migrated_effective_to DATE;
784: l_return_status VARCHAR2(1);
785: l_tax_regime_id NUMBER;
786: l_migrated_country_code ZX_REGIMES_B.country_code%TYPE;
787: l_context_info_rec ZX_API_PUB.context_info_rec_type;
788:
789: /* Bug 5557565 */
790:
791: CURSOR app_doc_regime_csr(l_index NUMBER) IS

Line 1175: -- l_context_info_rec ZX_API_PUB.context_info_rec_type;

1171: ) IS
1172:
1173: l_api_name CONSTANT VARCHAR2(30) := 'GET_SERVICE_PROVIDER';
1174: l_provider_name VARCHAR2(50);
1175: -- l_context_info_rec ZX_API_PUB.context_info_rec_type;
1176: l_tbl_index BINARY_INTEGER;
1177:
1178: BEGIN
1179: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1291: l_context_info_rec ZX_API_PUB.context_info_rec_type;

1287: x_return_status OUT NOCOPY VARCHAR2
1288: ) IS
1289:
1290: l_api_name CONSTANT VARCHAR2(30) := 'GET_SERVICE_PROVIDER';
1291: l_context_info_rec ZX_API_PUB.context_info_rec_type;
1292: l_product_family VARCHAR2(30);
1293: l_provider_name VARCHAR2(50);
1294:
1295: BEGIN

Line 1368: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,

1364: -- ZX_SRVC_TYPS_PKG.partner_inclusive_tax_override
1365: -----------------------------------------------------------------------
1366:
1367: PROCEDURE derive_ext_attrs (
1368: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
1369: p_tax_regime_code IN VARCHAR2,
1370: p_provider_id IN NUMBER,
1371: p_service_type_code IN VARCHAR2,
1372: x_return_status OUT NOCOPY VARCHAR2

Line 1375: l_context_info_rec ZX_API_PUB.context_info_rec_type;

1371: p_service_type_code IN VARCHAR2,
1372: x_return_status OUT NOCOPY VARCHAR2
1373: ) IS
1374: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_EXT_ATTRS';
1375: l_context_info_rec ZX_API_PUB.context_info_rec_type;
1376: l_regime_index NUMBER;
1377: l_service_type_id NUMBER;
1378: l_context_ccid NUMBER;
1379: l_data_transfer_mode VARCHAR2(30);

Line 1395: IF p_service_type_code = 'DERIVE_LINE_ATTRS' AND ZX_API_PUB.G_PUB_SRVC = 'DISCARD_TAX_ONLY_LINES' THEN

1391: --Set the global variables
1392: ZX_TAX_PARTNER_PKG.G_TAX_REGIME_CODE := p_tax_regime_code;
1393: ZX_TAX_PARTNER_PKG.G_EVENT_CLASS_REC := p_event_class_rec;
1394:
1395: IF p_service_type_code = 'DERIVE_LINE_ATTRS' AND ZX_API_PUB.G_PUB_SRVC = 'DISCARD_TAX_ONLY_LINES' THEN
1396: null;
1397: ELSE
1398: BEGIN
1399: l_user_extns := TRUE;

Line 1425: -- ZX_USER_EXT_PKG.G_EXT_ATTRS_INPUT_REC.transaction_service_type := ZX_API_PUB.G_PUB_SRVC;

1421: IF l_user_extns THEN
1422: --Populate the global attributes
1423: -- ZX_USER_EXT_PKG.G_EXT_ATTRS_INPUT_REC.business_flow := p_event_class_rec.prod_family_grp_code;
1424: -- ZX_USER_EXT_PKG.G_EXT_ATTRS_INPUT_REC.country_code := p_tax_regime_code;
1425: -- ZX_USER_EXT_PKG.G_EXT_ATTRS_INPUT_REC.transaction_service_type := ZX_API_PUB.G_PUB_SRVC;
1426: -- ZX_USER_EXT_PKG.G_EXT_ATTRS_INPUT_REC.derivation_level := p_service_type_code;
1427: -- ZX_USER_EXT_PKG.G_EXT_ATTRS_INPUT_REC.transaction_id := p_event_class_rec.trx_id;
1428: -- ZX_USER_EXT_PKG.G_EXT_ATTRS_INPUT_REC.event_id := p_event_class_rec.event_id;
1429:

Line 1460: ZX_API_PUB.add_msg(p_context_info_rec => ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

1456: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1457: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
1458: END IF;
1459: FND_MESSAGE.SET_NAME('ZX','ZX_PTNR_SERVICE_REQD');
1460: ZX_API_PUB.add_msg(p_context_info_rec => ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1461: RETURN;
1462: END;
1463: END IF;--no user extensible procedures defined
1464:

Line 1583: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,

1579: p_tax_regime_id IN NUMBER,
1580: p_tax_regime_code IN VARCHAR2,
1581: p_tax_provider_id IN NUMBER,
1582: p_ptnr_processing_flag IN VARCHAR2,
1583: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
1584: x_return_status OUT NOCOPY VARCHAR2
1585: ) IS
1586:
1587: l_api_name CONSTANT VARCHAR2(30) := 'PARTNER_PRE_PROCESSING';

Line 1591: l_context_info_rec ZX_API_PUB.context_info_rec_type;

1587: l_api_name CONSTANT VARCHAR2(30) := 'PARTNER_PRE_PROCESSING';
1588: l_provider_found NUMBER;
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;

Line 1644: IF ZX_API_PUB.G_PUB_SRVC = 'SYNCHRONIZE_TAX_REPOSITORY' THEN

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
1646: INSERT into ZX_TRX_PRE_PROC_OPTIONS_GT (INTERNAL_ORGANIZATION_ID,
1647: APPLICATION_ID,
1648: ENTITY_CODE,

Line 1882: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,

1878: PROCEDURE call_partner_service(
1879: p_tax_regime_code IN VARCHAR2,
1880: p_tax_provider_id IN NUMBER,
1881: p_service_type_code IN VARCHAR2,
1882: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
1883: x_return_status OUT NOCOPY VARCHAR2
1884: ) IS
1885:
1886: l_api_name CONSTANT VARCHAR2(30) := 'CALL_PARTNER_SERVICE';

Line 1887: l_context_info_rec ZX_API_PUB.context_info_rec_type;

1883: x_return_status OUT NOCOPY VARCHAR2
1884: ) IS
1885:
1886: l_api_name CONSTANT VARCHAR2(30) := 'CALL_PARTNER_SERVICE';
1887: l_context_info_rec ZX_API_PUB.context_info_rec_type;
1888: l_service_type_id NUMBER;
1889: l_context_ccid NUMBER;
1890: l_return_status VARCHAR2(1);
1891: l_counter NUMBER;

Line 1982: ' ZX_API_PUB.G_PUB_SRVC ' || ZX_API_PUB.G_PUB_SRVC ||

1978: --Populate trx_rec
1979: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1980: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1981: ' p_event_class_rec.event_class_mapping_id ' || p_event_class_rec.event_class_mapping_id ||
1982: ' ZX_API_PUB.G_PUB_SRVC ' || ZX_API_PUB.G_PUB_SRVC ||
1983: ' p_event_class_rec.event_type_code ' || p_event_class_rec.event_type_code ||
1984: ' p_event_class_rec.tax_event_type_code ' || p_event_class_rec.tax_event_type_code);
1985: END IF;
1986:

Line 1989: IF ZX_API_PUB.G_PUB_SRVC = 'CALCULATE_TAX' THEN --called for partner processing flag = 'N'

1985: END IF;
1986:
1987: ZX_PTNR_SRVC_INTGRTN_PKG.G_TRX_REC.document_type_id := p_event_class_rec.event_class_mapping_id;
1988: ZX_PTNR_SRVC_INTGRTN_PKG.G_TRX_REC.transaction_id := p_event_class_rec.trx_id;
1989: IF ZX_API_PUB.G_PUB_SRVC = 'CALCULATE_TAX' THEN --called for partner processing flag = 'N'
1990: ZX_PTNR_SRVC_INTGRTN_PKG.G_TRX_REC.document_level_action := 'DELETE';
1991: ELSE
1992: ZX_PTNR_SRVC_INTGRTN_PKG.G_TRX_REC.document_level_action := p_event_class_rec.event_type_code;
1993: END IF;

Line 2025: ZX_API_PUB.add_msg( p_context_info_rec =>l_context_info_rec );

2021: l_context_info_rec.APPLICATION_ID := p_event_class_rec.application_id;
2022: l_context_info_rec.ENTITY_CODE := p_event_class_rec.entity_code;
2023: l_context_info_rec.EVENT_CLASS_CODE := p_event_class_rec.event_class_code;
2024: l_context_info_rec.TRX_ID := p_event_class_rec.trx_id;
2025: ZX_API_PUB.add_msg( p_context_info_rec =>l_context_info_rec );
2026: WHEN OTHERS THEN
2027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2028: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
2029: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);

Line 2052: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,

2048:
2049: PROCEDURE ptnr_post_processing_calc_tax(
2050: p_tax_regime_code IN VARCHAR2,
2051: p_tax_provider_id IN NUMBER,
2052: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
2053: x_return_status OUT NOCOPY VARCHAR2
2054: ) IS
2055: l_api_name CONSTANT VARCHAR2(30) := 'PTNR_POST_PROCESSING_CALC_TAX';
2056: l_context_info_rec ZX_API_PUB.context_info_rec_type;

Line 2056: l_context_info_rec ZX_API_PUB.context_info_rec_type;

2052: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
2053: x_return_status OUT NOCOPY VARCHAR2
2054: ) IS
2055: l_api_name CONSTANT VARCHAR2(30) := 'PTNR_POST_PROCESSING_CALC_TAX';
2056: l_context_info_rec ZX_API_PUB.context_info_rec_type;
2057: l_app_regimes NUMBER;
2058: l_tax_found NUMBER;
2059: l_tax_index VARCHAR2(100);
2060: l_prepay_tax_rate NUMBER;

Line 2177: IF ZX_API_PUB.G_PUB_SRVC = 'IMPORT_DOCUMENT_WITH_TAX' THEN

2173: RETURN;
2174: END IF;
2175:
2176: --Point 3A in DLD
2177: IF ZX_API_PUB.G_PUB_SRVC = 'IMPORT_DOCUMENT_WITH_TAX' THEN
2178: IF p_event_class_rec.record_for_partners_flag = 'Y' THEN
2179: IF p_event_class_rec.process_for_applicability_flag = 'N' THEN
2180: l_sync_with_prvdr_flag := 'Y';
2181: l_delete_flag := 'Y';

Line 2844: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,

2840:
2841: PROCEDURE ptnr_post_proc_sync_tax(
2842: p_tax_regime_code IN VARCHAR2,
2843: p_tax_provider_id IN NUMBER,
2844: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
2845: x_return_status OUT NOCOPY VARCHAR2
2846: ) IS
2847:
2848: l_api_name CONSTANT VARCHAR2(30) := 'PTNR_POST_PROC_SYNC_TAX';

Line 2849: l_context_info_rec ZX_API_PUB.context_info_rec_type;

2845: x_return_status OUT NOCOPY VARCHAR2
2846: ) IS
2847:
2848: l_api_name CONSTANT VARCHAR2(30) := 'PTNR_POST_PROC_SYNC_TAX';
2849: l_context_info_rec ZX_API_PUB.context_info_rec_type;
2850: l_last_manual_entry zx_lines.last_manual_entry%type;
2851: l_tax_line_id zx_lines.tax_line_id%type; -- Bug 4908196
2852: l_return_status VARCHAR2(1);
2853:

Line 2867: IF ZX_API_PUB.G_PUB_SRVC = 'OVERRIDE_TAX' THEN

2863: If partner needs to return more than one tax line of the same tax, the tax line with different situs will be sent. */
2864:
2865: FOR i IN nvl(ZX_PTNR_SRVC_INTGRTN_PKG.g_sync_tax_lines_tbl.FIRST,0) .. nvl(ZX_PTNR_SRVC_INTGRTN_PKG.g_sync_tax_lines_tbl.LAST,-1)
2866: LOOP
2867: IF ZX_API_PUB.G_PUB_SRVC = 'OVERRIDE_TAX' THEN
2868: SELECT tax.last_manual_entry
2869: , tax.tax_line_id
2870: INTO l_last_manual_entry
2871: , l_tax_line_id