[Home] [Help]
PACKAGE: APPS.OKL_SETUPOPTIONS_PUB
Source
1 PACKAGE OKL_SETUPOPTIONS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPSOTS.pls 115.1 2002/02/06 20:30:04 pkm ship $ */
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_SETUPOPTIONS_PUB';
13
14 SUBTYPE optv_rec_type IS okl_setupoptions_pvt.optv_rec_type;
15 SUBTYPE optv_tbl_type IS okl_setupoptions_pvt.optv_tbl_type;
16
17 PROCEDURE get_rec(
18 p_optv_rec IN optv_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_optv_rec OUT NOCOPY optv_rec_type);
23
24 PROCEDURE insert_options(
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_optv_rec IN optv_rec_type,
31 x_optv_rec OUT NOCOPY optv_rec_type);
32
33 PROCEDURE update_options(
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_optv_rec IN optv_rec_type,
40 x_optv_rec OUT NOCOPY optv_rec_type);
41
42 END OKL_SETUPOPTIONS_PUB;