DBA Data[Home] [Help]

APPS.ZX_TCM_EXT_SERVICES_PUB dependencies on DBMS_UTILITY

Line 459: l_index := dbms_utility.get_hash_value(

455: x_found_in_cache => l_found_in_cache,
456: x_return_status => l_return_status,
457: x_error_buffer => l_error_buffer); */
458:
459: l_index := dbms_utility.get_hash_value(
460: p_org_id||p_item_id||p_fiscal_type_code,
461: 1,
462: 8192);
463:

Line 710: l_index := dbms_utility.get_hash_value(

706:
707: ELSIF p_fiscal_type_code ='PRODUCT_TYPE' then
708:
709: -- try to locate in cache first.
710: l_index := dbms_utility.get_hash_value(
711: p_org_id||p_item_id||p_fiscal_type_code,
712: 1,
713: 8192);
714:

Line 1591: l_index := dbms_utility.get_hash_value(

1587: 'ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info(+)');
1588: END IF;
1589:
1590:
1591: l_index := dbms_utility.get_hash_value(
1592: p_country_code||p_classification_type,
1593: 1,
1594: 8192);
1595: --

Line 1636: l_tbl_index := dbms_utility.get_hash_value(

1632: l_tbl_index binary_integer;
1633: BEGIN
1634:
1635: -- set the value in cache
1636: l_tbl_index := dbms_utility.get_hash_value(
1637: p_country_code||p_classification_type,
1638: 1,
1639: 8192);
1640:

Line 1652: l_country_index := dbms_utility.get_hash_value(P_COUNTRY_CODE, 1, 8192);

1648: RETURN BOOLEAN is
1649: l_country_index binary_integer;
1650: l_territory_code fnd_territories.territory_code%type;
1651: BEGIN
1652: l_country_index := dbms_utility.get_hash_value(P_COUNTRY_CODE, 1, 8192);
1653: IF ZX_GLOBAL_STRUCTURES_PKG.G_TERRITORY_TBL.exists(l_country_index) then
1654: RETURN TRUE;
1655: ELSE
1656: BEGIN