56: ,p_organization_id => p_organization_id
57: ,p_cost_allocation_keyflex_id => p_cost_allocation_keyflex_id
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_dflt_fund_src'
64: ,p_hook_type => 'BP'
57: ,p_cost_allocation_keyflex_id => p_cost_allocation_keyflex_id
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_dflt_fund_src'
64: ,p_hook_type => 'BP'
65: );
99: ,p_object_version_number => l_object_version_number
100: ,p_cost_allocation_keyflex_id => p_cost_allocation_keyflex_id
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_dflt_fund_src'
106: ,p_hook_type => 'AP'
107: );
100: ,p_cost_allocation_keyflex_id => p_cost_allocation_keyflex_id
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_dflt_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: --
158: --
159: procedure update_dflt_fund_src
160: (p_validate in boolean default false
161: ,p_dflt_fund_src_id in number
162: ,p_dflt_budget_element_id in number default hr_api.g_number
163: ,p_dflt_dist_percentage in number default hr_api.g_number
164: ,p_project_id in number default hr_api.g_number
165: ,p_award_id in number default hr_api.g_number
166: ,p_task_id in number default hr_api.g_number
159: procedure update_dflt_fund_src
160: (p_validate in boolean default false
161: ,p_dflt_fund_src_id in number
162: ,p_dflt_budget_element_id in number default hr_api.g_number
163: ,p_dflt_dist_percentage in number default hr_api.g_number
164: ,p_project_id in number default hr_api.g_number
165: ,p_award_id in number default hr_api.g_number
166: ,p_task_id in number default hr_api.g_number
167: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
160: (p_validate in boolean default false
161: ,p_dflt_fund_src_id in number
162: ,p_dflt_budget_element_id in number default hr_api.g_number
163: ,p_dflt_dist_percentage in number default hr_api.g_number
164: ,p_project_id in number default hr_api.g_number
165: ,p_award_id in number default hr_api.g_number
166: ,p_task_id in number default hr_api.g_number
167: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
168: ,p_organization_id in number default hr_api.g_number
161: ,p_dflt_fund_src_id in number
162: ,p_dflt_budget_element_id in number default hr_api.g_number
163: ,p_dflt_dist_percentage in number default hr_api.g_number
164: ,p_project_id in number default hr_api.g_number
165: ,p_award_id in number default hr_api.g_number
166: ,p_task_id in number default hr_api.g_number
167: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
168: ,p_organization_id in number default hr_api.g_number
169: ,p_object_version_number in out nocopy number
162: ,p_dflt_budget_element_id in number default hr_api.g_number
163: ,p_dflt_dist_percentage in number default hr_api.g_number
164: ,p_project_id in number default hr_api.g_number
165: ,p_award_id in number default hr_api.g_number
166: ,p_task_id in number default hr_api.g_number
167: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
168: ,p_organization_id in number default hr_api.g_number
169: ,p_object_version_number in out nocopy number
170: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
163: ,p_dflt_dist_percentage in number default hr_api.g_number
164: ,p_project_id in number default hr_api.g_number
165: ,p_award_id in number default hr_api.g_number
166: ,p_task_id in number default hr_api.g_number
167: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
168: ,p_organization_id in number default hr_api.g_number
169: ,p_object_version_number in out nocopy number
170: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
171: ) is
164: ,p_project_id in number default hr_api.g_number
165: ,p_award_id in number default hr_api.g_number
166: ,p_task_id in number default hr_api.g_number
167: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
168: ,p_organization_id in number default hr_api.g_number
169: ,p_object_version_number in out nocopy number
170: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
171: ) is
172: --
166: ,p_task_id in number default hr_api.g_number
167: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
168: ,p_organization_id in number default hr_api.g_number
169: ,p_object_version_number in out nocopy number
170: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
171: ) is
172: --
173: -- Declare cursors and local variables
174: --
206: ,p_object_version_number => p_object_version_number
207: ,p_cost_allocation_keyflex_id => p_cost_allocation_keyflex_id
208: );
209: exception
210: when hr_api.cannot_find_prog_unit then
211: hr_api.cannot_find_prog_unit_error
212: (p_module_name => 'update_dflt_fund_src'
213: ,p_hook_type => 'BP'
214: );
207: ,p_cost_allocation_keyflex_id => p_cost_allocation_keyflex_id
208: );
209: exception
210: when hr_api.cannot_find_prog_unit then
211: hr_api.cannot_find_prog_unit_error
212: (p_module_name => 'update_dflt_fund_src'
213: ,p_hook_type => 'BP'
214: );
215: --
248: ,p_object_version_number => l_object_version_number
249: ,p_cost_allocation_keyflex_id => p_cost_allocation_keyflex_id
250: );
251: exception
252: when hr_api.cannot_find_prog_unit then
253: hr_api.cannot_find_prog_unit_error
254: (p_module_name => 'update_dflt_fund_src'
255: ,p_hook_type => 'AP'
256: );
249: ,p_cost_allocation_keyflex_id => p_cost_allocation_keyflex_id
250: );
251: exception
252: when hr_api.cannot_find_prog_unit then
253: hr_api.cannot_find_prog_unit_error
254: (p_module_name => 'update_dflt_fund_src'
255: ,p_hook_type => 'AP'
256: );
257: --
263: --
264: -- When in validation only mode raise the Validate_Enabled exception
265: --
266: if p_validate then
267: raise hr_api.validate_enabled;
268: end if;
269: --
270: -- Set all output arguments
271: --
274: hr_utility.set_location(' Leaving:'||l_proc, 70);
275: --
276: exception
277: --
278: when hr_api.validate_enabled then
279: --
280: -- As the Validate_Enabled exception has been raised
281: -- we must rollback to the savepoint
282: --
336: p_dflt_fund_src_id => p_dflt_fund_src_id
337: ,p_object_version_number => p_object_version_number
338: );
339: exception
340: when hr_api.cannot_find_prog_unit then
341: hr_api.cannot_find_prog_unit_error
342: (p_module_name => 'delete_dflt_fund_src'
343: ,p_hook_type => 'BP'
344: );
337: ,p_object_version_number => p_object_version_number
338: );
339: exception
340: when hr_api.cannot_find_prog_unit then
341: hr_api.cannot_find_prog_unit_error
342: (p_module_name => 'delete_dflt_fund_src'
343: ,p_hook_type => 'BP'
344: );
345: --
362: p_dflt_fund_src_id => p_dflt_fund_src_id
363: ,p_object_version_number => l_object_version_number
364: );
365: exception
366: when hr_api.cannot_find_prog_unit then
367: hr_api.cannot_find_prog_unit_error
368: (p_module_name => 'delete_dflt_fund_src'
369: ,p_hook_type => 'AP'
370: );
363: ,p_object_version_number => l_object_version_number
364: );
365: exception
366: when hr_api.cannot_find_prog_unit then
367: hr_api.cannot_find_prog_unit_error
368: (p_module_name => 'delete_dflt_fund_src'
369: ,p_hook_type => 'AP'
370: );
371: --
377: --
378: -- When in validation only mode raise the Validate_Enabled exception
379: --
380: if p_validate then
381: raise hr_api.validate_enabled;
382: end if;
383: --
384: hr_utility.set_location(' Leaving:'||l_proc, 70);
385: --
384: hr_utility.set_location(' Leaving:'||l_proc, 70);
385: --
386: exception
387: --
388: when hr_api.validate_enabled then
389: --
390: -- As the Validate_Enabled exception has been raised
391: -- we must rollback to the savepoint
392: --