[Home] [Help]
PACKAGE: APPS.OKL_PROCESS_ACC_GROUP_PUB
Source
1 PACKAGE OKL_PROCESS_ACC_GROUP_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPAGGS.pls 115.3 2002/02/18 20:11:53 pkm ship $ */
3
4
5
6 SUBTYPE agcv_rec_type IS okl_process_acc_group_pvt.agcv_rec_type;
7
8 SUBTYPE agcv_tbl_type IS okl_process_acc_group_pvt.agcv_tbl_type;
9
10
11
12 SUBTYPE agbv_rec_type IS okl_process_acc_group_pvt.agbv_rec_type;
13
14 SUBTYPE agbv_tbl_type IS okl_process_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_PROCESS_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
135 PROCEDURE create_acc_ccid(
136
137 p_api_version IN NUMBER,
138
139 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
140
141 x_return_status OUT NOCOPY VARCHAR2,
142
143 x_msg_count OUT NOCOPY NUMBER,
144
145 x_msg_data OUT NOCOPY VARCHAR2,
146
147 p_agcv_rec IN agcv_rec_type,
148
149 x_agcv_rec OUT NOCOPY agcv_rec_type);
150
151
152
153
154 PROCEDURE update_acc_ccid(
155
156 p_api_version IN NUMBER,
157
158 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
159
160 x_return_status OUT NOCOPY VARCHAR2,
161
162 x_msg_count OUT NOCOPY NUMBER,
163
164 x_msg_data OUT NOCOPY VARCHAR2,
165
166 p_agcv_tbl IN agcv_tbl_type,
167
168 x_agcv_tbl OUT NOCOPY agcv_tbl_type);
169
170
171
172 PROCEDURE update_acc_ccid(
173
174 p_api_version IN NUMBER,
175
176 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
177
178 x_return_status OUT NOCOPY VARCHAR2,
179
180 x_msg_count OUT NOCOPY NUMBER,
181
182 x_msg_data OUT NOCOPY VARCHAR2,
183
184 p_agcv_rec IN agcv_rec_type,
185
186 x_agcv_rec OUT NOCOPY agcv_rec_type);
187
188
189
190 PROCEDURE delete_acc_ccid(
191
192 p_api_version IN NUMBER,
193
194 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
195
196 x_return_status OUT NOCOPY VARCHAR2,
197
198 x_msg_count OUT NOCOPY NUMBER,
199
200 x_msg_data OUT NOCOPY VARCHAR2,
201
202 p_agcv_tbl IN agcv_tbl_type);
203
204
205
206 PROCEDURE delete_acc_ccid(
207
208 p_api_version IN NUMBER,
209
210 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
211
212 x_return_status OUT NOCOPY VARCHAR2,
213
214 x_msg_count OUT NOCOPY NUMBER,
215
216 x_msg_data OUT NOCOPY VARCHAR2,
217
218 p_agcv_rec IN agcv_rec_type);
219
220
221
222
223
224 PROCEDURE create_acc_bal(
225
226 p_api_version IN NUMBER,
227
228 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
229
230 x_return_status OUT NOCOPY VARCHAR2,
231
232 x_msg_count OUT NOCOPY NUMBER,
233
234 x_msg_data OUT NOCOPY VARCHAR2,
235
236 p_agbv_rec IN agbv_rec_type,
237
238 x_agbv_rec OUT NOCOPY agbv_rec_type);
239
240
241
242
243 PROCEDURE update_acc_bal(
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_agbv_tbl IN agbv_tbl_type,
256
257 x_agbv_tbl OUT NOCOPY agbv_tbl_type);
258
259
260
261 PROCEDURE update_acc_bal(
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_agbv_rec IN agbv_rec_type,
274
275 x_agbv_rec OUT NOCOPY agbv_rec_type);
276
277
278
279 PROCEDURE delete_acc_bal(
280
281 p_api_version IN NUMBER,
282
283 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
284
285 x_return_status OUT NOCOPY VARCHAR2,
286
287 x_msg_count OUT NOCOPY NUMBER,
288
289 x_msg_data OUT NOCOPY VARCHAR2,
290
291 p_agbv_tbl IN agbv_tbl_type);
292
293
294
295 PROCEDURE delete_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
310 END OKL_PROCESS_ACC_GROUP_PUB;
311