DBA Data[Home] [Help]

APPS.OKL_SETUPCGRPARAMETERS_PVT dependencies on OKL_CNTX_GRP_PRMTRS_V

Line 5: -- PROCEDURE get_rec for: OKL_CNTX_GRP_PRMTRS_V

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,

Line 24: FROM Okl_Cntx_Grp_Prmtrs_V

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

Line 25: WHERE okl_Cntx_Grp_Prmtrs_V.id = p_id;

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;

Line 66: -- PROCEDURE check_context_groups for: OKL_CNTX_GRP_PRMTRS_V

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 (

Line 124: -- PROCEDURE insert_cgrparameters for: OKL_CNTX_GRP_PRMTRS_V

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,

Line 198: -- PROCEDURE update_cgrparameters for: OKL_CNTX_GRP_PRMTRS_V

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,

Line 287: -- PROCEDURE delete_cgrparameters for: OKL_CNTX_GRP_PRMTRS_V

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,

Line 393: -- rirawat 03-Feb-05 4149748: Added the following procedure to insert into OKL_CNTX_GRP_PRMTRS_V - TBL : begin

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,

Line 395: -- PROCEDURE insert_cgrparameters for: OKL_CNTX_GRP_PRMTRS_V

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,

Line 477: -- rirawat 03-Feb-05 4149748: Added the following procedure to insert into OKL_CNTX_GRP_PRMTRS_V - TBL : end

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

Line 479: -- rirawat 03-Feb-05 4149748: Added the following procedure to update into OKL_CNTX_GRP_PRMTRS_V - TBL : begin

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,

Line 481: -- PROCEDURE update_cgrparameters for: OKL_CNTX_GRP_PRMTRS_V

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,

Line 580: -- rirawat 03-Feb-05 4149748: Added the following procedure to update into OKL_CNTX_GRP_PRMTRS_V - TBL : end

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;