APPS.HZ_GEO_STRUCT_MAP_PUB dependencies on HZ_ADDRESS_USAGES

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 595: FROM hz_address_usages

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
596: WHERE map_id = p_map_id;
597:
598: CURSOR c_address_usage_dtls(c_geography_type varchar2) IS
599: SELECT dtl.usage_id

Line 600: FROM Hz_address_usages usg, Hz_address_usage_dtls dtl

596: WHERE map_id = p_map_id;
597:
598: CURSOR c_address_usage_dtls(c_geography_type varchar2) IS
599: SELECT dtl.usage_id
600: FROM Hz_address_usages usg, Hz_address_usage_dtls dtl
601: WHERE usg.map_id = p_map_id
602: AND dtl.geography_type = c_geography_type
603: AND dtl.usage_id = usg.usage_id;
604:

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,

Line 1227: FROM Hz_address_usages usg, Hz_address_usage_dtls dtl

1223: END IF;
1224:
1225: SELECT count(*)
1226: INTO l_count
1227: FROM Hz_address_usages usg, Hz_address_usage_dtls dtl
1228: WHERE usg.map_id = p_map_id
1229: AND usg.status_flag = 'A'
1230: AND dtl.usage_id = usg.usage_id;
1231: