1 package PSB_BUDGET_GROUPS_PVT AS
2 /* $Header: PSBVBGPS.pls 120.2 2005/07/13 11:23:27 shtripat ship $ */
3
4 PROCEDURE INSERT_ROW (
5 p_api_version in number,
6 p_init_msg_list in varchar2 := fnd_api.g_false,
7 p_commit in varchar2 := fnd_api.g_false,
8 p_validation_level in number := fnd_api.g_valid_level_full,
9 p_return_status OUT NOCOPY varchar2,
10 p_msg_count OUT NOCOPY number,
11 p_msg_data OUT NOCOPY varchar2,
12 p_rowid in OUT NOCOPY varchar2,
13 p_budget_group_id in number,
14 p_name in varchar2,
15 p_short_name in varchar2,
16 p_root_budget_group in varchar2,
17 p_parent_budget_group_id in number,
18 p_root_budget_group_id in number,
19 p_ps_account_position_set_id in number,
20 p_nps_account_position_set_id in number,
21 p_budget_group_category_set_id in number,
22 p_effective_start_date in date,
23 p_effective_end_date in date,
24 p_freeze_hierarchy_flag in varchar2,
25 p_description in varchar2,
26 p_set_of_books_id in number,
27 p_business_group_id in number,
28 p_num_proposed_years in number,
29 p_narrative_description in varchar2,
30 p_budget_group_type in varchar2,
31 p_organization_id in number,
32 p_request_id in number,
33 p_segment1_type in number,
34 p_segment2_type in number,
35 p_segment3_type in number,
36 p_segment4_type in number,
37 p_segment5_type in number,
38 p_segment6_type in number,
39 p_segment7_type in number,
40 p_segment8_type in number,
41 p_segment9_type in number,
42 p_segment10_type in number,
43 p_segment11_type in number,
44 p_segment12_type in number,
45 p_segment13_type in number,
46 p_segment14_type in number,
47 p_segment15_type in number,
48 p_segment16_type in number,
49 p_segment17_type in number,
50 p_segment18_type in number,
51 p_segment19_type in number,
52 p_segment20_type in number,
53 p_segment21_type in number,
54 p_segment22_type in number,
55 p_segment23_type in number,
56 p_segment24_type in number,
57 p_segment25_type in number,
58 p_segment26_type in number,
59 p_segment27_type in number,
60 p_segment28_type in number,
61 p_segment29_type in number,
62 p_segment30_type in number,
63 p_attribute1 in varchar2,
64 p_attribute2 in varchar2,
65 p_attribute3 in varchar2,
66 p_attribute4 in varchar2,
67 p_attribute5 in varchar2,
68 p_attribute6 in varchar2,
69 p_attribute7 in varchar2,
70 p_attribute8 in varchar2,
71 p_attribute9 in varchar2,
72 p_attribute10 in varchar2,
73 p_context in varchar2,
74 p_mode in varchar2 default 'R'
75 );
76
77 PROCEDURE LOCK_ROW (
78 p_api_version in number,
79 p_init_msg_list in varchar2 := FND_API.G_FALSE,
80 p_commit in varchar2 := FND_API.G_FALSE,
81 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
82 p_return_status OUT NOCOPY varchar2,
83 p_msg_count OUT NOCOPY number,
84 p_msg_data OUT NOCOPY varchar2,
85 p_lock_row OUT NOCOPY varchar2,
86 p_budget_group_id in number,
87 p_name in varchar2,
88 p_short_name in varchar2,
89 p_root_budget_group in varchar2,
90 p_parent_budget_group_id in number,
91 p_root_budget_group_id in number,
92 p_ps_account_position_set_id in number,
93 p_nps_account_position_set_id in number,
94 p_budget_group_category_set_id in number,
95 p_effective_start_date in date,
96 p_effective_end_date in date,
97 p_freeze_hierarchy_flag in varchar2,
98 p_description in varchar2,
99 p_set_of_books_id in number,
100 p_business_group_id in number,
101 p_num_proposed_years in number,
102 p_narrative_description in varchar2,
103 p_budget_group_type in varchar2,
104 p_organization_id in number,
105 p_request_id in number,
106 p_segment1_type in number,
107 p_segment2_type in number,
108 p_segment3_type in number,
109 p_segment4_type in number,
110 p_segment5_type in number,
111 p_segment6_type in number,
112 p_segment7_type in number,
113 p_segment8_type in number,
114 p_segment9_type in number,
115 p_segment10_type in number,
116 p_segment11_type in number,
117 p_segment12_type in number,
118 p_segment13_type in number,
119 p_segment14_type in number,
120 p_segment15_type in number,
121 p_segment16_type in number,
122 p_segment17_type in number,
123 p_segment18_type in number,
124 p_segment19_type in number,
125 p_segment20_type in number,
126 p_segment21_type in number,
127 p_segment22_type in number,
128 p_segment23_type in number,
129 p_segment24_type in number,
130 p_segment25_type in number,
131 p_segment26_type in number,
132 p_segment27_type in number,
133 p_segment28_type in number,
134 p_segment29_type in number,
135 p_segment30_type in number,
136 p_attribute1 in varchar2,
137 p_attribute2 in varchar2,
138 p_attribute3 in varchar2,
139 p_attribute4 in varchar2,
140 p_attribute5 in varchar2,
141 p_attribute6 in varchar2,
142 p_attribute7 in varchar2,
143 p_attribute8 in varchar2,
144 p_attribute9 in varchar2,
145 p_attribute10 in varchar2,
146 p_context in varchar2
147 );
148
149
150 PROCEDURE UPDATE_ROW (
151 p_api_version in number,
152 p_init_msg_list in varchar2 := fnd_api.g_false,
153 p_commit in varchar2 := fnd_api.g_false,
154 p_validation_level in number := fnd_api.g_valid_level_full,
155 p_return_status OUT NOCOPY varchar2,
156 p_msg_count OUT NOCOPY number,
157 p_msg_data OUT NOCOPY varchar2,
158 p_budget_group_id in number,
159 p_name in varchar2,
160 p_short_name in varchar2,
161 p_root_budget_group in varchar2,
162 p_parent_budget_group_id in number,
163 p_root_budget_group_id in number,
164 p_ps_account_position_set_id in number,
165 p_nps_account_position_set_id in number,
166 p_budget_group_category_set_id in number,
167 p_effective_start_date in date,
168 p_effective_end_date in date,
169 p_freeze_hierarchy_flag in varchar2,
170 p_description in varchar2,
171 p_set_of_books_id in number,
172 p_business_group_id in number,
173 p_num_proposed_years in number,
174 p_narrative_description in varchar2,
175 p_budget_group_type in varchar2,
176 p_organization_id in number,
177 p_request_id in number,
178 p_segment1_type in number,
179 p_segment2_type in number,
180 p_segment3_type in number,
181 p_segment4_type in number,
182 p_segment5_type in number,
183 p_segment6_type in number,
184 p_segment7_type in number,
185 p_segment8_type in number,
186 p_segment9_type in number,
187 p_segment10_type in number,
188 p_segment11_type in number,
189 p_segment12_type in number,
190 p_segment13_type in number,
191 p_segment14_type in number,
192 p_segment15_type in number,
193 p_segment16_type in number,
194 p_segment17_type in number,
195 p_segment18_type in number,
196 p_segment19_type in number,
197 p_segment20_type in number,
198 p_segment21_type in number,
199 p_segment22_type in number,
200 p_segment23_type in number,
201 p_segment24_type in number,
202 p_segment25_type in number,
203 p_segment26_type in number,
204 p_segment27_type in number,
205 p_segment28_type in number,
206 p_segment29_type in number,
207 p_segment30_type in number,
208 p_attribute1 in varchar2,
209 p_attribute2 in varchar2,
210 p_attribute3 in varchar2,
211 p_attribute4 in varchar2,
212 p_attribute5 in varchar2,
213 p_attribute6 in varchar2,
214 p_attribute7 in varchar2,
215 p_attribute8 in varchar2,
216 p_attribute9 in varchar2,
217 p_attribute10 in varchar2,
218 p_context in varchar2,
219 p_mode in varchar2 default 'R'
220 );
221
222 PROCEDURE ADD_ROW (
223 p_api_version in number,
224 p_init_msg_list in varchar2 := fnd_api.g_false,
225 p_commit in varchar2 := fnd_api.g_false,
226 p_validation_level in number := fnd_api.g_valid_level_full,
227 p_return_status OUT NOCOPY varchar2,
228 p_msg_count OUT NOCOPY number,
229 p_msg_data OUT NOCOPY varchar2,
230 p_rowid in OUT NOCOPY varchar2,
231 p_budget_group_id in number,
232 p_name in varchar2,
233 p_short_name in varchar2,
234 p_root_budget_group in varchar2,
235 p_parent_budget_group_id in number,
236 p_root_budget_group_id in number,
237 p_ps_account_position_set_id in number,
238 p_nps_account_position_set_id in number,
239 p_budget_group_category_set_id in number,
240 p_effective_start_date in date,
241 p_effective_end_date in date,
242 p_freeze_hierarchy_flag in varchar2,
243 p_description in varchar2,
244 p_set_of_books_id in number,
245 p_business_group_id in number,
246 p_num_proposed_years in number,
247 p_narrative_description in varchar2,
248 p_budget_group_type in varchar2,
249 p_organization_id in number ,
250 p_request_id in number,
251 p_segment1_type in number,
252 p_segment2_type in number,
253 p_segment3_type in number,
254 p_segment4_type in number,
255 p_segment5_type in number,
256 p_segment6_type in number,
257 p_segment7_type in number,
258 p_segment8_type in number,
259 p_segment9_type in number,
260 p_segment10_type in number,
261 p_segment11_type in number,
262 p_segment12_type in number,
263 p_segment13_type in number,
264 p_segment14_type in number,
265 p_segment15_type in number,
266 p_segment16_type in number,
267 p_segment17_type in number,
268 p_segment18_type in number,
269 p_segment19_type in number,
270 p_segment20_type in number,
271 p_segment21_type in number,
272 p_segment22_type in number,
273 p_segment23_type in number,
274 p_segment24_type in number,
275 p_segment25_type in number,
276 p_segment26_type in number,
277 p_segment27_type in number,
278 p_segment28_type in number,
279 p_segment29_type in number,
280 p_segment30_type in number,
281 p_attribute1 in varchar2,
282 p_attribute2 in varchar2,
283 p_attribute3 in varchar2,
284 p_attribute4 in varchar2,
285 p_attribute5 in varchar2,
286 p_attribute6 in varchar2,
287 p_attribute7 in varchar2,
288 p_attribute8 in varchar2,
289 p_attribute9 in varchar2,
290 p_attribute10 in varchar2,
291 p_context in varchar2,
292 p_mode in varchar2 default 'R'
293 );
294
295 PROCEDURE DELETE_ROW (
296 p_api_version in number,
297 p_init_msg_list in varchar2 := fnd_api.g_false,
298 p_commit in varchar2 := fnd_api.g_false,
299 p_validation_level in number := fnd_api.g_valid_level_full,
300 p_return_status OUT NOCOPY varchar2,
301 p_msg_count OUT NOCOPY number,
302 p_msg_data OUT NOCOPY varchar2,
303 p_budget_group_id in number,
304 p_delete OUT NOCOPY varchar2
305 );
306
307 PROCEDURE Delete_Review_Group(
308 p_api_version in number,
309 p_init_msg_list in varchar2 := fnd_api.g_false,
310 p_commit in varchar2 := fnd_api.g_false,
311 p_validation_level in number := fnd_api.g_valid_level_full,
312 p_return_status OUT NOCOPY varchar2,
313 p_msg_count OUT NOCOPY number,
314 p_msg_data OUT NOCOPY varchar2,
315 p_budget_group_id in number
316 );
317
318 PROCEDURE Copy_Budget_Group
319 ( p_api_version IN NUMBER,
320 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
321 p_commit IN VARCHAR2 := FND_API.G_FALSE,
322 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
323 p_src_budget_group_id IN NUMBER,
324 p_curr_budget_group_id IN NUMBER,
325 p_return_status OUT NOCOPY VARCHAR2,
326 p_msg_count OUT NOCOPY NUMBER,
327 p_msg_data OUT NOCOPY VARCHAR2
328 );
329 /* ----------------------------------------------------------------------- */
330
331 -- API name : Check_Budget_Group_Freeze
332 -- Type : Private
333 -- Pre-reqs : FND_API, FND_MESSAGE
334 -- Parameters :
335 -- IN : p_api_version IN NUMBER Required
336 -- p_init_msg_list IN VARCHAR2 Optional
337 -- Default = FND_API.G_FALSE
338 -- p_validation_level IN NUMBER Optional
339 -- Default = FND_API.G_VALID_LEVEL_NONE
340 -- p_budget_group_id IN NUMBER Required
341 -- .
342 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
343 -- p_msg_count OUT NOCOPY NUMBER
347 -- Initial version 1.0
344 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
345 -- .
346 -- Version : Current version 1.0
348 -- Created 05/27/1997 by Supriyo Ghosh
349 -- Modified 06/25/1997 by Supriyo Ghosh
350 --
351 -- Notes : Validate Budget Hierarchy Freeze
352
353 PROCEDURE Check_Budget_Group_Freeze
354 ( p_api_version IN NUMBER,
355 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
356 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
357 p_return_status OUT NOCOPY VARCHAR2,
358 p_msg_count OUT NOCOPY NUMBER,
359 p_msg_data OUT NOCOPY VARCHAR2,
360 p_budget_group_id IN NUMBER
361 );
362
363 /* ----------------------------------------------------------------------- */
364
365 -- API name : Val_Budget_Group_Hierarchy
366 -- Type : Private
367 -- Pre-reqs : FND_API, FND_MESSAGE
368 -- Parameters :
369 -- IN : p_api_version IN NUMBER Required
370 -- p_init_msg_list IN VARCHAR2 Optional
371 -- Default = FND_API.G_FALSE
372 -- p_commit IN VARCHAR2 Optional
373 -- Default = FND_API.G_FALSE
374 -- p_validation_level IN NUMBER Optional
375 -- Default = FND_API.G_VALID_LEVEL_NONE
376 -- p_budget_group_id IN NUMBER Required
377 -- p_budget_by_position IN VARCHAR2 Optional
378 -- Default = 'N'
379 -- p_validate_ranges IN VARCHAR2 Optional
380 -- Default = FND_API.G_TRUE
381 -- p_force_freeze IN VARCHAR2 Optional
382 -- Default = 'N'
383 -- .
384 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
385 -- p_msg_count OUT NOCOPY NUMBER
386 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
387 -- .
388 -- Version : Current version 1.0
389 -- Initial version 1.0
390 -- Created 05/27/1997 by Supriyo Ghosh
391 -- Modified 06/25/1997 by Supriyo Ghosh
392 --
393 -- Notes : Validate Budget Group Hierarchy for any root Budget Group
394
395 PROCEDURE Val_Budget_Group_Hierarchy
396 ( p_api_version IN NUMBER,
397 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
398 p_commit IN VARCHAR2 := FND_API.G_FALSE,
399 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
400 p_return_status OUT NOCOPY VARCHAR2,
401 p_msg_count OUT NOCOPY NUMBER,
402 p_msg_data OUT NOCOPY VARCHAR2,
403 p_budget_group_id IN NUMBER,
404 p_budget_by_position IN VARCHAR2 := 'N',
405 p_validate_ranges IN VARCHAR2 := FND_API.G_TRUE,
406 p_force_freeze IN VARCHAR2 := 'N',
407 p_check_missing_acct IN VARCHAR2 := FND_API.G_TRUE
408 );
409
410 /* ----------------------------------------------------------------------- */
411
412 PROCEDURE Account_Overlap_Validation
413 ( p_api_version IN NUMBER,
414 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
415 p_commit IN VARCHAR2 := FND_API.G_FALSE,
416 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
417 p_return_status OUT NOCOPY VARCHAR2,
418 p_msg_count OUT NOCOPY NUMBER,
419 p_msg_data OUT NOCOPY VARCHAR2,
420 p_budget_group_id IN NUMBER
421 );
422
423 PROCEDURE Account_Overlap_Validation_CP
424 (
425 errbuf OUT NOCOPY VARCHAR2,
426 retcode OUT NOCOPY VARCHAR2,
427 --
428 p_budget_group_id IN NUMBER
429 );
430 PROCEDURE Val_Budget_Group_Hierarchy_CP
431 (
432 errbuf OUT NOCOPY VARCHAR2,
433 retcode OUT NOCOPY VARCHAR2,
434 --
435 p_budget_group_id IN NUMBER ,
436 p_force_freeze IN VARCHAR2
437 );
438
439 PROCEDURE DELETE_ROW_CP
440 (
441 errbuf OUT NOCOPY VARCHAR2,
442 retcode OUT NOCOPY VARCHAR2,
443 --
444 p_budget_group_id IN NUMBER
445 );
446
447 PROCEDURE Validate_Budget_Group_Org
448 ( p_api_version IN NUMBER,
449 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
450 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
451 p_return_status OUT NOCOPY VARCHAR2,
452 p_msg_count OUT NOCOPY NUMBER,
453 p_msg_data OUT NOCOPY VARCHAR2,
454 p_top_budget_group_id IN NUMBER
455 );
456
457 /* ----------------------------------------------------------------------- */
458 /*For Bug No : 2230514 Start*/
459 --FUNCTION Get_Debug RETURN VARCHAR2;
460 /*For Bug No : 2230514 End*/
461 /* ----------------------------------------------------------------------- */
462
463
464 END PSB_BUDGET_GROUPS_PVT;