70: ,p_budget_unit3_value_type_cd => p_budget_unit3_value_type_cd
71: ,p_effective_date => trunc(p_effective_date)
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_set'
78: ,p_hook_type => 'BP'
71: ,p_effective_date => trunc(p_effective_date)
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_set'
78: ,p_hook_type => 'BP'
79: );
127: ,p_budget_unit3_value_type_cd => p_budget_unit3_value_type_cd
128: ,p_effective_date => trunc(p_effective_date)
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_set'
134: ,p_hook_type => 'AP'
135: );
128: ,p_effective_date => trunc(p_effective_date)
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_set'
134: ,p_hook_type => 'AP'
135: );
136: --
143: --
144: -- When in validation only mode raise the Validate_Enabled exception
145: --
146: if p_validate then
147: raise hr_api.validate_enabled;
148: end if;
149: --
150: -- Set all output arguments
151: --
155: hr_utility.set_location(' Leaving:'||l_proc, 70);
156: --
157: exception
158: --
159: when hr_api.validate_enabled then
160: --
161: -- As the Validate_Enabled exception has been raised
162: -- we must rollback to the savepoint
163: --
187: --
188: procedure update_budget_set
189: (p_validate in boolean default false
190: ,p_budget_set_id in number
191: ,p_dflt_budget_set_id in number default hr_api.g_number
192: ,p_budget_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: procedure update_budget_set
189: (p_validate in boolean default false
190: ,p_budget_set_id in number
191: ,p_dflt_budget_set_id in number default hr_api.g_number
192: ,p_budget_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_validate in boolean default false
190: ,p_budget_set_id in number
191: ,p_dflt_budget_set_id in number default hr_api.g_number
192: ,p_budget_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_set_id in number
191: ,p_dflt_budget_set_id in number default hr_api.g_number
192: ,p_budget_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_dflt_budget_set_id in number default hr_api.g_number
192: ,p_budget_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_available in number default hr_api.g_number
192: ,p_budget_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_available in number default hr_api.g_number
200: ,p_budget_unit2_available 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_available in number default hr_api.g_number
200: ,p_budget_unit2_available in number default hr_api.g_number
201: ,p_budget_unit3_available 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_available in number default hr_api.g_number
200: ,p_budget_unit2_available in number default hr_api.g_number
201: ,p_budget_unit3_available in number default hr_api.g_number
202: ,p_object_version_number in out nocopy 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_available in number default hr_api.g_number
200: ,p_budget_unit2_available in number default hr_api.g_number
201: ,p_budget_unit3_available in number default hr_api.g_number
202: ,p_object_version_number in out nocopy number
203: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
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_available in number default hr_api.g_number
200: ,p_budget_unit2_available in number default hr_api.g_number
201: ,p_budget_unit3_available in number default hr_api.g_number
202: ,p_object_version_number in out nocopy number
203: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
204: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
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_available in number default hr_api.g_number
200: ,p_budget_unit2_available in number default hr_api.g_number
201: ,p_budget_unit3_available in number default hr_api.g_number
202: ,p_object_version_number in out nocopy number
203: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
204: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
205: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
199: ,p_budget_unit1_available in number default hr_api.g_number
200: ,p_budget_unit2_available in number default hr_api.g_number
201: ,p_budget_unit3_available in number default hr_api.g_number
202: ,p_object_version_number in out nocopy number
203: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
204: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
205: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
206: ,p_effective_date in date
207: ) is
200: ,p_budget_unit2_available in number default hr_api.g_number
201: ,p_budget_unit3_available in number default hr_api.g_number
202: ,p_object_version_number in out nocopy number
203: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
204: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
205: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
206: ,p_effective_date in date
207: ) is
208: --
201: ,p_budget_unit3_available in number default hr_api.g_number
202: ,p_object_version_number in out nocopy number
203: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
204: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
205: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
206: ,p_effective_date in date
207: ) is
208: --
209: -- Declare cursors and local variables
249: ,p_budget_unit3_value_type_cd => p_budget_unit3_value_type_cd
250: ,p_effective_date => trunc(p_effective_date)
251: );
252: exception
253: when hr_api.cannot_find_prog_unit then
254: hr_api.cannot_find_prog_unit_error
255: (p_module_name => 'update_budget_set'
256: ,p_hook_type => 'BP'
257: );
250: ,p_effective_date => trunc(p_effective_date)
251: );
252: exception
253: when hr_api.cannot_find_prog_unit then
254: hr_api.cannot_find_prog_unit_error
255: (p_module_name => 'update_budget_set'
256: ,p_hook_type => 'BP'
257: );
258: --
305: ,p_budget_unit3_value_type_cd => p_budget_unit3_value_type_cd
306: ,p_effective_date => trunc(p_effective_date)
307: );
308: exception
309: when hr_api.cannot_find_prog_unit then
310: hr_api.cannot_find_prog_unit_error
311: (p_module_name => 'update_budget_set'
312: ,p_hook_type => 'AP'
313: );
306: ,p_effective_date => trunc(p_effective_date)
307: );
308: exception
309: when hr_api.cannot_find_prog_unit then
310: hr_api.cannot_find_prog_unit_error
311: (p_module_name => 'update_budget_set'
312: ,p_hook_type => 'AP'
313: );
314: --
320: --
321: -- When in validation only mode raise the Validate_Enabled exception
322: --
323: if p_validate then
324: raise hr_api.validate_enabled;
325: end if;
326: --
327: -- Set all output arguments
328: --
331: hr_utility.set_location(' Leaving:'||l_proc, 70);
332: --
333: exception
334: --
335: when hr_api.validate_enabled then
336: --
337: -- As the Validate_Enabled exception has been raised
338: -- we must rollback to the savepoint
339: --
395: ,p_object_version_number => p_object_version_number
396: ,p_effective_date => trunc(p_effective_date)
397: );
398: exception
399: when hr_api.cannot_find_prog_unit then
400: hr_api.cannot_find_prog_unit_error
401: (p_module_name => 'delete_budget_set'
402: ,p_hook_type => 'BP'
403: );
396: ,p_effective_date => trunc(p_effective_date)
397: );
398: exception
399: when hr_api.cannot_find_prog_unit then
400: hr_api.cannot_find_prog_unit_error
401: (p_module_name => 'delete_budget_set'
402: ,p_hook_type => 'BP'
403: );
404: --
423: ,p_object_version_number => l_object_version_number
424: ,p_effective_date => trunc(p_effective_date)
425: );
426: exception
427: when hr_api.cannot_find_prog_unit then
428: hr_api.cannot_find_prog_unit_error
429: (p_module_name => 'delete_budget_set'
430: ,p_hook_type => 'AP'
431: );
424: ,p_effective_date => trunc(p_effective_date)
425: );
426: exception
427: when hr_api.cannot_find_prog_unit then
428: hr_api.cannot_find_prog_unit_error
429: (p_module_name => 'delete_budget_set'
430: ,p_hook_type => 'AP'
431: );
432: --
438: --
439: -- When in validation only mode raise the Validate_Enabled exception
440: --
441: if p_validate then
442: raise hr_api.validate_enabled;
443: end if;
444: --
445: hr_utility.set_location(' Leaving:'||l_proc, 70);
446: --
445: hr_utility.set_location(' Leaving:'||l_proc, 70);
446: --
447: exception
448: --
449: when hr_api.validate_enabled then
450: --
451: -- As the Validate_Enabled exception has been raised
452: -- we must rollback to the savepoint
453: --