APPS.IGS_OR_INST_IMP_003_PKG dependencies on HZ_LOCATIONS

Line 1516: l_location_id hz_locations.location_id%TYPE;

1512: ***************************************************************/
1513: AS
1514: l_addr_usage igs_or_adrusge_int.site_use_code%TYPE;
1515: l_existing_usage igs_or_adrusge_int.site_use_code%TYPE;
1516: l_location_id hz_locations.location_id%TYPE;
1517: l_date DATE;
1518: l_addr_success BOOLEAN;
1519: l_addr_process BOOLEAN := FALSE;
1520:

Line 1533: l_location_ovn hz_locations.object_version_number%TYPE;

1529: l_party_site_id hz_party_sites.party_site_id%TYPE;
1530: l_party_site_use_id igs_or_adrusge_int.interface_addrusage_id%TYPE;
1531: SKIP_ADDR EXCEPTION;
1532: l_party_site_ovn hz_party_sites.object_version_number%TYPE;
1533: l_location_ovn hz_locations.object_version_number%TYPE;
1534: l_addr_warning VARCHAR2(1) := 'N';
1535: --Cursor to fetch the Interface Address Master Records for the Interface Identifier
1536: CURSOR cur_get_int_addr(cp_interface_id igs_or_adr_int.interface_id%TYPE,
1537: cp_status igs_or_adr_int.status%TYPE) IS

Line 1563: hz_locations addr

1559: --Cursor to check the Duplicate Address
1560: CURSOR cur_get_oss_addr(p_int_addr_rec igs_or_adr_int%ROWTYPE,cp_party_id hz_parties.party_id%TYPE) IS
1561: SELECT party_site_id
1562: FROM hz_party_sites hp,
1563: hz_locations addr
1564: WHERE hp.location_id = addr.location_id
1565: AND hp.party_id = cp_party_id
1566: AND NVL(addr.address1,' ') = NVL(p_int_addr_rec.addr_line_1,' ')
1567: AND NVL(addr.address2,' ') = NVL(p_int_addr_rec.addr_line_2,' ')

Line 1873: --There is an Address existing in HZ Locations for this Party ID

1869:
1870: END IF;
1871: CLOSE c_adr_val;
1872:
1873: --There is an Address existing in HZ Locations for this Party ID
1874: ELSIF l_party_site_id IS NOT NULL THEN
1875: --Need to Check if the Address Usage is already associated for this
1876: --address.Otherwise we need to create an association
1877: