[Home] [Help]
30: ,p_init_msg_list IN VARCHAR2
31: ,x_return_status OUT NOCOPY VARCHAR2
32: ,x_msg_count OUT NOCOPY NUMBER
33: ,x_msg_data OUT NOCOPY VARCHAR2
34: ,p_change_request_id IN okl_vp_change_requests.id%TYPE) IS
35: -- cursor that determines the change request and associated agreement details
36: -- for an AGREEMENT type of change request, the newly created agreement id is returned
37: -- and for ASSOCIATION type of change request, the original agreement id is returned.
38: CURSOR c_get_cr_details_csr (cp_change_request_id okl_vp_change_requests.id%TYPE)IS
34: ,p_change_request_id IN okl_vp_change_requests.id%TYPE) IS
35: -- cursor that determines the change request and associated agreement details
36: -- for an AGREEMENT type of change request, the newly created agreement id is returned
37: -- and for ASSOCIATION type of change request, the original agreement id is returned.
38: CURSOR c_get_cr_details_csr (cp_change_request_id okl_vp_change_requests.id%TYPE)IS
39: SELECT creq.change_type_code
40: ,creq.status_code
41: ,change_request_number
42: ,creq.chr_id orig_agr_chr_id
40: ,creq.status_code
41: ,change_request_number
42: ,creq.chr_id orig_agr_chr_id
43: ,chr.scs_code agreement_category
44: FROM okl_vp_change_requests creq
45: ,okc_k_headers_b chr
46: WHERE creq.id = cp_change_request_id
47: AND creq.chr_id = chr.id;
48:
47: AND creq.chr_id = chr.id;
48:
49: -- cursor to find out the agreement id that was created for the change request. this agreement id
50: -- is not the parent agreement id, but the one that was created using the copy api
51: CURSOR c_get_creq_chr_id (cp_change_request_id okl_vp_change_requests.id%TYPE)IS
52: SELECT id
53: FROM okl_k_headers
54: WHERE crs_id = cp_change_request_id;
55:
1757: ,x_msg_count OUT NOCOPY NUMBER
1758: ,x_msg_data OUT NOCOPY VARCHAR2
1759: ,p_orig_chr_id IN okc_k_headers_b.id%TYPE
1760: ,p_creq_chr_id IN okc_k_headers_b.id%TYPE
1761: ,p_change_request_id IN okl_vp_change_requests.id%TYPE
1762: ) IS
1763:
1764: -- cursor to get all the associations for the given change request
1765: CURSOR c_get_creq_assoc(cp_chr_id okc_k_headers_b.id%TYPE
1762: ) IS
1763:
1764: -- cursor to get all the associations for the given change request
1765: CURSOR c_get_creq_assoc(cp_chr_id okc_k_headers_b.id%TYPE
1766: ,cp_change_request_id okl_vp_change_requests.id%TYPE
1767: ,cp_assoc_object_id okl_vp_associations.assoc_object_id%TYPE
1768: ,cp_assoc_object_code okl_vp_associations.assoc_object_type_code%TYPE
1769: ,cp_assoc_object_version okl_vp_associations.assoc_object_version%TYPE
1770: )IS
1797: FROM okl_vp_associations
1798: WHERE crs_id IS NULL
1799: AND chr_id = cp_chr_id;
1800:
1801: CURSOR c_new_creq_assoc_csr(cp_change_request_id okl_vp_change_requests.id%TYPE
1802: ,cp_chr_id okc_k_headers_b.id%TYPE) IS
1803: SELECT creq.chr_id
1804: ,creq.crs_id
1805: ,creq.start_date
2002: ,x_msg_count OUT NOCOPY NUMBER
2003: ,x_msg_data OUT NOCOPY VARCHAR2
2004: ,p_orig_chr_id IN okc_k_headers_b.id%TYPE
2005: ,p_creq_chr_id IN okc_k_headers_b.id%TYPE
2006: ,p_change_request_id IN okl_vp_change_requests.id%TYPE
2007: ) IS
2008:
2009: -- cursor to get all the associations for the given change request of type AGREEMENT
2010: CURSOR c_get_creq_assoc(cp_chr_id okc_k_headers_b.id%TYPE
2040: FROM okl_vp_associations
2041: WHERE crs_id IS NULL
2042: AND chr_id = cp_chr_id;
2043:
2044: CURSOR c_new_creq_assoc_csr(cp_chr_id_orig okl_vp_change_requests.id%TYPE
2045: ,cp_chr_id_creq okc_k_headers_b.id%TYPE) IS
2046: SELECT creq.chr_id
2047: ,creq.crs_id
2048: ,creq.start_date