[Home] [Help]
PACKAGE: APPS.OKL_PROCESS_ACC_GROUP_PVT
Source
1 PACKAGE OKL_PROCESS_ACC_GROUP_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRAGGS.pls 115.3 2002/02/18 20:12:23 pkm ship $ */
3
4
5
6 SUBTYPE agcv_rec_type IS okl_acc_group_pub.agcv_rec_type;
7
8 SUBTYPE agcv_tbl_type IS okl_acc_group_pub.agcv_tbl_type;
9
10
11
12 SUBTYPE agbv_rec_type IS okl_acc_group_pub.agbv_rec_type;
13
14 SUBTYPE agbv_tbl_type IS okl_acc_group_pub.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_PROCESS_ACC_GROUP_PVT';
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
135
136
137 PROCEDURE create_acc_ccid(
138
139 p_api_version IN NUMBER,
140
141 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142
143 x_return_status OUT NOCOPY VARCHAR2,
144
145 x_msg_count OUT NOCOPY NUMBER,
146
147 x_msg_data OUT NOCOPY VARCHAR2,
148
149 p_agcv_tbl IN agcv_tbl_type,
150
151 x_agcv_tbl OUT NOCOPY agcv_tbl_type);
152
153
154
155 PROCEDURE create_acc_ccid(
156
157 p_api_version IN NUMBER,
158
159 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
160
161 x_return_status OUT NOCOPY VARCHAR2,
162
163 x_msg_count OUT NOCOPY NUMBER,
164
165 x_msg_data OUT NOCOPY VARCHAR2,
166
167 p_agcv_rec IN agcv_rec_type,
168
169 x_agcv_rec OUT NOCOPY agcv_rec_type);
170
171
172
173 PROCEDURE update_acc_ccid(
174
175 p_api_version IN NUMBER,
176
177 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
178
179 x_return_status OUT NOCOPY VARCHAR2,
180
181 x_msg_count OUT NOCOPY NUMBER,
182
183 x_msg_data OUT NOCOPY VARCHAR2,
184
185 p_agcv_tbl IN agcv_tbl_type,
186
187 x_agcv_tbl OUT NOCOPY agcv_tbl_type);
188
189
190
191 PROCEDURE update_acc_ccid(
192
193 p_api_version IN NUMBER,
194
195 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
196
197 x_return_status OUT NOCOPY VARCHAR2,
198
199 x_msg_count OUT NOCOPY NUMBER,
200
201 x_msg_data OUT NOCOPY VARCHAR2,
202
203 p_agcv_rec IN agcv_rec_type,
204
205 x_agcv_rec OUT NOCOPY agcv_rec_type);
206
207
208
209 PROCEDURE delete_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_tbl IN agcv_tbl_type);
222
223
224
225 PROCEDURE delete_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_rec IN agcv_rec_type);
238
239
240
241 PROCEDURE create_acc_bal(
242
243 p_api_version IN NUMBER,
244
245 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
246
247 x_return_status OUT NOCOPY VARCHAR2,
248
249 x_msg_count OUT NOCOPY NUMBER,
250
251 x_msg_data OUT NOCOPY VARCHAR2,
252
253 p_agbv_tbl IN agbv_tbl_type,
254
255 x_agbv_tbl OUT NOCOPY agbv_tbl_type);
256
257
258
259 PROCEDURE create_acc_bal(
260
261 p_api_version IN NUMBER,
262
263 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
264
265 x_return_status OUT NOCOPY VARCHAR2,
266
267 x_msg_count OUT NOCOPY NUMBER,
268
269 x_msg_data OUT NOCOPY VARCHAR2,
270
271 p_agbv_rec IN agbv_rec_type,
272
273 x_agbv_rec OUT NOCOPY agbv_rec_type);
274
275
276
277 PROCEDURE update_acc_bal(
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_agbv_tbl IN agbv_tbl_type,
290
291 x_agbv_tbl OUT NOCOPY agbv_tbl_type);
292
293
294
295 PROCEDURE update_acc_bal(
296
297 p_api_version IN NUMBER,
298
299 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
300
301 x_return_status OUT NOCOPY VARCHAR2,
302
303 x_msg_count OUT NOCOPY NUMBER,
304
305 x_msg_data OUT NOCOPY VARCHAR2,
306
307 p_agbv_rec IN agbv_rec_type,
308
309 x_agbv_rec OUT NOCOPY agbv_rec_type);
310
311
312
313 PROCEDURE delete_acc_bal(
314
315 p_api_version IN NUMBER,
316
317 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
318
319 x_return_status OUT NOCOPY VARCHAR2,
320
321 x_msg_count OUT NOCOPY NUMBER,
322
323 x_msg_data OUT NOCOPY VARCHAR2,
324
325 p_agbv_tbl IN agbv_tbl_type);
326
327
328
329 PROCEDURE delete_acc_bal(
330
331 p_api_version IN NUMBER,
332
333 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
334
335 x_return_status OUT NOCOPY VARCHAR2,
336
337 x_msg_count OUT NOCOPY NUMBER,
338
339 x_msg_data OUT NOCOPY VARCHAR2,
340
341 p_agbv_rec IN agbv_rec_type);
342
343
344
345 END OKL_PROCESS_ACC_GROUP_PVT;
346