APPS.OKL_SETUPCONTEXTGROUPS_PVT dependencies on OKL_API

Line 19: NVL(DESCRIPTION, OKL_API.G_MISS_CHAR) DESCRIPTION,

15: ID,
16: OBJECT_VERSION_NUMBER,
17: SFWT_FLAG,
18: NAME,
19: NVL(DESCRIPTION, OKL_API.G_MISS_CHAR) DESCRIPTION,
20: CREATED_BY,
21: CREATION_DATE,
22: LAST_UPDATED_BY,
23: LAST_UPDATE_DATE,

Line 24: NVL(LAST_UPDATE_LOGIN, OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN

20: CREATED_BY,
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;

Line 30: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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;
31: x_no_data_found := TRUE;
32:
33: -- Get current database values
34: OPEN okl_cgrv_pk_csr (p_cgrv_rec.id);

Line 52: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

48: x_cgrv_rec := l_cgrv_rec;
49: EXCEPTION
50: WHEN OTHERS THEN
51: -- store SQL error message on message stack
52: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
53: p_msg_name => G_UNEXPECTED_ERROR,
54: p_token1 => G_SQLCODE_TOKEN,
55: p_token1_value => sqlcode,
56: p_token2 => G_SQLERRM_TOKEN,

Line 59: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

55: p_token1_value => sqlcode,
56: p_token2 => G_SQLERRM_TOKEN,
57: p_token2_value => sqlerrm);
58: -- notify UNEXPECTED error for calling API.
59: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
60:
61: IF (okl_cgrv_pk_csr%ISOPEN) THEN
62: CLOSE okl_cgrv_pk_csr;
63: END IF;

Line 71: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

67: ---------------------------------------------------------------------------
68: -- PROCEDURE insert_contextgroups for: OKL_FMLA_OPRNDS_V
69: ---------------------------------------------------------------------------
70: PROCEDURE insert_contextgroups(p_api_version IN NUMBER,
71: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
72: x_return_status OUT NOCOPY VARCHAR2,
73: x_msg_count OUT NOCOPY NUMBER,
74: x_msg_data OUT NOCOPY VARCHAR2,
75: p_cgrv_rec IN cgrv_rec_type,

Line 146: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

142: ---------------------------------------------------------------------------
143: -- PROCEDURE update_contextgroups for: OKL_FMLA_OPRNDS_V
144: ---------------------------------------------------------------------------
145: PROCEDURE update_contextgroups(p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,
149: x_msg_data OUT NOCOPY VARCHAR2,
150: p_cgrv_rec IN cgrv_rec_type,