[Home] [Help]
PACKAGE: APPS.OKL_SETUPOVDTEMPLATES_PUB
Source
1 PACKAGE OKL_SETUPOVDTEMPLATES_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPSVTS.pls 115.1 2002/02/06 20:30:32 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_SETUPOVDTEMPLATES_PUB';
13
14 SUBTYPE optv_rec_type IS okl_setupovdtemplates_pvt.optv_rec_type;
15 SUBTYPE optv_tbl_type IS okl_setupovdtemplates_pvt.optv_tbl_type;
16 SUBTYPE ovev_rec_type IS okl_setupovdtemplates_pvt.ovev_rec_type;
17 SUBTYPE ovev_tbl_type IS okl_setupovdtemplates_pvt.ovev_tbl_type;
18 SUBTYPE ovdv_rec_type IS okl_setupovdtemplates_pvt.ovdv_rec_type;
19 SUBTYPE ovdv_tbl_type IS okl_setupovdtemplates_pvt.ovdv_tbl_type;
20 SUBTYPE ovtv_rec_type IS okl_setupovdtemplates_pvt.ovtv_rec_type;
21 SUBTYPE ovtv_tbl_type IS okl_setupovdtemplates_pvt.ovtv_tbl_type;
22
23 PROCEDURE get_rec(
24 p_ovtv_rec IN ovtv_rec_type,
25 x_return_status OUT NOCOPY VARCHAR2,
26 x_msg_data OUT NOCOPY VARCHAR2,
27 x_no_data_found OUT NOCOPY BOOLEAN,
28 x_ovtv_rec OUT NOCOPY ovtv_rec_type);
29
30 PROCEDURE insert_ovdtemplates(
31 p_api_version IN NUMBER,
32 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
33 x_return_status OUT NOCOPY VARCHAR2,
34 x_msg_count OUT NOCOPY NUMBER,
35 x_msg_data OUT NOCOPY VARCHAR2,
36 p_optv_rec IN optv_rec_type,
37 p_ovev_rec IN ovev_rec_type,
38 p_ovdv_rec IN ovdv_rec_type,
39 p_ovtv_rec IN ovtv_rec_type,
40 x_ovtv_rec OUT NOCOPY ovtv_rec_type);
41
42 PROCEDURE delete_ovdtemplates(
43 p_api_version IN NUMBER,
44 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_optv_rec IN optv_rec_type,
49 p_ovev_rec IN ovev_rec_type,
50 p_ovdv_rec IN ovdv_rec_type,
51 p_ovtv_tbl IN ovtv_tbl_type);
52
53 END OKL_SETUPOVDTEMPLATES_PUB;