[Home] [Help]
PACKAGE: APPS.OKC_OUTCOME_PUB
Source
1 package okc_outcome_pub AUTHID CURRENT_USER as
2 /* $Header: OKCPOCES.pls 120.0 2005/05/26 09:56:15 appldev noship $ */
3
4 subtype ocev_rec_type is okc_outcome_pvt.ocev_rec_type;
5 subtype ocev_tbl_type is okc_outcome_pvt.ocev_tbl_type;
6 subtype oatv_rec_type is okc_outcome_pvt.oatv_rec_type;
7 subtype oatv_tbl_type is okc_outcome_pvt.oatv_tbl_type;
8
9 ----------------------------------------------------------------------------------
10 -- Global Variables
11 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_OUTCOME_PUB';
12 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
13 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
14 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
16
17 g_ocev_rec okc_outcome_pvt.ocev_rec_type;
18 g_ocev_tbl okc_outcome_pvt.ocev_tbl_type;
19 g_oatv_rec okc_outcome_pvt.oatv_rec_type;
20 g_oatv_tbl okc_outcome_pvt.oatv_tbl_type;
21 ----------------------------------------------------------------------------------
22 --Global Exception
23 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
24 ----------------------------------------------------------------------------------
25
26 PROCEDURE ADD_LANGUAGE;
27
28 --Object type procedure for insert
29 PROCEDURE create_outcomes_args(
30 p_api_version IN NUMBER,
31 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
32 x_return_status OUT NOCOPY VARCHAR2,
33 x_msg_count OUT NOCOPY NUMBER,
34 x_msg_data OUT NOCOPY VARCHAR2,
35 p_ocev_rec IN ocev_rec_type,
36 p_oatv_tbl IN oatv_tbl_type,
37 x_ocev_rec OUT NOCOPY ocev_rec_type,
38 x_oatv_tbl OUT NOCOPY oatv_tbl_type);
39
40 --Object type procedure for update
41 PROCEDURE update_outcomes_args(
42 p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
44 x_return_status OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_msg_data OUT NOCOPY VARCHAR2,
47 p_ocev_rec IN ocev_rec_type,
48 p_oatv_tbl IN oatv_tbl_type,
49 x_ocev_rec OUT NOCOPY ocev_rec_type,
50 x_oatv_tbl OUT NOCOPY oatv_tbl_type);
51
52 --Object type procedure for validate
53 PROCEDURE validate_outcomes_args(
54 p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2,
59 p_ocev_rec IN ocev_rec_type,
60 p_oatv_tbl IN oatv_tbl_type);
61
62 --Procedures for Outcomes
63 PROCEDURE create_outcome(
64 p_api_version IN NUMBER,
65 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2,
69 p_ocev_tbl IN ocev_tbl_type,
70 x_ocev_tbl OUT NOCOPY ocev_tbl_type);
71
72 PROCEDURE create_outcome(
73 p_api_version IN NUMBER,
74 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2,
78 p_ocev_rec IN ocev_rec_type,
79 x_ocev_rec OUT NOCOPY ocev_rec_type);
80
81 PROCEDURE lock_outcome(
82 p_api_version IN NUMBER,
83 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2,
87 p_ocev_tbl IN ocev_tbl_type);
88
89 PROCEDURE lock_outcome(
90 p_api_version IN NUMBER,
91 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY VARCHAR2,
95 p_ocev_rec IN ocev_rec_type);
96
97 PROCEDURE update_outcome(
98 p_api_version IN NUMBER,
99 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2,
103 p_ocev_tbl IN ocev_tbl_type,
104 x_ocev_tbl OUT NOCOPY ocev_tbl_type);
105
106 PROCEDURE update_outcome(
107 p_api_version IN NUMBER,
108 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111 x_msg_data OUT NOCOPY VARCHAR2,
112 p_ocev_rec IN ocev_rec_type,
113 x_ocev_rec OUT NOCOPY ocev_rec_type);
114
115 PROCEDURE delete_outcome(
116 p_api_version IN NUMBER,
117 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2,
121 p_ocev_tbl IN ocev_tbl_type);
122
123 PROCEDURE delete_outcome(
124 p_api_version IN NUMBER,
125 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2,
129 p_ocev_rec IN ocev_rec_type);
130
131 PROCEDURE validate_outcome(
132 p_api_version IN NUMBER,
133 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2,
137 p_ocev_tbl IN ocev_tbl_type);
138
139 PROCEDURE validate_outcome(
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2,
145 p_ocev_rec IN ocev_rec_type);
146
147 --Procedures for Outcome arguments
148 PROCEDURE create_out_arg(
149 p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2,
154 p_oatv_tbl IN oatv_tbl_type,
155 x_oatv_tbl OUT NOCOPY oatv_tbl_type);
156
157 PROCEDURE create_out_arg(
158 p_api_version IN NUMBER,
159 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
160 x_return_status OUT NOCOPY VARCHAR2,
161 x_msg_count OUT NOCOPY NUMBER,
162 x_msg_data OUT NOCOPY VARCHAR2,
163 p_oatv_rec IN oatv_rec_type,
164 x_oatv_rec OUT NOCOPY oatv_rec_type);
165
166 PROCEDURE lock_out_arg(
167 p_api_version IN NUMBER,
168 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2,
172 p_oatv_tbl IN oatv_tbl_type);
173
174 PROCEDURE lock_out_arg(
175 p_api_version IN NUMBER,
176 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
177 x_return_status OUT NOCOPY VARCHAR2,
178 x_msg_count OUT NOCOPY NUMBER,
179 x_msg_data OUT NOCOPY VARCHAR2,
180 p_oatv_rec IN oatv_rec_type);
181
182 PROCEDURE update_out_arg(
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
185 x_return_status OUT NOCOPY VARCHAR2,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2,
188 p_oatv_tbl IN oatv_tbl_type,
189 x_oatv_tbl OUT NOCOPY oatv_tbl_type);
190
191 PROCEDURE update_out_arg(
192 p_api_version IN NUMBER,
193 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2,
197 p_oatv_rec IN oatv_rec_type,
198 x_oatv_rec OUT NOCOPY oatv_rec_type);
199
200 PROCEDURE delete_out_arg(
201 p_api_version IN NUMBER,
202 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
203 x_return_status OUT NOCOPY VARCHAR2,
204 x_msg_count OUT NOCOPY NUMBER,
205 x_msg_data OUT NOCOPY VARCHAR2,
206 p_oatv_rec IN oatv_rec_type);
207
208 PROCEDURE delete_out_arg(
209 p_api_version IN NUMBER,
210 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
211 x_return_status OUT NOCOPY VARCHAR2,
212 x_msg_count OUT NOCOPY NUMBER,
213 x_msg_data OUT NOCOPY VARCHAR2,
214 p_oatv_tbl IN oatv_tbl_type);
215
216 PROCEDURE validate_out_arg(
217 p_api_version IN NUMBER,
218 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
219 x_return_status OUT NOCOPY VARCHAR2,
220 x_msg_count OUT NOCOPY NUMBER,
221 x_msg_data OUT NOCOPY VARCHAR2,
222 p_oatv_tbl IN oatv_tbl_type);
223
224 PROCEDURE validate_out_arg(
225 p_api_version IN NUMBER,
226 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
227 x_return_status OUT NOCOPY VARCHAR2,
228 x_msg_count OUT NOCOPY NUMBER,
229 x_msg_data OUT NOCOPY VARCHAR2,
230 p_oatv_rec IN oatv_rec_type);
231
232 END okc_outcome_pub;