eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_VP_CHANGE_REQUEST_PVT dependencies on OKL_K_HEADERS

Line 106: -- the new agreement can be derived via the crs_id value in the okl_k_headers table

102: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
103: RAISE OKL_API.G_EXCEPTION_ERROR;
104: END IF;
105: -- construct other parameters for the change request. the chr_id of this change request is the parent agreement
106: -- the new agreement can be derived via the crs_id value in the okl_k_headers table
107: lv_vcrv_rec.chr_id := p_vcrv_rec.chr_id;
108: lv_vcrv_rec.change_type_code := p_vcrv_rec.change_type_code;
109: lv_vcrv_rec.status_code := G_COMPLETED_STS_CODE;
110: -- the request date will be the date on which the first change request has been initiated

Line 151: -- now that the agreement copy is created, set the change request id in the okl_k_headers to the created change request

147: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
148: RAISE OKL_API.G_EXCEPTION_ERROR;
149: END IF;
150:
151: -- now that the agreement copy is created, set the change request id in the okl_k_headers to the created change request
152: lv_khrv_rec.id := lx_new_agr_id;
153: lv_khrv_rec.crs_id := x_vcrv_rec.id;
154: okl_khr_pvt.update_row(p_api_version => p_api_version
155: ,p_init_msg_list => p_init_msg_list

Line 955: -- now that the agreement copy is created, set the change request id in the okl_k_headers to the created change request

951: RAISE OKL_API.G_EXCEPTION_ERROR;
952: END IF;
953: END IF; -- end of p_vrrv_tbl.COUNT > 0
954:
955: -- now that the agreement copy is created, set the change request id in the okl_k_headers to the created change request
956: -- commenting this call because okl_khr_pvt has not been modified to incl crs_id, template_type_code yet
957: lv_khrv_rec.id := lx_new_agr_id;
958: lv_khrv_rec.crs_id := x_vcrv_rec.id;
959: okl_khr_pvt.update_row(p_api_version => p_api_version

Line 1191: -- but the agreement that is copied from the parent agreement. this copy will have the crs_id value in okl_k_headers

1187: WHERE id = cp_change_req_id;
1188: cv_get_cr_dtls c_get_cr_dtls_csr%ROWTYPE;
1189:
1190: -- cursor to get the agreement id that is tied to the change request. this agreement id is not the parent agreement
1191: -- but the agreement that is copied from the parent agreement. this copy will have the crs_id value in okl_k_headers
1192: CURSOR c_get_creq_chr_id_csr (cp_change_req_id okl_vp_change_requests.id%TYPE)IS
1193: SELECT chr.id
1194: FROM okc_k_headers_b chr
1195: ,okl_k_headers khr

Line 1195: ,okl_k_headers khr

1191: -- but the agreement that is copied from the parent agreement. this copy will have the crs_id value in okl_k_headers
1192: CURSOR c_get_creq_chr_id_csr (cp_change_req_id okl_vp_change_requests.id%TYPE)IS
1193: SELECT chr.id
1194: FROM okc_k_headers_b chr
1195: ,okl_k_headers khr
1196: WHERE chr.id = khr.id
1197: AND khr.crs_id = cp_change_req_id;
1198: lv_creq_chr_id okc_k_headers_b.id%TYPE;
1199:

Line 1275: -- now get the copied agreement from okl_k_headers using the change request id

1271: -- at the change request level
1272: -- note that for ASSOCIATION type of change request, there is no agreement copy to update and the original agreement
1273: -- should not be updated
1274: IF(cv_get_cr_dtls.change_type_code = G_ARGREEMENT_TYPE_CODE)THEN
1275: -- now get the copied agreement from okl_k_headers using the change request id
1276: lv_creq_chr_id := NULL;
1277: OPEN c_get_creq_chr_id_csr (p_vp_crq_id);
1278: FETCH c_get_creq_chr_id_csr INTO lv_creq_chr_id; CLOSE c_get_creq_chr_id_csr;
1279: okl_contract_status_pub.update_contract_status(p_api_version => p_api_version

Line 1492: CURSOR c_get_change_req_csr(cp_chr_id okl_k_headers.id%TYPE)IS

1488: ,x_status_code OUT NOCOPY okl_vp_change_requests.status_code%TYPE
1489: ) IS
1490:
1491: -- cursor to identify the change request from the passed in agreement id
1492: CURSOR c_get_change_req_csr(cp_chr_id okl_k_headers.id%TYPE)IS
1493: SELECT id
1494: FROM okl_vp_change_requests
1495: WHERE chr_id = cp_chr_id
1496: AND status_code = G_PASSED_STS_CODE;

Line 1499: CURSOR c_get_crs_id_csr(cp_chr_id okl_k_headers.id%TYPE)IS

1495: WHERE chr_id = cp_chr_id
1496: AND status_code = G_PASSED_STS_CODE;
1497: lv_change_request_id okl_vp_change_requests.id%TYPE;
1498:
1499: CURSOR c_get_crs_id_csr(cp_chr_id okl_k_headers.id%TYPE)IS
1500: SELECT khr.crs_id
1501: FROM okl_k_headers khr
1502: ,okc_k_headers_b chr
1503: WHERE chr.id = khr.id

Line 1501: FROM okl_k_headers khr

1497: lv_change_request_id okl_vp_change_requests.id%TYPE;
1498:
1499: CURSOR c_get_crs_id_csr(cp_chr_id okl_k_headers.id%TYPE)IS
1500: SELECT khr.crs_id
1501: FROM okl_k_headers khr
1502: ,okc_k_headers_b chr
1503: WHERE chr.id = khr.id
1504: AND chr.sts_code = G_PASSED_STS_CODE
1505: AND chr.id = cp_chr_id;

Line 1542: -- this is the case of AGREEMENT type of change request. from the chr_id, we need to derive the crs_id from okl_k_headers

1538: -- get the change request id from the agreement id; error if no change request found
1539: OPEN c_get_change_req_csr(p_chr_id); FETCH c_get_change_req_csr INTO lv_change_request_id;
1540: IF(c_get_change_req_csr%NOTFOUND)THEN
1541: CLOSE c_get_change_req_csr;
1542: -- this is the case of AGREEMENT type of change request. from the chr_id, we need to derive the crs_id from okl_k_headers
1543: -- if no crs_id exists, then error
1544: OPEN c_get_crs_id_csr(p_chr_id); FETCH c_get_crs_id_csr INTO lv_change_request_id;
1545: IF(c_get_crs_id_csr%NOTFOUND)THEN
1546: CLOSE c_get_crs_id_csr;

Line 1686: ,okl_k_headers khr

1682:
1683: CURSOR c_get_chr_num_csr(cp_ch_req_id okl_vp_change_requests.id%TYPE) IS
1684: SELECT contract_number
1685: FROM okc_k_headers_b chr
1686: ,okl_k_headers khr
1687: WHERE chr.id = khr.id
1688: AND khr.crs_id = cp_ch_req_id;
1689:
1690: CURSOR c_get_chr (cp_chr_id okc_k_headers_b.id%TYPE)IS

Line 1702: -- find the agreement that is attached to this change request by looking into the okl_k_headers table

1698: OPEN c_get_chreq_csr(cp_ch_req_id => p_change_request_id);
1699: FETCH c_get_chreq_csr INTO cv_chreq_rec;
1700: CLOSE c_get_chreq_csr;
1701:
1702: -- find the agreement that is attached to this change request by looking into the okl_k_headers table
1703: IF(G_ARGREEMENT_TYPE_CODE = cv_chreq_rec.change_type_code)THEN
1704: OPEN c_get_chr_num_csr(cp_ch_req_id => p_change_request_id);
1705: FETCH c_get_chr_num_csr INTO lv_ageement_number;
1706: CLOSE c_get_chr_num_csr;

Line 1708: -- change request in the okl_k_headers table (such record can exist which was created as a backup copy)

1704: OPEN c_get_chr_num_csr(cp_ch_req_id => p_change_request_id);
1705: FETCH c_get_chr_num_csr INTO lv_ageement_number;
1706: CLOSE c_get_chr_num_csr;
1707: -- for ASSOCIATION type of change request, first we need to check if an agreement exists for this
1708: -- change request in the okl_k_headers table (such record can exist which was created as a backup copy)
1709: -- if no such record found then the contract_number associated to the chr_id from the change requests table
1710: -- is what we are interested in
1711: ELSIF(G_ASSOCIATE_TYPE_CODE = cv_chreq_rec.change_type_code)THEN
1712: OPEN c_get_chr_num_csr(cp_ch_req_id => p_change_request_id);

Line 1741: ,okl_k_headers khr

1737:
1738: CURSOR c_get_chr_id_csr(cp_ch_req_id okl_vp_change_requests.id%TYPE) IS
1739: SELECT chr.id
1740: FROM okc_k_headers_b chr
1741: ,okl_k_headers khr
1742: WHERE chr.id = khr.id
1743: AND khr.crs_id = cp_ch_req_id;
1744:
1745: lv_chr_id okc_k_headers_b.id%TYPE;

Line 1752: -- find the agreement that is attached to this change request by looking into the okl_k_headers table

1748: OPEN c_get_chreq_csr(cp_ch_req_id => p_change_request_id);
1749: FETCH c_get_chreq_csr INTO cv_chreq_rec;
1750: CLOSE c_get_chreq_csr;
1751:
1752: -- find the agreement that is attached to this change request by looking into the okl_k_headers table
1753: IF(G_ARGREEMENT_TYPE_CODE = cv_chreq_rec.change_type_code)THEN
1754: OPEN c_get_chr_id_csr(cp_ch_req_id => p_change_request_id);
1755: FETCH c_get_chr_id_csr INTO lv_chr_id;
1756: CLOSE c_get_chr_id_csr;