[Home] [Help]
PACKAGE: APPS.OKL_SETUPPDTTEMPLATES_PUB
Source
1 PACKAGE OKL_SETUPPDTTEMPLATES_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPSPTS.pls 120.5 2008/02/29 10:14:34 veramach 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_SETUPPDTTEMPLATES_PUB';
13
14 SUBTYPE ptlv_rec_type IS okl_setuppdttemplates_pvt.ptlv_rec_type;
15 SUBTYPE ptlv_tbl_type IS okl_setuppdttemplates_pvt.ptlv_tbl_type;
16
17 PROCEDURE get_rec(
18 p_ptlv_rec IN ptlv_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_ptlv_rec OUT NOCOPY ptlv_rec_type);
23
24 PROCEDURE insert_pdttemplates(
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_ptlv_rec IN ptlv_rec_type,
31 x_ptlv_rec OUT NOCOPY ptlv_rec_type);
32
33 PROCEDURE update_pdttemplates(
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_ptlv_rec IN ptlv_rec_type,
40 x_ptlv_rec OUT NOCOPY ptlv_rec_type);
41
42 END OKL_SETUPPDTTEMPLATES_PUB;