2551: l_usage_dtls_tbl HZ_GNR_UTIL_PKG.USAGE_DTLS_TBL_TYPE;
2552:
2553: CURSOR c_map(p_map_id IN NUMBER) IS
2554: SELECT MAP_ID,COUNTRY_CODE,LOC_TBL_NAME,ADDRESS_STYLE
2555: FROM hz_geo_struct_map
2556: WHERE map_id = p_map_id;
2557:
2558: CURSOR c_map_dtls(p_map_id IN NUMBER) IS
2559: SELECT MAP_ID,LOC_SEQ_NUM,LOC_COMPONENT,GEOGRAPHY_TYPE,GEO_ELEMENT_COL
2556: WHERE map_id = p_map_id;
2557:
2558: CURSOR c_map_dtls(p_map_id IN NUMBER) IS
2559: SELECT MAP_ID,LOC_SEQ_NUM,LOC_COMPONENT,GEOGRAPHY_TYPE,GEO_ELEMENT_COL
2560: FROM hz_geo_struct_map_dtl
2561: WHERE map_id = p_map_id
2562: ORDER BY LOC_SEQ_NUM;
2563:
2564: CURSOR c_usage(p_map_id IN NUMBER) IS