DBA Data[Home] [Help]

APPS.HZ_GEOGRAPHY_STRUCTURE_PUB dependencies on HZ_GEO_STRUCT_MAP_PUB

Line 785: l_geo_struct_map_dtl_tbl HZ_GEO_STRUCT_MAP_PUB.geo_struct_map_dtl_tbl_type;

781: l_geography_from VARCHAR2(30);
782: l_location_table_name VARCHAR2(30);
783: l_country VARCHAR2(2);
784: l_address_style VARCHAR2(30);
785: l_geo_struct_map_dtl_tbl HZ_GEO_STRUCT_MAP_PUB.geo_struct_map_dtl_tbl_type;
786:
787:
788: CURSOR c_get_geo_map is
789: Select map_id

Line 1198: HZ_GEO_STRUCT_MAP_PUB.delete_geo_struct_mapping(l_map_id,

1194: and geography_type = p_geography_type;
1195:
1196: if l_geo_struct_map_dtl_tbl.COUNT > 0 then
1197:
1198: HZ_GEO_STRUCT_MAP_PUB.delete_geo_struct_mapping(l_map_id,
1199: l_location_table_name,
1200: l_country,
1201: l_address_style,
1202: l_geo_struct_map_dtl_tbl,