56: ,p_organization_id => p_organization_id
57: ,p_distribution_percentage => p_distribution_percentage
58: );
59: exception
60: when hr_api.cannot_find_prog_unit then
61: hr_api.cannot_find_prog_unit_error
62: (
63: p_module_name => 'create_budget_fund_src'
64: ,p_hook_type => 'BP'
57: ,p_distribution_percentage => p_distribution_percentage
58: );
59: exception
60: when hr_api.cannot_find_prog_unit then
61: hr_api.cannot_find_prog_unit_error
62: (
63: p_module_name => 'create_budget_fund_src'
64: ,p_hook_type => 'BP'
65: );
99: ,p_distribution_percentage => p_distribution_percentage
100: ,p_object_version_number => l_object_version_number
101: );
102: exception
103: when hr_api.cannot_find_prog_unit then
104: hr_api.cannot_find_prog_unit_error
105: (p_module_name => 'create_budget_fund_src'
106: ,p_hook_type => 'AP'
107: );
100: ,p_object_version_number => l_object_version_number
101: );
102: exception
103: when hr_api.cannot_find_prog_unit then
104: hr_api.cannot_find_prog_unit_error
105: (p_module_name => 'create_budget_fund_src'
106: ,p_hook_type => 'AP'
107: );
108: --
114: --
115: -- When in validation only mode raise the Validate_Enabled exception
116: --
117: if p_validate then
118: raise hr_api.validate_enabled;
119: end if;
120: --
121: -- Set all output arguments
122: --
126: hr_utility.set_location(' Leaving:'||l_proc, 70);
127: --
128: exception
129: --
130: when hr_api.validate_enabled then
131: --
132: -- As the Validate_Enabled exception has been raised
133: -- we must rollback to the savepoint
134: --
159: --
160: procedure update_budget_fund_src
161: (p_validate in boolean default false
162: ,p_budget_fund_src_id in number
163: ,p_budget_element_id in number default hr_api.g_number
164: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
165: ,p_project_id in number default hr_api.g_number
166: ,p_award_id in number default hr_api.g_number
167: ,p_task_id in number default hr_api.g_number
160: procedure update_budget_fund_src
161: (p_validate in boolean default false
162: ,p_budget_fund_src_id in number
163: ,p_budget_element_id in number default hr_api.g_number
164: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
165: ,p_project_id in number default hr_api.g_number
166: ,p_award_id in number default hr_api.g_number
167: ,p_task_id in number default hr_api.g_number
168: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
161: (p_validate in boolean default false
162: ,p_budget_fund_src_id in number
163: ,p_budget_element_id in number default hr_api.g_number
164: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
165: ,p_project_id in number default hr_api.g_number
166: ,p_award_id in number default hr_api.g_number
167: ,p_task_id in number default hr_api.g_number
168: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
169: ,p_organization_id in number default hr_api.g_number
162: ,p_budget_fund_src_id in number
163: ,p_budget_element_id in number default hr_api.g_number
164: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
165: ,p_project_id in number default hr_api.g_number
166: ,p_award_id in number default hr_api.g_number
167: ,p_task_id in number default hr_api.g_number
168: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
169: ,p_organization_id in number default hr_api.g_number
170: ,p_distribution_percentage in number default hr_api.g_number
163: ,p_budget_element_id in number default hr_api.g_number
164: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
165: ,p_project_id in number default hr_api.g_number
166: ,p_award_id in number default hr_api.g_number
167: ,p_task_id in number default hr_api.g_number
168: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
169: ,p_organization_id in number default hr_api.g_number
170: ,p_distribution_percentage in number default hr_api.g_number
171: ,p_object_version_number in out nocopy number
164: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
165: ,p_project_id in number default hr_api.g_number
166: ,p_award_id in number default hr_api.g_number
167: ,p_task_id in number default hr_api.g_number
168: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
169: ,p_organization_id in number default hr_api.g_number
170: ,p_distribution_percentage in number default hr_api.g_number
171: ,p_object_version_number in out nocopy number
172: ) is
165: ,p_project_id in number default hr_api.g_number
166: ,p_award_id in number default hr_api.g_number
167: ,p_task_id in number default hr_api.g_number
168: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
169: ,p_organization_id in number default hr_api.g_number
170: ,p_distribution_percentage in number default hr_api.g_number
171: ,p_object_version_number in out nocopy number
172: ) is
173: --
166: ,p_award_id in number default hr_api.g_number
167: ,p_task_id in number default hr_api.g_number
168: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
169: ,p_organization_id in number default hr_api.g_number
170: ,p_distribution_percentage in number default hr_api.g_number
171: ,p_object_version_number in out nocopy number
172: ) is
173: --
174: -- Declare cursors and local variables
207: ,p_distribution_percentage => p_distribution_percentage
208: ,p_object_version_number => p_object_version_number
209: );
210: exception
211: when hr_api.cannot_find_prog_unit then
212: hr_api.cannot_find_prog_unit_error
213: (p_module_name => 'update_budget_fund_src'
214: ,p_hook_type => 'BP'
215: );
208: ,p_object_version_number => p_object_version_number
209: );
210: exception
211: when hr_api.cannot_find_prog_unit then
212: hr_api.cannot_find_prog_unit_error
213: (p_module_name => 'update_budget_fund_src'
214: ,p_hook_type => 'BP'
215: );
216: --
249: ,p_distribution_percentage => p_distribution_percentage
250: ,p_object_version_number => l_object_version_number
251: );
252: exception
253: when hr_api.cannot_find_prog_unit then
254: hr_api.cannot_find_prog_unit_error
255: (p_module_name => 'update_budget_fund_src'
256: ,p_hook_type => 'AP'
257: );
250: ,p_object_version_number => l_object_version_number
251: );
252: exception
253: when hr_api.cannot_find_prog_unit then
254: hr_api.cannot_find_prog_unit_error
255: (p_module_name => 'update_budget_fund_src'
256: ,p_hook_type => 'AP'
257: );
258: --
264: --
265: -- When in validation only mode raise the Validate_Enabled exception
266: --
267: if p_validate then
268: raise hr_api.validate_enabled;
269: end if;
270: --
271: -- Set all output arguments
272: --
275: hr_utility.set_location(' Leaving:'||l_proc, 70);
276: --
277: exception
278: --
279: when hr_api.validate_enabled then
280: --
281: -- As the Validate_Enabled exception has been raised
282: -- we must rollback to the savepoint
283: --
337: p_budget_fund_src_id => p_budget_fund_src_id
338: ,p_object_version_number => p_object_version_number
339: );
340: exception
341: when hr_api.cannot_find_prog_unit then
342: hr_api.cannot_find_prog_unit_error
343: (p_module_name => 'delete_budget_fund_src'
344: ,p_hook_type => 'BP'
345: );
338: ,p_object_version_number => p_object_version_number
339: );
340: exception
341: when hr_api.cannot_find_prog_unit then
342: hr_api.cannot_find_prog_unit_error
343: (p_module_name => 'delete_budget_fund_src'
344: ,p_hook_type => 'BP'
345: );
346: --
363: p_budget_fund_src_id => p_budget_fund_src_id
364: ,p_object_version_number => l_object_version_number
365: );
366: exception
367: when hr_api.cannot_find_prog_unit then
368: hr_api.cannot_find_prog_unit_error
369: (p_module_name => 'delete_budget_fund_src'
370: ,p_hook_type => 'AP'
371: );
364: ,p_object_version_number => l_object_version_number
365: );
366: exception
367: when hr_api.cannot_find_prog_unit then
368: hr_api.cannot_find_prog_unit_error
369: (p_module_name => 'delete_budget_fund_src'
370: ,p_hook_type => 'AP'
371: );
372: --
378: --
379: -- When in validation only mode raise the Validate_Enabled exception
380: --
381: if p_validate then
382: raise hr_api.validate_enabled;
383: end if;
384: --
385: hr_utility.set_location(' Leaving:'||l_proc, 70);
386: --
385: hr_utility.set_location(' Leaving:'||l_proc, 70);
386: --
387: exception
388: --
389: when hr_api.validate_enabled then
390: --
391: -- As the Validate_Enabled exception has been raised
392: -- we must rollback to the savepoint
393: --