APPS.ZX_TCM_GEO_JUR_PKG dependencies on HZ_GEOGRAPHIES

Line 689: FROM hz_geographies

685:
686: IF l_limited_by_geography_id IS NOT NULL THEN
687: SELECT country_code
688: INTO l_zone_type_country_code
689: FROM hz_geographies
690: WHERE geography_id = l_limited_by_geography_id;
691: END IF;
692:
693: IF l_limited_by_geography_id IS NULL OR

Line 1257: l_geography_use hz_geographies.geography_use%type;

1253: l_procedure_name CONSTANT VARCHAR2(30) := 'get_master_geography';
1254: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1255:
1256: l_location_info_rec ZX_GLOBAL_STRUCTURES_PKG.loc_info_rec_type;
1257: l_geography_use hz_geographies.geography_use%type;
1258: l_tbl_index binary_integer;
1259: l_tbl_country_index binary_integer;
1260:
1261: BEGIN

Line 1340: FROM hz_geo_name_references gnr, hz_geographies geo

1336:
1337: BEGIN
1338: SELECT gnr.geography_id, geo.geography_code, geo.geography_name, geo.geography_use
1339: INTO x_geography_id, x_geography_code, x_geography_name, l_geography_use
1340: FROM hz_geo_name_references gnr, hz_geographies geo
1341: WHERE gnr.location_table_name = x_location_table_name
1342: AND gnr.location_id = p_location_id
1343: AND gnr.geography_type = p_geography_type
1344: AND geo.geography_id = gnr.geography_id;

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

1375: l_country_code := l_location_info_rec.country_code;
1376:
1377: -- Logging Infra: "B" means "B"reak point
1378: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1379: l_log_msg := 'B: SEL hz_geographies: in: l_country_code='||l_country_code;
1380: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1381: END IF;
1382:
1383: BEGIN

Line 1386: FROM hz_geographies

1382:
1383: BEGIN
1384: SELECT geography_id, geography_code, geography_name
1385: INTO x_geography_id, x_geography_code, x_geography_name
1386: FROM hz_geographies
1387: WHERE geography_code = l_country_code
1388: AND geography_type = 'COUNTRY';
1389:
1390: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 1393: l_log_msg := 'E: SEL hz_geographies: no_data_found: '||'l_country_code='||l_country_code;

1389:
1390: EXCEPTION WHEN NO_DATA_FOUND THEN
1391:
1392: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1393: l_log_msg := 'E: SEL hz_geographies: no_data_found: '||'l_country_code='||l_country_code;
1394: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1395: END IF;
1396:
1397: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1620: FROM hz_geo_name_references gnr, hz_geographies g

1616: BEGIN
1617: l_error_flag := 'N';
1618: SELECT gnr.geography_id, gnr.geography_type, g.geography_name
1619: BULK COLLECT INTO l_geography_id, l_geography_type, l_geography_name
1620: FROM hz_geo_name_references gnr, hz_geographies g
1621: WHERE location_table_name = x_loc_tbl
1622: AND location_id = location_id_tbl(i)
1623: AND gnr.geography_id = g.geography_id
1624: ORDER BY gnr.geography_id;