APPS.OKL_COPY_ASSET_PVT dependencies on HZ_PARTY_SITES

Line 4229: HZ_PARTY_SITES ps

4225: CURSOR c_get_iti_object_id1(p_party_site_id HZ_PARTY_SITE_USES.PARTY_SITE_ID%TYPE)
4226: IS
4227: SELECT psu.party_site_use_id
4228: FROM HZ_PARTY_SITE_USES psu,
4229: HZ_PARTY_SITES ps
4230: WHERE ps.party_site_id = psu.party_site_id
4231: AND psu.site_use_type = 'INSTALL_AT'
4232: AND psu.party_site_id = p_party_site_id;
4233:

Line 4246: hz_party_sites ps

4242:
4243: CURSOR l_site_use_csr (p_location_id in number) is
4244: SELECT psu.party_site_use_id
4245: FROM hz_party_site_uses psu,
4246: hz_party_sites ps
4247: WHERE psu.party_site_id = ps.party_site_id
4248: AND psu.site_use_type = 'INSTALL_AT'
4249: AND ps.location_id = p_location_id;
4250:

Line 4257: hz_party_sites ps

4253: --Cursor to get address for error
4254: Cursor l_address_csr (pty_site_id in number ) is
4255: select substr(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,null,hl.country,null, null,null,null,null,null,null,'n','n',80,1,1),1,80)
4256: from hz_locations hl,
4257: hz_party_sites ps
4258: where hl.location_id = ps.location_id
4259: and ps.party_site_id = pty_site_id;
4260:
4261: Cursor l_address_csr2 (loc_id in number) is

Line 5124: If nvl(l_loc_type_rec.install_location_type_code,OKL_API.G_MISS_CHAR) not in ('HZ_PARTY_SITES','HZ_LOCATIONS') then

5120: Null;
5121: End If;
5122: CLOSE l_loc_type_csr;
5123:
5124: If nvl(l_loc_type_rec.install_location_type_code,OKL_API.G_MISS_CHAR) not in ('HZ_PARTY_SITES','HZ_LOCATIONS') then
5125:
5126: --Raise Error
5127: OKL_API.Set_Message(p_app_name => G_APP_NAME,
5128: p_msg_name => G_INVALID_INSTALL_LOC_TYPE,

Line 5132: p_token2_value => 'HZ_PARTY_SITES',

5128: p_msg_name => G_INVALID_INSTALL_LOC_TYPE,
5129: p_token1 => G_LOCATION_TYPE_TOKEN,
5130: p_token1_value => l_loc_type_rec.install_location_type_code,
5131: p_token2 => G_LOC_TYPE1_TOKEN,
5132: p_token2_value => 'HZ_PARTY_SITES',
5133: p_token3 => G_LOC_TYPE2_TOKEN,
5134: p_token3_value => 'HZ_LOCATIONS');
5135: x_return_status := OKL_API.G_RET_STS_ERROR;
5136: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 5138: Elsif nvl(l_loc_type_rec.install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' then

5134: p_token3_value => 'HZ_LOCATIONS');
5135: x_return_status := OKL_API.G_RET_STS_ERROR;
5136: RAISE OKL_API.G_EXCEPTION_ERROR;
5137:
5138: Elsif nvl(l_loc_type_rec.install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' then
5139:
5140: OPEN c_get_iti_object_id1(r_ib_info.install_location_id);
5141: FETCH c_get_iti_object_id1 INTO l_itiv_rec.object_id1_new;
5142: IF c_get_iti_object_id1%NOTFOUND THEN