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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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: -- .
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
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,
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
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
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
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
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
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)
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,
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,
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,
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:
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:
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,
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,
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
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,
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