70: ,p_budget_unit2_available => p_budget_unit2_available
71: ,p_budget_unit3_available => p_budget_unit3_available
72: );
73: exception
74: when hr_api.cannot_find_prog_unit then
75: hr_api.cannot_find_prog_unit_error
76: (
77: p_module_name => 'create_budget_period'
78: ,p_hook_type => 'BP'
71: ,p_budget_unit3_available => p_budget_unit3_available
72: );
73: exception
74: when hr_api.cannot_find_prog_unit then
75: hr_api.cannot_find_prog_unit_error
76: (
77: p_module_name => 'create_budget_period'
78: ,p_hook_type => 'BP'
79: );
127: ,p_budget_unit3_available => p_budget_unit3_available
128: ,p_object_version_number => l_object_version_number
129: );
130: exception
131: when hr_api.cannot_find_prog_unit then
132: hr_api.cannot_find_prog_unit_error
133: (p_module_name => 'create_budget_period'
134: ,p_hook_type => 'AP'
135: );
128: ,p_object_version_number => l_object_version_number
129: );
130: exception
131: when hr_api.cannot_find_prog_unit then
132: hr_api.cannot_find_prog_unit_error
133: (p_module_name => 'create_budget_period'
134: ,p_hook_type => 'AP'
135: );
136: --
142: --
143: -- When in validation only mode raise the Validate_Enabled exception
144: --
145: if p_validate then
146: raise hr_api.validate_enabled;
147: end if;
148: --
149: -- Set all output arguments
150: --
154: hr_utility.set_location(' Leaving:'||l_proc, 70);
155: --
156: exception
157: --
158: when hr_api.validate_enabled then
159: --
160: -- As the Validate_Enabled exception has been raised
161: -- we must rollback to the savepoint
162: --
186: --
187: procedure update_budget_period
188: (p_validate in boolean default false
189: ,p_budget_period_id in number
190: ,p_budget_detail_id in number default hr_api.g_number
191: ,p_start_time_period_id in number default hr_api.g_number
192: ,p_end_time_period_id in number default hr_api.g_number
193: ,p_budget_unit1_percent in number default hr_api.g_number
194: ,p_budget_unit2_percent in number default hr_api.g_number
187: procedure update_budget_period
188: (p_validate in boolean default false
189: ,p_budget_period_id in number
190: ,p_budget_detail_id in number default hr_api.g_number
191: ,p_start_time_period_id in number default hr_api.g_number
192: ,p_end_time_period_id in number default hr_api.g_number
193: ,p_budget_unit1_percent in number default hr_api.g_number
194: ,p_budget_unit2_percent in number default hr_api.g_number
195: ,p_budget_unit3_percent in number default hr_api.g_number
188: (p_validate in boolean default false
189: ,p_budget_period_id in number
190: ,p_budget_detail_id in number default hr_api.g_number
191: ,p_start_time_period_id in number default hr_api.g_number
192: ,p_end_time_period_id in number default hr_api.g_number
193: ,p_budget_unit1_percent in number default hr_api.g_number
194: ,p_budget_unit2_percent in number default hr_api.g_number
195: ,p_budget_unit3_percent in number default hr_api.g_number
196: ,p_budget_unit1_value in number default hr_api.g_number
189: ,p_budget_period_id in number
190: ,p_budget_detail_id in number default hr_api.g_number
191: ,p_start_time_period_id in number default hr_api.g_number
192: ,p_end_time_period_id in number default hr_api.g_number
193: ,p_budget_unit1_percent in number default hr_api.g_number
194: ,p_budget_unit2_percent in number default hr_api.g_number
195: ,p_budget_unit3_percent in number default hr_api.g_number
196: ,p_budget_unit1_value in number default hr_api.g_number
197: ,p_budget_unit2_value in number default hr_api.g_number
190: ,p_budget_detail_id in number default hr_api.g_number
191: ,p_start_time_period_id in number default hr_api.g_number
192: ,p_end_time_period_id in number default hr_api.g_number
193: ,p_budget_unit1_percent in number default hr_api.g_number
194: ,p_budget_unit2_percent in number default hr_api.g_number
195: ,p_budget_unit3_percent in number default hr_api.g_number
196: ,p_budget_unit1_value in number default hr_api.g_number
197: ,p_budget_unit2_value in number default hr_api.g_number
198: ,p_budget_unit3_value in number default hr_api.g_number
191: ,p_start_time_period_id in number default hr_api.g_number
192: ,p_end_time_period_id in number default hr_api.g_number
193: ,p_budget_unit1_percent in number default hr_api.g_number
194: ,p_budget_unit2_percent in number default hr_api.g_number
195: ,p_budget_unit3_percent in number default hr_api.g_number
196: ,p_budget_unit1_value in number default hr_api.g_number
197: ,p_budget_unit2_value in number default hr_api.g_number
198: ,p_budget_unit3_value in number default hr_api.g_number
199: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
192: ,p_end_time_period_id in number default hr_api.g_number
193: ,p_budget_unit1_percent in number default hr_api.g_number
194: ,p_budget_unit2_percent in number default hr_api.g_number
195: ,p_budget_unit3_percent in number default hr_api.g_number
196: ,p_budget_unit1_value in number default hr_api.g_number
197: ,p_budget_unit2_value in number default hr_api.g_number
198: ,p_budget_unit3_value in number default hr_api.g_number
199: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
200: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
193: ,p_budget_unit1_percent in number default hr_api.g_number
194: ,p_budget_unit2_percent in number default hr_api.g_number
195: ,p_budget_unit3_percent in number default hr_api.g_number
196: ,p_budget_unit1_value in number default hr_api.g_number
197: ,p_budget_unit2_value in number default hr_api.g_number
198: ,p_budget_unit3_value in number default hr_api.g_number
199: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
200: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
201: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
194: ,p_budget_unit2_percent in number default hr_api.g_number
195: ,p_budget_unit3_percent in number default hr_api.g_number
196: ,p_budget_unit1_value in number default hr_api.g_number
197: ,p_budget_unit2_value in number default hr_api.g_number
198: ,p_budget_unit3_value in number default hr_api.g_number
199: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
200: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
201: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
202: ,p_budget_unit1_available in number default hr_api.g_number
195: ,p_budget_unit3_percent in number default hr_api.g_number
196: ,p_budget_unit1_value in number default hr_api.g_number
197: ,p_budget_unit2_value in number default hr_api.g_number
198: ,p_budget_unit3_value in number default hr_api.g_number
199: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
200: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
201: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
202: ,p_budget_unit1_available in number default hr_api.g_number
203: ,p_budget_unit2_available in number default hr_api.g_number
196: ,p_budget_unit1_value in number default hr_api.g_number
197: ,p_budget_unit2_value in number default hr_api.g_number
198: ,p_budget_unit3_value in number default hr_api.g_number
199: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
200: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
201: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
202: ,p_budget_unit1_available in number default hr_api.g_number
203: ,p_budget_unit2_available in number default hr_api.g_number
204: ,p_budget_unit3_available in number default hr_api.g_number
197: ,p_budget_unit2_value in number default hr_api.g_number
198: ,p_budget_unit3_value in number default hr_api.g_number
199: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
200: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
201: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
202: ,p_budget_unit1_available in number default hr_api.g_number
203: ,p_budget_unit2_available in number default hr_api.g_number
204: ,p_budget_unit3_available in number default hr_api.g_number
205: ,p_object_version_number in out nocopy number
198: ,p_budget_unit3_value in number default hr_api.g_number
199: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
200: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
201: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
202: ,p_budget_unit1_available in number default hr_api.g_number
203: ,p_budget_unit2_available in number default hr_api.g_number
204: ,p_budget_unit3_available in number default hr_api.g_number
205: ,p_object_version_number in out nocopy number
206: ) is
199: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
200: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
201: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
202: ,p_budget_unit1_available in number default hr_api.g_number
203: ,p_budget_unit2_available in number default hr_api.g_number
204: ,p_budget_unit3_available in number default hr_api.g_number
205: ,p_object_version_number in out nocopy number
206: ) is
207: --
200: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
201: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
202: ,p_budget_unit1_available in number default hr_api.g_number
203: ,p_budget_unit2_available in number default hr_api.g_number
204: ,p_budget_unit3_available in number default hr_api.g_number
205: ,p_object_version_number in out nocopy number
206: ) is
207: --
208: -- Declare cursors and local variables
248: ,p_budget_unit3_available => p_budget_unit3_available
249: ,p_object_version_number => p_object_version_number
250: );
251: exception
252: when hr_api.cannot_find_prog_unit then
253: hr_api.cannot_find_prog_unit_error
254: (p_module_name => 'update_budget_period'
255: ,p_hook_type => 'BP'
256: );
249: ,p_object_version_number => p_object_version_number
250: );
251: exception
252: when hr_api.cannot_find_prog_unit then
253: hr_api.cannot_find_prog_unit_error
254: (p_module_name => 'update_budget_period'
255: ,p_hook_type => 'BP'
256: );
257: --
304: ,p_budget_unit3_available => p_budget_unit3_available
305: ,p_object_version_number => l_object_version_number
306: );
307: exception
308: when hr_api.cannot_find_prog_unit then
309: hr_api.cannot_find_prog_unit_error
310: (p_module_name => 'update_budget_period'
311: ,p_hook_type => 'AP'
312: );
305: ,p_object_version_number => l_object_version_number
306: );
307: exception
308: when hr_api.cannot_find_prog_unit then
309: hr_api.cannot_find_prog_unit_error
310: (p_module_name => 'update_budget_period'
311: ,p_hook_type => 'AP'
312: );
313: --
319: --
320: -- When in validation only mode raise the Validate_Enabled exception
321: --
322: if p_validate then
323: raise hr_api.validate_enabled;
324: end if;
325: --
326: -- Set all output arguments
327: --
330: hr_utility.set_location(' Leaving:'||l_proc, 70);
331: --
332: exception
333: --
334: when hr_api.validate_enabled then
335: --
336: -- As the Validate_Enabled exception has been raised
337: -- we must rollback to the savepoint
338: --
392: p_budget_period_id => p_budget_period_id
393: ,p_object_version_number => p_object_version_number
394: );
395: exception
396: when hr_api.cannot_find_prog_unit then
397: hr_api.cannot_find_prog_unit_error
398: (p_module_name => 'delete_budget_period'
399: ,p_hook_type => 'BP'
400: );
393: ,p_object_version_number => p_object_version_number
394: );
395: exception
396: when hr_api.cannot_find_prog_unit then
397: hr_api.cannot_find_prog_unit_error
398: (p_module_name => 'delete_budget_period'
399: ,p_hook_type => 'BP'
400: );
401: --
418: p_budget_period_id => p_budget_period_id
419: ,p_object_version_number => l_object_version_number
420: );
421: exception
422: when hr_api.cannot_find_prog_unit then
423: hr_api.cannot_find_prog_unit_error
424: (p_module_name => 'delete_budget_period'
425: ,p_hook_type => 'AP'
426: );
419: ,p_object_version_number => l_object_version_number
420: );
421: exception
422: when hr_api.cannot_find_prog_unit then
423: hr_api.cannot_find_prog_unit_error
424: (p_module_name => 'delete_budget_period'
425: ,p_hook_type => 'AP'
426: );
427: --
433: --
434: -- When in validation only mode raise the Validate_Enabled exception
435: --
436: if p_validate then
437: raise hr_api.validate_enabled;
438: end if;
439: --
440: hr_utility.set_location(' Leaving:'||l_proc, 70);
441: --
440: hr_utility.set_location(' Leaving:'||l_proc, 70);
441: --
442: exception
443: --
444: when hr_api.validate_enabled then
445: --
446: -- As the Validate_Enabled exception has been raised
447: -- we must rollback to the savepoint
448: --