APPS.OKL_SETUPCONTEXTGROUPS_PVT dependencies on OKL_CONTEXT_GROUPS_V

Line 5: -- PROCEDURE get_rec for: OKL_CONTEXT_GROUPS_V

1: PACKAGE BODY OKL_SETUPCONTEXTGROUPS_PVT AS
2: /* $Header: OKLRSCGB.pls 115.2 2002/07/17 23:20:46 santonyr noship $ */
3:
4: ---------------------------------------------------------------------------
5: -- PROCEDURE get_rec for: OKL_CONTEXT_GROUPS_V
6: ---------------------------------------------------------------------------
7: PROCEDURE get_rec (
8: p_cgrv_rec IN cgrv_rec_type,
9: x_return_status OUT NOCOPY VARCHAR2,

Line 25: FROM Okl_Context_Groups_V

21: CREATION_DATE,
22: LAST_UPDATED_BY,
23: LAST_UPDATE_DATE,
24: NVL(LAST_UPDATE_LOGIN, OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN
25: FROM Okl_Context_Groups_V
26: WHERE okl_Context_Groups_V.id = p_id;
27: l_okl_cgrv_pk okl_cgrv_pk_csr%ROWTYPE;
28: l_cgrv_rec cgrv_rec_type;
29: BEGIN

Line 26: WHERE okl_Context_Groups_V.id = p_id;

22: LAST_UPDATED_BY,
23: LAST_UPDATE_DATE,
24: NVL(LAST_UPDATE_LOGIN, OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN
25: FROM Okl_Context_Groups_V
26: WHERE okl_Context_Groups_V.id = p_id;
27: l_okl_cgrv_pk okl_cgrv_pk_csr%ROWTYPE;
28: l_cgrv_rec cgrv_rec_type;
29: BEGIN
30: x_return_status := OKL_API.G_RET_STS_SUCCESS;