APPS.ZX_TCM_GEO_JUR_PKG dependencies on HZ_GEOGRAPHY_TYPES_B

Line 604: FROM hz_geography_types_b

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

Line 626: l_geography_type hz_geography_types_b.geography_type%TYPE;

622: x_msg_data VARCHAR2(2000);
623: l_location_info_rec ZX_GLOBAL_STRUCTURES_PKG.loc_info_rec_type;
624:
625: l_geography_type_index BINARY_INTEGER;
626: l_geography_type hz_geography_types_b.geography_type%TYPE;
627: l_geography_use hz_geography_types_b.geography_use%TYPE;
628: l_limited_by_geography_id hz_geography_types_b.limited_by_geography_id%TYPE;
629:
630: --bug8251315

Line 627: l_geography_use hz_geography_types_b.geography_use%TYPE;

623: l_location_info_rec ZX_GLOBAL_STRUCTURES_PKG.loc_info_rec_type;
624:
625: l_geography_type_index BINARY_INTEGER;
626: l_geography_type hz_geography_types_b.geography_type%TYPE;
627: l_geography_use hz_geography_types_b.geography_use%TYPE;
628: l_limited_by_geography_id hz_geography_types_b.limited_by_geography_id%TYPE;
629:
630: --bug8251315
631: l_tbl_index BINARY_INTEGER;

Line 628: l_limited_by_geography_id hz_geography_types_b.limited_by_geography_id%TYPE;

624:
625: l_geography_type_index BINARY_INTEGER;
626: l_geography_type hz_geography_types_b.geography_type%TYPE;
627: l_geography_use hz_geography_types_b.geography_use%TYPE;
628: l_limited_by_geography_id hz_geography_types_b.limited_by_geography_id%TYPE;
629:
630: --bug8251315
631: l_tbl_index BINARY_INTEGER;
632: l_zone_indx VARCHAR2(4000);

Line 960: l_obj_geo_type hz_geography_types_b.geography_type%type;

956: l_tmp_count NUMBER;
957: l_tax_id NUMBER;
958: l_error_buffer VARCHAR2(200);
959:
960: l_obj_geo_type hz_geography_types_b.geography_type%type;
961: l_geography_type geography_type_use_type;
962: l_geography_use geography_type_use_type;
963: l_geography_type_num geography_type_num_type;
964: l_inner_city_jurisdiction_flag VARCHAR2(30);

Line 1147: FROM hz_geography_types_b gt

1143: SELECT geography_type, geography_use, geography_type_num
1144: BULK COLLECT INTO l_geography_type, l_geography_use, l_geography_type_num
1145: FROM
1146: (SELECT gt.geography_type geography_type, gt.geography_use geography_use, 1 geography_type_num
1147: FROM hz_geography_types_b gt
1148: WHERE l_tax_rec.zone_geography_type = gt.geography_type
1149: UNION
1150: SELECT gt.geography_type geography_type, gt.geography_use geography_use, 2 geography_type_num
1151: FROM hz_geography_types_b gt

Line 1151: FROM hz_geography_types_b gt

1147: FROM hz_geography_types_b gt
1148: WHERE l_tax_rec.zone_geography_type = gt.geography_type
1149: UNION
1150: SELECT gt.geography_type geography_type, gt.geography_use geography_use, 2 geography_type_num
1151: FROM hz_geography_types_b gt
1152: WHERE l_tax_rec.override_geography_type = gt.geography_type
1153: UNION
1154: SELECT rt.object_type geography_type,
1155: gt.geography_use geography_use,

Line 1158: hz_geography_types_b gt

1154: SELECT rt.object_type geography_type,
1155: gt.geography_use geography_use,
1156: 2+rownum geography_type_num
1157: FROM hz_relationship_types rt,
1158: hz_geography_types_b gt
1159: WHERE l_tax_rec.override_geography_type = rt.subject_type
1160: AND rt.object_type = gt.geography_type)
1161: ORDER BY 3 desc;
1162:

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

1480: x_return_status := FND_API.G_RET_STS_SUCCESS;
1481:
1482: /* nipatel commented out this validation because the call to get_master_geography is
1483: being made from within this package itself and there we are already fetching the
1484: goegoraphy type from hz_geography_types_b and the call is made only when geograpy_use
1485: is 'MASTER_REF'
1486:
1487: -- Validate geography type
1488: SELECT count(*)

Line 1490: FROM hz_geography_types_b

1486:
1487: -- Validate geography type
1488: SELECT count(*)
1489: INTO l_count
1490: FROM hz_geography_types_b
1491: WHERE geography_type = p_geography_type
1492: AND geography_use = 'MASTER_REF';
1493:
1494: -- ---------------------