89: ,p_attribute18 => p_attribute18
90: ,p_attribute19 => p_attribute19
91: ,p_attribute20 => p_attribute20);
92: exception
93: when hr_api.cannot_find_prog_unit then
94: hr_api.cannot_find_prog_unit_error
95: (p_module_name => 'create_premium'
96: ,p_hook_type => 'BP'
97: );
90: ,p_attribute19 => p_attribute19
91: ,p_attribute20 => p_attribute20);
92: exception
93: when hr_api.cannot_find_prog_unit then
94: hr_api.cannot_find_prog_unit_error
95: (p_module_name => 'create_premium'
96: ,p_hook_type => 'BP'
97: );
98: end;
167: ,p_object_version_number => l_object_version_number
168: ,p_effective_start_date => l_effective_start_date
169: ,p_effective_end_date => l_effective_end_date);
170: exception
171: when hr_api.cannot_find_prog_unit then
172: hr_api.cannot_find_prog_unit_error
173: (p_module_name => 'create_premium'
174: ,p_hook_type => 'AP'
175: );
168: ,p_effective_start_date => l_effective_start_date
169: ,p_effective_end_date => l_effective_end_date);
170: exception
171: when hr_api.cannot_find_prog_unit then
172: hr_api.cannot_find_prog_unit_error
173: (p_module_name => 'create_premium'
174: ,p_hook_type => 'AP'
175: );
176: end;
177: --
178: -- When in validation only mode raise the Validate_Enabled exception
179: --
180: if p_validate then
181: raise hr_api.validate_enabled;
182: end if;
183: --
184: -- Set all output arguments
185: --
189: p_effective_end_date := l_effective_end_date;
190: --
191: hr_utility.set_location(' Leaving:'||l_proc, 70);
192: exception
193: when hr_api.validate_enabled then
194: --
195: -- As the Validate_Enabled exception has been raised
196: -- we must rollback to the savepoint
197: --
228: (p_validate in boolean default false
229: ,p_effective_date in date
230: ,p_datetrack_mode in varchar2
231: ,p_liability_premiums_id in number
232: ,p_std_percentage in number default hr_api.g_number
233: ,p_calculation_method in varchar2 default hr_api.g_varchar2
234: ,p_std_working_hours_per_year in number default hr_api.g_number
235: ,p_max_remuneration in number default hr_api.g_number
236: ,p_attribute_category in varchar2 default hr_api.g_varchar2
229: ,p_effective_date in date
230: ,p_datetrack_mode in varchar2
231: ,p_liability_premiums_id in number
232: ,p_std_percentage in number default hr_api.g_number
233: ,p_calculation_method in varchar2 default hr_api.g_varchar2
234: ,p_std_working_hours_per_year in number default hr_api.g_number
235: ,p_max_remuneration in number default hr_api.g_number
236: ,p_attribute_category in varchar2 default hr_api.g_varchar2
237: ,p_attribute1 in varchar2 default hr_api.g_varchar2
230: ,p_datetrack_mode in varchar2
231: ,p_liability_premiums_id in number
232: ,p_std_percentage in number default hr_api.g_number
233: ,p_calculation_method in varchar2 default hr_api.g_varchar2
234: ,p_std_working_hours_per_year in number default hr_api.g_number
235: ,p_max_remuneration in number default hr_api.g_number
236: ,p_attribute_category in varchar2 default hr_api.g_varchar2
237: ,p_attribute1 in varchar2 default hr_api.g_varchar2
238: ,p_attribute2 in varchar2 default hr_api.g_varchar2
231: ,p_liability_premiums_id in number
232: ,p_std_percentage in number default hr_api.g_number
233: ,p_calculation_method in varchar2 default hr_api.g_varchar2
234: ,p_std_working_hours_per_year in number default hr_api.g_number
235: ,p_max_remuneration in number default hr_api.g_number
236: ,p_attribute_category in varchar2 default hr_api.g_varchar2
237: ,p_attribute1 in varchar2 default hr_api.g_varchar2
238: ,p_attribute2 in varchar2 default hr_api.g_varchar2
239: ,p_attribute3 in varchar2 default hr_api.g_varchar2
232: ,p_std_percentage in number default hr_api.g_number
233: ,p_calculation_method in varchar2 default hr_api.g_varchar2
234: ,p_std_working_hours_per_year in number default hr_api.g_number
235: ,p_max_remuneration in number default hr_api.g_number
236: ,p_attribute_category in varchar2 default hr_api.g_varchar2
237: ,p_attribute1 in varchar2 default hr_api.g_varchar2
238: ,p_attribute2 in varchar2 default hr_api.g_varchar2
239: ,p_attribute3 in varchar2 default hr_api.g_varchar2
240: ,p_attribute4 in varchar2 default hr_api.g_varchar2
233: ,p_calculation_method in varchar2 default hr_api.g_varchar2
234: ,p_std_working_hours_per_year in number default hr_api.g_number
235: ,p_max_remuneration in number default hr_api.g_number
236: ,p_attribute_category in varchar2 default hr_api.g_varchar2
237: ,p_attribute1 in varchar2 default hr_api.g_varchar2
238: ,p_attribute2 in varchar2 default hr_api.g_varchar2
239: ,p_attribute3 in varchar2 default hr_api.g_varchar2
240: ,p_attribute4 in varchar2 default hr_api.g_varchar2
241: ,p_attribute5 in varchar2 default hr_api.g_varchar2
234: ,p_std_working_hours_per_year in number default hr_api.g_number
235: ,p_max_remuneration in number default hr_api.g_number
236: ,p_attribute_category in varchar2 default hr_api.g_varchar2
237: ,p_attribute1 in varchar2 default hr_api.g_varchar2
238: ,p_attribute2 in varchar2 default hr_api.g_varchar2
239: ,p_attribute3 in varchar2 default hr_api.g_varchar2
240: ,p_attribute4 in varchar2 default hr_api.g_varchar2
241: ,p_attribute5 in varchar2 default hr_api.g_varchar2
242: ,p_attribute6 in varchar2 default hr_api.g_varchar2
235: ,p_max_remuneration in number default hr_api.g_number
236: ,p_attribute_category in varchar2 default hr_api.g_varchar2
237: ,p_attribute1 in varchar2 default hr_api.g_varchar2
238: ,p_attribute2 in varchar2 default hr_api.g_varchar2
239: ,p_attribute3 in varchar2 default hr_api.g_varchar2
240: ,p_attribute4 in varchar2 default hr_api.g_varchar2
241: ,p_attribute5 in varchar2 default hr_api.g_varchar2
242: ,p_attribute6 in varchar2 default hr_api.g_varchar2
243: ,p_attribute7 in varchar2 default hr_api.g_varchar2
236: ,p_attribute_category in varchar2 default hr_api.g_varchar2
237: ,p_attribute1 in varchar2 default hr_api.g_varchar2
238: ,p_attribute2 in varchar2 default hr_api.g_varchar2
239: ,p_attribute3 in varchar2 default hr_api.g_varchar2
240: ,p_attribute4 in varchar2 default hr_api.g_varchar2
241: ,p_attribute5 in varchar2 default hr_api.g_varchar2
242: ,p_attribute6 in varchar2 default hr_api.g_varchar2
243: ,p_attribute7 in varchar2 default hr_api.g_varchar2
244: ,p_attribute8 in varchar2 default hr_api.g_varchar2
237: ,p_attribute1 in varchar2 default hr_api.g_varchar2
238: ,p_attribute2 in varchar2 default hr_api.g_varchar2
239: ,p_attribute3 in varchar2 default hr_api.g_varchar2
240: ,p_attribute4 in varchar2 default hr_api.g_varchar2
241: ,p_attribute5 in varchar2 default hr_api.g_varchar2
242: ,p_attribute6 in varchar2 default hr_api.g_varchar2
243: ,p_attribute7 in varchar2 default hr_api.g_varchar2
244: ,p_attribute8 in varchar2 default hr_api.g_varchar2
245: ,p_attribute9 in varchar2 default hr_api.g_varchar2
238: ,p_attribute2 in varchar2 default hr_api.g_varchar2
239: ,p_attribute3 in varchar2 default hr_api.g_varchar2
240: ,p_attribute4 in varchar2 default hr_api.g_varchar2
241: ,p_attribute5 in varchar2 default hr_api.g_varchar2
242: ,p_attribute6 in varchar2 default hr_api.g_varchar2
243: ,p_attribute7 in varchar2 default hr_api.g_varchar2
244: ,p_attribute8 in varchar2 default hr_api.g_varchar2
245: ,p_attribute9 in varchar2 default hr_api.g_varchar2
246: ,p_attribute10 in varchar2 default hr_api.g_varchar2
239: ,p_attribute3 in varchar2 default hr_api.g_varchar2
240: ,p_attribute4 in varchar2 default hr_api.g_varchar2
241: ,p_attribute5 in varchar2 default hr_api.g_varchar2
242: ,p_attribute6 in varchar2 default hr_api.g_varchar2
243: ,p_attribute7 in varchar2 default hr_api.g_varchar2
244: ,p_attribute8 in varchar2 default hr_api.g_varchar2
245: ,p_attribute9 in varchar2 default hr_api.g_varchar2
246: ,p_attribute10 in varchar2 default hr_api.g_varchar2
247: ,p_attribute11 in varchar2 default hr_api.g_varchar2
240: ,p_attribute4 in varchar2 default hr_api.g_varchar2
241: ,p_attribute5 in varchar2 default hr_api.g_varchar2
242: ,p_attribute6 in varchar2 default hr_api.g_varchar2
243: ,p_attribute7 in varchar2 default hr_api.g_varchar2
244: ,p_attribute8 in varchar2 default hr_api.g_varchar2
245: ,p_attribute9 in varchar2 default hr_api.g_varchar2
246: ,p_attribute10 in varchar2 default hr_api.g_varchar2
247: ,p_attribute11 in varchar2 default hr_api.g_varchar2
248: ,p_attribute12 in varchar2 default hr_api.g_varchar2
241: ,p_attribute5 in varchar2 default hr_api.g_varchar2
242: ,p_attribute6 in varchar2 default hr_api.g_varchar2
243: ,p_attribute7 in varchar2 default hr_api.g_varchar2
244: ,p_attribute8 in varchar2 default hr_api.g_varchar2
245: ,p_attribute9 in varchar2 default hr_api.g_varchar2
246: ,p_attribute10 in varchar2 default hr_api.g_varchar2
247: ,p_attribute11 in varchar2 default hr_api.g_varchar2
248: ,p_attribute12 in varchar2 default hr_api.g_varchar2
249: ,p_attribute13 in varchar2 default hr_api.g_varchar2
242: ,p_attribute6 in varchar2 default hr_api.g_varchar2
243: ,p_attribute7 in varchar2 default hr_api.g_varchar2
244: ,p_attribute8 in varchar2 default hr_api.g_varchar2
245: ,p_attribute9 in varchar2 default hr_api.g_varchar2
246: ,p_attribute10 in varchar2 default hr_api.g_varchar2
247: ,p_attribute11 in varchar2 default hr_api.g_varchar2
248: ,p_attribute12 in varchar2 default hr_api.g_varchar2
249: ,p_attribute13 in varchar2 default hr_api.g_varchar2
250: ,p_attribute14 in varchar2 default hr_api.g_varchar2
243: ,p_attribute7 in varchar2 default hr_api.g_varchar2
244: ,p_attribute8 in varchar2 default hr_api.g_varchar2
245: ,p_attribute9 in varchar2 default hr_api.g_varchar2
246: ,p_attribute10 in varchar2 default hr_api.g_varchar2
247: ,p_attribute11 in varchar2 default hr_api.g_varchar2
248: ,p_attribute12 in varchar2 default hr_api.g_varchar2
249: ,p_attribute13 in varchar2 default hr_api.g_varchar2
250: ,p_attribute14 in varchar2 default hr_api.g_varchar2
251: ,p_attribute15 in varchar2 default hr_api.g_varchar2
244: ,p_attribute8 in varchar2 default hr_api.g_varchar2
245: ,p_attribute9 in varchar2 default hr_api.g_varchar2
246: ,p_attribute10 in varchar2 default hr_api.g_varchar2
247: ,p_attribute11 in varchar2 default hr_api.g_varchar2
248: ,p_attribute12 in varchar2 default hr_api.g_varchar2
249: ,p_attribute13 in varchar2 default hr_api.g_varchar2
250: ,p_attribute14 in varchar2 default hr_api.g_varchar2
251: ,p_attribute15 in varchar2 default hr_api.g_varchar2
252: ,p_attribute16 in varchar2 default hr_api.g_varchar2
245: ,p_attribute9 in varchar2 default hr_api.g_varchar2
246: ,p_attribute10 in varchar2 default hr_api.g_varchar2
247: ,p_attribute11 in varchar2 default hr_api.g_varchar2
248: ,p_attribute12 in varchar2 default hr_api.g_varchar2
249: ,p_attribute13 in varchar2 default hr_api.g_varchar2
250: ,p_attribute14 in varchar2 default hr_api.g_varchar2
251: ,p_attribute15 in varchar2 default hr_api.g_varchar2
252: ,p_attribute16 in varchar2 default hr_api.g_varchar2
253: ,p_attribute17 in varchar2 default hr_api.g_varchar2
246: ,p_attribute10 in varchar2 default hr_api.g_varchar2
247: ,p_attribute11 in varchar2 default hr_api.g_varchar2
248: ,p_attribute12 in varchar2 default hr_api.g_varchar2
249: ,p_attribute13 in varchar2 default hr_api.g_varchar2
250: ,p_attribute14 in varchar2 default hr_api.g_varchar2
251: ,p_attribute15 in varchar2 default hr_api.g_varchar2
252: ,p_attribute16 in varchar2 default hr_api.g_varchar2
253: ,p_attribute17 in varchar2 default hr_api.g_varchar2
254: ,p_attribute18 in varchar2 default hr_api.g_varchar2
247: ,p_attribute11 in varchar2 default hr_api.g_varchar2
248: ,p_attribute12 in varchar2 default hr_api.g_varchar2
249: ,p_attribute13 in varchar2 default hr_api.g_varchar2
250: ,p_attribute14 in varchar2 default hr_api.g_varchar2
251: ,p_attribute15 in varchar2 default hr_api.g_varchar2
252: ,p_attribute16 in varchar2 default hr_api.g_varchar2
253: ,p_attribute17 in varchar2 default hr_api.g_varchar2
254: ,p_attribute18 in varchar2 default hr_api.g_varchar2
255: ,p_attribute19 in varchar2 default hr_api.g_varchar2
248: ,p_attribute12 in varchar2 default hr_api.g_varchar2
249: ,p_attribute13 in varchar2 default hr_api.g_varchar2
250: ,p_attribute14 in varchar2 default hr_api.g_varchar2
251: ,p_attribute15 in varchar2 default hr_api.g_varchar2
252: ,p_attribute16 in varchar2 default hr_api.g_varchar2
253: ,p_attribute17 in varchar2 default hr_api.g_varchar2
254: ,p_attribute18 in varchar2 default hr_api.g_varchar2
255: ,p_attribute19 in varchar2 default hr_api.g_varchar2
256: ,p_attribute20 in varchar2 default hr_api.g_varchar2
249: ,p_attribute13 in varchar2 default hr_api.g_varchar2
250: ,p_attribute14 in varchar2 default hr_api.g_varchar2
251: ,p_attribute15 in varchar2 default hr_api.g_varchar2
252: ,p_attribute16 in varchar2 default hr_api.g_varchar2
253: ,p_attribute17 in varchar2 default hr_api.g_varchar2
254: ,p_attribute18 in varchar2 default hr_api.g_varchar2
255: ,p_attribute19 in varchar2 default hr_api.g_varchar2
256: ,p_attribute20 in varchar2 default hr_api.g_varchar2
257: ,p_object_version_number in out nocopy number
250: ,p_attribute14 in varchar2 default hr_api.g_varchar2
251: ,p_attribute15 in varchar2 default hr_api.g_varchar2
252: ,p_attribute16 in varchar2 default hr_api.g_varchar2
253: ,p_attribute17 in varchar2 default hr_api.g_varchar2
254: ,p_attribute18 in varchar2 default hr_api.g_varchar2
255: ,p_attribute19 in varchar2 default hr_api.g_varchar2
256: ,p_attribute20 in varchar2 default hr_api.g_varchar2
257: ,p_object_version_number in out nocopy number
258: ,p_effective_start_date out nocopy date
251: ,p_attribute15 in varchar2 default hr_api.g_varchar2
252: ,p_attribute16 in varchar2 default hr_api.g_varchar2
253: ,p_attribute17 in varchar2 default hr_api.g_varchar2
254: ,p_attribute18 in varchar2 default hr_api.g_varchar2
255: ,p_attribute19 in varchar2 default hr_api.g_varchar2
256: ,p_attribute20 in varchar2 default hr_api.g_varchar2
257: ,p_object_version_number in out nocopy number
258: ,p_effective_start_date out nocopy date
259: ,p_effective_end_date out nocopy date
252: ,p_attribute16 in varchar2 default hr_api.g_varchar2
253: ,p_attribute17 in varchar2 default hr_api.g_varchar2
254: ,p_attribute18 in varchar2 default hr_api.g_varchar2
255: ,p_attribute19 in varchar2 default hr_api.g_varchar2
256: ,p_attribute20 in varchar2 default hr_api.g_varchar2
257: ,p_object_version_number in out nocopy number
258: ,p_effective_start_date out nocopy date
259: ,p_effective_end_date out nocopy date
260: ) is
309: ,p_attribute19 => p_attribute19
310: ,p_attribute20 => p_attribute20
311: ,p_object_version_number => l_object_version_number);
312: exception
313: when hr_api.cannot_find_prog_unit then
314: hr_api.cannot_find_prog_unit_error
315: (p_module_name => 'update_premium'
316: ,p_hook_type => 'BP'
317: );
310: ,p_attribute20 => p_attribute20
311: ,p_object_version_number => l_object_version_number);
312: exception
313: when hr_api.cannot_find_prog_unit then
314: hr_api.cannot_find_prog_unit_error
315: (p_module_name => 'update_premium'
316: ,p_hook_type => 'BP'
317: );
318: end;
388: ,p_object_version_number => l_object_version_number
389: ,p_effective_start_date => l_effective_start_date
390: ,p_effective_end_date => l_effective_end_date);
391: exception
392: when hr_api.cannot_find_prog_unit then
393: hr_api.cannot_find_prog_unit_error
394: (p_module_name => 'after_premium'
395: ,p_hook_type => 'AP'
396: );
389: ,p_effective_start_date => l_effective_start_date
390: ,p_effective_end_date => l_effective_end_date);
391: exception
392: when hr_api.cannot_find_prog_unit then
393: hr_api.cannot_find_prog_unit_error
394: (p_module_name => 'after_premium'
395: ,p_hook_type => 'AP'
396: );
397: end;
398: --
399: -- When in validation only mode raise the Validate_Enabled exception
400: --
401: if p_validate then
402: raise hr_api.validate_enabled;
403: end if;
404: --
405: -- Set all output arguments
406: --
409: p_effective_end_date := l_effective_end_date;
410: --
411: hr_utility.set_location(' Leaving:'||l_proc, 70);
412: exception
413: when hr_api.validate_enabled then
414: --
415: -- As the Validate_Enabled exception has been raised
416: -- we must rollback to the savepoint
417: --
476: ,p_liability_premiums_id => p_liability_premiums_id
477: ,p_organization_link_id_o => l_organization_link_id_o
478: ,p_object_version_number => l_object_version_number);
479: exception
480: when hr_api.cannot_find_prog_unit then
481: hr_api.cannot_find_prog_unit_error
482: (p_module_name => 'delete_premium'
483: ,p_hook_type => 'BP'
484: );
477: ,p_organization_link_id_o => l_organization_link_id_o
478: ,p_object_version_number => l_object_version_number);
479: exception
480: when hr_api.cannot_find_prog_unit then
481: hr_api.cannot_find_prog_unit_error
482: (p_module_name => 'delete_premium'
483: ,p_hook_type => 'BP'
484: );
485: end;
505: ,p_object_version_number => l_object_version_number
506: ,p_effective_start_date => l_effective_start_date
507: ,p_effective_end_date => l_effective_end_date);
508: exception
509: when hr_api.cannot_find_prog_unit then
510: hr_api.cannot_find_prog_unit_error
511: (p_module_name => 'delete_premium'
512: ,p_hook_type => 'AP'
513: );
506: ,p_effective_start_date => l_effective_start_date
507: ,p_effective_end_date => l_effective_end_date);
508: exception
509: when hr_api.cannot_find_prog_unit then
510: hr_api.cannot_find_prog_unit_error
511: (p_module_name => 'delete_premium'
512: ,p_hook_type => 'AP'
513: );
514: end;
515: --
516: -- When in validation only mode raise the Validate_Enabled exception
517: --
518: if p_validate then
519: raise hr_api.validate_enabled;
520: end if;
521: --
522: -- Set all output arguments
523: --
526: p_effective_end_date := l_effective_end_date;
527: --
528: hr_utility.set_location(' Leaving:'||l_proc, 70);
529: exception
530: when hr_api.validate_enabled then
531: --
532: -- As the Validate_Enabled exception has been raised
533: -- we must rollback to the savepoint
534: --