APPS.PQH_BGT_UPD dependencies on HR_API

Line 97: When hr_api.check_integrity_violated Then

93: --
94: hr_utility.set_location(' Leaving:'||l_proc, 10);
95: --
96: Exception
97: When hr_api.check_integrity_violated Then
98: -- A check constraint has been violated
99: pqh_bgt_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then

Line 100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

96: Exception
97: When hr_api.check_integrity_violated Then
98: -- A check constraint has been violated
99: pqh_bgt_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: pqh_bgt_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 101: When hr_api.parent_integrity_violated Then

97: When hr_api.check_integrity_violated Then
98: -- A check constraint has been violated
99: pqh_bgt_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: pqh_bgt_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then

Line 104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: pqh_bgt_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: pqh_bgt_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 105: When hr_api.unique_integrity_violated Then

101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: pqh_bgt_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: pqh_bgt_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When Others Then

Line 108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: pqh_bgt_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When Others Then
110: Raise;
111: End update_dml;
112: --

Line 285: when hr_api.cannot_find_prog_unit then

281: );
282: --
283: exception
284: --
285: when hr_api.cannot_find_prog_unit then
286: --
287: hr_api.cannot_find_prog_unit_error
288: (p_module_name => 'pqh_budgets'
289: ,p_hook_type => 'AU');

Line 287: hr_api.cannot_find_prog_unit_error

283: exception
284: --
285: when hr_api.cannot_find_prog_unit then
286: --
287: hr_api.cannot_find_prog_unit_error
288: (p_module_name => 'pqh_budgets'
289: ,p_hook_type => 'AU');
290: --
291: end;

Line 355: If (p_rec.business_group_id = hr_api.g_number) then

351: -- p_rec plsql record structure
352: -- to see if a system default is being used. If a system default
353: -- is being used then we must set to the 'current' argument value.
354: --
355: If (p_rec.business_group_id = hr_api.g_number) then
356: p_rec.business_group_id :=
357: pqh_bgt_shd.g_old_rec.business_group_id;
358: End If;
359: If (p_rec.start_organization_id = hr_api.g_number) then

Line 359: If (p_rec.start_organization_id = hr_api.g_number) then

355: If (p_rec.business_group_id = hr_api.g_number) then
356: p_rec.business_group_id :=
357: pqh_bgt_shd.g_old_rec.business_group_id;
358: End If;
359: If (p_rec.start_organization_id = hr_api.g_number) then
360: p_rec.start_organization_id :=
361: pqh_bgt_shd.g_old_rec.start_organization_id;
362: End If;
363: If (p_rec.org_structure_version_id = hr_api.g_number) then

Line 363: If (p_rec.org_structure_version_id = hr_api.g_number) then

359: If (p_rec.start_organization_id = hr_api.g_number) then
360: p_rec.start_organization_id :=
361: pqh_bgt_shd.g_old_rec.start_organization_id;
362: End If;
363: If (p_rec.org_structure_version_id = hr_api.g_number) then
364: p_rec.org_structure_version_id :=
365: pqh_bgt_shd.g_old_rec.org_structure_version_id;
366: End If;
367: If (p_rec.budgeted_entity_cd = hr_api.g_varchar2) then

Line 367: If (p_rec.budgeted_entity_cd = hr_api.g_varchar2) then

363: If (p_rec.org_structure_version_id = hr_api.g_number) then
364: p_rec.org_structure_version_id :=
365: pqh_bgt_shd.g_old_rec.org_structure_version_id;
366: End If;
367: If (p_rec.budgeted_entity_cd = hr_api.g_varchar2) then
368: p_rec.budgeted_entity_cd :=
369: pqh_bgt_shd.g_old_rec.budgeted_entity_cd;
370: End If;
371: If (p_rec.budget_style_cd = hr_api.g_varchar2) then

Line 371: If (p_rec.budget_style_cd = hr_api.g_varchar2) then

367: If (p_rec.budgeted_entity_cd = hr_api.g_varchar2) then
368: p_rec.budgeted_entity_cd :=
369: pqh_bgt_shd.g_old_rec.budgeted_entity_cd;
370: End If;
371: If (p_rec.budget_style_cd = hr_api.g_varchar2) then
372: p_rec.budget_style_cd :=
373: pqh_bgt_shd.g_old_rec.budget_style_cd;
374: End If;
375: If (p_rec.budget_name = hr_api.g_varchar2) then

Line 375: If (p_rec.budget_name = hr_api.g_varchar2) then

371: If (p_rec.budget_style_cd = hr_api.g_varchar2) then
372: p_rec.budget_style_cd :=
373: pqh_bgt_shd.g_old_rec.budget_style_cd;
374: End If;
375: If (p_rec.budget_name = hr_api.g_varchar2) then
376: p_rec.budget_name :=
377: pqh_bgt_shd.g_old_rec.budget_name;
378: End If;
379: If (p_rec.period_set_name = hr_api.g_varchar2) then

Line 379: If (p_rec.period_set_name = hr_api.g_varchar2) then

375: If (p_rec.budget_name = hr_api.g_varchar2) then
376: p_rec.budget_name :=
377: pqh_bgt_shd.g_old_rec.budget_name;
378: End If;
379: If (p_rec.period_set_name = hr_api.g_varchar2) then
380: p_rec.period_set_name :=
381: pqh_bgt_shd.g_old_rec.period_set_name;
382: End If;
383: If (p_rec.budget_start_date = hr_api.g_date) then

Line 383: If (p_rec.budget_start_date = hr_api.g_date) then

379: If (p_rec.period_set_name = hr_api.g_varchar2) then
380: p_rec.period_set_name :=
381: pqh_bgt_shd.g_old_rec.period_set_name;
382: End If;
383: If (p_rec.budget_start_date = hr_api.g_date) then
384: p_rec.budget_start_date :=
385: pqh_bgt_shd.g_old_rec.budget_start_date;
386: End If;
387: If (p_rec.budget_end_date = hr_api.g_date) then

Line 387: If (p_rec.budget_end_date = hr_api.g_date) then

383: If (p_rec.budget_start_date = hr_api.g_date) then
384: p_rec.budget_start_date :=
385: pqh_bgt_shd.g_old_rec.budget_start_date;
386: End If;
387: If (p_rec.budget_end_date = hr_api.g_date) then
388: p_rec.budget_end_date :=
389: pqh_bgt_shd.g_old_rec.budget_end_date;
390: End If;
391: If (p_rec.gl_budget_name = hr_api.g_varchar2) then

Line 391: If (p_rec.gl_budget_name = hr_api.g_varchar2) then

387: If (p_rec.budget_end_date = hr_api.g_date) then
388: p_rec.budget_end_date :=
389: pqh_bgt_shd.g_old_rec.budget_end_date;
390: End If;
391: If (p_rec.gl_budget_name = hr_api.g_varchar2) then
392: p_rec.gl_budget_name :=
393: pqh_bgt_shd.g_old_rec.gl_budget_name;
394: End If;
395: If (p_rec.psb_budget_flag = hr_api.g_varchar2) then

Line 395: If (p_rec.psb_budget_flag = hr_api.g_varchar2) then

391: If (p_rec.gl_budget_name = hr_api.g_varchar2) then
392: p_rec.gl_budget_name :=
393: pqh_bgt_shd.g_old_rec.gl_budget_name;
394: End If;
395: If (p_rec.psb_budget_flag = hr_api.g_varchar2) then
396: p_rec.psb_budget_flag :=
397: pqh_bgt_shd.g_old_rec.psb_budget_flag;
398: End If;
399: If (p_rec.transfer_to_gl_flag = hr_api.g_varchar2) then

Line 399: If (p_rec.transfer_to_gl_flag = hr_api.g_varchar2) then

395: If (p_rec.psb_budget_flag = hr_api.g_varchar2) then
396: p_rec.psb_budget_flag :=
397: pqh_bgt_shd.g_old_rec.psb_budget_flag;
398: End If;
399: If (p_rec.transfer_to_gl_flag = hr_api.g_varchar2) then
400: p_rec.transfer_to_gl_flag :=
401: pqh_bgt_shd.g_old_rec.transfer_to_gl_flag;
402: End If;
403: If (p_rec.transfer_to_grants_flag = hr_api.g_varchar2) then

Line 403: If (p_rec.transfer_to_grants_flag = hr_api.g_varchar2) then

399: If (p_rec.transfer_to_gl_flag = hr_api.g_varchar2) then
400: p_rec.transfer_to_gl_flag :=
401: pqh_bgt_shd.g_old_rec.transfer_to_gl_flag;
402: End If;
403: If (p_rec.transfer_to_grants_flag = hr_api.g_varchar2) then
404: p_rec.transfer_to_grants_flag :=
405: pqh_bgt_shd.g_old_rec.transfer_to_grants_flag;
406: End If;
407: If (p_rec.status = hr_api.g_varchar2) then

Line 407: If (p_rec.status = hr_api.g_varchar2) then

403: If (p_rec.transfer_to_grants_flag = hr_api.g_varchar2) then
404: p_rec.transfer_to_grants_flag :=
405: pqh_bgt_shd.g_old_rec.transfer_to_grants_flag;
406: End If;
407: If (p_rec.status = hr_api.g_varchar2) then
408: p_rec.status :=
409: pqh_bgt_shd.g_old_rec.status;
410: End If;
411: If (p_rec.budget_unit1_id = hr_api.g_number) then

Line 411: If (p_rec.budget_unit1_id = hr_api.g_number) then

407: If (p_rec.status = hr_api.g_varchar2) then
408: p_rec.status :=
409: pqh_bgt_shd.g_old_rec.status;
410: End If;
411: If (p_rec.budget_unit1_id = hr_api.g_number) then
412: p_rec.budget_unit1_id :=
413: pqh_bgt_shd.g_old_rec.budget_unit1_id;
414: End If;
415: If (p_rec.budget_unit2_id = hr_api.g_number) then

Line 415: If (p_rec.budget_unit2_id = hr_api.g_number) then

411: If (p_rec.budget_unit1_id = hr_api.g_number) then
412: p_rec.budget_unit1_id :=
413: pqh_bgt_shd.g_old_rec.budget_unit1_id;
414: End If;
415: If (p_rec.budget_unit2_id = hr_api.g_number) then
416: p_rec.budget_unit2_id :=
417: pqh_bgt_shd.g_old_rec.budget_unit2_id;
418: End If;
419: If (p_rec.budget_unit3_id = hr_api.g_number) then

Line 419: If (p_rec.budget_unit3_id = hr_api.g_number) then

415: If (p_rec.budget_unit2_id = hr_api.g_number) then
416: p_rec.budget_unit2_id :=
417: pqh_bgt_shd.g_old_rec.budget_unit2_id;
418: End If;
419: If (p_rec.budget_unit3_id = hr_api.g_number) then
420: p_rec.budget_unit3_id :=
421: pqh_bgt_shd.g_old_rec.budget_unit3_id;
422: End If;
423: If (p_rec.gl_set_of_books_id = hr_api.g_number) then

Line 423: If (p_rec.gl_set_of_books_id = hr_api.g_number) then

419: If (p_rec.budget_unit3_id = hr_api.g_number) then
420: p_rec.budget_unit3_id :=
421: pqh_bgt_shd.g_old_rec.budget_unit3_id;
422: End If;
423: If (p_rec.gl_set_of_books_id = hr_api.g_number) then
424: p_rec.gl_set_of_books_id :=
425: pqh_bgt_shd.g_old_rec.gl_set_of_books_id;
426: End If;
427: If (p_rec.budget_unit1_aggregate = hr_api.g_varchar2) then

Line 427: If (p_rec.budget_unit1_aggregate = hr_api.g_varchar2) then

423: If (p_rec.gl_set_of_books_id = hr_api.g_number) then
424: p_rec.gl_set_of_books_id :=
425: pqh_bgt_shd.g_old_rec.gl_set_of_books_id;
426: End If;
427: If (p_rec.budget_unit1_aggregate = hr_api.g_varchar2) then
428: p_rec.budget_unit1_aggregate :=
429: pqh_bgt_shd.g_old_rec.budget_unit1_aggregate;
430: End If;
431: If (p_rec.budget_unit2_aggregate = hr_api.g_varchar2) then

Line 431: If (p_rec.budget_unit2_aggregate = hr_api.g_varchar2) then

427: If (p_rec.budget_unit1_aggregate = hr_api.g_varchar2) then
428: p_rec.budget_unit1_aggregate :=
429: pqh_bgt_shd.g_old_rec.budget_unit1_aggregate;
430: End If;
431: If (p_rec.budget_unit2_aggregate = hr_api.g_varchar2) then
432: p_rec.budget_unit2_aggregate :=
433: pqh_bgt_shd.g_old_rec.budget_unit2_aggregate;
434: End If;
435: If (p_rec.budget_unit3_aggregate = hr_api.g_varchar2) then

Line 435: If (p_rec.budget_unit3_aggregate = hr_api.g_varchar2) then

431: If (p_rec.budget_unit2_aggregate = hr_api.g_varchar2) then
432: p_rec.budget_unit2_aggregate :=
433: pqh_bgt_shd.g_old_rec.budget_unit2_aggregate;
434: End If;
435: If (p_rec.budget_unit3_aggregate = hr_api.g_varchar2) then
436: p_rec.budget_unit3_aggregate :=
437: pqh_bgt_shd.g_old_rec.budget_unit3_aggregate;
438: End If;
439: If (p_rec.position_control_flag = hr_api.g_varchar2) then

Line 439: If (p_rec.position_control_flag = hr_api.g_varchar2) then

435: If (p_rec.budget_unit3_aggregate = hr_api.g_varchar2) then
436: p_rec.budget_unit3_aggregate :=
437: pqh_bgt_shd.g_old_rec.budget_unit3_aggregate;
438: End If;
439: If (p_rec.position_control_flag = hr_api.g_varchar2) then
440: p_rec.position_control_flag :=
441: pqh_bgt_shd.g_old_rec.position_control_flag;
442: End If;
443: If (p_rec.valid_grade_reqd_flag = hr_api.g_varchar2) then

Line 443: If (p_rec.valid_grade_reqd_flag = hr_api.g_varchar2) then

439: If (p_rec.position_control_flag = hr_api.g_varchar2) then
440: p_rec.position_control_flag :=
441: pqh_bgt_shd.g_old_rec.position_control_flag;
442: End If;
443: If (p_rec.valid_grade_reqd_flag = hr_api.g_varchar2) then
444: p_rec.valid_grade_reqd_flag :=
445: pqh_bgt_shd.g_old_rec.valid_grade_reqd_flag;
446: End If;
447: If (p_rec.currency_code = hr_api.g_varchar2) then

Line 447: If (p_rec.currency_code = hr_api.g_varchar2) then

443: If (p_rec.valid_grade_reqd_flag = hr_api.g_varchar2) then
444: p_rec.valid_grade_reqd_flag :=
445: pqh_bgt_shd.g_old_rec.valid_grade_reqd_flag;
446: End If;
447: If (p_rec.currency_code = hr_api.g_varchar2) then
448: p_rec.currency_code :=
449: pqh_bgt_shd.g_old_rec.currency_code;
450: End If;
451: If (p_rec.dflt_budget_set_id = hr_api.g_number) then

Line 451: If (p_rec.dflt_budget_set_id = hr_api.g_number) then

447: If (p_rec.currency_code = hr_api.g_varchar2) then
448: p_rec.currency_code :=
449: pqh_bgt_shd.g_old_rec.currency_code;
450: End If;
451: If (p_rec.dflt_budget_set_id = hr_api.g_number) then
452: p_rec.dflt_budget_set_id :=
453: pqh_bgt_shd.g_old_rec.dflt_budget_set_id;
454: End If;
455:

Line 514: p_business_group_id in number default hr_api.g_number,

510: Procedure upd
511: (
512: p_effective_date in date,
513: p_budget_id in number,
514: p_business_group_id in number default hr_api.g_number,
515: p_start_organization_id in number default hr_api.g_number,
516: p_org_structure_version_id in number default hr_api.g_number,
517: p_budgeted_entity_cd in varchar2 default hr_api.g_varchar2,
518: p_budget_style_cd in varchar2 default hr_api.g_varchar2,

Line 515: p_start_organization_id in number default hr_api.g_number,

511: (
512: p_effective_date in date,
513: p_budget_id in number,
514: p_business_group_id in number default hr_api.g_number,
515: p_start_organization_id in number default hr_api.g_number,
516: p_org_structure_version_id in number default hr_api.g_number,
517: p_budgeted_entity_cd in varchar2 default hr_api.g_varchar2,
518: p_budget_style_cd in varchar2 default hr_api.g_varchar2,
519: p_budget_name in varchar2 default hr_api.g_varchar2,

Line 516: p_org_structure_version_id in number default hr_api.g_number,

512: p_effective_date in date,
513: p_budget_id in number,
514: p_business_group_id in number default hr_api.g_number,
515: p_start_organization_id in number default hr_api.g_number,
516: p_org_structure_version_id in number default hr_api.g_number,
517: p_budgeted_entity_cd in varchar2 default hr_api.g_varchar2,
518: p_budget_style_cd in varchar2 default hr_api.g_varchar2,
519: p_budget_name in varchar2 default hr_api.g_varchar2,
520: p_period_set_name in varchar2 default hr_api.g_varchar2,

Line 517: p_budgeted_entity_cd in varchar2 default hr_api.g_varchar2,

513: p_budget_id in number,
514: p_business_group_id in number default hr_api.g_number,
515: p_start_organization_id in number default hr_api.g_number,
516: p_org_structure_version_id in number default hr_api.g_number,
517: p_budgeted_entity_cd in varchar2 default hr_api.g_varchar2,
518: p_budget_style_cd in varchar2 default hr_api.g_varchar2,
519: p_budget_name in varchar2 default hr_api.g_varchar2,
520: p_period_set_name in varchar2 default hr_api.g_varchar2,
521: p_budget_start_date in date default hr_api.g_date,

Line 518: p_budget_style_cd in varchar2 default hr_api.g_varchar2,

514: p_business_group_id in number default hr_api.g_number,
515: p_start_organization_id in number default hr_api.g_number,
516: p_org_structure_version_id in number default hr_api.g_number,
517: p_budgeted_entity_cd in varchar2 default hr_api.g_varchar2,
518: p_budget_style_cd in varchar2 default hr_api.g_varchar2,
519: p_budget_name in varchar2 default hr_api.g_varchar2,
520: p_period_set_name in varchar2 default hr_api.g_varchar2,
521: p_budget_start_date in date default hr_api.g_date,
522: p_budget_end_date in date default hr_api.g_date,

Line 519: p_budget_name in varchar2 default hr_api.g_varchar2,

515: p_start_organization_id in number default hr_api.g_number,
516: p_org_structure_version_id in number default hr_api.g_number,
517: p_budgeted_entity_cd in varchar2 default hr_api.g_varchar2,
518: p_budget_style_cd in varchar2 default hr_api.g_varchar2,
519: p_budget_name in varchar2 default hr_api.g_varchar2,
520: p_period_set_name in varchar2 default hr_api.g_varchar2,
521: p_budget_start_date in date default hr_api.g_date,
522: p_budget_end_date in date default hr_api.g_date,
523: p_gl_budget_name in varchar2 default hr_api.g_varchar2,

Line 520: p_period_set_name in varchar2 default hr_api.g_varchar2,

516: p_org_structure_version_id in number default hr_api.g_number,
517: p_budgeted_entity_cd in varchar2 default hr_api.g_varchar2,
518: p_budget_style_cd in varchar2 default hr_api.g_varchar2,
519: p_budget_name in varchar2 default hr_api.g_varchar2,
520: p_period_set_name in varchar2 default hr_api.g_varchar2,
521: p_budget_start_date in date default hr_api.g_date,
522: p_budget_end_date in date default hr_api.g_date,
523: p_gl_budget_name in varchar2 default hr_api.g_varchar2,
524: p_psb_budget_flag in varchar2 default hr_api.g_varchar2,

Line 521: p_budget_start_date in date default hr_api.g_date,

517: p_budgeted_entity_cd in varchar2 default hr_api.g_varchar2,
518: p_budget_style_cd in varchar2 default hr_api.g_varchar2,
519: p_budget_name in varchar2 default hr_api.g_varchar2,
520: p_period_set_name in varchar2 default hr_api.g_varchar2,
521: p_budget_start_date in date default hr_api.g_date,
522: p_budget_end_date in date default hr_api.g_date,
523: p_gl_budget_name in varchar2 default hr_api.g_varchar2,
524: p_psb_budget_flag in varchar2 default hr_api.g_varchar2,
525: p_transfer_to_gl_flag in varchar2 default hr_api.g_varchar2,

Line 522: p_budget_end_date in date default hr_api.g_date,

518: p_budget_style_cd in varchar2 default hr_api.g_varchar2,
519: p_budget_name in varchar2 default hr_api.g_varchar2,
520: p_period_set_name in varchar2 default hr_api.g_varchar2,
521: p_budget_start_date in date default hr_api.g_date,
522: p_budget_end_date in date default hr_api.g_date,
523: p_gl_budget_name in varchar2 default hr_api.g_varchar2,
524: p_psb_budget_flag in varchar2 default hr_api.g_varchar2,
525: p_transfer_to_gl_flag in varchar2 default hr_api.g_varchar2,
526: p_transfer_to_grants_flag in varchar2 default hr_api.g_varchar2,

Line 523: p_gl_budget_name in varchar2 default hr_api.g_varchar2,

519: p_budget_name in varchar2 default hr_api.g_varchar2,
520: p_period_set_name in varchar2 default hr_api.g_varchar2,
521: p_budget_start_date in date default hr_api.g_date,
522: p_budget_end_date in date default hr_api.g_date,
523: p_gl_budget_name in varchar2 default hr_api.g_varchar2,
524: p_psb_budget_flag in varchar2 default hr_api.g_varchar2,
525: p_transfer_to_gl_flag in varchar2 default hr_api.g_varchar2,
526: p_transfer_to_grants_flag in varchar2 default hr_api.g_varchar2,
527: p_status in varchar2 default hr_api.g_varchar2,

Line 524: p_psb_budget_flag in varchar2 default hr_api.g_varchar2,

520: p_period_set_name in varchar2 default hr_api.g_varchar2,
521: p_budget_start_date in date default hr_api.g_date,
522: p_budget_end_date in date default hr_api.g_date,
523: p_gl_budget_name in varchar2 default hr_api.g_varchar2,
524: p_psb_budget_flag in varchar2 default hr_api.g_varchar2,
525: p_transfer_to_gl_flag in varchar2 default hr_api.g_varchar2,
526: p_transfer_to_grants_flag in varchar2 default hr_api.g_varchar2,
527: p_status in varchar2 default hr_api.g_varchar2,
528: p_object_version_number in out nocopy number,

Line 525: p_transfer_to_gl_flag in varchar2 default hr_api.g_varchar2,

521: p_budget_start_date in date default hr_api.g_date,
522: p_budget_end_date in date default hr_api.g_date,
523: p_gl_budget_name in varchar2 default hr_api.g_varchar2,
524: p_psb_budget_flag in varchar2 default hr_api.g_varchar2,
525: p_transfer_to_gl_flag in varchar2 default hr_api.g_varchar2,
526: p_transfer_to_grants_flag in varchar2 default hr_api.g_varchar2,
527: p_status in varchar2 default hr_api.g_varchar2,
528: p_object_version_number in out nocopy number,
529: p_budget_unit1_id in number default hr_api.g_number,

Line 526: p_transfer_to_grants_flag in varchar2 default hr_api.g_varchar2,

522: p_budget_end_date in date default hr_api.g_date,
523: p_gl_budget_name in varchar2 default hr_api.g_varchar2,
524: p_psb_budget_flag in varchar2 default hr_api.g_varchar2,
525: p_transfer_to_gl_flag in varchar2 default hr_api.g_varchar2,
526: p_transfer_to_grants_flag in varchar2 default hr_api.g_varchar2,
527: p_status in varchar2 default hr_api.g_varchar2,
528: p_object_version_number in out nocopy number,
529: p_budget_unit1_id in number default hr_api.g_number,
530: p_budget_unit2_id in number default hr_api.g_number,

Line 527: p_status in varchar2 default hr_api.g_varchar2,

523: p_gl_budget_name in varchar2 default hr_api.g_varchar2,
524: p_psb_budget_flag in varchar2 default hr_api.g_varchar2,
525: p_transfer_to_gl_flag in varchar2 default hr_api.g_varchar2,
526: p_transfer_to_grants_flag in varchar2 default hr_api.g_varchar2,
527: p_status in varchar2 default hr_api.g_varchar2,
528: p_object_version_number in out nocopy number,
529: p_budget_unit1_id in number default hr_api.g_number,
530: p_budget_unit2_id in number default hr_api.g_number,
531: p_budget_unit3_id in number default hr_api.g_number,

Line 529: p_budget_unit1_id in number default hr_api.g_number,

525: p_transfer_to_gl_flag in varchar2 default hr_api.g_varchar2,
526: p_transfer_to_grants_flag in varchar2 default hr_api.g_varchar2,
527: p_status in varchar2 default hr_api.g_varchar2,
528: p_object_version_number in out nocopy number,
529: p_budget_unit1_id in number default hr_api.g_number,
530: p_budget_unit2_id in number default hr_api.g_number,
531: p_budget_unit3_id in number default hr_api.g_number,
532: p_gl_set_of_books_id in number default hr_api.g_number,
533: p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2,

Line 530: p_budget_unit2_id in number default hr_api.g_number,

526: p_transfer_to_grants_flag in varchar2 default hr_api.g_varchar2,
527: p_status in varchar2 default hr_api.g_varchar2,
528: p_object_version_number in out nocopy number,
529: p_budget_unit1_id in number default hr_api.g_number,
530: p_budget_unit2_id in number default hr_api.g_number,
531: p_budget_unit3_id in number default hr_api.g_number,
532: p_gl_set_of_books_id in number default hr_api.g_number,
533: p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2,
534: p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2,

Line 531: p_budget_unit3_id in number default hr_api.g_number,

527: p_status in varchar2 default hr_api.g_varchar2,
528: p_object_version_number in out nocopy number,
529: p_budget_unit1_id in number default hr_api.g_number,
530: p_budget_unit2_id in number default hr_api.g_number,
531: p_budget_unit3_id in number default hr_api.g_number,
532: p_gl_set_of_books_id in number default hr_api.g_number,
533: p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2,
534: p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2,
535: p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2,

Line 532: p_gl_set_of_books_id in number default hr_api.g_number,

528: p_object_version_number in out nocopy number,
529: p_budget_unit1_id in number default hr_api.g_number,
530: p_budget_unit2_id in number default hr_api.g_number,
531: p_budget_unit3_id in number default hr_api.g_number,
532: p_gl_set_of_books_id in number default hr_api.g_number,
533: p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2,
534: p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2,
535: p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2,
536: p_position_control_flag in varchar2 default hr_api.g_varchar2,

Line 533: p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2,

529: p_budget_unit1_id in number default hr_api.g_number,
530: p_budget_unit2_id in number default hr_api.g_number,
531: p_budget_unit3_id in number default hr_api.g_number,
532: p_gl_set_of_books_id in number default hr_api.g_number,
533: p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2,
534: p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2,
535: p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2,
536: p_position_control_flag in varchar2 default hr_api.g_varchar2,
537: p_valid_grade_reqd_flag in varchar2 default hr_api.g_varchar2,

Line 534: p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2,

530: p_budget_unit2_id in number default hr_api.g_number,
531: p_budget_unit3_id in number default hr_api.g_number,
532: p_gl_set_of_books_id in number default hr_api.g_number,
533: p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2,
534: p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2,
535: p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2,
536: p_position_control_flag in varchar2 default hr_api.g_varchar2,
537: p_valid_grade_reqd_flag in varchar2 default hr_api.g_varchar2,
538: p_currency_code in varchar2 default hr_api.g_varchar2,

Line 535: p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2,

531: p_budget_unit3_id in number default hr_api.g_number,
532: p_gl_set_of_books_id in number default hr_api.g_number,
533: p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2,
534: p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2,
535: p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2,
536: p_position_control_flag in varchar2 default hr_api.g_varchar2,
537: p_valid_grade_reqd_flag in varchar2 default hr_api.g_varchar2,
538: p_currency_code in varchar2 default hr_api.g_varchar2,
539: p_dflt_budget_set_id in number default hr_api.g_number

Line 536: p_position_control_flag in varchar2 default hr_api.g_varchar2,

532: p_gl_set_of_books_id in number default hr_api.g_number,
533: p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2,
534: p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2,
535: p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2,
536: p_position_control_flag in varchar2 default hr_api.g_varchar2,
537: p_valid_grade_reqd_flag in varchar2 default hr_api.g_varchar2,
538: p_currency_code in varchar2 default hr_api.g_varchar2,
539: p_dflt_budget_set_id in number default hr_api.g_number
540: ) is

Line 537: p_valid_grade_reqd_flag in varchar2 default hr_api.g_varchar2,

533: p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2,
534: p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2,
535: p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2,
536: p_position_control_flag in varchar2 default hr_api.g_varchar2,
537: p_valid_grade_reqd_flag in varchar2 default hr_api.g_varchar2,
538: p_currency_code in varchar2 default hr_api.g_varchar2,
539: p_dflt_budget_set_id in number default hr_api.g_number
540: ) is
541: --

Line 538: p_currency_code in varchar2 default hr_api.g_varchar2,

534: p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2,
535: p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2,
536: p_position_control_flag in varchar2 default hr_api.g_varchar2,
537: p_valid_grade_reqd_flag in varchar2 default hr_api.g_varchar2,
538: p_currency_code in varchar2 default hr_api.g_varchar2,
539: p_dflt_budget_set_id in number default hr_api.g_number
540: ) is
541: --
542: l_rec pqh_bgt_shd.g_rec_type;

Line 539: p_dflt_budget_set_id in number default hr_api.g_number

535: p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2,
536: p_position_control_flag in varchar2 default hr_api.g_varchar2,
537: p_valid_grade_reqd_flag in varchar2 default hr_api.g_varchar2,
538: p_currency_code in varchar2 default hr_api.g_varchar2,
539: p_dflt_budget_set_id in number default hr_api.g_number
540: ) is
541: --
542: l_rec pqh_bgt_shd.g_rec_type;
543: l_proc varchar2(72) := g_package||'upd';