APPS.IGS_AD_IMP_002 dependencies on HZ_LOCATIONS

Line 916: FROM hz_locations loc, hz_party_sites site

912: DECLARE
913: CURSOR check_addr_dup_cur(cp_person_id hz_party_sites.party_id%TYPE,
914: cp_addr_rec addr_cur%ROWTYPE) IS
915: SELECT site.location_id, site.party_site_id
916: FROM hz_locations loc, hz_party_sites site
917: WHERE site.party_id = cp_person_id
918: AND site.location_id = loc.location_id
919: AND UPPER(NVL(loc.address1,'X')) = UPPER(NVL(cp_addr_rec.addr_line_1,'X'))
920: AND UPPER(NVL(loc.address2,'X')) = UPPER(NVL(cp_addr_rec.addr_line_2,'X'))

Line 1582: FROM hz_locations loc, hz_party_sites site

1578: DECLARE
1579: CURSOR check_addr_dup_cur(cp_person_id hz_party_sites.party_id%TYPE,
1580: cp_addr_rec addr_cur%ROWTYPE) IS
1581: SELECT site.location_id , site.party_site_id
1582: FROM hz_locations loc, hz_party_sites site
1583: WHERE site.party_id = cp_person_id
1584: AND site.location_id = loc.location_id
1585: AND UPPER(NVL(loc.address1,'X')) = UPPER(NVL(cp_addr_rec.addr_line_1,'X'))
1586: AND UPPER(NVL(loc.address2,'X')) = UPPER(NVL(cp_addr_rec.addr_line_2,'X'))

Line 2160: l_location_ovn hz_locations.object_version_number%TYPE;

2156: l_debug_str VARCHAR2(4000);
2157: l_enable_log VARCHAR2(1);
2158: l_request_id NUMBER(10);
2159: l_party_site_ovn hz_party_sites.object_version_number%TYPE;
2160: l_location_ovn hz_locations.object_version_number%TYPE;
2161:
2162: -- local procedure to check whether duplicate record exists for hz_party_site_uses for a party site id
2163: PROCEDURE check_dup_addr_usage(l_party_site_id IN HZ_PARTY_SITE_USES.PARTY_SITE_ID%TYPE,
2164: l_site_use_code IN HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE,

Line 2575: l_location_ovn hz_locations.object_version_number%TYPE;

2571: l_debug_str VARCHAR2(4000);
2572: l_enable_log VARCHAR2(1);
2573: l_request_id NUMBER(10);
2574: l_party_site_ovn hz_party_sites.object_version_number%TYPE;
2575: l_location_ovn hz_locations.object_version_number%TYPE;
2576:
2577:
2578: CURSOR null_hand_addr_cur(cp_location_id IGS_PE_PERSON_ADDR_V.location_id%TYPE,
2579: cp_party_site_id IGS_PE_PERSON_ADDR_V.party_site_id%TYPE)IS