68: ,p_budget_unit3_available => p_budget_unit3_available
69: ,p_effective_date => trunc(p_effective_date)
70: );
71: exception
72: when hr_api.cannot_find_prog_unit then
73: hr_api.cannot_find_prog_unit_error
74: (
75: p_module_name => 'create_budget_version'
76: ,p_hook_type => 'BP'
69: ,p_effective_date => trunc(p_effective_date)
70: );
71: exception
72: when hr_api.cannot_find_prog_unit then
73: hr_api.cannot_find_prog_unit_error
74: (
75: p_module_name => 'create_budget_version'
76: ,p_hook_type => 'BP'
77: );
123: ,p_budget_unit3_available => p_budget_unit3_available
124: ,p_effective_date => trunc(p_effective_date)
125: );
126: exception
127: when hr_api.cannot_find_prog_unit then
128: hr_api.cannot_find_prog_unit_error
129: (p_module_name => 'create_budget_version'
130: ,p_hook_type => 'AP'
131: );
124: ,p_effective_date => trunc(p_effective_date)
125: );
126: exception
127: when hr_api.cannot_find_prog_unit then
128: hr_api.cannot_find_prog_unit_error
129: (p_module_name => 'create_budget_version'
130: ,p_hook_type => 'AP'
131: );
132: --
138: --
139: -- When in validation only mode raise the Validate_Enabled exception
140: --
141: if p_validate then
142: raise hr_api.validate_enabled;
143: end if;
144: --
145: -- Set all output arguments
146: --
150: hr_utility.set_location(' Leaving:'||l_proc, 70);
151: --
152: exception
153: --
154: when hr_api.validate_enabled then
155: --
156: -- As the Validate_Enabled exception has been raised
157: -- we must rollback to the savepoint
158: --
182: --
183: procedure update_budget_version
184: (p_validate in boolean default false
185: ,p_budget_version_id in number
186: ,p_budget_id in number default hr_api.g_number
187: ,p_version_number in number default hr_api.g_number
188: ,p_date_from in date default hr_api.g_date
189: ,p_date_to in date default hr_api.g_date
190: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
183: procedure update_budget_version
184: (p_validate in boolean default false
185: ,p_budget_version_id in number
186: ,p_budget_id in number default hr_api.g_number
187: ,p_version_number in number default hr_api.g_number
188: ,p_date_from in date default hr_api.g_date
189: ,p_date_to in date default hr_api.g_date
190: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
191: ,p_gl_status in varchar2 default hr_api.g_varchar2
184: (p_validate in boolean default false
185: ,p_budget_version_id in number
186: ,p_budget_id in number default hr_api.g_number
187: ,p_version_number in number default hr_api.g_number
188: ,p_date_from in date default hr_api.g_date
189: ,p_date_to in date default hr_api.g_date
190: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
191: ,p_gl_status in varchar2 default hr_api.g_varchar2
192: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
185: ,p_budget_version_id in number
186: ,p_budget_id in number default hr_api.g_number
187: ,p_version_number in number default hr_api.g_number
188: ,p_date_from in date default hr_api.g_date
189: ,p_date_to in date default hr_api.g_date
190: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
191: ,p_gl_status in varchar2 default hr_api.g_varchar2
192: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
193: ,p_object_version_number in out nocopy number
186: ,p_budget_id in number default hr_api.g_number
187: ,p_version_number in number default hr_api.g_number
188: ,p_date_from in date default hr_api.g_date
189: ,p_date_to in date default hr_api.g_date
190: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
191: ,p_gl_status in varchar2 default hr_api.g_varchar2
192: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
193: ,p_object_version_number in out nocopy number
194: ,p_budget_unit1_value in number default hr_api.g_number
187: ,p_version_number in number default hr_api.g_number
188: ,p_date_from in date default hr_api.g_date
189: ,p_date_to in date default hr_api.g_date
190: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
191: ,p_gl_status in varchar2 default hr_api.g_varchar2
192: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
193: ,p_object_version_number in out nocopy number
194: ,p_budget_unit1_value in number default hr_api.g_number
195: ,p_budget_unit2_value in number default hr_api.g_number
188: ,p_date_from in date default hr_api.g_date
189: ,p_date_to in date default hr_api.g_date
190: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
191: ,p_gl_status in varchar2 default hr_api.g_varchar2
192: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
193: ,p_object_version_number in out nocopy number
194: ,p_budget_unit1_value in number default hr_api.g_number
195: ,p_budget_unit2_value in number default hr_api.g_number
196: ,p_budget_unit3_value in number default hr_api.g_number
190: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
191: ,p_gl_status in varchar2 default hr_api.g_varchar2
192: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
193: ,p_object_version_number in out nocopy number
194: ,p_budget_unit1_value in number default hr_api.g_number
195: ,p_budget_unit2_value in number default hr_api.g_number
196: ,p_budget_unit3_value in number default hr_api.g_number
197: ,p_budget_unit1_available in number default hr_api.g_number
198: ,p_budget_unit2_available in number default hr_api.g_number
191: ,p_gl_status in varchar2 default hr_api.g_varchar2
192: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
193: ,p_object_version_number in out nocopy number
194: ,p_budget_unit1_value in number default hr_api.g_number
195: ,p_budget_unit2_value in number default hr_api.g_number
196: ,p_budget_unit3_value in number default hr_api.g_number
197: ,p_budget_unit1_available in number default hr_api.g_number
198: ,p_budget_unit2_available in number default hr_api.g_number
199: ,p_budget_unit3_available in number default hr_api.g_number
192: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
193: ,p_object_version_number in out nocopy number
194: ,p_budget_unit1_value in number default hr_api.g_number
195: ,p_budget_unit2_value in number default hr_api.g_number
196: ,p_budget_unit3_value in number default hr_api.g_number
197: ,p_budget_unit1_available in number default hr_api.g_number
198: ,p_budget_unit2_available in number default hr_api.g_number
199: ,p_budget_unit3_available in number default hr_api.g_number
200: ,p_effective_date in date
193: ,p_object_version_number in out nocopy number
194: ,p_budget_unit1_value in number default hr_api.g_number
195: ,p_budget_unit2_value in number default hr_api.g_number
196: ,p_budget_unit3_value in number default hr_api.g_number
197: ,p_budget_unit1_available in number default hr_api.g_number
198: ,p_budget_unit2_available in number default hr_api.g_number
199: ,p_budget_unit3_available in number default hr_api.g_number
200: ,p_effective_date in date
201: ) is
194: ,p_budget_unit1_value in number default hr_api.g_number
195: ,p_budget_unit2_value in number default hr_api.g_number
196: ,p_budget_unit3_value in number default hr_api.g_number
197: ,p_budget_unit1_available in number default hr_api.g_number
198: ,p_budget_unit2_available in number default hr_api.g_number
199: ,p_budget_unit3_available in number default hr_api.g_number
200: ,p_effective_date in date
201: ) is
202: --
195: ,p_budget_unit2_value in number default hr_api.g_number
196: ,p_budget_unit3_value in number default hr_api.g_number
197: ,p_budget_unit1_available in number default hr_api.g_number
198: ,p_budget_unit2_available in number default hr_api.g_number
199: ,p_budget_unit3_available in number default hr_api.g_number
200: ,p_effective_date in date
201: ) is
202: --
203: -- Declare cursors and local variables
242: ,p_budget_unit3_available => p_budget_unit3_available
243: ,p_effective_date => trunc(p_effective_date)
244: );
245: exception
246: when hr_api.cannot_find_prog_unit then
247: hr_api.cannot_find_prog_unit_error
248: (p_module_name => 'update_budget_version'
249: ,p_hook_type => 'BP'
250: );
243: ,p_effective_date => trunc(p_effective_date)
244: );
245: exception
246: when hr_api.cannot_find_prog_unit then
247: hr_api.cannot_find_prog_unit_error
248: (p_module_name => 'update_budget_version'
249: ,p_hook_type => 'BP'
250: );
251: --
296: ,p_budget_unit3_available => p_budget_unit3_available
297: ,p_effective_date => trunc(p_effective_date)
298: );
299: exception
300: when hr_api.cannot_find_prog_unit then
301: hr_api.cannot_find_prog_unit_error
302: (p_module_name => 'update_budget_version'
303: ,p_hook_type => 'AP'
304: );
297: ,p_effective_date => trunc(p_effective_date)
298: );
299: exception
300: when hr_api.cannot_find_prog_unit then
301: hr_api.cannot_find_prog_unit_error
302: (p_module_name => 'update_budget_version'
303: ,p_hook_type => 'AP'
304: );
305: --
311: --
312: -- When in validation only mode raise the Validate_Enabled exception
313: --
314: if p_validate then
315: raise hr_api.validate_enabled;
316: end if;
317: --
318: -- Set all output arguments
319: --
322: hr_utility.set_location(' Leaving:'||l_proc, 70);
323: --
324: exception
325: --
326: when hr_api.validate_enabled then
327: --
328: -- As the Validate_Enabled exception has been raised
329: -- we must rollback to the savepoint
330: --
386: ,p_object_version_number => p_object_version_number
387: ,p_effective_date => trunc(p_effective_date)
388: );
389: exception
390: when hr_api.cannot_find_prog_unit then
391: hr_api.cannot_find_prog_unit_error
392: (p_module_name => 'delete_budget_version'
393: ,p_hook_type => 'BP'
394: );
387: ,p_effective_date => trunc(p_effective_date)
388: );
389: exception
390: when hr_api.cannot_find_prog_unit then
391: hr_api.cannot_find_prog_unit_error
392: (p_module_name => 'delete_budget_version'
393: ,p_hook_type => 'BP'
394: );
395: --
414: ,p_object_version_number => l_object_version_number
415: ,p_effective_date => trunc(p_effective_date)
416: );
417: exception
418: when hr_api.cannot_find_prog_unit then
419: hr_api.cannot_find_prog_unit_error
420: (p_module_name => 'delete_budget_version'
421: ,p_hook_type => 'AP'
422: );
415: ,p_effective_date => trunc(p_effective_date)
416: );
417: exception
418: when hr_api.cannot_find_prog_unit then
419: hr_api.cannot_find_prog_unit_error
420: (p_module_name => 'delete_budget_version'
421: ,p_hook_type => 'AP'
422: );
423: --
429: --
430: -- When in validation only mode raise the Validate_Enabled exception
431: --
432: if p_validate then
433: raise hr_api.validate_enabled;
434: end if;
435: --
436: hr_utility.set_location(' Leaving:'||l_proc, 70);
437: --
436: hr_utility.set_location(' Leaving:'||l_proc, 70);
437: --
438: exception
439: --
440: when hr_api.validate_enabled then
441: --
442: -- As the Validate_Enabled exception has been raised
443: -- we must rollback to the savepoint
444: --