[Home] [Help]
PACKAGE: APPS.OKL_PDT_STYS_PUB
Source
1 PACKAGE OKL_PDT_STYS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPPSYS.pls 115.2 2002/05/15 09:11:28 pkm ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL VARIABLES
5 ---------------------------------------------------------------------------
6 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
7 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
8 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
9
10 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
11 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_PQY_VALUES_PUB';
12
13 SUBTYPE psyv_rec_type IS okl_psy_pvt.psyv_rec_type;
14 SUBTYPE psyv_tbl_type IS okl_psy_pvt.psyv_tbl_type;
15
16 PROCEDURE add_language;
17
18 PROCEDURE insert_pdt_stys(
19 p_api_version IN NUMBER,
20 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
21 x_return_status OUT NOCOPY VARCHAR2,
22 x_msg_count OUT NOCOPY NUMBER,
23 x_msg_data OUT NOCOPY VARCHAR2,
24 p_psyv_rec IN psyv_rec_type,
25 x_psyv_rec OUT NOCOPY psyv_rec_type);
26
27 PROCEDURE insert_pdt_stys(
28 p_api_version IN NUMBER,
29 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_msg_count OUT NOCOPY NUMBER,
32 x_msg_data OUT NOCOPY VARCHAR2,
33 p_psyv_tbl IN psyv_tbl_type,
34 x_psyv_tbl OUT NOCOPY psyv_tbl_type);
35
36 PROCEDURE lock_pdt_stys(
37 p_api_version IN NUMBER,
38 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_msg_count OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2,
42 p_psyv_rec IN psyv_rec_type);
43
44 PROCEDURE lock_pdt_stys(
45 p_api_version IN NUMBER,
46 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2,
50 p_psyv_tbl IN psyv_tbl_type);
51
52 PROCEDURE update_pdt_stys(
53 p_api_version IN NUMBER,
54 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2,
58 p_psyv_rec IN psyv_rec_type,
59 x_psyv_rec OUT NOCOPY psyv_rec_type);
60
61 PROCEDURE update_pdt_stys(
62 p_api_version IN NUMBER,
63 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2,
67 p_psyv_tbl IN psyv_tbl_type,
68 x_psyv_tbl OUT NOCOPY psyv_tbl_type);
69
70 PROCEDURE delete_pdt_stys(
71 p_api_version IN NUMBER,
72 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 p_psyv_rec IN psyv_rec_type);
77
78 PROCEDURE delete_pdt_stys(
79 p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2,
84 p_psyv_tbl IN psyv_tbl_type);
85
86 PROCEDURE validate_pdt_stys(
87 p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2,
92 p_psyv_rec IN psyv_rec_type);
93
94 PROCEDURE validate_pdt_stys(
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 p_psyv_tbl IN psyv_tbl_type);
101
102 END OKL_PDT_STYS_PUB;