1: PACKAGE BODY OKL_SETUPCGRPARAMETERS_PVT AS
2: /* $Header: OKLRSCMB.pls 120.1 2005/06/03 05:30:33 rirawat noship $ */
3:
4: ---------------------------------------------------------------------------
5: -- PROCEDURE get_rec for: OKL_CNTX_GRP_PRMTRS_V
6: ---------------------------------------------------------------------------
7: PROCEDURE get_rec (
8: p_cgmv_rec IN cgmv_rec_type,
9: x_return_status OUT NOCOPY VARCHAR2,
20: CREATION_DATE,
21: LAST_UPDATED_BY,
22: LAST_UPDATE_DATE,
23: NVL(LAST_UPDATE_LOGIN, OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN
24: FROM Okl_Cntx_Grp_Prmtrs_V
25: WHERE okl_Cntx_Grp_Prmtrs_V.id = p_id;
26: l_okl_cgmv_pk okl_cgmv_pk_csr%ROWTYPE;
27: l_cgmv_rec cgmv_rec_type;
28: BEGIN
21: LAST_UPDATED_BY,
22: LAST_UPDATE_DATE,
23: NVL(LAST_UPDATE_LOGIN, OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN
24: FROM Okl_Cntx_Grp_Prmtrs_V
25: WHERE okl_Cntx_Grp_Prmtrs_V.id = p_id;
26: l_okl_cgmv_pk okl_cgmv_pk_csr%ROWTYPE;
27: l_cgmv_rec cgmv_rec_type;
28: BEGIN
29: x_return_status := OKL_API.G_RET_STS_SUCCESS;
62:
63: END get_rec;
64:
65: ---------------------------------------------------------------------------
66: -- PROCEDURE check_context_groups for: OKL_CNTX_GRP_PRMTRS_V
67: -- To verify whether context group under consideration is being attached to
68: -- any formula
69: ---------------------------------------------------------------------------
70: PROCEDURE check_context_groups (
120:
121: END check_context_groups;
122:
123: ---------------------------------------------------------------------------
124: -- PROCEDURE insert_cgrparameters for: OKL_CNTX_GRP_PRMTRS_V
125: ---------------------------------------------------------------------------
126: PROCEDURE insert_cgrparameters(p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
128: x_return_status OUT NOCOPY VARCHAR2,
194:
195: END insert_cgrparameters;
196:
197: ---------------------------------------------------------------------------
198: -- PROCEDURE update_cgrparameters for: OKL_CNTX_GRP_PRMTRS_V
199: ---------------------------------------------------------------------------
200: PROCEDURE update_cgrparameters(p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
202: x_return_status OUT NOCOPY VARCHAR2,
283: END update_cgrparameters;
284:
285:
286: ---------------------------------------------------------------------------
287: -- PROCEDURE delete_cgrparameters for: OKL_CNTX_GRP_PRMTRS_V
288: -- This allows the user to delete table of records
289: ---------------------------------------------------------------------------
290: PROCEDURE delete_cgrparameters(p_api_version IN NUMBER,
291: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
389: p_api_type => '_PVT');
390:
391: END delete_cgrparameters;
392:
393: -- rirawat 03-Feb-05 4149748: Added the following procedure to insert into OKL_CNTX_GRP_PRMTRS_V - TBL : begin
394: ---------------------------------------------------------------------------
395: -- PROCEDURE insert_cgrparameters for: OKL_CNTX_GRP_PRMTRS_V
396: ---------------------------------------------------------------------------
397: PROCEDURE insert_cgrparameters(p_api_version IN NUMBER,
391: END delete_cgrparameters;
392:
393: -- rirawat 03-Feb-05 4149748: Added the following procedure to insert into OKL_CNTX_GRP_PRMTRS_V - TBL : begin
394: ---------------------------------------------------------------------------
395: -- PROCEDURE insert_cgrparameters for: OKL_CNTX_GRP_PRMTRS_V
396: ---------------------------------------------------------------------------
397: PROCEDURE insert_cgrparameters(p_api_version IN NUMBER,
398: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
399: x_return_status OUT NOCOPY VARCHAR2,
473: x_msg_data => x_msg_data,
474: p_api_type => '_PVT');
475:
476: END insert_cgrparameters;
477: -- rirawat 03-Feb-05 4149748: Added the following procedure to insert into OKL_CNTX_GRP_PRMTRS_V - TBL : end
478:
479: -- rirawat 03-Feb-05 4149748: Added the following procedure to update into OKL_CNTX_GRP_PRMTRS_V - TBL : begin
480: ---------------------------------------------------------------------------
481: -- PROCEDURE update_cgrparameters for: OKL_CNTX_GRP_PRMTRS_V
475:
476: END insert_cgrparameters;
477: -- rirawat 03-Feb-05 4149748: Added the following procedure to insert into OKL_CNTX_GRP_PRMTRS_V - TBL : end
478:
479: -- rirawat 03-Feb-05 4149748: Added the following procedure to update into OKL_CNTX_GRP_PRMTRS_V - TBL : begin
480: ---------------------------------------------------------------------------
481: -- PROCEDURE update_cgrparameters for: OKL_CNTX_GRP_PRMTRS_V
482: ---------------------------------------------------------------------------
483: PROCEDURE update_cgrparameters(p_api_version IN NUMBER,
477: -- rirawat 03-Feb-05 4149748: Added the following procedure to insert into OKL_CNTX_GRP_PRMTRS_V - TBL : end
478:
479: -- rirawat 03-Feb-05 4149748: Added the following procedure to update into OKL_CNTX_GRP_PRMTRS_V - TBL : begin
480: ---------------------------------------------------------------------------
481: -- PROCEDURE update_cgrparameters for: OKL_CNTX_GRP_PRMTRS_V
482: ---------------------------------------------------------------------------
483: PROCEDURE update_cgrparameters(p_api_version IN NUMBER,
484: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
485: x_return_status OUT NOCOPY VARCHAR2,
576: p_api_type => '_PVT');
577:
578: END update_cgrparameters;
579:
580: -- rirawat 03-Feb-05 4149748: Added the following procedure to update into OKL_CNTX_GRP_PRMTRS_V - TBL : end
581:
582:
583: END OKL_SETUPCGRPARAMETERS_PVT;