APPS.OKL_COPY_ASSET_PVT dependencies on HZ_LOCATIONS

Line 4256: from hz_locations hl,

4252:
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:

Line 4263: from hz_locations hl

4259: and ps.party_site_id = pty_site_id;
4260:
4261: Cursor l_address_csr2 (loc_id in number) is
4262: 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)
4263: from hz_locations hl
4264: where hl.location_id = loc_id;
4265:
4266: l_address varchar2(80);
4267: --End BUG# 3569441

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 5134: p_token3_value => 'HZ_LOCATIONS');

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;
5137:
5138: Elsif nvl(l_loc_type_rec.install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' then

Line 5160: Elsif nvl(l_loc_type_rec.install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_LOCATIONS' then

5156: RAISE OKL_API.G_EXCEPTION_ERROR;
5157: END IF;
5158: CLOSE c_get_iti_object_id1;
5159:
5160: Elsif nvl(l_loc_type_rec.install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_LOCATIONS' then
5161:
5162: OPEN l_site_use_csr(r_ib_info.install_location_id);
5163: FETCH l_site_use_csr INTO l_site_use_rec;
5164: IF l_site_use_csr%NOTFOUND THEN