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_VP_CHANGE_REQUESTS

Line 36: FUNCTION generate_change_req_num RETURN okl_vp_change_requests.change_request_number%TYPE IS

32: G_SYSTEM_REASON_CD CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'SYSTEM';
33:
34: -- local procedures/functions. START
35:
36: FUNCTION generate_change_req_num RETURN okl_vp_change_requests.change_request_number%TYPE IS
37: -- cursor to fetch the next available change request number
38: CURSOR c_get_next_cr_num IS
39: SELECT okl_vp_change_req_num_seq.NEXTVAL
40: FROM dual;

Line 41: lv_new_change_request_number okl_vp_change_requests.change_request_number%TYPE;

37: -- cursor to fetch the next available change request number
38: CURSOR c_get_next_cr_num IS
39: SELECT okl_vp_change_req_num_seq.NEXTVAL
40: FROM dual;
41: lv_new_change_request_number okl_vp_change_requests.change_request_number%TYPE;
42: BEGIN
43: OPEN c_get_next_cr_num; FETCH c_get_next_cr_num INTO lv_new_change_request_number;
44: CLOSE c_get_next_cr_num;
45: RETURN lv_new_change_request_number;

Line 274: CURSOR c_get_chr_id (cp_change_request_id okl_vp_change_requests.id%TYPE)IS

270: ,p_vcrv_rec IN vcrv_rec_type
271: ,x_vcrv_rec OUT NOCOPY vcrv_rec_type
272: ) IS
273:
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;

Line 276: FROM okl_vp_change_requests

272: ) IS
273:
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;

Line 382: ,x_request_status OUT NOCOPY okl_vp_change_requests.status_code%TYPE

378: ,x_msg_count OUT NOCOPY NUMBER
379: ,x_msg_data OUT NOCOPY VARCHAR2
380: ,p_vrrv_tbl IN vrrv_tbl_type
381: ,x_vrrv_tbl OUT NOCOPY vrrv_tbl_type
382: ,x_request_status OUT NOCOPY okl_vp_change_requests.status_code%TYPE
383: ) IS
384: lv_crs_id okl_vp_change_requests.id%TYPE;
385: l_api_version CONSTANT NUMBER DEFAULT 1.0;
386: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CREATE_CHANGE_REQUEST_LNS';

Line 384: lv_crs_id okl_vp_change_requests.id%TYPE;

380: ,p_vrrv_tbl IN vrrv_tbl_type
381: ,x_vrrv_tbl OUT NOCOPY vrrv_tbl_type
382: ,x_request_status OUT NOCOPY okl_vp_change_requests.status_code%TYPE
383: ) IS
384: lv_crs_id okl_vp_change_requests.id%TYPE;
385: l_api_version CONSTANT NUMBER DEFAULT 1.0;
386: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CREATE_CHANGE_REQUEST_LNS';
387: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CHANGE_REQUEST_PVT.CREATE_CHANGE_REQUEST_LINES';
388: l_debug_enabled VARCHAR2(10);

Line 497: ,x_request_status OUT NOCOPY okl_vp_change_requests.status_code%TYPE

493: ,x_msg_count OUT NOCOPY NUMBER
494: ,x_msg_data OUT NOCOPY VARCHAR2
495: ,p_vrrv_tbl IN vrrv_tbl_type
496: ,x_vrrv_tbl OUT NOCOPY vrrv_tbl_type
497: ,x_request_status OUT NOCOPY okl_vp_change_requests.status_code%TYPE
498: ) IS
499: lv_crs_id okl_vp_change_requests.id%TYPE;
500: l_api_version CONSTANT NUMBER DEFAULT 1.0;
501: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'UPDATE_CHANGE_REQUEST_LNS';

Line 499: lv_crs_id okl_vp_change_requests.id%TYPE;

495: ,p_vrrv_tbl IN vrrv_tbl_type
496: ,x_vrrv_tbl OUT NOCOPY vrrv_tbl_type
497: ,x_request_status OUT NOCOPY okl_vp_change_requests.status_code%TYPE
498: ) IS
499: lv_crs_id okl_vp_change_requests.id%TYPE;
500: l_api_version CONSTANT NUMBER DEFAULT 1.0;
501: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'UPDATE_CHANGE_REQUEST_LNS';
502: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CHANGE_REQUEST_PVT.UPDATE_CHANGE_REQUEST_LINES';
503: l_debug_enabled VARCHAR2(10);

Line 611: ,x_request_status OUT NOCOPY okl_vp_change_requests.status_code%TYPE

607: ,x_return_status OUT NOCOPY VARCHAR2
608: ,x_msg_count OUT NOCOPY NUMBER
609: ,x_msg_data OUT NOCOPY VARCHAR2
610: ,p_vrrv_tbl IN vrrv_tbl_type
611: ,x_request_status OUT NOCOPY okl_vp_change_requests.status_code%TYPE
612: ) IS
613: CURSOR c_get_more_reasons_csr(cp_creq_id okl_vp_change_requests.id%TYPE)IS
614: SELECT 'X'
615: FROM okl_vp_cr_reasons

Line 613: CURSOR c_get_more_reasons_csr(cp_creq_id okl_vp_change_requests.id%TYPE)IS

609: ,x_msg_data OUT NOCOPY VARCHAR2
610: ,p_vrrv_tbl IN vrrv_tbl_type
611: ,x_request_status OUT NOCOPY okl_vp_change_requests.status_code%TYPE
612: ) IS
613: CURSOR c_get_more_reasons_csr(cp_creq_id okl_vp_change_requests.id%TYPE)IS
614: SELECT 'X'
615: FROM okl_vp_cr_reasons
616: WHERE crs_id = cp_creq_id;
617: lv_dummy VARCHAR2(1);

Line 618: lv_crs_id okl_vp_change_requests.id%TYPE;

614: SELECT 'X'
615: FROM okl_vp_cr_reasons
616: WHERE crs_id = cp_creq_id;
617: lv_dummy VARCHAR2(1);
618: lv_crs_id okl_vp_change_requests.id%TYPE;
619: l_api_version CONSTANT NUMBER DEFAULT 1.0;
620: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'DELETE_CHANGE_REQUEST_LNS';
621: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CHANGE_REQUEST_PVT.DELETE_CHANGE_REQUEST_LINES';
622: l_debug_enabled VARCHAR2(10);

Line 761: FROM okl_vp_change_requests creq

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');
764:
765: -- cursor to get the agreement number

Line 775: FROM okl_vp_change_requests crq

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'
778: AND crq.status_code = G_COMPLETED_STS_CODE;
779:

Line 791: x_request_status okl_vp_change_requests.status_code%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;
792: lv_vrrv_tbl vrrv_tbl_type;
793:
794: l_api_version CONSTANT NUMBER DEFAULT 1.0;
795: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CREATE_CHANGE_REQUEST';

Line 1177: ,p_vp_crq_id IN okl_vp_change_requests.id%TYPE

1173: ,p_init_msg_list IN VARCHAR2
1174: ,x_return_status OUT NOCOPY VARCHAR2
1175: ,x_msg_count OUT NOCOPY NUMBER
1176: ,x_msg_data OUT NOCOPY VARCHAR2
1177: ,p_vp_crq_id IN okl_vp_change_requests.id%TYPE
1178: ,p_status_code IN okl_vp_change_requests.status_code%TYPE
1179: ) IS
1180: -- cursor to fetch the status of the change request
1181: CURSOR c_get_cr_dtls_csr (cp_change_req_id okl_vp_change_requests.id%TYPE)IS

Line 1178: ,p_status_code IN okl_vp_change_requests.status_code%TYPE

1174: ,x_return_status OUT NOCOPY VARCHAR2
1175: ,x_msg_count OUT NOCOPY NUMBER
1176: ,x_msg_data OUT NOCOPY VARCHAR2
1177: ,p_vp_crq_id IN okl_vp_change_requests.id%TYPE
1178: ,p_status_code IN okl_vp_change_requests.status_code%TYPE
1179: ) IS
1180: -- cursor to fetch the status of the change request
1181: CURSOR c_get_cr_dtls_csr (cp_change_req_id okl_vp_change_requests.id%TYPE)IS
1182: SELECT status_code

Line 1181: CURSOR c_get_cr_dtls_csr (cp_change_req_id okl_vp_change_requests.id%TYPE)IS

1177: ,p_vp_crq_id IN okl_vp_change_requests.id%TYPE
1178: ,p_status_code IN okl_vp_change_requests.status_code%TYPE
1179: ) IS
1180: -- cursor to fetch the status of the change request
1181: CURSOR c_get_cr_dtls_csr (cp_change_req_id okl_vp_change_requests.id%TYPE)IS
1182: SELECT status_code
1183: ,change_request_number
1184: ,change_type_code
1185: ,chr_id -- this chr_id is for only ASSOCIATION type of change request

Line 1186: FROM okl_vp_change_requests

1182: SELECT status_code
1183: ,change_request_number
1184: ,change_type_code
1185: ,chr_id -- this chr_id is for only ASSOCIATION type of change request
1186: FROM okl_vp_change_requests
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

Line 1192: CURSOR c_get_creq_chr_id_csr (cp_change_req_id okl_vp_change_requests.id%TYPE)IS

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
1196: WHERE chr.id = khr.id

Line 1370: ,p_vp_crq_id IN okl_vp_change_requests.id%TYPE

1366: ,p_init_msg_list IN VARCHAR2
1367: ,x_return_status OUT NOCOPY VARCHAR2
1368: ,x_msg_count OUT NOCOPY NUMBER
1369: ,x_msg_data OUT NOCOPY VARCHAR2
1370: ,p_vp_crq_id IN okl_vp_change_requests.id%TYPE
1371: ,x_status_code OUT NOCOPY okl_vp_change_requests.status_code%TYPE
1372: ) IS
1373: -- cursor to fetch the status of the change request
1374: CURSOR c_get_cr_sts_csr (cp_change_req_id okl_vp_change_requests.id%TYPE)IS

Line 1371: ,x_status_code OUT NOCOPY okl_vp_change_requests.status_code%TYPE

1367: ,x_return_status OUT NOCOPY VARCHAR2
1368: ,x_msg_count OUT NOCOPY NUMBER
1369: ,x_msg_data OUT NOCOPY VARCHAR2
1370: ,p_vp_crq_id IN okl_vp_change_requests.id%TYPE
1371: ,x_status_code OUT NOCOPY okl_vp_change_requests.status_code%TYPE
1372: ) IS
1373: -- cursor to fetch the status of the change request
1374: CURSOR c_get_cr_sts_csr (cp_change_req_id okl_vp_change_requests.id%TYPE)IS
1375: SELECT status_code

Line 1374: CURSOR c_get_cr_sts_csr (cp_change_req_id okl_vp_change_requests.id%TYPE)IS

1370: ,p_vp_crq_id IN okl_vp_change_requests.id%TYPE
1371: ,x_status_code OUT NOCOPY okl_vp_change_requests.status_code%TYPE
1372: ) IS
1373: -- cursor to fetch the status of the change request
1374: CURSOR c_get_cr_sts_csr (cp_change_req_id okl_vp_change_requests.id%TYPE)IS
1375: SELECT status_code
1376: FROM okl_vp_change_requests
1377: WHERE id = cp_change_req_id;
1378: c_get_cr_sts_rec c_get_cr_sts_csr%ROWTYPE;

Line 1376: FROM okl_vp_change_requests

1372: ) IS
1373: -- cursor to fetch the status of the change request
1374: CURSOR c_get_cr_sts_csr (cp_change_req_id okl_vp_change_requests.id%TYPE)IS
1375: SELECT status_code
1376: FROM okl_vp_change_requests
1377: WHERE id = cp_change_req_id;
1378: c_get_cr_sts_rec c_get_cr_sts_csr%ROWTYPE;
1379:
1380: lv_vcrv_rec vcrv_rec_type;

Line 1488: ,x_status_code OUT NOCOPY okl_vp_change_requests.status_code%TYPE

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
1492: CURSOR c_get_change_req_csr(cp_chr_id okl_k_headers.id%TYPE)IS

Line 1494: FROM okl_vp_change_requests

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;
1497: lv_change_request_id okl_vp_change_requests.id%TYPE;
1498:

Line 1497: lv_change_request_id okl_vp_change_requests.id%TYPE;

1493: SELECT id
1494: FROM okl_vp_change_requests
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

Line 1674: FUNCTION get_assoc_agr_number(p_change_request_id IN okl_vp_change_requests.id%TYPE) RETURN VARCHAR2 IS

1670: x_msg_data => x_msg_data,
1671: p_api_type => g_api_type);
1672: END submit_cr_for_approval;
1673:
1674: FUNCTION get_assoc_agr_number(p_change_request_id IN okl_vp_change_requests.id%TYPE) RETURN VARCHAR2 IS
1675: CURSOR c_get_chreq_csr (cp_ch_req_id okl_vp_change_requests.id%TYPE) IS
1676: SELECT chr_id
1677: ,change_type_code
1678: ,status_code

Line 1675: CURSOR c_get_chreq_csr (cp_ch_req_id okl_vp_change_requests.id%TYPE) IS

1671: p_api_type => g_api_type);
1672: END submit_cr_for_approval;
1673:
1674: FUNCTION get_assoc_agr_number(p_change_request_id IN okl_vp_change_requests.id%TYPE) RETURN VARCHAR2 IS
1675: CURSOR c_get_chreq_csr (cp_ch_req_id okl_vp_change_requests.id%TYPE) IS
1676: SELECT chr_id
1677: ,change_type_code
1678: ,status_code
1679: FROM okl_vp_change_requests

Line 1679: FROM okl_vp_change_requests

1675: CURSOR c_get_chreq_csr (cp_ch_req_id okl_vp_change_requests.id%TYPE) IS
1676: SELECT chr_id
1677: ,change_type_code
1678: ,status_code
1679: FROM okl_vp_change_requests
1680: WHERE id = cp_ch_req_id;
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

Line 1683: CURSOR c_get_chr_num_csr(cp_ch_req_id okl_vp_change_requests.id%TYPE) IS

1679: FROM okl_vp_change_requests
1680: WHERE id = cp_ch_req_id;
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

Line 1729: FUNCTION get_assoc_agr_id(p_change_request_id IN okl_vp_change_requests.id%TYPE) RETURN NUMBER IS

1725: END IF; -- end of p_change_request_id IS NOT NULL AND p_change_request_id <> OKL_API.G_MISS_NUM
1726: RETURN lv_ageement_number;
1727: END get_assoc_agr_number;
1728:
1729: FUNCTION get_assoc_agr_id(p_change_request_id IN okl_vp_change_requests.id%TYPE) RETURN NUMBER IS
1730: CURSOR c_get_chreq_csr (cp_ch_req_id okl_vp_change_requests.id%TYPE) IS
1731: SELECT chr_id
1732: ,change_type_code
1733: ,status_code

Line 1730: CURSOR c_get_chreq_csr (cp_ch_req_id okl_vp_change_requests.id%TYPE) IS

1726: RETURN lv_ageement_number;
1727: END get_assoc_agr_number;
1728:
1729: FUNCTION get_assoc_agr_id(p_change_request_id IN okl_vp_change_requests.id%TYPE) RETURN NUMBER IS
1730: CURSOR c_get_chreq_csr (cp_ch_req_id okl_vp_change_requests.id%TYPE) IS
1731: SELECT chr_id
1732: ,change_type_code
1733: ,status_code
1734: FROM okl_vp_change_requests

Line 1734: FROM okl_vp_change_requests

1730: CURSOR c_get_chreq_csr (cp_ch_req_id okl_vp_change_requests.id%TYPE) IS
1731: SELECT chr_id
1732: ,change_type_code
1733: ,status_code
1734: FROM okl_vp_change_requests
1735: WHERE id = cp_ch_req_id;
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

Line 1738: CURSOR c_get_chr_id_csr(cp_ch_req_id okl_vp_change_requests.id%TYPE) IS

1734: FROM okl_vp_change_requests
1735: WHERE id = cp_ch_req_id;
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