[Home] [Help]
PACKAGE: APPS.OKL_ACC_GROUP_PUB
Source
1 PACKAGE OKL_ACC_GROUP_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPAGCS.pls 115.2 2002/02/18 22:40:15 pkm ship $ */
3
4
5
6 SUBTYPE agcv_rec_type IS okl_acc_group_pvt.agcv_rec_type;
7
8 SUBTYPE agcv_tbl_type IS okl_acc_group_pvt.agcv_tbl_type;
9
10
11
12 SUBTYPE agbv_rec_type IS okl_acc_group_pvt.agbv_rec_type;
13
14 SUBTYPE agbv_tbl_type IS okl_acc_group_pvt.agbv_tbl_type;
15
16
17
18 -- GLOBAL MESSAGE CONSTANTS
19
20 ---------------------------------------------------------------------------------
21
22 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
23
24 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
25
26 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
27
28 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
29
30 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
31
32 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
33
34 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
35
36 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
37
38 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
39
40 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
41
42 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
43
44 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
45
46 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
47
48 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
49
50 ---------------------------------------------------------------------------------
51
52
53
54 -- GLOBAL EXCEPTION
55
56 ---------------------------------------------------------------------------------
57
58 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
59
60 ---------------------------------------------------------------------------------
61
62
63
64 -- GLOBAL VARIABLES
65
66 ---------------------------------------------------------------------------------
67
68 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ACC_GROUP_PUB';
69
70 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
71
72 ---------------------------------------------------------------------------------
73
74
75
76 g_agcv_rec agcv_rec_type;
77
78 g_agbv_rec agbv_rec_type;
79
80
81
82 PROCEDURE create_acc_group(
83
84 p_api_version IN NUMBER
85
86 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
87
88 ,x_return_status OUT NOCOPY VARCHAR2
89
90 ,x_msg_count OUT NOCOPY NUMBER
91
92 ,x_msg_data OUT NOCOPY VARCHAR2
93
94 ,p_agcv_rec IN agcv_rec_type
95
96 ,p_agbv_tbl IN agbv_tbl_type
97
98 ,x_agcv_rec OUT NOCOPY agcv_rec_type
99
100 ,x_agbv_tbl OUT NOCOPY agbv_tbl_type
101
102 );
103
104
105
106 --Object type procedure for update
107
108 PROCEDURE update_acc_group(
109
110 p_api_version IN NUMBER
111
112 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
113
114 ,x_return_status OUT NOCOPY VARCHAR2
115
116 ,x_msg_count OUT NOCOPY NUMBER
117
118 ,x_msg_data OUT NOCOPY VARCHAR2
119
120 ,p_agcv_rec IN agcv_rec_type
121
122 ,p_agbv_tbl IN agbv_tbl_type
123
124 ,x_agcv_rec OUT NOCOPY agcv_rec_type
125
126 ,x_agbv_tbl OUT NOCOPY agbv_tbl_type
127
128 );
129
130
131
132 --Object type procedure for validate
133
134 PROCEDURE validate_acc_group(
135
136 p_api_version IN NUMBER
137
138 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
139
140 ,x_return_status OUT NOCOPY VARCHAR2
141
142 ,x_msg_count OUT NOCOPY NUMBER
143
144 ,x_msg_data OUT NOCOPY VARCHAR2
145
146 ,p_agcv_rec IN agcv_rec_type
147
148 ,p_agbv_tbl IN agbv_tbl_type
149
150 );
151
152
153
154
155
156
157 PROCEDURE create_acc_ccid(
158
159 p_api_version IN NUMBER,
160
161 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
162
163 x_return_status OUT NOCOPY VARCHAR2,
164
165 x_msg_count OUT NOCOPY NUMBER,
166
167 x_msg_data OUT NOCOPY VARCHAR2,
168
169 p_agcv_tbl IN agcv_tbl_type,
170
171 x_agcv_tbl OUT NOCOPY agcv_tbl_type);
172
173
174
175 PROCEDURE create_acc_ccid(
176
177 p_api_version IN NUMBER,
178
179 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
180
181 x_return_status OUT NOCOPY VARCHAR2,
182
183 x_msg_count OUT NOCOPY NUMBER,
184
185 x_msg_data OUT NOCOPY VARCHAR2,
186
187 p_agcv_rec IN agcv_rec_type,
188
189 x_agcv_rec OUT NOCOPY agcv_rec_type);
190
191
192
193 PROCEDURE lock_acc_ccid(
194
195 p_api_version IN NUMBER,
196
197 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
198
199 x_return_status OUT NOCOPY VARCHAR2,
200
201 x_msg_count OUT NOCOPY NUMBER,
202
203 x_msg_data OUT NOCOPY VARCHAR2,
204
205 p_agcv_tbl IN agcv_tbl_type);
206
207
208
209 PROCEDURE lock_acc_ccid(
210
211 p_api_version IN NUMBER,
212
213 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
214
215 x_return_status OUT NOCOPY VARCHAR2,
216
217 x_msg_count OUT NOCOPY NUMBER,
218
219 x_msg_data OUT NOCOPY VARCHAR2,
220
221 p_agcv_rec IN agcv_rec_type);
222
223
224
225 PROCEDURE update_acc_ccid(
226
227 p_api_version IN NUMBER,
228
229 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
230
231 x_return_status OUT NOCOPY VARCHAR2,
232
233 x_msg_count OUT NOCOPY NUMBER,
234
235 x_msg_data OUT NOCOPY VARCHAR2,
236
237 p_agcv_tbl IN agcv_tbl_type,
238
239 x_agcv_tbl OUT NOCOPY agcv_tbl_type);
240
241
242
243 PROCEDURE update_acc_ccid(
244
245 p_api_version IN NUMBER,
246
247 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
248
249 x_return_status OUT NOCOPY VARCHAR2,
250
251 x_msg_count OUT NOCOPY NUMBER,
252
253 x_msg_data OUT NOCOPY VARCHAR2,
254
255 p_agcv_rec IN agcv_rec_type,
256
257 x_agcv_rec OUT NOCOPY agcv_rec_type);
258
259
260
261 PROCEDURE delete_acc_ccid(
262
263 p_api_version IN NUMBER,
264
265 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
266
267 x_return_status OUT NOCOPY VARCHAR2,
268
269 x_msg_count OUT NOCOPY NUMBER,
270
271 x_msg_data OUT NOCOPY VARCHAR2,
272
273 p_agcv_tbl IN agcv_tbl_type);
274
275
276
277 PROCEDURE delete_acc_ccid(
278
279 p_api_version IN NUMBER,
280
281 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
282
283 x_return_status OUT NOCOPY VARCHAR2,
284
285 x_msg_count OUT NOCOPY NUMBER,
286
287 x_msg_data OUT NOCOPY VARCHAR2,
288
289 p_agcv_rec IN agcv_rec_type);
290
291
292
293 PROCEDURE validate_acc_ccid(
294
295 p_api_version IN NUMBER,
296
297 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
298
299 x_return_status OUT NOCOPY VARCHAR2,
300
301 x_msg_count OUT NOCOPY NUMBER,
302
303 x_msg_data OUT NOCOPY VARCHAR2,
304
305 p_agcv_tbl IN agcv_tbl_type);
306
307
308
309 PROCEDURE validate_acc_ccid(
310
311 p_api_version IN NUMBER,
312
313 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
314
315 x_return_status OUT NOCOPY VARCHAR2,
316
317 x_msg_count OUT NOCOPY NUMBER,
318
319 x_msg_data OUT NOCOPY VARCHAR2,
320
321 p_agcv_rec IN agcv_rec_type);
322
323
324
325
326
327 PROCEDURE create_acc_bal(
328
329 p_api_version IN NUMBER,
330
331 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
332
333 x_return_status OUT NOCOPY VARCHAR2,
334
335 x_msg_count OUT NOCOPY NUMBER,
336
337 x_msg_data OUT NOCOPY VARCHAR2,
338
339 p_agbv_tbl IN agbv_tbl_type,
340
341 x_agbv_tbl OUT NOCOPY agbv_tbl_type);
342
343
344
345 PROCEDURE create_acc_bal(
346
347 p_api_version IN NUMBER,
348
349 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
350
351 x_return_status OUT NOCOPY VARCHAR2,
352
353 x_msg_count OUT NOCOPY NUMBER,
354
355 x_msg_data OUT NOCOPY VARCHAR2,
356
357 p_agbv_rec IN agbv_rec_type,
358
359 x_agbv_rec OUT NOCOPY agbv_rec_type);
360
361
362
363 PROCEDURE lock_acc_bal(
364
365 p_api_version IN NUMBER,
366
367 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
368
369 x_return_status OUT NOCOPY VARCHAR2,
370
371 x_msg_count OUT NOCOPY NUMBER,
372
373 x_msg_data OUT NOCOPY VARCHAR2,
374
375 p_agbv_tbl IN agbv_tbl_type);
376
377
378
379 PROCEDURE lock_acc_bal(
380
381 p_api_version IN NUMBER,
382
383 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
384
385 x_return_status OUT NOCOPY VARCHAR2,
386
387 x_msg_count OUT NOCOPY NUMBER,
388
389 x_msg_data OUT NOCOPY VARCHAR2,
390
391 p_agbv_rec IN agbv_rec_type);
392
393
394
395 PROCEDURE update_acc_bal(
396
397 p_api_version IN NUMBER,
398
399 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
400
401 x_return_status OUT NOCOPY VARCHAR2,
402
403 x_msg_count OUT NOCOPY NUMBER,
404
405 x_msg_data OUT NOCOPY VARCHAR2,
406
407 p_agbv_tbl IN agbv_tbl_type,
408
409 x_agbv_tbl OUT NOCOPY agbv_tbl_type);
410
411
412
413 PROCEDURE update_acc_bal(
414
415 p_api_version IN NUMBER,
416
417 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
418
419 x_return_status OUT NOCOPY VARCHAR2,
420
421 x_msg_count OUT NOCOPY NUMBER,
422
423 x_msg_data OUT NOCOPY VARCHAR2,
424
425 p_agbv_rec IN agbv_rec_type,
426
427 x_agbv_rec OUT NOCOPY agbv_rec_type);
428
429
430
431 PROCEDURE delete_acc_bal(
432
433 p_api_version IN NUMBER,
434
435 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
436
437 x_return_status OUT NOCOPY VARCHAR2,
438
439 x_msg_count OUT NOCOPY NUMBER,
440
441 x_msg_data OUT NOCOPY VARCHAR2,
442
443 p_agbv_tbl IN agbv_tbl_type);
444
445
446
447 PROCEDURE delete_acc_bal(
448
449 p_api_version IN NUMBER,
450
451 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
452
453 x_return_status OUT NOCOPY VARCHAR2,
454
455 x_msg_count OUT NOCOPY NUMBER,
456
457 x_msg_data OUT NOCOPY VARCHAR2,
458
459 p_agbv_rec IN agbv_rec_type);
460
461
462
463 PROCEDURE validate_acc_bal(
464
465 p_api_version IN NUMBER,
466
467 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
468
469 x_return_status OUT NOCOPY VARCHAR2,
470
471 x_msg_count OUT NOCOPY NUMBER,
472
473 x_msg_data OUT NOCOPY VARCHAR2,
474
475 p_agbv_tbl IN agbv_tbl_type);
476
477
478
479 PROCEDURE validate_acc_bal(
480
481 p_api_version IN NUMBER,
482
483 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
484
485 x_return_status OUT NOCOPY VARCHAR2,
486
487 x_msg_count OUT NOCOPY NUMBER,
488
489 x_msg_data OUT NOCOPY VARCHAR2,
490
491 p_agbv_rec IN agbv_rec_type);
492
493
494
495 END OKL_ACC_GROUP_PUB;
496