44: p_dflt_budget_set_name => p_dflt_budget_set_name
45: ,p_business_group_id => p_business_group_id
46: );
47: exception
48: when hr_api.cannot_find_prog_unit then
49: hr_api.cannot_find_prog_unit_error
50: (
51: p_module_name => 'create_dflt_budget_set'
52: ,p_hook_type => 'BP'
45: ,p_business_group_id => p_business_group_id
46: );
47: exception
48: when hr_api.cannot_find_prog_unit then
49: hr_api.cannot_find_prog_unit_error
50: (
51: p_module_name => 'create_dflt_budget_set'
52: ,p_hook_type => 'BP'
53: );
75: ,p_business_group_id => p_business_group_id
76: ,p_object_version_number => l_object_version_number
77: );
78: exception
79: when hr_api.cannot_find_prog_unit then
80: hr_api.cannot_find_prog_unit_error
81: (p_module_name => 'create_dflt_budget_set'
82: ,p_hook_type => 'AP'
83: );
76: ,p_object_version_number => l_object_version_number
77: );
78: exception
79: when hr_api.cannot_find_prog_unit then
80: hr_api.cannot_find_prog_unit_error
81: (p_module_name => 'create_dflt_budget_set'
82: ,p_hook_type => 'AP'
83: );
84: --
90: --
91: -- When in validation only mode raise the Validate_Enabled exception
92: --
93: if p_validate then
94: raise hr_api.validate_enabled;
95: end if;
96: --
97: -- Set all output arguments
98: --
102: hr_utility.set_location(' Leaving:'||l_proc, 70);
103: --
104: exception
105: --
106: when hr_api.validate_enabled then
107: --
108: -- As the Validate_Enabled exception has been raised
109: -- we must rollback to the savepoint
110: --
134: --
135: procedure update_dflt_budget_set
136: (p_validate in boolean default false
137: ,p_dflt_budget_set_id in number
138: ,p_dflt_budget_set_name in varchar2 default hr_api.g_varchar2
139: ,p_business_group_id in number default hr_api.g_number
140: ,p_object_version_number in out nocopy number
141: ) is
142: --
135: procedure update_dflt_budget_set
136: (p_validate in boolean default false
137: ,p_dflt_budget_set_id in number
138: ,p_dflt_budget_set_name in varchar2 default hr_api.g_varchar2
139: ,p_business_group_id in number default hr_api.g_number
140: ,p_object_version_number in out nocopy number
141: ) is
142: --
143: -- Declare cursors and local variables
170: ,p_business_group_id => p_business_group_id
171: ,p_object_version_number => p_object_version_number
172: );
173: exception
174: when hr_api.cannot_find_prog_unit then
175: hr_api.cannot_find_prog_unit_error
176: (p_module_name => 'update_dflt_budget_set'
177: ,p_hook_type => 'BP'
178: );
171: ,p_object_version_number => p_object_version_number
172: );
173: exception
174: when hr_api.cannot_find_prog_unit then
175: hr_api.cannot_find_prog_unit_error
176: (p_module_name => 'update_dflt_budget_set'
177: ,p_hook_type => 'BP'
178: );
179: --
200: ,p_business_group_id => p_business_group_id
201: ,p_object_version_number => l_object_version_number
202: );
203: exception
204: when hr_api.cannot_find_prog_unit then
205: hr_api.cannot_find_prog_unit_error
206: (p_module_name => 'update_dflt_budget_set'
207: ,p_hook_type => 'AP'
208: );
201: ,p_object_version_number => l_object_version_number
202: );
203: exception
204: when hr_api.cannot_find_prog_unit then
205: hr_api.cannot_find_prog_unit_error
206: (p_module_name => 'update_dflt_budget_set'
207: ,p_hook_type => 'AP'
208: );
209: --
215: --
216: -- When in validation only mode raise the Validate_Enabled exception
217: --
218: if p_validate then
219: raise hr_api.validate_enabled;
220: end if;
221: --
222: -- Set all output arguments
223: --
226: hr_utility.set_location(' Leaving:'||l_proc, 70);
227: --
228: exception
229: --
230: when hr_api.validate_enabled then
231: --
232: -- As the Validate_Enabled exception has been raised
233: -- we must rollback to the savepoint
234: --
288: p_dflt_budget_set_id => p_dflt_budget_set_id
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 => 'delete_dflt_budget_set'
295: ,p_hook_type => 'BP'
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 => 'delete_dflt_budget_set'
295: ,p_hook_type => 'BP'
296: );
297: --
314: p_dflt_budget_set_id => p_dflt_budget_set_id
315: ,p_object_version_number => l_object_version_number
316: );
317: exception
318: when hr_api.cannot_find_prog_unit then
319: hr_api.cannot_find_prog_unit_error
320: (p_module_name => 'delete_dflt_budget_set'
321: ,p_hook_type => 'AP'
322: );
315: ,p_object_version_number => l_object_version_number
316: );
317: exception
318: when hr_api.cannot_find_prog_unit then
319: hr_api.cannot_find_prog_unit_error
320: (p_module_name => 'delete_dflt_budget_set'
321: ,p_hook_type => 'AP'
322: );
323: --
329: --
330: -- When in validation only mode raise the Validate_Enabled exception
331: --
332: if p_validate then
333: raise hr_api.validate_enabled;
334: end if;
335: --
336: hr_utility.set_location(' Leaving:'||l_proc, 70);
337: --
336: hr_utility.set_location(' Leaving:'||l_proc, 70);
337: --
338: exception
339: --
340: when hr_api.validate_enabled then
341: --
342: -- As the Validate_Enabled exception has been raised
343: -- we must rollback to the savepoint
344: --