APPS.IGS_OR_INST_IMP_003_PKG dependencies on HZ_PARTY_SITES

Line 1529: l_party_site_id hz_party_sites.party_site_id%TYPE;

1525: l_return_status VARCHAR2(10);
1526: l_msg_data VARCHAR2(1000);
1527: l_addr_row_id VARCHAR2(25);
1528: l_usage_row_id VARCHAR2(25);
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;

Line 1532: l_party_site_ovn hz_party_sites.object_version_number%TYPE;

1528: l_usage_row_id VARCHAR2(25);
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,

Line 1562: FROM hz_party_sites hp,

1558:
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,' ')

Line 1578: CURSOR cur_get_usage(cp_party_site_id hz_party_sites.party_site_id%TYPE,

1574: AND NVL(addr.country,' ') = NVL(p_int_addr_rec.country,' ')
1575: AND NVL(addr.postal_code,' ') = NVL(p_int_addr_rec.postcode,' ');
1576:
1577: --Cursor to fetch the existing address usage
1578: CURSOR cur_get_usage(cp_party_site_id hz_party_sites.party_site_id%TYPE,
1579: cp_addr_usage igs_or_adrusge_int.site_use_code%TYPE) IS
1580: SELECT site_use_type
1581: FROM hz_party_site_uses
1582: WHERE party_site_id = cp_party_site_id