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_VENDOR_PROGRAM_PVT dependencies on OKL_VP_CHANGE_REQUESTS

Line 1639: l_cr_id OKL_VP_CHANGE_REQUESTS.ID%TYPE := NULL;

1635: x_msg_data OUT NOCOPY VARCHAR2,
1636: p_program_id IN OKC_K_HEADERS_V.ID%TYPE) IS
1637:
1638: l_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := NULL;
1639: l_cr_id OKL_VP_CHANGE_REQUESTS.ID%TYPE := NULL;
1640: l_cr_ret_sts_code okl_vp_change_requests.status_code%TYPE := NULL;
1641: l_cr_status_code okl_vp_change_requests.status_code%TYPE := NULL;
1642: l_cr_type okl_vp_change_requests.change_type_code%TYPE := NULL;
1643: l_incomplete_status_code OKC_K_HEADERS_V.STS_CODE%TYPE := 'INCOMPLETE';

Line 1640: l_cr_ret_sts_code okl_vp_change_requests.status_code%TYPE := NULL;

1636: p_program_id IN OKC_K_HEADERS_V.ID%TYPE) IS
1637:
1638: l_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := NULL;
1639: l_cr_id OKL_VP_CHANGE_REQUESTS.ID%TYPE := NULL;
1640: l_cr_ret_sts_code okl_vp_change_requests.status_code%TYPE := NULL;
1641: l_cr_status_code okl_vp_change_requests.status_code%TYPE := NULL;
1642: l_cr_type okl_vp_change_requests.change_type_code%TYPE := NULL;
1643: l_incomplete_status_code OKC_K_HEADERS_V.STS_CODE%TYPE := 'INCOMPLETE';
1644:

Line 1641: l_cr_status_code okl_vp_change_requests.status_code%TYPE := NULL;

1637:
1638: l_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := NULL;
1639: l_cr_id OKL_VP_CHANGE_REQUESTS.ID%TYPE := NULL;
1640: l_cr_ret_sts_code okl_vp_change_requests.status_code%TYPE := NULL;
1641: l_cr_status_code okl_vp_change_requests.status_code%TYPE := NULL;
1642: l_cr_type okl_vp_change_requests.change_type_code%TYPE := NULL;
1643: l_incomplete_status_code OKC_K_HEADERS_V.STS_CODE%TYPE := 'INCOMPLETE';
1644:
1645: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1642: l_cr_type okl_vp_change_requests.change_type_code%TYPE := NULL;

1638: l_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := NULL;
1639: l_cr_id OKL_VP_CHANGE_REQUESTS.ID%TYPE := NULL;
1640: l_cr_ret_sts_code okl_vp_change_requests.status_code%TYPE := NULL;
1641: l_cr_status_code okl_vp_change_requests.status_code%TYPE := NULL;
1642: l_cr_type okl_vp_change_requests.change_type_code%TYPE := NULL;
1643: l_incomplete_status_code OKC_K_HEADERS_V.STS_CODE%TYPE := 'INCOMPLETE';
1644:
1645: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1646:

Line 1662: FROM OKL_VP_CHANGE_REQUESTS

1658:
1659: -- cursor to get the corresponding Change Request record
1660: CURSOR l_cr_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) is
1661: SELECT id, status_code, change_type_code
1662: FROM OKL_VP_CHANGE_REQUESTS
1663: WHERE id = (SELECT crs_id FROM okl_k_headers WHERE id = p_chr_id);
1664:
1665: BEGIN
1666: