92: ,p_dflt_budget_set_id => p_dflt_budget_set_id
93: ,p_effective_date => trunc(p_effective_date)
94: );
95: exception
96: when hr_api.cannot_find_prog_unit then
97: hr_api.cannot_find_prog_unit_error
98: (
99: p_module_name => 'create_budget'
100: ,p_hook_type => 'BP'
93: ,p_effective_date => trunc(p_effective_date)
94: );
95: exception
96: when hr_api.cannot_find_prog_unit then
97: hr_api.cannot_find_prog_unit_error
98: (
99: p_module_name => 'create_budget'
100: ,p_hook_type => 'BP'
101: );
171: ,p_dflt_budget_set_id => p_dflt_budget_set_id
172: ,p_effective_date => trunc(p_effective_date)
173: );
174: exception
175: when hr_api.cannot_find_prog_unit then
176: hr_api.cannot_find_prog_unit_error
177: (p_module_name => 'create_budget'
178: ,p_hook_type => 'AP'
179: );
172: ,p_effective_date => trunc(p_effective_date)
173: );
174: exception
175: when hr_api.cannot_find_prog_unit then
176: hr_api.cannot_find_prog_unit_error
177: (p_module_name => 'create_budget'
178: ,p_hook_type => 'AP'
179: );
180: --
186: --
187: -- When in validation only mode raise the Validate_Enabled exception
188: --
189: if p_validate then
190: raise hr_api.validate_enabled;
191: end if;
192: --
193: -- Set all output arguments
194: --
198: hr_utility.set_location(' Leaving:'||l_proc, 70);
199: --
200: exception
201: --
202: when hr_api.validate_enabled then
203: --
204: -- As the Validate_Enabled exception has been raised
205: -- we must rollback to the savepoint
206: --
230: --
231: procedure update_budget
232: (p_validate in boolean default false
233: ,p_budget_id in number
234: ,p_business_group_id in number default hr_api.g_number
235: ,p_start_organization_id in number default hr_api.g_number
236: ,p_org_structure_version_id in number default hr_api.g_number
237: ,p_budgeted_entity_cd in varchar2 default hr_api.g_varchar2
238: ,p_budget_style_cd in varchar2 default hr_api.g_varchar2
231: procedure update_budget
232: (p_validate in boolean default false
233: ,p_budget_id in number
234: ,p_business_group_id in number default hr_api.g_number
235: ,p_start_organization_id in number default hr_api.g_number
236: ,p_org_structure_version_id in number default hr_api.g_number
237: ,p_budgeted_entity_cd in varchar2 default hr_api.g_varchar2
238: ,p_budget_style_cd in varchar2 default hr_api.g_varchar2
239: ,p_budget_name in varchar2 default hr_api.g_varchar2
232: (p_validate in boolean default false
233: ,p_budget_id in number
234: ,p_business_group_id in number default hr_api.g_number
235: ,p_start_organization_id in number default hr_api.g_number
236: ,p_org_structure_version_id in number default hr_api.g_number
237: ,p_budgeted_entity_cd in varchar2 default hr_api.g_varchar2
238: ,p_budget_style_cd in varchar2 default hr_api.g_varchar2
239: ,p_budget_name in varchar2 default hr_api.g_varchar2
240: ,p_period_set_name in varchar2 default hr_api.g_varchar2
233: ,p_budget_id in number
234: ,p_business_group_id in number default hr_api.g_number
235: ,p_start_organization_id in number default hr_api.g_number
236: ,p_org_structure_version_id in number default hr_api.g_number
237: ,p_budgeted_entity_cd in varchar2 default hr_api.g_varchar2
238: ,p_budget_style_cd in varchar2 default hr_api.g_varchar2
239: ,p_budget_name in varchar2 default hr_api.g_varchar2
240: ,p_period_set_name in varchar2 default hr_api.g_varchar2
241: ,p_budget_start_date in date default hr_api.g_date
234: ,p_business_group_id in number default hr_api.g_number
235: ,p_start_organization_id in number default hr_api.g_number
236: ,p_org_structure_version_id in number default hr_api.g_number
237: ,p_budgeted_entity_cd in varchar2 default hr_api.g_varchar2
238: ,p_budget_style_cd in varchar2 default hr_api.g_varchar2
239: ,p_budget_name in varchar2 default hr_api.g_varchar2
240: ,p_period_set_name in varchar2 default hr_api.g_varchar2
241: ,p_budget_start_date in date default hr_api.g_date
242: ,p_budget_end_date in date default hr_api.g_date
235: ,p_start_organization_id in number default hr_api.g_number
236: ,p_org_structure_version_id in number default hr_api.g_number
237: ,p_budgeted_entity_cd in varchar2 default hr_api.g_varchar2
238: ,p_budget_style_cd in varchar2 default hr_api.g_varchar2
239: ,p_budget_name in varchar2 default hr_api.g_varchar2
240: ,p_period_set_name in varchar2 default hr_api.g_varchar2
241: ,p_budget_start_date in date default hr_api.g_date
242: ,p_budget_end_date in date default hr_api.g_date
243: ,p_gl_budget_name in varchar2 default hr_api.g_varchar2
236: ,p_org_structure_version_id in number default hr_api.g_number
237: ,p_budgeted_entity_cd in varchar2 default hr_api.g_varchar2
238: ,p_budget_style_cd in varchar2 default hr_api.g_varchar2
239: ,p_budget_name in varchar2 default hr_api.g_varchar2
240: ,p_period_set_name in varchar2 default hr_api.g_varchar2
241: ,p_budget_start_date in date default hr_api.g_date
242: ,p_budget_end_date in date default hr_api.g_date
243: ,p_gl_budget_name in varchar2 default hr_api.g_varchar2
244: ,p_psb_budget_flag in varchar2 default hr_api.g_varchar2
237: ,p_budgeted_entity_cd in varchar2 default hr_api.g_varchar2
238: ,p_budget_style_cd in varchar2 default hr_api.g_varchar2
239: ,p_budget_name in varchar2 default hr_api.g_varchar2
240: ,p_period_set_name in varchar2 default hr_api.g_varchar2
241: ,p_budget_start_date in date default hr_api.g_date
242: ,p_budget_end_date in date default hr_api.g_date
243: ,p_gl_budget_name in varchar2 default hr_api.g_varchar2
244: ,p_psb_budget_flag in varchar2 default hr_api.g_varchar2
245: ,p_transfer_to_gl_flag in varchar2 default hr_api.g_varchar2
238: ,p_budget_style_cd in varchar2 default hr_api.g_varchar2
239: ,p_budget_name in varchar2 default hr_api.g_varchar2
240: ,p_period_set_name in varchar2 default hr_api.g_varchar2
241: ,p_budget_start_date in date default hr_api.g_date
242: ,p_budget_end_date in date default hr_api.g_date
243: ,p_gl_budget_name in varchar2 default hr_api.g_varchar2
244: ,p_psb_budget_flag in varchar2 default hr_api.g_varchar2
245: ,p_transfer_to_gl_flag in varchar2 default hr_api.g_varchar2
246: ,p_transfer_to_grants_flag in varchar2 default hr_api.g_varchar2
239: ,p_budget_name in varchar2 default hr_api.g_varchar2
240: ,p_period_set_name in varchar2 default hr_api.g_varchar2
241: ,p_budget_start_date in date default hr_api.g_date
242: ,p_budget_end_date in date default hr_api.g_date
243: ,p_gl_budget_name in varchar2 default hr_api.g_varchar2
244: ,p_psb_budget_flag in varchar2 default hr_api.g_varchar2
245: ,p_transfer_to_gl_flag in varchar2 default hr_api.g_varchar2
246: ,p_transfer_to_grants_flag in varchar2 default hr_api.g_varchar2
247: ,p_status in varchar2 default hr_api.g_varchar2
240: ,p_period_set_name in varchar2 default hr_api.g_varchar2
241: ,p_budget_start_date in date default hr_api.g_date
242: ,p_budget_end_date in date default hr_api.g_date
243: ,p_gl_budget_name in varchar2 default hr_api.g_varchar2
244: ,p_psb_budget_flag in varchar2 default hr_api.g_varchar2
245: ,p_transfer_to_gl_flag in varchar2 default hr_api.g_varchar2
246: ,p_transfer_to_grants_flag in varchar2 default hr_api.g_varchar2
247: ,p_status in varchar2 default hr_api.g_varchar2
248: ,p_object_version_number in out nocopy number
241: ,p_budget_start_date in date default hr_api.g_date
242: ,p_budget_end_date in date default hr_api.g_date
243: ,p_gl_budget_name in varchar2 default hr_api.g_varchar2
244: ,p_psb_budget_flag in varchar2 default hr_api.g_varchar2
245: ,p_transfer_to_gl_flag in varchar2 default hr_api.g_varchar2
246: ,p_transfer_to_grants_flag in varchar2 default hr_api.g_varchar2
247: ,p_status in varchar2 default hr_api.g_varchar2
248: ,p_object_version_number in out nocopy number
249: ,p_budget_unit1_id in number default hr_api.g_number
242: ,p_budget_end_date in date default hr_api.g_date
243: ,p_gl_budget_name in varchar2 default hr_api.g_varchar2
244: ,p_psb_budget_flag in varchar2 default hr_api.g_varchar2
245: ,p_transfer_to_gl_flag in varchar2 default hr_api.g_varchar2
246: ,p_transfer_to_grants_flag in varchar2 default hr_api.g_varchar2
247: ,p_status in varchar2 default hr_api.g_varchar2
248: ,p_object_version_number in out nocopy number
249: ,p_budget_unit1_id in number default hr_api.g_number
250: ,p_budget_unit2_id in number default hr_api.g_number
243: ,p_gl_budget_name in varchar2 default hr_api.g_varchar2
244: ,p_psb_budget_flag in varchar2 default hr_api.g_varchar2
245: ,p_transfer_to_gl_flag in varchar2 default hr_api.g_varchar2
246: ,p_transfer_to_grants_flag in varchar2 default hr_api.g_varchar2
247: ,p_status in varchar2 default hr_api.g_varchar2
248: ,p_object_version_number in out nocopy number
249: ,p_budget_unit1_id in number default hr_api.g_number
250: ,p_budget_unit2_id in number default hr_api.g_number
251: ,p_budget_unit3_id in number default hr_api.g_number
245: ,p_transfer_to_gl_flag in varchar2 default hr_api.g_varchar2
246: ,p_transfer_to_grants_flag in varchar2 default hr_api.g_varchar2
247: ,p_status in varchar2 default hr_api.g_varchar2
248: ,p_object_version_number in out nocopy number
249: ,p_budget_unit1_id in number default hr_api.g_number
250: ,p_budget_unit2_id in number default hr_api.g_number
251: ,p_budget_unit3_id in number default hr_api.g_number
252: ,p_gl_set_of_books_id in number default hr_api.g_number
253: ,p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2
246: ,p_transfer_to_grants_flag in varchar2 default hr_api.g_varchar2
247: ,p_status in varchar2 default hr_api.g_varchar2
248: ,p_object_version_number in out nocopy number
249: ,p_budget_unit1_id in number default hr_api.g_number
250: ,p_budget_unit2_id in number default hr_api.g_number
251: ,p_budget_unit3_id in number default hr_api.g_number
252: ,p_gl_set_of_books_id in number default hr_api.g_number
253: ,p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2
254: ,p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2
247: ,p_status in varchar2 default hr_api.g_varchar2
248: ,p_object_version_number in out nocopy number
249: ,p_budget_unit1_id in number default hr_api.g_number
250: ,p_budget_unit2_id in number default hr_api.g_number
251: ,p_budget_unit3_id in number default hr_api.g_number
252: ,p_gl_set_of_books_id in number default hr_api.g_number
253: ,p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2
254: ,p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2
255: ,p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2
248: ,p_object_version_number in out nocopy number
249: ,p_budget_unit1_id in number default hr_api.g_number
250: ,p_budget_unit2_id in number default hr_api.g_number
251: ,p_budget_unit3_id in number default hr_api.g_number
252: ,p_gl_set_of_books_id in number default hr_api.g_number
253: ,p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2
254: ,p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2
255: ,p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2
256: ,p_position_control_flag in varchar2 default hr_api.g_varchar2
249: ,p_budget_unit1_id in number default hr_api.g_number
250: ,p_budget_unit2_id in number default hr_api.g_number
251: ,p_budget_unit3_id in number default hr_api.g_number
252: ,p_gl_set_of_books_id in number default hr_api.g_number
253: ,p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2
254: ,p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2
255: ,p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2
256: ,p_position_control_flag in varchar2 default hr_api.g_varchar2
257: ,p_valid_grade_reqd_flag in varchar2 default hr_api.g_varchar2
250: ,p_budget_unit2_id in number default hr_api.g_number
251: ,p_budget_unit3_id in number default hr_api.g_number
252: ,p_gl_set_of_books_id in number default hr_api.g_number
253: ,p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2
254: ,p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2
255: ,p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2
256: ,p_position_control_flag in varchar2 default hr_api.g_varchar2
257: ,p_valid_grade_reqd_flag in varchar2 default hr_api.g_varchar2
258: ,p_currency_code in varchar2 default hr_api.g_varchar2
251: ,p_budget_unit3_id in number default hr_api.g_number
252: ,p_gl_set_of_books_id in number default hr_api.g_number
253: ,p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2
254: ,p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2
255: ,p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2
256: ,p_position_control_flag in varchar2 default hr_api.g_varchar2
257: ,p_valid_grade_reqd_flag in varchar2 default hr_api.g_varchar2
258: ,p_currency_code in varchar2 default hr_api.g_varchar2
259: ,p_dflt_budget_set_id in number default hr_api.g_number
252: ,p_gl_set_of_books_id in number default hr_api.g_number
253: ,p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2
254: ,p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2
255: ,p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2
256: ,p_position_control_flag in varchar2 default hr_api.g_varchar2
257: ,p_valid_grade_reqd_flag in varchar2 default hr_api.g_varchar2
258: ,p_currency_code in varchar2 default hr_api.g_varchar2
259: ,p_dflt_budget_set_id in number default hr_api.g_number
260: ,p_effective_date in date
253: ,p_budget_unit1_aggregate in varchar2 default hr_api.g_varchar2
254: ,p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2
255: ,p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2
256: ,p_position_control_flag in varchar2 default hr_api.g_varchar2
257: ,p_valid_grade_reqd_flag in varchar2 default hr_api.g_varchar2
258: ,p_currency_code in varchar2 default hr_api.g_varchar2
259: ,p_dflt_budget_set_id in number default hr_api.g_number
260: ,p_effective_date in date
261: ) is
254: ,p_budget_unit2_aggregate in varchar2 default hr_api.g_varchar2
255: ,p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2
256: ,p_position_control_flag in varchar2 default hr_api.g_varchar2
257: ,p_valid_grade_reqd_flag in varchar2 default hr_api.g_varchar2
258: ,p_currency_code in varchar2 default hr_api.g_varchar2
259: ,p_dflt_budget_set_id in number default hr_api.g_number
260: ,p_effective_date in date
261: ) is
262: --
255: ,p_budget_unit3_aggregate in varchar2 default hr_api.g_varchar2
256: ,p_position_control_flag in varchar2 default hr_api.g_varchar2
257: ,p_valid_grade_reqd_flag in varchar2 default hr_api.g_varchar2
258: ,p_currency_code in varchar2 default hr_api.g_varchar2
259: ,p_dflt_budget_set_id in number default hr_api.g_number
260: ,p_effective_date in date
261: ) is
262: --
263: -- Declare cursors and local variables
314: ,p_dflt_budget_set_id => p_dflt_budget_set_id
315: ,p_effective_date => trunc(p_effective_date)
316: );
317: exception
318: when hr_api.cannot_find_prog_unit then
319: hr_api.cannot_find_prog_unit_error
320: (p_module_name => 'update_budget'
321: ,p_hook_type => 'BP'
322: );
315: ,p_effective_date => trunc(p_effective_date)
316: );
317: exception
318: when hr_api.cannot_find_prog_unit then
319: hr_api.cannot_find_prog_unit_error
320: (p_module_name => 'update_budget'
321: ,p_hook_type => 'BP'
322: );
323: --
392: ,p_dflt_budget_set_id => p_dflt_budget_set_id
393: ,p_effective_date => trunc(p_effective_date)
394: );
395: exception
396: when hr_api.cannot_find_prog_unit then
397: hr_api.cannot_find_prog_unit_error
398: (p_module_name => 'update_budget'
399: ,p_hook_type => 'AP'
400: );
393: ,p_effective_date => trunc(p_effective_date)
394: );
395: exception
396: when hr_api.cannot_find_prog_unit then
397: hr_api.cannot_find_prog_unit_error
398: (p_module_name => 'update_budget'
399: ,p_hook_type => 'AP'
400: );
401: --
407: --
408: -- When in validation only mode raise the Validate_Enabled exception
409: --
410: if p_validate then
411: raise hr_api.validate_enabled;
412: end if;
413: --
414: -- Set all output arguments
415: --
418: hr_utility.set_location(' Leaving:'||l_proc, 70);
419: --
420: exception
421: --
422: when hr_api.validate_enabled then
423: --
424: -- As the Validate_Enabled exception has been raised
425: -- we must rollback to the savepoint
426: --
482: ,p_object_version_number => p_object_version_number
483: ,p_effective_date => trunc(p_effective_date)
484: );
485: exception
486: when hr_api.cannot_find_prog_unit then
487: hr_api.cannot_find_prog_unit_error
488: (p_module_name => 'delete_budget'
489: ,p_hook_type => 'BP'
490: );
483: ,p_effective_date => trunc(p_effective_date)
484: );
485: exception
486: when hr_api.cannot_find_prog_unit then
487: hr_api.cannot_find_prog_unit_error
488: (p_module_name => 'delete_budget'
489: ,p_hook_type => 'BP'
490: );
491: --
510: ,p_object_version_number => l_object_version_number
511: ,p_effective_date => trunc(p_effective_date)
512: );
513: exception
514: when hr_api.cannot_find_prog_unit then
515: hr_api.cannot_find_prog_unit_error
516: (p_module_name => 'delete_budget'
517: ,p_hook_type => 'AP'
518: );
511: ,p_effective_date => trunc(p_effective_date)
512: );
513: exception
514: when hr_api.cannot_find_prog_unit then
515: hr_api.cannot_find_prog_unit_error
516: (p_module_name => 'delete_budget'
517: ,p_hook_type => 'AP'
518: );
519: --
525: --
526: -- When in validation only mode raise the Validate_Enabled exception
527: --
528: if p_validate then
529: raise hr_api.validate_enabled;
530: end if;
531: --
532: hr_utility.set_location(' Leaving:'||l_proc, 70);
533: --
532: hr_utility.set_location(' Leaving:'||l_proc, 70);
533: --
534: exception
535: --
536: when hr_api.validate_enabled then
537: --
538: -- As the Validate_Enabled exception has been raised
539: -- we must rollback to the savepoint
540: --