[Home] [Help]
PACKAGE: APPS.OKL_ACCT_EVENT_PVT
Source
1 PACKAGE okl_acct_event_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLCAETS.pls 115.3 2002/02/05 11:48:37 pkm ship $ */
3
4 SUBTYPE aetv_rec_type IS okl_aet_pvt.aetv_rec_type;
5 SUBTYPE aetv_tbl_type IS okl_aet_pvt.aetv_tbl_type;
6
7 SUBTYPE aehv_rec_type IS okl_aeh_pvt.aehv_rec_type;
8 SUBTYPE aehv_tbl_type IS okl_aeh_pvt.aehv_tbl_type;
9
10 SUBTYPE aelv_rec_type IS okl_ael_pvt.aelv_rec_type;
11 SUBTYPE aelv_tbl_type IS okl_ael_pvt.aelv_tbl_type;
12
13 ------------------------------------------------------------------------------
14 -- Global Variables
15 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ACCT_EVENT_PVT';
16 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
17 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
18 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
19 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
20 ------------------------------------------------------------------------------
21 --Global Exception
22 ------------------------------------------------------------------------------
23 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
24 ------------------------------------------------------------------------------
25
26
27 --Object type procedure for insert
28 PROCEDURE create_acct_event(
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_aetv_rec IN aetv_rec_type
35 ,p_aehv_tbl IN aehv_tbl_type
36
37 ,p_aelv_tbl IN aelv_tbl_type
38
39 ,x_aetv_rec OUT NOCOPY aetv_rec_type
40 ,x_aehv_tbl OUT NOCOPY aehv_tbl_type
41 ,x_aelv_tbl OUT NOCOPY aelv_tbl_type
42 );
43
44 --Object type procedure for update
45 PROCEDURE update_acct_event(
46 p_api_version IN NUMBER
47 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
48 ,x_return_status OUT NOCOPY VARCHAR2
49 ,x_msg_count OUT NOCOPY NUMBER
50 ,x_msg_data OUT NOCOPY VARCHAR2
51 ,p_aetv_rec IN aetv_rec_type
52 ,p_aehv_tbl IN aehv_tbl_type
53 ,p_aelv_tbl IN aelv_tbl_type
54 ,x_aetv_rec OUT NOCOPY aetv_rec_type
55 ,x_aehv_tbl OUT NOCOPY aehv_tbl_type
56 ,x_aelv_tbl OUT NOCOPY aelv_tbl_type
57 );
58
59 --Object type procedure for validate
60 PROCEDURE validate_acct_event(
61 p_api_version IN NUMBER
62 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
63 ,x_return_status OUT NOCOPY VARCHAR2
64 ,x_msg_count OUT NOCOPY NUMBER
65 ,x_msg_data OUT NOCOPY VARCHAR2
66 ,p_aetv_rec IN aetv_rec_type
67 ,p_aehv_tbl IN aehv_tbl_type
68 ,p_aelv_tbl IN aelv_tbl_type
69 );
70
71
72 PROCEDURE create_acct_event(
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_aetv_tbl IN aetv_tbl_type,
79 x_aetv_tbl OUT NOCOPY aetv_tbl_type);
80
81 PROCEDURE create_acct_event(
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_aetv_rec IN aetv_rec_type,
88 x_aetv_rec OUT NOCOPY aetv_rec_type);
89
90 PROCEDURE lock_acct_event(
91 p_api_version IN NUMBER,
92 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2,
96 p_aetv_tbl IN aetv_tbl_type);
97
98 PROCEDURE lock_acct_event(
99 p_api_version IN NUMBER,
100 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2,
104 p_aetv_rec IN aetv_rec_type);
105
106 PROCEDURE update_acct_event(
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_aetv_tbl IN aetv_tbl_type,
113 x_aetv_tbl OUT NOCOPY aetv_tbl_type);
114
115 PROCEDURE update_acct_event(
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_aetv_rec IN aetv_rec_type,
122 x_aetv_rec OUT NOCOPY aetv_rec_type);
123
124 PROCEDURE delete_acct_event(
125 p_api_version IN NUMBER,
126 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
127 x_return_status OUT NOCOPY VARCHAR2,
128 x_msg_count OUT NOCOPY NUMBER,
129 x_msg_data OUT NOCOPY VARCHAR2,
130 p_aetv_tbl IN aetv_tbl_type);
131
132 PROCEDURE delete_acct_event(
133 p_api_version IN NUMBER,
134 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
135 x_return_status OUT NOCOPY VARCHAR2,
136 x_msg_count OUT NOCOPY NUMBER,
137 x_msg_data OUT NOCOPY VARCHAR2,
138 p_aetv_rec IN aetv_rec_type);
139
140 PROCEDURE validate_acct_event(
141 p_api_version IN NUMBER,
142 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2,
146 p_aetv_tbl IN aetv_tbl_type);
147
148 PROCEDURE validate_acct_event(
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_aetv_rec IN aetv_rec_type);
155
156
157 PROCEDURE create_acct_header(
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_aehv_tbl IN aehv_tbl_type,
164 x_aehv_tbl OUT NOCOPY aehv_tbl_type);
165
166 PROCEDURE create_acct_header(
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_aehv_rec IN aehv_rec_type,
173 x_aehv_rec OUT NOCOPY aehv_rec_type);
174
175 PROCEDURE lock_acct_header(
176 p_api_version IN NUMBER,
177 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
178 x_return_status OUT NOCOPY VARCHAR2,
179 x_msg_count OUT NOCOPY NUMBER,
180 x_msg_data OUT NOCOPY VARCHAR2,
181 p_aehv_tbl IN aehv_tbl_type);
182
183 PROCEDURE lock_acct_header(
184 p_api_version IN NUMBER,
185 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2,
189 p_aehv_rec IN aehv_rec_type);
190
191 PROCEDURE update_acct_header(
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_aehv_tbl IN aehv_tbl_type,
198 x_aehv_tbl OUT NOCOPY aehv_tbl_type);
199
200 PROCEDURE update_acct_header(
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_aehv_rec IN aehv_rec_type,
207 x_aehv_rec OUT NOCOPY aehv_rec_type);
208
209 PROCEDURE delete_acct_header(
210 p_api_version IN NUMBER,
211 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
212 x_return_status OUT NOCOPY VARCHAR2,
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2,
215 p_aehv_tbl IN aehv_tbl_type);
216
217 PROCEDURE delete_acct_header(
218 p_api_version IN NUMBER,
219 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
220 x_return_status OUT NOCOPY VARCHAR2,
221 x_msg_count OUT NOCOPY NUMBER,
222 x_msg_data OUT NOCOPY VARCHAR2,
223 p_aehv_rec IN aehv_rec_type);
224
225 PROCEDURE validate_acct_header(
226 p_api_version IN NUMBER,
227 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
228 x_return_status OUT NOCOPY VARCHAR2,
229 x_msg_count OUT NOCOPY NUMBER,
230 x_msg_data OUT NOCOPY VARCHAR2,
231 p_aehv_tbl IN aehv_tbl_type);
232
233 PROCEDURE validate_acct_header(
234 p_api_version IN NUMBER,
235 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
236 x_return_status OUT NOCOPY VARCHAR2,
237 x_msg_count OUT NOCOPY NUMBER,
238 x_msg_data OUT NOCOPY VARCHAR2,
239 p_aehv_rec IN aehv_rec_type);
240
241
242 PROCEDURE create_acct_lines(
243 p_api_version IN NUMBER,
244 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
245 x_return_status OUT NOCOPY VARCHAR2,
246 x_msg_count OUT NOCOPY NUMBER,
247 x_msg_data OUT NOCOPY VARCHAR2,
248 p_aelv_tbl IN aelv_tbl_type,
249 x_aelv_tbl OUT NOCOPY aelv_tbl_type);
250
251 PROCEDURE create_acct_lines(
252 p_api_version IN NUMBER,
253 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
254 x_return_status OUT NOCOPY VARCHAR2,
255 x_msg_count OUT NOCOPY NUMBER,
256 x_msg_data OUT NOCOPY VARCHAR2,
257 p_aelv_rec IN aelv_rec_type,
258 x_aelv_rec OUT NOCOPY aelv_rec_type);
259
260 PROCEDURE lock_acct_lines(
261 p_api_version IN NUMBER,
262 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
263 x_return_status OUT NOCOPY VARCHAR2,
264 x_msg_count OUT NOCOPY NUMBER,
265 x_msg_data OUT NOCOPY VARCHAR2,
266 p_aelv_tbl IN aelv_tbl_type);
267
268 PROCEDURE lock_acct_lines(
269 p_api_version IN NUMBER,
270 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
271 x_return_status OUT NOCOPY VARCHAR2,
272 x_msg_count OUT NOCOPY NUMBER,
273 x_msg_data OUT NOCOPY VARCHAR2,
274 p_aelv_rec IN aelv_rec_type);
275
276 PROCEDURE update_acct_lines(
277 p_api_version IN NUMBER,
278 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
279 x_return_status OUT NOCOPY VARCHAR2,
280 x_msg_count OUT NOCOPY NUMBER,
281 x_msg_data OUT NOCOPY VARCHAR2,
282 p_aelv_tbl IN aelv_tbl_type,
283 x_aelv_tbl OUT NOCOPY aelv_tbl_type);
284
285 PROCEDURE update_acct_lines(
286 p_api_version IN NUMBER,
287 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
288 x_return_status OUT NOCOPY VARCHAR2,
289 x_msg_count OUT NOCOPY NUMBER,
290 x_msg_data OUT NOCOPY VARCHAR2,
291 p_aelv_rec IN aelv_rec_type,
292 x_aelv_rec OUT NOCOPY aelv_rec_type);
293
294 PROCEDURE delete_acct_lines(
295 p_api_version IN NUMBER,
296 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
297 x_return_status OUT NOCOPY VARCHAR2,
298 x_msg_count OUT NOCOPY NUMBER,
299 x_msg_data OUT NOCOPY VARCHAR2,
300 p_aelv_tbl IN aelv_tbl_type);
301
302 PROCEDURE delete_acct_lines(
303 p_api_version IN NUMBER,
304 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
305 x_return_status OUT NOCOPY VARCHAR2,
306 x_msg_count OUT NOCOPY NUMBER,
307 x_msg_data OUT NOCOPY VARCHAR2,
308 p_aelv_rec IN aelv_rec_type);
309
310 PROCEDURE validate_acct_lines(
311 p_api_version IN NUMBER,
312 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
313 x_return_status OUT NOCOPY VARCHAR2,
314 x_msg_count OUT NOCOPY NUMBER,
315 x_msg_data OUT NOCOPY VARCHAR2,
316 p_aelv_tbl IN aelv_tbl_type);
317
318 PROCEDURE validate_acct_lines(
319 p_api_version IN NUMBER,
320 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
321 x_return_status OUT NOCOPY VARCHAR2,
322 x_msg_count OUT NOCOPY NUMBER,
323 x_msg_data OUT NOCOPY VARCHAR2,
324 p_aelv_rec IN aelv_rec_type);
325
326 END okl_acct_event_pvt;
327