55: ,p_cost_date => p_cost_date
56: ,p_description => p_description
57: );
58: exception
59: when hr_api.cannot_find_prog_unit then
60: hr_api.cannot_find_prog_unit_error
61: (p_module_name => 'CREATE_AGENCY_COSTS'
62: ,p_hook_type => 'BP'
63: );
56: ,p_description => p_description
57: );
58: exception
59: when hr_api.cannot_find_prog_unit then
60: hr_api.cannot_find_prog_unit_error
61: (p_module_name => 'CREATE_AGENCY_COSTS'
62: ,p_hook_type => 'BP'
63: );
64: end;
102: ,p_compl_agency_cost_id => l_compl_agency_cost_id
103: ,p_object_version_number => l_object_version_number
104: );
105: exception
106: when hr_api.cannot_find_prog_unit then
107: hr_api.cannot_find_prog_unit_error
108: (p_module_name => 'CREATE_AGENCY_COSTS'
109: ,p_hook_type => 'AP'
110: );
103: ,p_object_version_number => l_object_version_number
104: );
105: exception
106: when hr_api.cannot_find_prog_unit then
107: hr_api.cannot_find_prog_unit_error
108: (p_module_name => 'CREATE_AGENCY_COSTS'
109: ,p_hook_type => 'AP'
110: );
111: end;
112: --
113: -- When in validation only mode raise the Validate_Enabled exception
114: --
115: if p_validate then
116: raise hr_api.validate_enabled;
117: end if;
118: --
119: -- Set all output arguments
120: --
122: p_object_version_number := l_object_version_number;
123: --
124: hr_utility.set_location(' Leaving:'||l_proc, 70);
125: exception
126: when hr_api.validate_enabled then
127: --
128: -- As the Validate_Enabled exception has been raised
129: -- we must rollback to the savepoint
130: --
156: procedure update_agency_costs
157: (p_validate in boolean default false
158: ,p_effective_date in date
159: ,p_compl_agency_cost_id in number
160: ,p_complaint_id in number default hr_api.g_number
161: ,p_phase in varchar2 default hr_api.g_varchar2
162: ,p_stage in varchar2 default hr_api.g_varchar2
163: ,p_category in varchar2 default hr_api.g_varchar2
164: ,p_amount in number default hr_api.g_number
157: (p_validate in boolean default false
158: ,p_effective_date in date
159: ,p_compl_agency_cost_id in number
160: ,p_complaint_id in number default hr_api.g_number
161: ,p_phase in varchar2 default hr_api.g_varchar2
162: ,p_stage in varchar2 default hr_api.g_varchar2
163: ,p_category in varchar2 default hr_api.g_varchar2
164: ,p_amount in number default hr_api.g_number
165: ,p_cost_date in date default hr_api.g_date
158: ,p_effective_date in date
159: ,p_compl_agency_cost_id in number
160: ,p_complaint_id in number default hr_api.g_number
161: ,p_phase in varchar2 default hr_api.g_varchar2
162: ,p_stage in varchar2 default hr_api.g_varchar2
163: ,p_category in varchar2 default hr_api.g_varchar2
164: ,p_amount in number default hr_api.g_number
165: ,p_cost_date in date default hr_api.g_date
166: ,p_description in varchar2 default hr_api.g_varchar2
159: ,p_compl_agency_cost_id in number
160: ,p_complaint_id in number default hr_api.g_number
161: ,p_phase in varchar2 default hr_api.g_varchar2
162: ,p_stage in varchar2 default hr_api.g_varchar2
163: ,p_category in varchar2 default hr_api.g_varchar2
164: ,p_amount in number default hr_api.g_number
165: ,p_cost_date in date default hr_api.g_date
166: ,p_description in varchar2 default hr_api.g_varchar2
167: ,p_object_version_number in out nocopy number
160: ,p_complaint_id in number default hr_api.g_number
161: ,p_phase in varchar2 default hr_api.g_varchar2
162: ,p_stage in varchar2 default hr_api.g_varchar2
163: ,p_category in varchar2 default hr_api.g_varchar2
164: ,p_amount in number default hr_api.g_number
165: ,p_cost_date in date default hr_api.g_date
166: ,p_description in varchar2 default hr_api.g_varchar2
167: ,p_object_version_number in out nocopy number
168: )
161: ,p_phase in varchar2 default hr_api.g_varchar2
162: ,p_stage in varchar2 default hr_api.g_varchar2
163: ,p_category in varchar2 default hr_api.g_varchar2
164: ,p_amount in number default hr_api.g_number
165: ,p_cost_date in date default hr_api.g_date
166: ,p_description in varchar2 default hr_api.g_varchar2
167: ,p_object_version_number in out nocopy number
168: )
169:
162: ,p_stage in varchar2 default hr_api.g_varchar2
163: ,p_category in varchar2 default hr_api.g_varchar2
164: ,p_amount in number default hr_api.g_number
165: ,p_cost_date in date default hr_api.g_date
166: ,p_description in varchar2 default hr_api.g_varchar2
167: ,p_object_version_number in out nocopy number
168: )
169:
170: is
199: ,p_compl_agency_cost_id => p_compl_agency_cost_id
200: ,p_object_version_number => p_object_version_number
201: );
202: exception
203: when hr_api.cannot_find_prog_unit then
204: hr_api.cannot_find_prog_unit_error
205: (p_module_name => 'UPDATE_AGENCY_COSTS'
206: ,p_hook_type => 'BP'
207: );
200: ,p_object_version_number => p_object_version_number
201: );
202: exception
203: when hr_api.cannot_find_prog_unit then
204: hr_api.cannot_find_prog_unit_error
205: (p_module_name => 'UPDATE_AGENCY_COSTS'
206: ,p_hook_type => 'BP'
207: );
208: end;
243: ,p_compl_agency_cost_id => p_compl_agency_cost_id
244: ,p_object_version_number => l_object_version_number
245: );
246: exception
247: when hr_api.cannot_find_prog_unit then
248: hr_api.cannot_find_prog_unit_error
249: (p_module_name => 'UPDATE_AGENCY_COSTS'
250: ,p_hook_type => 'AP'
251: );
244: ,p_object_version_number => l_object_version_number
245: );
246: exception
247: when hr_api.cannot_find_prog_unit then
248: hr_api.cannot_find_prog_unit_error
249: (p_module_name => 'UPDATE_AGENCY_COSTS'
250: ,p_hook_type => 'AP'
251: );
252: end;
253: --
254: -- When in validation only mode raise the Validate_Enabled exception
255: --
256: if p_validate then
257: raise hr_api.validate_enabled;
258: end if;
259: --
260: -- Set all output arguments
261: --
262: p_object_version_number := l_object_version_number;
263: --
264: hr_utility.set_location(' Leaving:'||l_proc, 70);
265: exception
266: when hr_api.validate_enabled then
267: --
268: -- As the Validate_Enabled exception has been raised
269: -- we must rollback to the savepoint
270: --
322: (p_compl_agency_cost_id => p_compl_agency_cost_id
323: ,p_object_version_number => p_object_version_number
324: );
325: exception
326: when hr_api.cannot_find_prog_unit then
327: hr_api.cannot_find_prog_unit_error
328: (p_module_name => 'DELETE_AGENCY_COSTS'
329: ,p_hook_type => 'BP'
330: );
323: ,p_object_version_number => p_object_version_number
324: );
325: exception
326: when hr_api.cannot_find_prog_unit then
327: hr_api.cannot_find_prog_unit_error
328: (p_module_name => 'DELETE_AGENCY_COSTS'
329: ,p_hook_type => 'BP'
330: );
331: end;
347: (p_compl_agency_cost_id => p_compl_agency_cost_id
348: ,p_object_version_number => p_object_version_number
349: );
350: exception
351: when hr_api.cannot_find_prog_unit then
352: hr_api.cannot_find_prog_unit_error
353: (p_module_name => 'DELETE_AGENCY_COSTS'
354: ,p_hook_type => 'AP'
355: );
348: ,p_object_version_number => p_object_version_number
349: );
350: exception
351: when hr_api.cannot_find_prog_unit then
352: hr_api.cannot_find_prog_unit_error
353: (p_module_name => 'DELETE_AGENCY_COSTS'
354: ,p_hook_type => 'AP'
355: );
356: end;
357: --
358: -- When in validation only mode raise the Validate_Enabled exception
359: --
360: if p_validate then
361: raise hr_api.validate_enabled;
362: end if;
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 11);
365: exception
362: end if;
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 11);
365: exception
366: when hr_api.validate_enabled then
367: -- we must rollback to the savepoint
368: --
369: ROLLBACK TO delete_agency_costs;
370: --