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_SYNC_CR_PVT dependencies on OKL_VP_ASSOCIATIONS

Line 1767: ,cp_assoc_object_id okl_vp_associations.assoc_object_id%TYPE

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
1771: SELECT crs_id

Line 1768: ,cp_assoc_object_code okl_vp_associations.assoc_object_type_code%TYPE

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
1771: SELECT crs_id
1772: ,start_date

Line 1769: ,cp_assoc_object_version okl_vp_associations.assoc_object_version%TYPE

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
1771: SELECT crs_id
1772: ,start_date
1773: ,end_date

Line 1778: FROM okl_vp_associations

1774: ,description
1775: ,assoc_object_type_code
1776: ,assoc_object_id
1777: ,assoc_object_version
1778: FROM okl_vp_associations
1779: WHERE crs_id = cp_change_request_id
1780: AND chr_id = cp_chr_id
1781: AND assoc_object_id = cp_assoc_object_id
1782: AND assoc_object_type_code = cp_assoc_object_code

Line 1797: FROM okl_vp_associations

1793: ,assoc_object_type_code
1794: ,assoc_object_id
1795: ,assoc_object_version
1796: ,id
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

Line 1811: FROM okl_vp_associations creq

1807: ,creq.description
1808: ,creq.assoc_object_type_code
1809: ,creq.assoc_object_id
1810: ,creq.assoc_object_version
1811: FROM okl_vp_associations creq
1812: WHERE crs_id = cp_change_request_id
1813: AND NOT EXISTS (
1814: SELECT 'X'
1815: FROM okl_vp_associations orig

Line 1815: FROM okl_vp_associations orig

1811: FROM okl_vp_associations creq
1812: WHERE crs_id = cp_change_request_id
1813: AND NOT EXISTS (
1814: SELECT 'X'
1815: FROM okl_vp_associations orig
1816: WHERE orig.chr_id = cp_chr_id
1817: AND orig.crs_id IS NULL
1818: AND orig.start_date = creq.start_date
1819: AND NVL(orig.end_date, TRUNC(SYSDATE)) = NVL(creq.end_date,TRUNC(SYSDATE))

Line 1889: okl_vp_associations_pvt.update_vp_associations(p_api_version => p_api_version

1885: lv_vasv_rec.start_date := TRUNC(cv_creq_assoc_rec.start_date);
1886: lv_vasv_rec.end_date := cv_creq_assoc_rec.end_date;
1887: lv_vasv_rec.description := cv_creq_assoc_rec.description;
1888: lv_vasv_rec.chr_id := p_orig_chr_id;
1889: okl_vp_associations_pvt.update_vp_associations(p_api_version => p_api_version
1890: ,p_init_msg_list => p_init_msg_list
1891: ,x_return_status => x_return_status
1892: ,x_msg_count => x_msg_count
1893: ,x_msg_data => x_msg_data

Line 1900: 'okl_vp_associations_pvt.update_vp_associations returned with status '||x_return_status

1896: );
1897: IF(l_debug_enabled='Y') THEN
1898: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1899: l_module,
1900: 'okl_vp_associations_pvt.update_vp_associations returned with status '||x_return_status
1901: );
1902: END IF;
1903: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1904: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1914: okl_vp_associations_pvt.delete_vp_associations(p_api_version => p_api_version

1910: CLOSE c_get_creq_assoc;
1911: -- since the record is not present on the change request, delete this record from the original agreement too
1912: lv_vasv_rec := NULL;
1913: lv_vasv_rec.id := orig_assoc_rec.id;
1914: okl_vp_associations_pvt.delete_vp_associations(p_api_version => p_api_version
1915: ,p_init_msg_list => p_init_msg_list
1916: ,x_return_status => x_return_status
1917: ,x_msg_count => x_msg_count
1918: ,x_msg_data => x_msg_data

Line 1924: 'okl_vp_associations_pvt.delete_vp_associations returned with status '||x_return_status

1920: );
1921: IF(l_debug_enabled='Y') THEN
1922: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1923: l_module,
1924: 'okl_vp_associations_pvt.delete_vp_associations returned with status '||x_return_status
1925: );
1926: END IF;
1927: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1928: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1946: okl_vp_associations_pvt.create_vp_associations(p_api_version => p_api_version

1942: lv_vasv_rec.description := new_creq_rec.description;
1943: lv_vasv_rec.assoc_object_type_code := new_creq_rec.assoc_object_type_code;
1944: lv_vasv_rec.assoc_object_id := new_creq_rec.assoc_object_id;
1945: lv_vasv_rec.assoc_object_version := new_creq_rec.assoc_object_version;
1946: okl_vp_associations_pvt.create_vp_associations(p_api_version => p_api_version
1947: ,p_init_msg_list => p_init_msg_list
1948: ,x_return_status => x_return_status
1949: ,x_msg_count => x_msg_count
1950: ,x_msg_data => x_msg_data

Line 1957: 'okl_vp_associations_pvt.create_vp_associations returned with status '||x_return_status

1953: );
1954: IF(l_debug_enabled='Y') THEN
1955: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1956: l_module,
1957: 'okl_vp_associations_pvt.create_vp_associations returned with status '||x_return_status
1958: );
1959: END IF;
1960: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1961: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2011: ,cp_assoc_object_id okl_vp_associations.assoc_object_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
2011: ,cp_assoc_object_id okl_vp_associations.assoc_object_id%TYPE
2012: ,cp_assoc_object_code okl_vp_associations.assoc_object_type_code%TYPE
2013: ,cp_assoc_object_version okl_vp_associations.assoc_object_version%TYPE
2014: )IS
2015: SELECT crs_id

Line 2012: ,cp_assoc_object_code okl_vp_associations.assoc_object_type_code%TYPE

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
2011: ,cp_assoc_object_id okl_vp_associations.assoc_object_id%TYPE
2012: ,cp_assoc_object_code okl_vp_associations.assoc_object_type_code%TYPE
2013: ,cp_assoc_object_version okl_vp_associations.assoc_object_version%TYPE
2014: )IS
2015: SELECT crs_id
2016: ,start_date

Line 2013: ,cp_assoc_object_version okl_vp_associations.assoc_object_version%TYPE

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
2011: ,cp_assoc_object_id okl_vp_associations.assoc_object_id%TYPE
2012: ,cp_assoc_object_code okl_vp_associations.assoc_object_type_code%TYPE
2013: ,cp_assoc_object_version okl_vp_associations.assoc_object_version%TYPE
2014: )IS
2015: SELECT crs_id
2016: ,start_date
2017: ,end_date

Line 2022: FROM okl_vp_associations

2018: ,description
2019: ,assoc_object_type_code
2020: ,assoc_object_id
2021: ,assoc_object_version
2022: FROM okl_vp_associations
2023: WHERE chr_id = cp_chr_id
2024: AND assoc_object_id = cp_assoc_object_id
2025: AND assoc_object_type_code = cp_assoc_object_code
2026: AND nvl(assoc_object_version,1) = nvl(cp_assoc_object_version,1);

Line 2040: FROM okl_vp_associations

2036: ,assoc_object_type_code
2037: ,assoc_object_id
2038: ,assoc_object_version
2039: ,id
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

Line 2054: FROM okl_vp_associations creq

2050: ,creq.description
2051: ,creq.assoc_object_type_code
2052: ,creq.assoc_object_id
2053: ,creq.assoc_object_version
2054: FROM okl_vp_associations creq
2055: WHERE chr_id = cp_chr_id_creq
2056: AND NOT EXISTS (
2057: SELECT 'X'
2058: FROM okl_vp_associations orig

Line 2058: FROM okl_vp_associations orig

2054: FROM okl_vp_associations creq
2055: WHERE chr_id = cp_chr_id_creq
2056: AND NOT EXISTS (
2057: SELECT 'X'
2058: FROM okl_vp_associations orig
2059: WHERE orig.chr_id = cp_chr_id_orig
2060: AND orig.crs_id IS NULL
2061: AND orig.start_date = creq.start_date
2062: AND NVL(orig.end_date, TRUNC(SYSDATE)) = NVL(creq.end_date,TRUNC(SYSDATE))

Line 2126: okl_vp_associations_pvt.update_vp_associations(p_api_version => p_api_version

2122: lv_vasv_rec.start_date := TRUNC(cv_creq_assoc_rec.start_date);
2123: lv_vasv_rec.end_date := cv_creq_assoc_rec.end_date;
2124: lv_vasv_rec.description := cv_creq_assoc_rec.description;
2125: lv_vasv_rec.chr_id := p_orig_chr_id;
2126: okl_vp_associations_pvt.update_vp_associations(p_api_version => p_api_version
2127: ,p_init_msg_list => p_init_msg_list
2128: ,x_return_status => x_return_status
2129: ,x_msg_count => x_msg_count
2130: ,x_msg_data => x_msg_data

Line 2137: 'okl_vp_associations_pvt.update_vp_associations returned with status '||x_return_status

2133: );
2134: IF(l_debug_enabled='Y') THEN
2135: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
2136: l_module,
2137: 'okl_vp_associations_pvt.update_vp_associations returned with status '||x_return_status
2138: );
2139: END IF;
2140: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2141: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2151: okl_vp_associations_pvt.delete_vp_associations(p_api_version => p_api_version

2147: CLOSE c_get_creq_assoc;
2148: -- since the record is not present on the change request, delete this record from the original agreement too
2149: lv_vasv_rec := NULL;
2150: lv_vasv_rec.id := orig_assoc_rec.id;
2151: okl_vp_associations_pvt.delete_vp_associations(p_api_version => p_api_version
2152: ,p_init_msg_list => p_init_msg_list
2153: ,x_return_status => x_return_status
2154: ,x_msg_count => x_msg_count
2155: ,x_msg_data => x_msg_data

Line 2161: 'okl_vp_associations_pvt.delete_vp_associations returned with status '||x_return_status

2157: );
2158: IF(l_debug_enabled='Y') THEN
2159: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
2160: l_module,
2161: 'okl_vp_associations_pvt.delete_vp_associations returned with status '||x_return_status
2162: );
2163: END IF;
2164: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2165: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2183: okl_vp_associations_pvt.create_vp_associations(p_api_version => p_api_version

2179: lv_vasv_rec.description := new_creq_rec.description;
2180: lv_vasv_rec.assoc_object_type_code := new_creq_rec.assoc_object_type_code;
2181: lv_vasv_rec.assoc_object_id := new_creq_rec.assoc_object_id;
2182: lv_vasv_rec.assoc_object_version := new_creq_rec.assoc_object_version;
2183: okl_vp_associations_pvt.create_vp_associations(p_api_version => p_api_version
2184: ,p_init_msg_list => p_init_msg_list
2185: ,x_return_status => x_return_status
2186: ,x_msg_count => x_msg_count
2187: ,x_msg_data => x_msg_data

Line 2194: 'okl_vp_associations_pvt.create_vp_associations returned with status '||x_return_status

2190: );
2191: IF(l_debug_enabled='Y') THEN
2192: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
2193: l_module,
2194: 'okl_vp_associations_pvt.create_vp_associations returned with status '||x_return_status
2195: );
2196: END IF;
2197: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2198: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;