70: ,p_budget_unit3_available => p_budget_unit3_available
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_WORKSHEET_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_WORKSHEET_BUDGET_SET'
78: ,p_hook_type => 'BP'
79: );
127: ,p_budget_unit3_available => p_budget_unit3_available
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_WORKSHEET_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_WORKSHEET_BUDGET_SET'
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_WORKSHEET_BUDGET_SET
188: (p_validate in boolean default false
189: ,p_worksheet_budget_set_id in number
190: ,p_dflt_budget_set_id in number default hr_api.g_number
191: ,p_worksheet_period_id in number default hr_api.g_number
192: ,p_budget_unit1_percent in number default hr_api.g_number
193: ,p_budget_unit2_percent in number default hr_api.g_number
194: ,p_budget_unit3_percent in number default hr_api.g_number
187: procedure update_WORKSHEET_BUDGET_SET
188: (p_validate in boolean default false
189: ,p_worksheet_budget_set_id in number
190: ,p_dflt_budget_set_id in number default hr_api.g_number
191: ,p_worksheet_period_id in number default hr_api.g_number
192: ,p_budget_unit1_percent in number default hr_api.g_number
193: ,p_budget_unit2_percent in number default hr_api.g_number
194: ,p_budget_unit3_percent in number default hr_api.g_number
195: ,p_budget_unit1_value in number default hr_api.g_number
188: (p_validate in boolean default false
189: ,p_worksheet_budget_set_id in number
190: ,p_dflt_budget_set_id in number default hr_api.g_number
191: ,p_worksheet_period_id in number default hr_api.g_number
192: ,p_budget_unit1_percent in number default hr_api.g_number
193: ,p_budget_unit2_percent in number default hr_api.g_number
194: ,p_budget_unit3_percent in number default hr_api.g_number
195: ,p_budget_unit1_value in number default hr_api.g_number
196: ,p_budget_unit2_value in number default hr_api.g_number
189: ,p_worksheet_budget_set_id in number
190: ,p_dflt_budget_set_id in number default hr_api.g_number
191: ,p_worksheet_period_id in number default hr_api.g_number
192: ,p_budget_unit1_percent in number default hr_api.g_number
193: ,p_budget_unit2_percent in number default hr_api.g_number
194: ,p_budget_unit3_percent in number default hr_api.g_number
195: ,p_budget_unit1_value in number default hr_api.g_number
196: ,p_budget_unit2_value in number default hr_api.g_number
197: ,p_budget_unit3_value in number default hr_api.g_number
190: ,p_dflt_budget_set_id in number default hr_api.g_number
191: ,p_worksheet_period_id in number default hr_api.g_number
192: ,p_budget_unit1_percent in number default hr_api.g_number
193: ,p_budget_unit2_percent in number default hr_api.g_number
194: ,p_budget_unit3_percent in number default hr_api.g_number
195: ,p_budget_unit1_value in number default hr_api.g_number
196: ,p_budget_unit2_value in number default hr_api.g_number
197: ,p_budget_unit3_value in number default hr_api.g_number
198: ,p_object_version_number in out nocopy number
191: ,p_worksheet_period_id in number default hr_api.g_number
192: ,p_budget_unit1_percent in number default hr_api.g_number
193: ,p_budget_unit2_percent in number default hr_api.g_number
194: ,p_budget_unit3_percent in number default hr_api.g_number
195: ,p_budget_unit1_value in number default hr_api.g_number
196: ,p_budget_unit2_value in number default hr_api.g_number
197: ,p_budget_unit3_value in number default hr_api.g_number
198: ,p_object_version_number in out nocopy number
199: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
192: ,p_budget_unit1_percent in number default hr_api.g_number
193: ,p_budget_unit2_percent in number default hr_api.g_number
194: ,p_budget_unit3_percent in number default hr_api.g_number
195: ,p_budget_unit1_value in number default hr_api.g_number
196: ,p_budget_unit2_value in number default hr_api.g_number
197: ,p_budget_unit3_value in number default hr_api.g_number
198: ,p_object_version_number in out nocopy 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_unit2_percent in number default hr_api.g_number
194: ,p_budget_unit3_percent in number default hr_api.g_number
195: ,p_budget_unit1_value in number default hr_api.g_number
196: ,p_budget_unit2_value in number default hr_api.g_number
197: ,p_budget_unit3_value in number default hr_api.g_number
198: ,p_object_version_number in out nocopy 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
195: ,p_budget_unit1_value in number default hr_api.g_number
196: ,p_budget_unit2_value in number default hr_api.g_number
197: ,p_budget_unit3_value in number default hr_api.g_number
198: ,p_object_version_number in out nocopy 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_unit2_value in number default hr_api.g_number
197: ,p_budget_unit3_value in number default hr_api.g_number
198: ,p_object_version_number in out nocopy 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_unit3_value in number default hr_api.g_number
198: ,p_object_version_number in out nocopy 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_effective_date in date
198: ,p_object_version_number in out nocopy 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_effective_date in date
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_effective_date in date
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_effective_date in date
206: ) is
207: --
208: -- Declare cursors and local variables
248: ,p_budget_unit3_available => p_budget_unit3_available
249: ,p_effective_date => trunc(p_effective_date)
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_WORKSHEET_BUDGET_SET'
255: ,p_hook_type => 'BP'
256: );
249: ,p_effective_date => trunc(p_effective_date)
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_WORKSHEET_BUDGET_SET'
255: ,p_hook_type => 'BP'
256: );
257: --
304: ,p_budget_unit3_available => p_budget_unit3_available
305: ,p_effective_date => trunc(p_effective_date)
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_WORKSHEET_BUDGET_SET'
311: ,p_hook_type => 'AP'
312: );
305: ,p_effective_date => trunc(p_effective_date)
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_WORKSHEET_BUDGET_SET'
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: --
394: ,p_object_version_number => p_object_version_number
395: ,p_effective_date => trunc(p_effective_date)
396: );
397: exception
398: when hr_api.cannot_find_prog_unit then
399: hr_api.cannot_find_prog_unit_error
400: (p_module_name => 'DELETE_WORKSHEET_BUDGET_SET'
401: ,p_hook_type => 'BP'
402: );
395: ,p_effective_date => trunc(p_effective_date)
396: );
397: exception
398: when hr_api.cannot_find_prog_unit then
399: hr_api.cannot_find_prog_unit_error
400: (p_module_name => 'DELETE_WORKSHEET_BUDGET_SET'
401: ,p_hook_type => 'BP'
402: );
403: --
422: ,p_object_version_number => l_object_version_number
423: ,p_effective_date => trunc(p_effective_date)
424: );
425: exception
426: when hr_api.cannot_find_prog_unit then
427: hr_api.cannot_find_prog_unit_error
428: (p_module_name => 'DELETE_WORKSHEET_BUDGET_SET'
429: ,p_hook_type => 'AP'
430: );
423: ,p_effective_date => trunc(p_effective_date)
424: );
425: exception
426: when hr_api.cannot_find_prog_unit then
427: hr_api.cannot_find_prog_unit_error
428: (p_module_name => 'DELETE_WORKSHEET_BUDGET_SET'
429: ,p_hook_type => 'AP'
430: );
431: --
437: --
438: -- When in validation only mode raise the Validate_Enabled exception
439: --
440: if p_validate then
441: raise hr_api.validate_enabled;
442: end if;
443: --
444: hr_utility.set_location(' Leaving:'||l_proc, 70);
445: --
444: hr_utility.set_location(' Leaving:'||l_proc, 70);
445: --
446: exception
447: --
448: when hr_api.validate_enabled then
449: --
450: -- As the Validate_Enabled exception has been raised
451: -- we must rollback to the savepoint
452: --