APPS.ZX_TCM_GEO_JUR_PKG dependencies on HZ_GEOGRAPHIES

Line 700: FROM hz_geographies

696:
697: IF l_limited_by_geography_id IS NOT NULL THEN
698: SELECT country_code
699: INTO l_zone_type_country_code
700: FROM hz_geographies
701: WHERE geography_id = l_limited_by_geography_id;
702: END IF;
703:
704: IF l_limited_by_geography_id IS NULL OR

Line 1464: l_geography_use hz_geographies.geography_use%type;

1460: l_procedure_name CONSTANT VARCHAR2(30) := 'get_master_geography';
1461: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1462:
1463: l_location_info_rec ZX_GLOBAL_STRUCTURES_PKG.loc_info_rec_type;
1464: l_geography_use hz_geographies.geography_use%type;
1465: l_tbl_index binary_integer;
1466: l_tbl_country_index binary_integer;
1467:
1468: BEGIN

Line 1547: FROM hz_geo_name_references gnr, hz_geographies geo

1543:
1544: BEGIN
1545: SELECT gnr.geography_id, geo.geography_code, geo.geography_name, geo.geography_use
1546: INTO x_geography_id, x_geography_code, x_geography_name, l_geography_use
1547: FROM hz_geo_name_references gnr, hz_geographies geo
1548: WHERE gnr.location_table_name = x_location_table_name
1549: AND gnr.location_id = p_location_id
1550: AND gnr.geography_type = p_geography_type
1551: AND geo.geography_id = gnr.geography_id;

Line 1586: l_log_msg := 'B: SEL hz_geographies: in: l_country_code='||l_country_code;

1582: l_country_code := l_location_info_rec.country_code;
1583:
1584: -- Logging Infra: "B" means "B"reak point
1585: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1586: l_log_msg := 'B: SEL hz_geographies: in: l_country_code='||l_country_code;
1587: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1588: END IF;
1589:
1590: BEGIN

Line 1593: FROM hz_geographies

1589:
1590: BEGIN
1591: SELECT geography_id, geography_code, geography_name
1592: INTO x_geography_id, x_geography_code, x_geography_name
1593: FROM hz_geographies
1594: WHERE geography_code = l_country_code
1595: AND geography_type = 'COUNTRY';
1596:
1597: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 1600: l_log_msg := 'E: SEL hz_geographies: no_data_found: '||'l_country_code='

1596:
1597: EXCEPTION WHEN NO_DATA_FOUND THEN
1598:
1599: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1600: l_log_msg := 'E: SEL hz_geographies: no_data_found: '||'l_country_code='
1601: ||l_country_code||' for location '||p_location_id
1602: ||' and table '||x_location_table_name;
1603: FND_LOG.STRING(G_LEVEL_STATEMENT,
1604: G_MODULE_NAME || l_procedure_name,

Line 1831: FROM hz_geo_name_references gnr, hz_geographies g

1827: BEGIN
1828: l_error_flag := 'N';
1829: SELECT gnr.geography_id, gnr.geography_type, g.geography_name
1830: BULK COLLECT INTO l_geography_id, l_geography_type, l_geography_name
1831: FROM hz_geo_name_references gnr, hz_geographies g
1832: WHERE location_table_name = x_loc_tbl
1833: AND location_id = location_id_tbl(i)
1834: AND gnr.geography_id = g.geography_id
1835: ORDER BY gnr.geography_id;