APPS.HZ_GEO_STRUCT_MAP_PUB dependencies on HZ_ADDRESS_USAGES_PUB

Line 591: l_address_usage_dtls_tbl HZ_ADDRESS_USAGES_PUB.address_usage_dtls_tbl_type;

587: l_pkgname VARCHAR2(50);
588: l_status VARCHAR2(30);
589: -- pkg_name VARCHAR2(1000);
590: -- l_drp_sql VARCHAR2(1000);
591: l_address_usage_dtls_tbl HZ_ADDRESS_USAGES_PUB.address_usage_dtls_tbl_type;
592:
593: CURSOR c_address_usages IS
594: SELECT usage_id
595: FROM hz_address_usages

Line 742: HZ_ADDRESS_USAGES_PUB.delete_address_usages(

738: LOOP
739: FETCH c_address_usage_dtls INTO l_usage_id;
740: EXIT WHEN c_address_usage_dtls%NOTFOUND;
741: l_address_usage_dtls_tbl(1).geography_type := p_geo_struct_map_dtl_tbl(i).geo_type;
742: HZ_ADDRESS_USAGES_PUB.delete_address_usages(
743: p_usage_id => l_usage_id,
744: p_address_usage_dtls_tbl => l_address_usage_dtls_tbl,
745: p_init_msg_list => 'F',
746: x_return_status => l_return_status,

Line 810: HZ_ADDRESS_USAGES_PUB.delete_address_usages(

806:
807: -- If count is > 0 there is usage exists and we need to delete the usage records.
808: -- Else, there is no need to call the delete usage API
809: IF l_count > 0 then
810: HZ_ADDRESS_USAGES_PUB.delete_address_usages(
811: p_usage_id => i.usage_id,
812: p_address_usage_dtls_tbl => l_address_usage_dtls_tbl,
813: p_init_msg_list => 'F',
814: x_return_status => l_return_status,