DBA Data[Home] [Help]

APPS.ZX_TPI_SERVICES_PKG dependencies on DBMS_UTILITY

Line 418: l_ptnr_exemption_indx := dbms_utility.get_hash_value

414: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_jurisdiction_id(p_ptnr_tax_line_ind) := NULL;
415: END;
416:
417: -- adding code to populate exemption details in partner calculated tax lines
418: l_ptnr_exemption_indx := dbms_utility.get_hash_value
419: (to_char(ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.transaction_id(p_ptnr_tax_line_ind))
420: ||to_char(ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.transaction_line_id(p_ptnr_tax_line_ind))
421: ||to_char(ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_provider_id(p_ptnr_tax_line_ind))
422: , 1, 8192);

Line 1196: l_tbl_index := dbms_utility.get_hash_value(to_char(p_application_id)||'$$'||p_entity_code||'$$'||p_event_class_code||'$$'||to_char(ZX_SECURITY.G_FIRST_PARTY_ORG_ID)||'$$'||p_tax_regime_code, 1, 8192);

1192: ' Tax Regime code = ' || p_tax_regime_code ||
1193: ' ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW =' || ZX_TAX_PARTNER_PKG.G_BUSINESS_FLOW);
1194: END IF;
1195:
1196: l_tbl_index := dbms_utility.get_hash_value(to_char(p_application_id)||'$$'||p_entity_code||'$$'||p_event_class_code||'$$'||to_char(ZX_SECURITY.G_FIRST_PARTY_ORG_ID)||'$$'||p_tax_regime_code, 1, 8192);
1197:
1198: IF tax_regime_tmp_tbl.exists(l_tbl_index) THEN
1199: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1200: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,