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