APPS.OKL_COPY_CONTRACT_PVT dependencies on HZ_LOCATIONS

Line 19394: FROM hz_locations hl,

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

Line 19401: FROM hz_locations hl

19397: AND ps.party_site_id = pty_site_id;
19398:
19399: CURSOR l_address_csr2 (loc_id IN NUMBER) IS
19400: 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)
19401: FROM hz_locations hl
19402: WHERE hl.location_id = loc_id;
19403:
19404: l_address VARCHAR2(80);
19405:

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

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;
19420:
19421: ELSIF NVL(p_install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' THEN

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

19440: RAISE OKL_API.G_EXCEPTION_ERROR;
19441: END IF;
19442: CLOSE c_get_iti_object_id1;
19443:
19444: ELSIF NVL(p_install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_LOCATIONS' THEN
19445:
19446: OPEN l_site_use_csr(p_install_location_id);
19447: FETCH l_site_use_csr INTO l_site_use_rec;
19448: IF l_site_use_csr%NOTFOUND THEN