APPS.HZ_GNR_UTIL_PKG dependencies on HZ_GEO_STRUCT_MAP

Line 538: l_sql1 := 'select map_id from hz_geo_struct_map where loc_tbl_name =:tbl and

534: -- hence, to identify them appropriately to give user friedly mesg
535: -- l_eflag is used.
536:
537: IF (l_addrstyle IS NULL) THEN
538: l_sql1 := 'select map_id from hz_geo_struct_map where loc_tbl_name =:tbl and
539: country_code = :cntry and address_style is null';
540: l_eflag := 'AN'; -- address style null case
541:
542: execute IMMEDIATE l_sql1 INTO x_mapId USING IN p_loctbl, x_cntry;

Line 544: l_sql1 := 'select map_id from hz_geo_struct_map where loc_tbl_name =:tbl and

540: l_eflag := 'AN'; -- address style null case
541:
542: execute IMMEDIATE l_sql1 INTO x_mapId USING IN p_loctbl, x_cntry;
543: ELSE
544: l_sql1 := 'select map_id from hz_geo_struct_map where loc_tbl_name =:tbl and
545: country_code = :cntry and address_style = :style';
546: l_eflag := 'A'; -- address style case
547:
548: execute IMMEDIATE l_sql1 INTO x_mapId USING IN p_loctbl, x_cntry, l_addrstyle;

Line 626: l_mapdtl hz_geo_struct_map_dtl%ROWTYPE;

622: -- temp variable declaration
623: -- l_cntry varchar2(2);
624: l_addrstyle varchar2(30);
625: l_sql1 varchar2(1000);
626: l_mapdtl hz_geo_struct_map_dtl%ROWTYPE;
627: i number;
628: l_eflag varchar2(2);
629: l_debug_prefix VARCHAR2(30) := '';
630:

Line 634: FROM hz_geo_struct_map_dtl

630:
631: CURSOR c1 (cp_map_id number) IS
632: SELECT loc_seq_num, loc_component,
633: geography_type, geo_element_col
634: FROM hz_geo_struct_map_dtl
635: WHERE map_id = cp_map_id
636: ORDER BY loc_seq_num ASC;
637:
638: BEGIN

Line 3632: FROM hz_geo_struct_map;

3628: retcode OUT NOCOPY VARCHAR2
3629: ) IS
3630: CURSOR c_map IS
3631: SELECT map_id
3632: FROM hz_geo_struct_map;
3633:
3634: CURSOR c_usage(l_map_id IN NUMBER) IS
3635: SELECT count(*)
3636: FROM Hz_address_usages usg, Hz_address_usage_dtls dtl