APPS.OKL_COPY_CONTRACT_PVT dependencies on HZ_PARTY_SITES

Line 19376: HZ_PARTY_SITES ps

19372: CURSOR c_get_iti_object_id1(p_party_site_id HZ_PARTY_SITE_USES.PARTY_SITE_ID%TYPE)
19373: IS
19374: SELECT psu.party_site_use_id
19375: FROM HZ_PARTY_SITE_USES psu,
19376: HZ_PARTY_SITES ps
19377: WHERE ps.party_site_id = psu.party_site_id
19378: AND psu.site_use_type = 'INSTALL_AT'
19379: AND psu.party_site_id = p_party_site_id;
19380:

Line 19384: hz_party_sites ps

19380:
19381: CURSOR l_site_use_csr (p_location_id IN NUMBER) IS
19382: SELECT psu.party_site_use_id
19383: FROM hz_party_site_uses psu,
19384: hz_party_sites ps
19385: WHERE psu.party_site_id = ps.party_site_id
19386: AND psu.site_use_type = 'INSTALL_AT'
19387: AND ps.location_id = p_location_id;
19388:

Line 19395: hz_party_sites ps

19391: --Cursor to get address for error
19392: CURSOR l_address_csr (pty_site_id IN NUMBER ) IS
19393: 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)
19394: FROM hz_locations hl,
19395: hz_party_sites ps
19396: WHERE hl.location_id = ps.location_id
19397: AND ps.party_site_id = pty_site_id;
19398:
19399: CURSOR l_address_csr2 (loc_id IN NUMBER) IS

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

19404: l_address VARCHAR2(80);
19405:
19406: BEGIN
19407: --Logic
19408: IF NVL(p_install_location_type_code,OKL_API.G_MISS_CHAR) NOT IN ('HZ_PARTY_SITES','HZ_LOCATIONS') THEN
19409: --Raise Error
19410: OKL_API.Set_Message(p_app_name => 'OKL_COPY_CONTRACT_PVT',
19411: p_msg_name => 'OKL_INVALID_INSTALL_LOC_TYPE',
19412: p_token1 => 'LOCATION_TYPE',

Line 19415: p_token2_value => 'HZ_PARTY_SITES',

19411: p_msg_name => 'OKL_INVALID_INSTALL_LOC_TYPE',
19412: p_token1 => 'LOCATION_TYPE',
19413: p_token1_value => p_install_location_type_code,
19414: p_token2 => 'LOCATION_TYPE1',
19415: p_token2_value => 'HZ_PARTY_SITES',
19416: p_token3 => 'LOCATION_TYPE2',
19417: p_token3_value => 'HZ_LOCATIONS');
19418: x_return_status := OKL_API.G_RET_STS_ERROR;
19419: RAISE OKL_API.G_EXCEPTION_ERROR;

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

19417: p_token3_value => 'HZ_LOCATIONS');
19418: x_return_status := OKL_API.G_RET_STS_ERROR;
19419: RAISE OKL_API.G_EXCEPTION_ERROR;
19420:
19421: ELSIF NVL(p_install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' THEN
19422:
19423: OPEN c_get_iti_object_id1(p_install_location_id);
19424: FETCH c_get_iti_object_id1 INTO x_OBJECT_ID1_NEW;
19425: IF c_get_iti_object_id1%NOTFOUND THEN