72: ,p_budget_unit1_available => p_budget_unit1_available
73: ,p_effective_date => trunc(p_effective_date)
74: );
75: exception
76: when hr_api.cannot_find_prog_unit then
77: hr_api.cannot_find_prog_unit_error
78: (
79: p_module_name => 'CREATE_WORKSHEET_PERIOD'
80: ,p_hook_type => 'BP'
73: ,p_effective_date => trunc(p_effective_date)
74: );
75: exception
76: when hr_api.cannot_find_prog_unit then
77: hr_api.cannot_find_prog_unit_error
78: (
79: p_module_name => 'CREATE_WORKSHEET_PERIOD'
80: ,p_hook_type => 'BP'
81: );
131: ,p_budget_unit1_available => p_budget_unit1_available
132: ,p_effective_date => trunc(p_effective_date)
133: );
134: exception
135: when hr_api.cannot_find_prog_unit then
136: hr_api.cannot_find_prog_unit_error
137: (p_module_name => 'CREATE_WORKSHEET_PERIOD'
138: ,p_hook_type => 'AP'
139: );
132: ,p_effective_date => trunc(p_effective_date)
133: );
134: exception
135: when hr_api.cannot_find_prog_unit then
136: hr_api.cannot_find_prog_unit_error
137: (p_module_name => 'CREATE_WORKSHEET_PERIOD'
138: ,p_hook_type => 'AP'
139: );
140: --
146: --
147: -- When in validation only mode raise the Validate_Enabled exception
148: --
149: if p_validate then
150: raise hr_api.validate_enabled;
151: end if;
152: --
153: -- Set all output arguments
154: --
158: hr_utility.set_location(' Leaving:'||l_proc, 70);
159: --
160: exception
161: --
162: when hr_api.validate_enabled then
163: --
164: -- As the Validate_Enabled exception has been raised
165: -- we must rollback to the savepoint
166: --
190: --
191: procedure update_WORKSHEET_PERIOD
192: (p_validate in boolean default false
193: ,p_worksheet_period_id in number
194: ,p_end_time_period_id in number default hr_api.g_number
195: ,p_worksheet_detail_id in number default hr_api.g_number
196: ,p_budget_unit1_percent in number default hr_api.g_number
197: ,p_budget_unit2_percent in number default hr_api.g_number
198: ,p_budget_unit3_percent in number default hr_api.g_number
191: procedure update_WORKSHEET_PERIOD
192: (p_validate in boolean default false
193: ,p_worksheet_period_id in number
194: ,p_end_time_period_id in number default hr_api.g_number
195: ,p_worksheet_detail_id in number default hr_api.g_number
196: ,p_budget_unit1_percent in number default hr_api.g_number
197: ,p_budget_unit2_percent in number default hr_api.g_number
198: ,p_budget_unit3_percent in number default hr_api.g_number
199: ,p_budget_unit1_value in number default hr_api.g_number
192: (p_validate in boolean default false
193: ,p_worksheet_period_id in number
194: ,p_end_time_period_id in number default hr_api.g_number
195: ,p_worksheet_detail_id in number default hr_api.g_number
196: ,p_budget_unit1_percent in number default hr_api.g_number
197: ,p_budget_unit2_percent in number default hr_api.g_number
198: ,p_budget_unit3_percent in number default hr_api.g_number
199: ,p_budget_unit1_value in number default hr_api.g_number
200: ,p_budget_unit2_value in number default hr_api.g_number
193: ,p_worksheet_period_id in number
194: ,p_end_time_period_id in number default hr_api.g_number
195: ,p_worksheet_detail_id in number default hr_api.g_number
196: ,p_budget_unit1_percent in number default hr_api.g_number
197: ,p_budget_unit2_percent in number default hr_api.g_number
198: ,p_budget_unit3_percent in number default hr_api.g_number
199: ,p_budget_unit1_value in number default hr_api.g_number
200: ,p_budget_unit2_value in number default hr_api.g_number
201: ,p_budget_unit3_value in number default hr_api.g_number
194: ,p_end_time_period_id in number default hr_api.g_number
195: ,p_worksheet_detail_id in number default hr_api.g_number
196: ,p_budget_unit1_percent in number default hr_api.g_number
197: ,p_budget_unit2_percent in number default hr_api.g_number
198: ,p_budget_unit3_percent in number default hr_api.g_number
199: ,p_budget_unit1_value in number default hr_api.g_number
200: ,p_budget_unit2_value in number default hr_api.g_number
201: ,p_budget_unit3_value in number default hr_api.g_number
202: ,p_object_version_number in out nocopy number
195: ,p_worksheet_detail_id in number default hr_api.g_number
196: ,p_budget_unit1_percent in number default hr_api.g_number
197: ,p_budget_unit2_percent in number default hr_api.g_number
198: ,p_budget_unit3_percent in number default hr_api.g_number
199: ,p_budget_unit1_value in number default hr_api.g_number
200: ,p_budget_unit2_value in number default hr_api.g_number
201: ,p_budget_unit3_value 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_percent in number default hr_api.g_number
197: ,p_budget_unit2_percent in number default hr_api.g_number
198: ,p_budget_unit3_percent in number default hr_api.g_number
199: ,p_budget_unit1_value in number default hr_api.g_number
200: ,p_budget_unit2_value in number default hr_api.g_number
201: ,p_budget_unit3_value 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_percent in number default hr_api.g_number
198: ,p_budget_unit3_percent in number default hr_api.g_number
199: ,p_budget_unit1_value in number default hr_api.g_number
200: ,p_budget_unit2_value in number default hr_api.g_number
201: ,p_budget_unit3_value 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_value in number default hr_api.g_number
200: ,p_budget_unit2_value in number default hr_api.g_number
201: ,p_budget_unit3_value 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_start_time_period_id in number default hr_api.g_number
207: ,p_budget_unit3_available in number default hr_api.g_number
200: ,p_budget_unit2_value in number default hr_api.g_number
201: ,p_budget_unit3_value 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_start_time_period_id in number default hr_api.g_number
207: ,p_budget_unit3_available in number default hr_api.g_number
208: ,p_budget_unit2_available in number default hr_api.g_number
201: ,p_budget_unit3_value 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_start_time_period_id in number default hr_api.g_number
207: ,p_budget_unit3_available in number default hr_api.g_number
208: ,p_budget_unit2_available in number default hr_api.g_number
209: ,p_budget_unit1_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_start_time_period_id in number default hr_api.g_number
207: ,p_budget_unit3_available in number default hr_api.g_number
208: ,p_budget_unit2_available in number default hr_api.g_number
209: ,p_budget_unit1_available in number default hr_api.g_number
210: ,p_effective_date in date
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_start_time_period_id in number default hr_api.g_number
207: ,p_budget_unit3_available in number default hr_api.g_number
208: ,p_budget_unit2_available in number default hr_api.g_number
209: ,p_budget_unit1_available in number default hr_api.g_number
210: ,p_effective_date in date
211: ) is
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_start_time_period_id in number default hr_api.g_number
207: ,p_budget_unit3_available in number default hr_api.g_number
208: ,p_budget_unit2_available in number default hr_api.g_number
209: ,p_budget_unit1_available in number default hr_api.g_number
210: ,p_effective_date in date
211: ) is
212: --
205: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
206: ,p_start_time_period_id in number default hr_api.g_number
207: ,p_budget_unit3_available in number default hr_api.g_number
208: ,p_budget_unit2_available in number default hr_api.g_number
209: ,p_budget_unit1_available in number default hr_api.g_number
210: ,p_effective_date in date
211: ) is
212: --
213: -- Declare cursors and local variables
254: ,p_budget_unit1_available => p_budget_unit1_available
255: ,p_effective_date => trunc(p_effective_date)
256: );
257: exception
258: when hr_api.cannot_find_prog_unit then
259: hr_api.cannot_find_prog_unit_error
260: (p_module_name => 'UPDATE_WORKSHEET_PERIOD'
261: ,p_hook_type => 'BP'
262: );
255: ,p_effective_date => trunc(p_effective_date)
256: );
257: exception
258: when hr_api.cannot_find_prog_unit then
259: hr_api.cannot_find_prog_unit_error
260: (p_module_name => 'UPDATE_WORKSHEET_PERIOD'
261: ,p_hook_type => 'BP'
262: );
263: --
312: ,p_budget_unit1_available => p_budget_unit1_available
313: ,p_effective_date => trunc(p_effective_date)
314: );
315: exception
316: when hr_api.cannot_find_prog_unit then
317: hr_api.cannot_find_prog_unit_error
318: (p_module_name => 'UPDATE_WORKSHEET_PERIOD'
319: ,p_hook_type => 'AP'
320: );
313: ,p_effective_date => trunc(p_effective_date)
314: );
315: exception
316: when hr_api.cannot_find_prog_unit then
317: hr_api.cannot_find_prog_unit_error
318: (p_module_name => 'UPDATE_WORKSHEET_PERIOD'
319: ,p_hook_type => 'AP'
320: );
321: --
327: --
328: -- When in validation only mode raise the Validate_Enabled exception
329: --
330: if p_validate then
331: raise hr_api.validate_enabled;
332: end if;
333: --
334: -- Set all output arguments
335: --
338: hr_utility.set_location(' Leaving:'||l_proc, 70);
339: --
340: exception
341: --
342: when hr_api.validate_enabled then
343: --
344: -- As the Validate_Enabled exception has been raised
345: -- we must rollback to the savepoint
346: --
402: ,p_object_version_number => p_object_version_number
403: ,p_effective_date => trunc(p_effective_date)
404: );
405: exception
406: when hr_api.cannot_find_prog_unit then
407: hr_api.cannot_find_prog_unit_error
408: (p_module_name => 'DELETE_WORKSHEET_PERIOD'
409: ,p_hook_type => 'BP'
410: );
403: ,p_effective_date => trunc(p_effective_date)
404: );
405: exception
406: when hr_api.cannot_find_prog_unit then
407: hr_api.cannot_find_prog_unit_error
408: (p_module_name => 'DELETE_WORKSHEET_PERIOD'
409: ,p_hook_type => 'BP'
410: );
411: --
430: ,p_object_version_number => l_object_version_number
431: ,p_effective_date => trunc(p_effective_date)
432: );
433: exception
434: when hr_api.cannot_find_prog_unit then
435: hr_api.cannot_find_prog_unit_error
436: (p_module_name => 'DELETE_WORKSHEET_PERIOD'
437: ,p_hook_type => 'AP'
438: );
431: ,p_effective_date => trunc(p_effective_date)
432: );
433: exception
434: when hr_api.cannot_find_prog_unit then
435: hr_api.cannot_find_prog_unit_error
436: (p_module_name => 'DELETE_WORKSHEET_PERIOD'
437: ,p_hook_type => 'AP'
438: );
439: --
445: --
446: -- When in validation only mode raise the Validate_Enabled exception
447: --
448: if p_validate then
449: raise hr_api.validate_enabled;
450: end if;
451: --
452: hr_utility.set_location(' Leaving:'||l_proc, 70);
453: --
452: hr_utility.set_location(' Leaving:'||l_proc, 70);
453: --
454: exception
455: --
456: when hr_api.validate_enabled then
457: --
458: -- As the Validate_Enabled exception has been raised
459: -- we must rollback to the savepoint
460: --