[Home] [Help]
PACKAGE: APPS.OKL_SETUPOVERULES_PUB
Source
1 PACKAGE OKL_SETUPOVERULES_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPSODS.pls 115.1 2002/02/06 20:29:57 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_SETUPOVERULES_PUB';
13
14 SUBTYPE optv_rec_type IS okl_setupoverules_pvt.optv_rec_type;
15 SUBTYPE optv_tbl_type IS okl_setupoverules_pvt.optv_tbl_type;
16 SUBTYPE ovev_rec_type IS okl_setupoverules_pvt.ovev_rec_type;
17 SUBTYPE ovev_tbl_type IS okl_setupoverules_pvt.ovev_tbl_type;
18 SUBTYPE ovdv_rec_type IS okl_setupoverules_pvt.ovdv_rec_type;
19 SUBTYPE ovdv_tbl_type IS okl_setupoverules_pvt.ovdv_tbl_type;
20
21 PROCEDURE get_rec(
22 p_ovdv_rec IN ovdv_rec_type,
23 x_return_status OUT NOCOPY VARCHAR2,
24 x_msg_data OUT NOCOPY VARCHAR2,
25 x_no_data_found OUT NOCOPY BOOLEAN,
26 x_ovdv_rec OUT NOCOPY ovdv_rec_type);
27
28 PROCEDURE insert_overules(
29 p_api_version IN NUMBER,
30 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
31 x_return_status OUT NOCOPY VARCHAR2,
32 x_msg_count OUT NOCOPY NUMBER,
33 x_msg_data OUT NOCOPY VARCHAR2,
34 p_optv_rec IN optv_rec_type,
35 p_ovev_rec IN ovev_rec_type,
36 p_ovdv_rec IN ovdv_rec_type,
37 x_ovdv_rec OUT NOCOPY ovdv_rec_type);
38
39 PROCEDURE delete_overules(
40 p_api_version IN NUMBER,
41 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2,
45 p_optv_rec IN optv_rec_type,
46 p_ovev_rec IN ovev_rec_type,
47 p_ovdv_tbl IN ovdv_tbl_type);
48
49 END OKL_SETUPOVERULES_PUB;