[Home] [Help]
PACKAGE: APPS.OKL_SETUPCONTEXTGROUPS_PVT
Source
1 PACKAGE OKL_SETUPCONTEXTGROUPS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRSCGS.pls 115.1 2002/02/06 20:32:59 pkm ship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL VARIABLES
6 ---------------------------------------------------------------------------
7 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
8
9 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
10 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
11
12 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
13 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPCONTEXTGROUPS_PVT';
14
15 G_EXCEPTION_HALT_PROCESSING EXCEPTION;
16
17 SUBTYPE cgrv_rec_type IS okl_context_groups_pub.cgrv_rec_type;
18 SUBTYPE cgrv_tbl_type IS okl_context_groups_pub.cgrv_tbl_type;
19
20 PROCEDURE get_rec(
21 p_cgrv_rec IN cgrv_rec_type,
22 x_return_status OUT NOCOPY VARCHAR2,
23 x_no_data_found OUT NOCOPY BOOLEAN,
24 x_cgrv_rec OUT NOCOPY cgrv_rec_type);
25
26 PROCEDURE insert_contextgroups(
27 p_api_version IN NUMBER,
28 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2,
32 p_cgrv_rec IN cgrv_rec_type,
33 x_cgrv_rec OUT NOCOPY cgrv_rec_type);
34
35 PROCEDURE update_contextgroups(
36 p_api_version IN NUMBER,
37 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_msg_count OUT NOCOPY NUMBER,
40 x_msg_data OUT NOCOPY VARCHAR2,
41 p_cgrv_rec IN cgrv_rec_type,
42 x_cgrv_rec OUT NOCOPY cgrv_rec_type);
43
44 END OKL_SETUPCONTEXTGROUPS_PVT;