APPS.ZX_TCM_GEO_JUR_PKG dependencies on HZ_GEOGRAPHY_TYPES_B

Line 601: FROM hz_geography_types_b

597: CURSOR C_GEOGRAPHY_TYPES (c_geography_type in VARCHAR2) IS
598: SELECT geography_type,
599: geography_use,
600: limited_by_geography_id
601: FROM hz_geography_types_b
602: WHERE geography_type = c_geography_type;
603:
604:
605: x_location_table_name VARCHAR2(30);

Line 623: l_geography_type hz_geography_types_b.geography_type%TYPE;

619: x_msg_data VARCHAR2(2000);
620: l_location_info_rec ZX_GLOBAL_STRUCTURES_PKG.loc_info_rec_type;
621:
622: l_geography_type_index BINARY_INTEGER;
623: l_geography_type hz_geography_types_b.geography_type%TYPE;
624: l_geography_use hz_geography_types_b.geography_use%TYPE;
625: l_limited_by_geography_id hz_geography_types_b.limited_by_geography_id%TYPE;
626:
627: l_tbl_index BINARY_INTEGER;

Line 624: l_geography_use hz_geography_types_b.geography_use%TYPE;

620: l_location_info_rec ZX_GLOBAL_STRUCTURES_PKG.loc_info_rec_type;
621:
622: l_geography_type_index BINARY_INTEGER;
623: l_geography_type hz_geography_types_b.geography_type%TYPE;
624: l_geography_use hz_geography_types_b.geography_use%TYPE;
625: l_limited_by_geography_id hz_geography_types_b.limited_by_geography_id%TYPE;
626:
627: l_tbl_index BINARY_INTEGER;
628: BEGIN

Line 625: l_limited_by_geography_id hz_geography_types_b.limited_by_geography_id%TYPE;

621:
622: l_geography_type_index BINARY_INTEGER;
623: l_geography_type hz_geography_types_b.geography_type%TYPE;
624: l_geography_use hz_geography_types_b.geography_use%TYPE;
625: l_limited_by_geography_id hz_geography_types_b.limited_by_geography_id%TYPE;
626:
627: l_tbl_index BINARY_INTEGER;
628: BEGIN
629: -- Logging Infra: Setting up runtime level

Line 1032: FROM hz_geography_types_b gt

1028: SELECT geography_type, geography_use, geography_type_num
1029: BULK COLLECT INTO l_geography_type, l_geography_use, l_geography_type_num
1030: FROM
1031: (SELECT gt.geography_type geography_type, gt.geography_use geography_use, 1 geography_type_num
1032: FROM hz_geography_types_b gt
1033: WHERE l_tax_rec.zone_geography_type = gt.geography_type
1034: UNION
1035: SELECT gt.geography_type geography_type, gt.geography_use geography_use, 2 geography_type_num
1036: FROM hz_geography_types_b gt

Line 1036: FROM hz_geography_types_b gt

1032: FROM hz_geography_types_b gt
1033: WHERE l_tax_rec.zone_geography_type = gt.geography_type
1034: UNION
1035: SELECT gt.geography_type geography_type, gt.geography_use geography_use, 2 geography_type_num
1036: FROM hz_geography_types_b gt
1037: WHERE l_tax_rec.override_geography_type = gt.geography_type
1038: UNION
1039: SELECT rt.object_type geography_type,
1040: gt.geography_use geography_use,

Line 1043: hz_geography_types_b gt

1039: SELECT rt.object_type geography_type,
1040: gt.geography_use geography_use,
1041: 2+rownum geography_type_num
1042: FROM hz_relationship_types rt,
1043: hz_geography_types_b gt
1044: WHERE l_tax_rec.override_geography_type = rt.subject_type
1045: AND rt.object_type = gt.geography_type)
1046: ORDER BY 3 desc;
1047:

Line 1277: goegoraphy type from hz_geography_types_b and the call is made only when geograpy_use

1273: x_return_status := FND_API.G_RET_STS_SUCCESS;
1274:
1275: /* nipatel commented out this validation because the call to get_master_geography is
1276: being made from within this package itself and there we are already fetching the
1277: goegoraphy type from hz_geography_types_b and the call is made only when geograpy_use
1278: is 'MASTER_REF'
1279:
1280: -- Validate geography type
1281: SELECT count(*)

Line 1283: FROM hz_geography_types_b

1279:
1280: -- Validate geography type
1281: SELECT count(*)
1282: INTO l_count
1283: FROM hz_geography_types_b
1284: WHERE geography_type = p_geography_type
1285: AND geography_use = 'MASTER_REF';
1286:
1287: -- ---------------------