67: ,p_created_by => p_created_by
68: ,p_creation_date => p_creation_date
69: );
70: exception
71: when hr_api.cannot_find_prog_unit then
72: hr_api.cannot_find_prog_unit_error
73: (p_module_name => 'CREATE_ASG_BUDGET_VALUE'
74: ,p_hook_type => 'BP'
75: );
68: ,p_creation_date => p_creation_date
69: );
70: exception
71: when hr_api.cannot_find_prog_unit then
72: hr_api.cannot_find_prog_unit_error
73: (p_module_name => 'CREATE_ASG_BUDGET_VALUE'
74: ,p_hook_type => 'BP'
75: );
76: end;
125: ,p_effective_end_date => l_effective_end_date
126: ,p_object_version_number => l_object_version_number
127: );
128: exception
129: when hr_api.cannot_find_prog_unit then
130: hr_api.cannot_find_prog_unit_error
131: (p_module_name => 'CREATE_ASG_BUDGET_VALUE'
132: ,p_hook_type => 'AP'
133: );
126: ,p_object_version_number => l_object_version_number
127: );
128: exception
129: when hr_api.cannot_find_prog_unit then
130: hr_api.cannot_find_prog_unit_error
131: (p_module_name => 'CREATE_ASG_BUDGET_VALUE'
132: ,p_hook_type => 'AP'
133: );
134: end;
135: --
136: -- When in validation only mode raise the Validate_Enabled exception
137: --
138: if p_validate then
139: raise hr_api.validate_enabled;
140: end if;
141: --
142: -- Set all output arguments
143: --
145: p_object_version_number := l_object_version_number;
146: --
147: hr_utility.set_location(' Leaving:'||l_proc, 70);
148: exception
149: when hr_api.validate_enabled then
150: --
151: -- As the Validate_Enabled exception has been raised
152: -- we must rollback to the savepoint
153: --
180: (p_validate in boolean default false
181: ,p_assignment_budget_value_id in number
182: ,p_effective_date in date
183: ,p_datetrack_mode in varchar2
184: ,p_business_group_id in number default hr_api.g_number
185: ,p_unit in varchar2 default hr_api.g_varchar2
186: ,p_value in number default hr_api.g_number
187: ,p_request_id in number default hr_api.g_number
188: ,p_program_application_id in number default hr_api.g_number
181: ,p_assignment_budget_value_id in number
182: ,p_effective_date in date
183: ,p_datetrack_mode in varchar2
184: ,p_business_group_id in number default hr_api.g_number
185: ,p_unit in varchar2 default hr_api.g_varchar2
186: ,p_value in number default hr_api.g_number
187: ,p_request_id in number default hr_api.g_number
188: ,p_program_application_id in number default hr_api.g_number
189: ,p_program_id in number default hr_api.g_number
182: ,p_effective_date in date
183: ,p_datetrack_mode in varchar2
184: ,p_business_group_id in number default hr_api.g_number
185: ,p_unit in varchar2 default hr_api.g_varchar2
186: ,p_value in number default hr_api.g_number
187: ,p_request_id in number default hr_api.g_number
188: ,p_program_application_id in number default hr_api.g_number
189: ,p_program_id in number default hr_api.g_number
190: ,p_program_update_date in date default hr_api.g_date
183: ,p_datetrack_mode in varchar2
184: ,p_business_group_id in number default hr_api.g_number
185: ,p_unit in varchar2 default hr_api.g_varchar2
186: ,p_value in number default hr_api.g_number
187: ,p_request_id in number default hr_api.g_number
188: ,p_program_application_id in number default hr_api.g_number
189: ,p_program_id in number default hr_api.g_number
190: ,p_program_update_date in date default hr_api.g_date
191: ,p_last_update_date in date default hr_api.g_date
184: ,p_business_group_id in number default hr_api.g_number
185: ,p_unit in varchar2 default hr_api.g_varchar2
186: ,p_value in number default hr_api.g_number
187: ,p_request_id in number default hr_api.g_number
188: ,p_program_application_id in number default hr_api.g_number
189: ,p_program_id in number default hr_api.g_number
190: ,p_program_update_date in date default hr_api.g_date
191: ,p_last_update_date in date default hr_api.g_date
192: ,p_last_updated_by in number default hr_api.g_number
185: ,p_unit in varchar2 default hr_api.g_varchar2
186: ,p_value in number default hr_api.g_number
187: ,p_request_id in number default hr_api.g_number
188: ,p_program_application_id in number default hr_api.g_number
189: ,p_program_id in number default hr_api.g_number
190: ,p_program_update_date in date default hr_api.g_date
191: ,p_last_update_date in date default hr_api.g_date
192: ,p_last_updated_by in number default hr_api.g_number
193: ,p_last_update_login in number default hr_api.g_number
186: ,p_value in number default hr_api.g_number
187: ,p_request_id in number default hr_api.g_number
188: ,p_program_application_id in number default hr_api.g_number
189: ,p_program_id in number default hr_api.g_number
190: ,p_program_update_date in date default hr_api.g_date
191: ,p_last_update_date in date default hr_api.g_date
192: ,p_last_updated_by in number default hr_api.g_number
193: ,p_last_update_login in number default hr_api.g_number
194: ,p_created_by in number default hr_api.g_number
187: ,p_request_id in number default hr_api.g_number
188: ,p_program_application_id in number default hr_api.g_number
189: ,p_program_id in number default hr_api.g_number
190: ,p_program_update_date in date default hr_api.g_date
191: ,p_last_update_date in date default hr_api.g_date
192: ,p_last_updated_by in number default hr_api.g_number
193: ,p_last_update_login in number default hr_api.g_number
194: ,p_created_by in number default hr_api.g_number
195: ,p_creation_date in date default hr_api.g_date
188: ,p_program_application_id in number default hr_api.g_number
189: ,p_program_id in number default hr_api.g_number
190: ,p_program_update_date in date default hr_api.g_date
191: ,p_last_update_date in date default hr_api.g_date
192: ,p_last_updated_by in number default hr_api.g_number
193: ,p_last_update_login in number default hr_api.g_number
194: ,p_created_by in number default hr_api.g_number
195: ,p_creation_date in date default hr_api.g_date
196: ,p_object_version_number in out nocopy number
189: ,p_program_id in number default hr_api.g_number
190: ,p_program_update_date in date default hr_api.g_date
191: ,p_last_update_date in date default hr_api.g_date
192: ,p_last_updated_by in number default hr_api.g_number
193: ,p_last_update_login in number default hr_api.g_number
194: ,p_created_by in number default hr_api.g_number
195: ,p_creation_date in date default hr_api.g_date
196: ,p_object_version_number in out nocopy number
197: ) is
190: ,p_program_update_date in date default hr_api.g_date
191: ,p_last_update_date in date default hr_api.g_date
192: ,p_last_updated_by in number default hr_api.g_number
193: ,p_last_update_login in number default hr_api.g_number
194: ,p_created_by in number default hr_api.g_number
195: ,p_creation_date in date default hr_api.g_date
196: ,p_object_version_number in out nocopy number
197: ) is
198: --
191: ,p_last_update_date in date default hr_api.g_date
192: ,p_last_updated_by in number default hr_api.g_number
193: ,p_last_update_login in number default hr_api.g_number
194: ,p_created_by in number default hr_api.g_number
195: ,p_creation_date in date default hr_api.g_date
196: ,p_object_version_number in out nocopy number
197: ) is
198: --
199: -- Declare cursors and local variables
237: ,p_datetrack_mode => p_datetrack_mode
238: ,p_object_version_number => p_object_version_number
239: );
240: exception
241: when hr_api.cannot_find_prog_unit then
242: hr_api.cannot_find_prog_unit_error
243: (p_module_name => 'UPDATE_ASG_BUDGET_VALUE'
244: ,p_hook_type => 'BP'
245: );
238: ,p_object_version_number => p_object_version_number
239: );
240: exception
241: when hr_api.cannot_find_prog_unit then
242: hr_api.cannot_find_prog_unit_error
243: (p_module_name => 'UPDATE_ASG_BUDGET_VALUE'
244: ,p_hook_type => 'BP'
245: );
246: end;
288: ,p_effective_end_date => l_effective_end_date
289: ,p_object_version_number => p_object_version_number
290: );
291: exception
292: when hr_api.cannot_find_prog_unit then
293: hr_api.cannot_find_prog_unit_error
294: (p_module_name => 'UPDATE_ASG_BUDGET_VALUE'
295: ,p_hook_type => 'AP'
296: );
289: ,p_object_version_number => p_object_version_number
290: );
291: exception
292: when hr_api.cannot_find_prog_unit then
293: hr_api.cannot_find_prog_unit_error
294: (p_module_name => 'UPDATE_ASG_BUDGET_VALUE'
295: ,p_hook_type => 'AP'
296: );
297: end;
298: --
299: -- When in validation only mode raise the Validate_Enabled exception
300: --
301: if p_validate then
302: raise hr_api.validate_enabled;
303: end if;
304: --
305: -- Set all output arguments
306: --
306: --
307: --
308: hr_utility.set_location(' Leaving:'||l_proc, 70);
309: exception
310: when hr_api.validate_enabled then
311: --
312: -- As the Validate_Enabled exception has been raised
313: -- we must rollback to the savepoint
314: --
373: ,p_datetrack_mode => p_datetrack_mode
374: ,p_effective_date => p_effective_date
375: ,p_object_version_number => p_object_version_number);
376: exception
377: when hr_api.cannot_find_prog_unit then
378: hr_api.cannot_find_prog_unit_error
379: (p_module_name => 'DELETE_ASG_BUDGET_VALUE'
380: ,p_hook_type => 'BP'
381: );
374: ,p_effective_date => p_effective_date
375: ,p_object_version_number => p_object_version_number);
376: exception
377: when hr_api.cannot_find_prog_unit then
378: hr_api.cannot_find_prog_unit_error
379: (p_module_name => 'DELETE_ASG_BUDGET_VALUE'
380: ,p_hook_type => 'BP'
381: );
382: end;
406: ,p_effective_end_date => l_effective_end_date
407: ,p_object_version_number => l_object_version_number
408: );
409: exception
410: when hr_api.cannot_find_prog_unit then
411: hr_api.cannot_find_prog_unit_error
412: (p_module_name => 'DELETE_ASG_BUDGET_VALUE'
413: ,p_hook_type => 'AP'
414: );
407: ,p_object_version_number => l_object_version_number
408: );
409: exception
410: when hr_api.cannot_find_prog_unit then
411: hr_api.cannot_find_prog_unit_error
412: (p_module_name => 'DELETE_ASG_BUDGET_VALUE'
413: ,p_hook_type => 'AP'
414: );
415: end;
416: --
417: -- When in validation only mode raise the Validate_Enabled exception
418: --
419: if p_validate then
420: raise hr_api.validate_enabled;
421: end if;
422: --
423: -- Set all output arguments
424: --
425: --
426: p_object_version_number := l_object_version_number;
427: hr_utility.set_location(' Leaving:'||l_proc, 70);
428: exception
429: when hr_api.validate_enabled then
430: --
431: -- As the Validate_Enabled exception has been raised
432: -- we must rollback to the savepoint
433: --