APPS.OKL_COPY_CONTRACT_PVT dependencies on HZ_PARTY_SITES

Line 19553: HZ_PARTY_SITES ps

19549: CURSOR c_get_iti_object_id1(p_party_site_id HZ_PARTY_SITE_USES.PARTY_SITE_ID%TYPE)
19550: IS
19551: SELECT psu.party_site_use_id
19552: FROM HZ_PARTY_SITE_USES psu,
19553: HZ_PARTY_SITES ps
19554: WHERE ps.party_site_id = psu.party_site_id
19555: AND psu.site_use_type = 'INSTALL_AT'
19556: AND psu.party_site_id = p_party_site_id;
19557:

Line 19561: hz_party_sites ps

19557:
19558: CURSOR l_site_use_csr (p_location_id IN NUMBER) IS
19559: SELECT psu.party_site_use_id
19560: FROM hz_party_site_uses psu,
19561: hz_party_sites ps
19562: WHERE psu.party_site_id = ps.party_site_id
19563: AND psu.site_use_type = 'INSTALL_AT'
19564: AND ps.location_id = p_location_id;
19565:

Line 19572: hz_party_sites ps

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:
19576: CURSOR l_address_csr2 (loc_id IN NUMBER) IS

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 19592: p_token2_value => 'HZ_PARTY_SITES',

19588: p_msg_name => 'OKL_INVALID_INSTALL_LOC_TYPE',
19589: p_token1 => 'LOCATION_TYPE',
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;

Line 19598: ELSIF NVL(p_install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' THEN

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
19599:
19600: OPEN c_get_iti_object_id1(p_install_location_id);
19601: FETCH c_get_iti_object_id1 INTO x_OBJECT_ID1_NEW;
19602: IF c_get_iti_object_id1%NOTFOUND THEN