APPS.OKL_COPY_CONTRACT_PVT dependencies on HZ_LOCATIONS

Line 19571: FROM hz_locations hl,

19567:
19568: --Cursor to get address for error
19569: CURSOR l_address_csr (pty_site_id IN NUMBER ) IS
19570: 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)
19571: FROM hz_locations hl,
19572: hz_party_sites ps
19573: WHERE hl.location_id = ps.location_id
19574: AND ps.party_site_id = pty_site_id;
19575:

Line 19578: FROM hz_locations hl

19574: AND ps.party_site_id = pty_site_id;
19575:
19576: CURSOR l_address_csr2 (loc_id IN NUMBER) IS
19577: 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)
19578: FROM hz_locations hl
19579: WHERE hl.location_id = loc_id;
19580:
19581: l_address VARCHAR2(80);
19582:

Line 19585: IF NVL(p_install_location_type_code,OKL_API.G_MISS_CHAR) NOT IN ('HZ_PARTY_SITES','HZ_LOCATIONS') THEN

19581: l_address VARCHAR2(80);
19582:
19583: BEGIN
19584: --Logic
19585: IF NVL(p_install_location_type_code,OKL_API.G_MISS_CHAR) NOT IN ('HZ_PARTY_SITES','HZ_LOCATIONS') THEN
19586: --Raise Error
19587: OKL_API.Set_Message(p_app_name => 'OKL_COPY_CONTRACT_PVT',
19588: p_msg_name => 'OKL_INVALID_INSTALL_LOC_TYPE',
19589: p_token1 => 'LOCATION_TYPE',

Line 19594: p_token3_value => 'HZ_LOCATIONS');

19590: p_token1_value => p_install_location_type_code,
19591: p_token2 => 'LOCATION_TYPE1',
19592: p_token2_value => 'HZ_PARTY_SITES',
19593: p_token3 => 'LOCATION_TYPE2',
19594: p_token3_value => 'HZ_LOCATIONS');
19595: x_return_status := OKL_API.G_RET_STS_ERROR;
19596: RAISE OKL_API.G_EXCEPTION_ERROR;
19597:
19598: ELSIF NVL(p_install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' THEN

Line 19621: ELSIF NVL(p_install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_LOCATIONS' THEN

19617: RAISE OKL_API.G_EXCEPTION_ERROR;
19618: END IF;
19619: CLOSE c_get_iti_object_id1;
19620:
19621: ELSIF NVL(p_install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_LOCATIONS' THEN
19622:
19623: OPEN l_site_use_csr(p_install_location_id);
19624: FETCH l_site_use_csr INTO l_site_use_rec;
19625: IF l_site_use_csr%NOTFOUND THEN