46: ,p_element_type_id => p_element_type_id
47: ,p_distribution_percentage => p_distribution_percentage
48: );
49: exception
50: when hr_api.cannot_find_prog_unit then
51: hr_api.cannot_find_prog_unit_error
52: (
53: p_module_name => 'CREATE_WORKSHEET_BDGT_ELMNT'
54: ,p_hook_type => 'BP'
47: ,p_distribution_percentage => p_distribution_percentage
48: );
49: exception
50: when hr_api.cannot_find_prog_unit then
51: hr_api.cannot_find_prog_unit_error
52: (
53: p_module_name => 'CREATE_WORKSHEET_BDGT_ELMNT'
54: ,p_hook_type => 'BP'
55: );
79: ,p_distribution_percentage => p_distribution_percentage
80: ,p_object_version_number => l_object_version_number
81: );
82: exception
83: when hr_api.cannot_find_prog_unit then
84: hr_api.cannot_find_prog_unit_error
85: (p_module_name => 'CREATE_WORKSHEET_BDGT_ELMNT'
86: ,p_hook_type => 'AP'
87: );
80: ,p_object_version_number => l_object_version_number
81: );
82: exception
83: when hr_api.cannot_find_prog_unit then
84: hr_api.cannot_find_prog_unit_error
85: (p_module_name => 'CREATE_WORKSHEET_BDGT_ELMNT'
86: ,p_hook_type => 'AP'
87: );
88: --
94: --
95: -- When in validation only mode raise the Validate_Enabled exception
96: --
97: if p_validate then
98: raise hr_api.validate_enabled;
99: end if;
100: --
101: -- Set all output arguments
102: --
106: hr_utility.set_location(' Leaving:'||l_proc, 70);
107: --
108: exception
109: --
110: when hr_api.validate_enabled then
111: --
112: -- As the Validate_Enabled exception has been raised
113: -- we must rollback to the savepoint
114: --
138: --
139: procedure update_WORKSHEET_BDGT_ELMNT
140: (p_validate in boolean default false
141: ,p_worksheet_bdgt_elmnt_id in number
142: ,p_worksheet_budget_set_id in number default hr_api.g_number
143: ,p_element_type_id in number default hr_api.g_number
144: ,p_distribution_percentage in number default hr_api.g_number
145: ,p_object_version_number in out nocopy number
146: ) is
139: procedure update_WORKSHEET_BDGT_ELMNT
140: (p_validate in boolean default false
141: ,p_worksheet_bdgt_elmnt_id in number
142: ,p_worksheet_budget_set_id in number default hr_api.g_number
143: ,p_element_type_id in number default hr_api.g_number
144: ,p_distribution_percentage in number default hr_api.g_number
145: ,p_object_version_number in out nocopy number
146: ) is
147: --
140: (p_validate in boolean default false
141: ,p_worksheet_bdgt_elmnt_id in number
142: ,p_worksheet_budget_set_id in number default hr_api.g_number
143: ,p_element_type_id in number default hr_api.g_number
144: ,p_distribution_percentage in number default hr_api.g_number
145: ,p_object_version_number in out nocopy number
146: ) is
147: --
148: -- Declare cursors and local variables
176: ,p_distribution_percentage => p_distribution_percentage
177: ,p_object_version_number => p_object_version_number
178: );
179: exception
180: when hr_api.cannot_find_prog_unit then
181: hr_api.cannot_find_prog_unit_error
182: (p_module_name => 'UPDATE_WORKSHEET_BDGT_ELMNT'
183: ,p_hook_type => 'BP'
184: );
177: ,p_object_version_number => p_object_version_number
178: );
179: exception
180: when hr_api.cannot_find_prog_unit then
181: hr_api.cannot_find_prog_unit_error
182: (p_module_name => 'UPDATE_WORKSHEET_BDGT_ELMNT'
183: ,p_hook_type => 'BP'
184: );
185: --
208: ,p_distribution_percentage => p_distribution_percentage
209: ,p_object_version_number => l_object_version_number
210: );
211: exception
212: when hr_api.cannot_find_prog_unit then
213: hr_api.cannot_find_prog_unit_error
214: (p_module_name => 'UPDATE_WORKSHEET_BDGT_ELMNT'
215: ,p_hook_type => 'AP'
216: );
209: ,p_object_version_number => l_object_version_number
210: );
211: exception
212: when hr_api.cannot_find_prog_unit then
213: hr_api.cannot_find_prog_unit_error
214: (p_module_name => 'UPDATE_WORKSHEET_BDGT_ELMNT'
215: ,p_hook_type => 'AP'
216: );
217: --
223: --
224: -- When in validation only mode raise the Validate_Enabled exception
225: --
226: if p_validate then
227: raise hr_api.validate_enabled;
228: end if;
229: --
230: -- Set all output arguments
231: --
234: hr_utility.set_location(' Leaving:'||l_proc, 70);
235: --
236: exception
237: --
238: when hr_api.validate_enabled then
239: --
240: -- As the Validate_Enabled exception has been raised
241: -- we must rollback to the savepoint
242: --
297: p_worksheet_bdgt_elmnt_id => p_worksheet_bdgt_elmnt_id
298: ,p_object_version_number => p_object_version_number
299: );
300: exception
301: when hr_api.cannot_find_prog_unit then
302: hr_api.cannot_find_prog_unit_error
303: (p_module_name => 'DELETE_WORKSHEET_BDGT_ELMNT'
304: ,p_hook_type => 'BP'
305: );
298: ,p_object_version_number => p_object_version_number
299: );
300: exception
301: when hr_api.cannot_find_prog_unit then
302: hr_api.cannot_find_prog_unit_error
303: (p_module_name => 'DELETE_WORKSHEET_BDGT_ELMNT'
304: ,p_hook_type => 'BP'
305: );
306: --
323: p_worksheet_bdgt_elmnt_id => p_worksheet_bdgt_elmnt_id
324: ,p_object_version_number => l_object_version_number
325: );
326: exception
327: when hr_api.cannot_find_prog_unit then
328: hr_api.cannot_find_prog_unit_error
329: (p_module_name => 'DELETE_WORKSHEET_BDGT_ELMNT'
330: ,p_hook_type => 'AP'
331: );
324: ,p_object_version_number => l_object_version_number
325: );
326: exception
327: when hr_api.cannot_find_prog_unit then
328: hr_api.cannot_find_prog_unit_error
329: (p_module_name => 'DELETE_WORKSHEET_BDGT_ELMNT'
330: ,p_hook_type => 'AP'
331: );
332: --
338: --
339: -- When in validation only mode raise the Validate_Enabled exception
340: --
341: if p_validate then
342: raise hr_api.validate_enabled;
343: end if;
344: --
345: hr_utility.set_location(' Leaving:'||l_proc, 70);
346: --
345: hr_utility.set_location(' Leaving:'||l_proc, 70);
346: --
347: exception
348: --
349: when hr_api.validate_enabled then
350: --
351: -- As the Validate_Enabled exception has been raised
352: -- we must rollback to the savepoint
353: --