DBA Data[Home] [Help]

APPS.PSB_BUDGET_GROUPS_PVT dependencies on FND_API

Line 6: p_init_msg_list in varchar2 := fnd_api.g_false,

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,

Line 7: p_commit in varchar2 := fnd_api.g_false,

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,

Line 8: p_validation_level in number := fnd_api.g_valid_level_full,

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,

Line 79: p_init_msg_list in varchar2 := FND_API.G_FALSE,

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,

Line 80: p_commit in varchar2 := FND_API.G_FALSE,

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,

Line 81: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

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,

Line 152: p_init_msg_list in varchar2 := fnd_api.g_false,

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,

Line 153: p_commit in varchar2 := fnd_api.g_false,

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,

Line 154: p_validation_level in number := fnd_api.g_valid_level_full,

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,

Line 224: p_init_msg_list in varchar2 := fnd_api.g_false,

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,

Line 225: p_commit in varchar2 := fnd_api.g_false,

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,

Line 226: p_validation_level in number := fnd_api.g_valid_level_full,

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,

Line 297: p_init_msg_list in varchar2 := fnd_api.g_false,

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,

Line 298: p_commit in varchar2 := fnd_api.g_false,

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,

Line 299: p_validation_level in number := fnd_api.g_valid_level_full,

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,

Line 309: p_init_msg_list in varchar2 := fnd_api.g_false,

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,

Line 310: p_commit in varchar2 := fnd_api.g_false,

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,

Line 311: p_validation_level in number := fnd_api.g_valid_level_full,

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

Line 320: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 321: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 322: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 333: -- Pre-reqs : FND_API, FND_MESSAGE

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

Line 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: -- .

Line 339: -- Default = FND_API.G_VALID_LEVEL_NONE

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

Line 355: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 356: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

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

Line 367: -- Pre-reqs : FND_API, FND_MESSAGE

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

Line 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

Line 373: -- Default = FND_API.G_FALSE

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

Line 375: -- Default = FND_API.G_VALID_LEVEL_NONE

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

Line 380: -- Default = FND_API.G_TRUE

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)

Line 397: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 398: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 399: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

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,

Line 405: p_validate_ranges IN VARCHAR2 := FND_API.G_TRUE,

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:

Line 407: p_check_missing_acct IN VARCHAR2 := FND_API.G_TRUE

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:

Line 414: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 415: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 416: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

Line 449: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 450: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

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