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 OKC_K_HEADERS_B

Line 54: ,p_agreement_number IN okc_k_headers_b.contract_number%TYPE

50: ,x_return_status OUT NOCOPY VARCHAR2
51: ,x_msg_count OUT NOCOPY NUMBER
52: ,x_msg_data OUT NOCOPY VARCHAR2
53: ,p_vcrv_rec IN vcrv_rec_type
54: ,p_agreement_number IN okc_k_headers_b.contract_number%TYPE
55: ,x_vcrv_rec OUT NOCOPY vcrv_rec_type
56: ) IS
57: lv_vcrv_rec vcrv_rec_type;
58: lv_calc_agr_number VARCHAR2(100);

Line 60: lx_new_agr_id okc_k_headers_b.id%TYPE;

56: ) IS
57: lv_vcrv_rec vcrv_rec_type;
58: lv_calc_agr_number VARCHAR2(100);
59: lv_vagr_hdr_rec okl_vp_copy_contract_pvt.copy_header_rec_type;
60: lx_new_agr_id okc_k_headers_b.id%TYPE;
61: lv_khrv_rec okl_khr_pvt.khrv_rec_type;
62: x_khrv_rec okl_khr_pvt.khrv_rec_type;
63: lv_vrrv_rec okl_vrr_pvt.vrrv_rec_type;
64: x_vrrv_rec okl_vrr_pvt.vrrv_rec_type;

Line 278: lv_chr_id okc_k_headers_b.id%TYPE;

274: CURSOR c_get_chr_id (cp_change_request_id okl_vp_change_requests.id%TYPE)IS
275: SELECT chr_id
276: FROM okl_vp_change_requests
277: WHERE id = cp_change_request_id;
278: lv_chr_id okc_k_headers_b.id%TYPE;
279:
280: lv_vcrv_rec okl_vcr_pvt.vcrv_rec_type;
281:
282: l_api_version CONSTANT NUMBER DEFAULT 1.0;

Line 759: CURSOR c_chk_pending_req_csr (cp_agreement_id okc_k_headers_b.id%TYPE) IS

755: ,x_vcrv_rec OUT NOCOPY vcrv_rec_type
756: ,x_vrrv_tbl OUT NOCOPY vrrv_tbl_type
757: ) IS
758: -- cursor to check if there are any existing change requests
759: CURSOR c_chk_pending_req_csr (cp_agreement_id okc_k_headers_b.id%TYPE) IS
760: SELECT 'X'
761: FROM okl_vp_change_requests creq
762: WHERE creq.chr_id = cp_agreement_id
763: AND creq.status_code IN ('NEW','INCOMPELTE','REJECTED','PENDING_APPROVAL','PASSED');

Line 766: CURSOR c_get_agr_num_csr (cp_agreement_id okc_k_headers_b.id%TYPE) IS

762: WHERE creq.chr_id = cp_agreement_id
763: AND creq.status_code IN ('NEW','INCOMPELTE','REJECTED','PENDING_APPROVAL','PASSED');
764:
765: -- cursor to get the agreement number
766: CURSOR c_get_agr_num_csr (cp_agreement_id okc_k_headers_b.id%TYPE) IS
767: SELECT contract_number, sts_code
768: FROM okc_k_headers_b
769: WHERE id = cp_agreement_id;
770:

Line 768: FROM okc_k_headers_b

764:
765: -- cursor to get the agreement number
766: CURSOR c_get_agr_num_csr (cp_agreement_id okc_k_headers_b.id%TYPE) IS
767: SELECT contract_number, sts_code
768: FROM okc_k_headers_b
769: WHERE id = cp_agreement_id;
770:
771: -- cursor to check if this is the first change request of type AGREEMENT for the agreement
772: -- this can be derived by looking at change requests of type AGREEMENT in the context of the original agreement

Line 773: CURSOR c_chk_first_cr_csr (cp_agreement_id okc_k_headers_b.id%TYPE)IS

769: WHERE id = cp_agreement_id;
770:
771: -- cursor to check if this is the first change request of type AGREEMENT for the agreement
772: -- this can be derived by looking at change requests of type AGREEMENT in the context of the original agreement
773: CURSOR c_chk_first_cr_csr (cp_agreement_id okc_k_headers_b.id%TYPE)IS
774: SELECT 'X'
775: FROM okl_vp_change_requests crq
776: WHERE crq.chr_id = cp_agreement_id
777: -- AND crq.change_type_code <> 'ASSOCIATION'

Line 783: lv_agreement_number okc_k_headers_b.contract_number%TYPE;

779:
780: lv_vcrv_rec vcrv_rec_type;
781: xc_vcrv_rec vcrv_rec_type;
782: lv_pending_req_cvar VARCHAR2(1);
783: lv_agreement_number okc_k_headers_b.contract_number%TYPE;
784: lv_agreement_status okc_k_headers_b.sts_code%TYPE;
785: lv_calc_agr_number VARCHAR2(100);
786: lv_vagr_hdr_rec okl_vp_copy_contract_pvt.copy_header_rec_type;
787: lx_new_agr_id okc_k_headers_b.id%TYPE;

Line 784: lv_agreement_status okc_k_headers_b.sts_code%TYPE;

780: lv_vcrv_rec vcrv_rec_type;
781: xc_vcrv_rec vcrv_rec_type;
782: lv_pending_req_cvar VARCHAR2(1);
783: lv_agreement_number okc_k_headers_b.contract_number%TYPE;
784: lv_agreement_status okc_k_headers_b.sts_code%TYPE;
785: lv_calc_agr_number VARCHAR2(100);
786: lv_vagr_hdr_rec okl_vp_copy_contract_pvt.copy_header_rec_type;
787: lx_new_agr_id okc_k_headers_b.id%TYPE;
788: lv_is_first_cr VARCHAR2(1);

Line 787: lx_new_agr_id okc_k_headers_b.id%TYPE;

783: lv_agreement_number okc_k_headers_b.contract_number%TYPE;
784: lv_agreement_status okc_k_headers_b.sts_code%TYPE;
785: lv_calc_agr_number VARCHAR2(100);
786: lv_vagr_hdr_rec okl_vp_copy_contract_pvt.copy_header_rec_type;
787: lx_new_agr_id okc_k_headers_b.id%TYPE;
788: lv_is_first_cr VARCHAR2(1);
789: lv_khrv_rec okl_khr_pvt.khrv_rec_type;
790: x_khrv_rec okl_khr_pvt.khrv_rec_type;
791: x_request_status okl_vp_change_requests.status_code%TYPE;

Line 1194: FROM okc_k_headers_b chr

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
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;

Line 1198: lv_creq_chr_id okc_k_headers_b.id%TYPE;

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:
1200: lv_vcrv_rec vcrv_rec_type;
1201: x_vcrv_rec vcrv_rec_type;
1202: l_api_version CONSTANT NUMBER DEFAULT 1.0;

Line 1487: ,p_chr_id IN okc_k_headers_b.id%TYPE

1483: ,p_init_msg_list IN VARCHAR2
1484: ,x_return_status OUT NOCOPY VARCHAR2
1485: ,x_msg_count OUT NOCOPY NUMBER
1486: ,x_msg_data OUT NOCOPY VARCHAR2
1487: ,p_chr_id IN okc_k_headers_b.id%TYPE
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

Line 1502: ,okc_k_headers_b chr

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;
1506:

Line 1685: FROM okc_k_headers_b chr

1681: cv_chreq_rec c_get_chreq_csr%ROWTYPE;
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:

Line 1690: CURSOR c_get_chr (cp_chr_id okc_k_headers_b.id%TYPE)IS

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
1691: SELECT contract_number
1692: FROM okc_k_headers_b
1693: WHERE id = cp_chr_id;
1694:

Line 1692: FROM okc_k_headers_b

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
1691: SELECT contract_number
1692: FROM okc_k_headers_b
1693: WHERE id = cp_chr_id;
1694:
1695: lv_ageement_number okc_k_headers_b.contract_number%TYPE;
1696: BEGIN

Line 1695: lv_ageement_number okc_k_headers_b.contract_number%TYPE;

1691: SELECT contract_number
1692: FROM okc_k_headers_b
1693: WHERE id = cp_chr_id;
1694:
1695: lv_ageement_number okc_k_headers_b.contract_number%TYPE;
1696: BEGIN
1697: IF(p_change_request_id IS NOT NULL AND p_change_request_id <> OKL_API.G_MISS_NUM)THEN
1698: OPEN c_get_chreq_csr(cp_ch_req_id => p_change_request_id);
1699: FETCH c_get_chreq_csr INTO cv_chreq_rec;

Line 1740: FROM okc_k_headers_b chr

1736: cv_chreq_rec c_get_chreq_csr%ROWTYPE;
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:

Line 1745: lv_chr_id okc_k_headers_b.id%TYPE;

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;
1746: BEGIN
1747: IF(p_change_request_id IS NOT NULL AND p_change_request_id <> OKL_API.G_MISS_NUM)THEN
1748: OPEN c_get_chreq_csr(cp_ch_req_id => p_change_request_id);
1749: FETCH c_get_chreq_csr INTO cv_chreq_rec;