[Home] [Help]
PACKAGE: APPS.OKL_SETUPCGRPARAMETERS_PVT
Source
1 PACKAGE OKL_SETUPCGRPARAMETERS_PVT AS
2 /* $Header: OKLRSCMS.pls 120.1 2005/06/03 05:30:48 rirawat noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL VARIABLES
6 ---------------------------------------------------------------------------
7 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
8 G_IN_USE CONSTANT VARCHAR2(200) := 'OKL_IN_USE';
9
10 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
11 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
12 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
13 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
14
15 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
16 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPCGRPARAMETERS_PVT';
17
18 G_EXCEPTION_HALT_PROCESSING EXCEPTION;
19
20 SUBTYPE cgmv_rec_type IS okl_cntx_grp_prmtrs_pub.cgmv_rec_type;
21 SUBTYPE cgmv_tbl_type IS okl_cntx_grp_prmtrs_pub.cgmv_tbl_type;
22
23 PROCEDURE get_rec(
24 p_cgmv_rec IN cgmv_rec_type,
25 x_return_status OUT NOCOPY VARCHAR2,
26 x_no_data_found OUT NOCOPY BOOLEAN,
27 x_cgmv_rec OUT NOCOPY cgmv_rec_type);
28
29 PROCEDURE insert_cgrparameters(
30 p_api_version IN NUMBER,
31 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
32 x_return_status OUT NOCOPY VARCHAR2,
33 x_msg_count OUT NOCOPY NUMBER,
34 x_msg_data OUT NOCOPY VARCHAR2,
35 p_cgmv_rec IN cgmv_rec_type,
36 x_cgmv_rec OUT NOCOPY cgmv_rec_type);
37
38 PROCEDURE update_cgrparameters(
39 p_api_version IN NUMBER,
40 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2,
44 p_cgmv_rec IN cgmv_rec_type,
45 x_cgmv_rec OUT NOCOPY cgmv_rec_type);
46
47 PROCEDURE delete_cgrparameters(
48 p_api_version IN NUMBER,
49 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_msg_count OUT NOCOPY NUMBER,
52 x_msg_data OUT NOCOPY VARCHAR2,
53 p_cgmv_tbl IN cgmv_tbl_type);
54
55 -- rirawat 03-Feb-05 4149748: Added the following procedure to insert into OKL_CNTX_GRP_PRMTRS_V - TBL : begin
56 PROCEDURE insert_cgrparameters(
57 p_api_version IN NUMBER,
58 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 p_cgmv_tbl IN cgmv_tbl_type,
63 x_cgmv_tbl OUT NOCOPY cgmv_tbl_type);
64
65 -- rirawat 03-Feb-05 4149748: Added the following procedure to insert into OKL_CNTX_GRP_PRMTRS_V - TBL : end
66
67 -- rirawat 03-Feb-05 4149748: Added the following procedure to update into OKL_CNTX_GRP_PRMTRS_V - TBL : begin
68 PROCEDURE update_cgrparameters(
69 p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2,
74 p_cgmv_tbl IN cgmv_tbl_type,
75 x_cgmv_tbl OUT NOCOPY cgmv_tbl_type);
76 -- rirawat 03-Feb-05 4149748: Added the following procedure to update into OKL_CNTX_GRP_PRMTRS_V - TBL : end
77
78
79 END OKL_SETUPCGRPARAMETERS_PVT;