11: --
12: procedure create_bal_type
13: (p_validate in boolean default false
14: ,p_effective_date in date
15: ,p_language_code in varchar2 Default hr_api.userenv_lang
16: ,p_balance_name in varchar2
17: ,p_balance_uom in varchar2
18: ,p_business_group_id in number
19: ,p_legislation_code in varchar2 default null
143: ,p_base_balance_type_id => p_base_balance_type_id
144: ,p_input_value_id => p_input_value_id
145: );
146: exception
147: when hr_api.cannot_find_prog_unit then
148: hr_api.cannot_find_prog_unit_error
149: (p_module_name => 'CREATE_BAL_TYPE'
150: ,p_hook_type => 'BP'
151: );
144: ,p_input_value_id => p_input_value_id
145: );
146: exception
147: when hr_api.cannot_find_prog_unit then
148: hr_api.cannot_find_prog_unit_error
149: (p_module_name => 'CREATE_BAL_TYPE'
150: ,p_hook_type => 'BP'
151: );
152: end;
254: ,p_balance_type_id => l_balance_type_id
255: ,p_object_version_number => l_object_version_number
256: );
257: exception
258: when hr_api.cannot_find_prog_unit then
259: hr_api.cannot_find_prog_unit_error
260: (p_module_name => 'CREATE_BAL_TYPE'
261: ,p_hook_type => 'AP'
262: );
255: ,p_object_version_number => l_object_version_number
256: );
257: exception
258: when hr_api.cannot_find_prog_unit then
259: hr_api.cannot_find_prog_unit_error
260: (p_module_name => 'CREATE_BAL_TYPE'
261: ,p_hook_type => 'AP'
262: );
263: end;
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 IN OUT and OUT parameters with out values
272: --
275:
276: --
277: hr_utility.set_location(' Leaving:'||l_proc, 70);
278: exception
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: --
313: --
314: procedure update_bal_type
315: (p_validate in boolean default false
316: ,p_effective_date in date
317: ,p_language_code in varchar2 Default hr_api.userenv_lang
318: ,p_balance_type_id in number
319: ,p_object_version_number in out nocopy number
320: ,p_balance_name in varchar2 default hr_api.g_varchar2
321: ,p_balance_uom in varchar2 default hr_api.g_varchar2
316: ,p_effective_date in date
317: ,p_language_code in varchar2 Default hr_api.userenv_lang
318: ,p_balance_type_id in number
319: ,p_object_version_number in out nocopy number
320: ,p_balance_name in varchar2 default hr_api.g_varchar2
321: ,p_balance_uom in varchar2 default hr_api.g_varchar2
322: ,p_currency_code in varchar2 default hr_api.g_varchar2
323: ,p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2
324: ,p_comments in varchar2 default hr_api.g_varchar2
317: ,p_language_code in varchar2 Default hr_api.userenv_lang
318: ,p_balance_type_id in number
319: ,p_object_version_number in out nocopy number
320: ,p_balance_name in varchar2 default hr_api.g_varchar2
321: ,p_balance_uom in varchar2 default hr_api.g_varchar2
322: ,p_currency_code in varchar2 default hr_api.g_varchar2
323: ,p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2
324: ,p_comments in varchar2 default hr_api.g_varchar2
325: ,p_reporting_name in varchar2 default hr_api.g_varchar2
318: ,p_balance_type_id in number
319: ,p_object_version_number in out nocopy number
320: ,p_balance_name in varchar2 default hr_api.g_varchar2
321: ,p_balance_uom in varchar2 default hr_api.g_varchar2
322: ,p_currency_code in varchar2 default hr_api.g_varchar2
323: ,p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2
324: ,p_comments in varchar2 default hr_api.g_varchar2
325: ,p_reporting_name in varchar2 default hr_api.g_varchar2
326: ,p_attribute_category in varchar2 default hr_api.g_varchar2
319: ,p_object_version_number in out nocopy number
320: ,p_balance_name in varchar2 default hr_api.g_varchar2
321: ,p_balance_uom in varchar2 default hr_api.g_varchar2
322: ,p_currency_code in varchar2 default hr_api.g_varchar2
323: ,p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2
324: ,p_comments in varchar2 default hr_api.g_varchar2
325: ,p_reporting_name in varchar2 default hr_api.g_varchar2
326: ,p_attribute_category in varchar2 default hr_api.g_varchar2
327: ,p_attribute1 in varchar2 default hr_api.g_varchar2
320: ,p_balance_name in varchar2 default hr_api.g_varchar2
321: ,p_balance_uom in varchar2 default hr_api.g_varchar2
322: ,p_currency_code in varchar2 default hr_api.g_varchar2
323: ,p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2
324: ,p_comments in varchar2 default hr_api.g_varchar2
325: ,p_reporting_name in varchar2 default hr_api.g_varchar2
326: ,p_attribute_category in varchar2 default hr_api.g_varchar2
327: ,p_attribute1 in varchar2 default hr_api.g_varchar2
328: ,p_attribute2 in varchar2 default hr_api.g_varchar2
321: ,p_balance_uom in varchar2 default hr_api.g_varchar2
322: ,p_currency_code in varchar2 default hr_api.g_varchar2
323: ,p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2
324: ,p_comments in varchar2 default hr_api.g_varchar2
325: ,p_reporting_name in varchar2 default hr_api.g_varchar2
326: ,p_attribute_category in varchar2 default hr_api.g_varchar2
327: ,p_attribute1 in varchar2 default hr_api.g_varchar2
328: ,p_attribute2 in varchar2 default hr_api.g_varchar2
329: ,p_attribute3 in varchar2 default hr_api.g_varchar2
322: ,p_currency_code in varchar2 default hr_api.g_varchar2
323: ,p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2
324: ,p_comments in varchar2 default hr_api.g_varchar2
325: ,p_reporting_name in varchar2 default hr_api.g_varchar2
326: ,p_attribute_category in varchar2 default hr_api.g_varchar2
327: ,p_attribute1 in varchar2 default hr_api.g_varchar2
328: ,p_attribute2 in varchar2 default hr_api.g_varchar2
329: ,p_attribute3 in varchar2 default hr_api.g_varchar2
330: ,p_attribute4 in varchar2 default hr_api.g_varchar2
323: ,p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2
324: ,p_comments in varchar2 default hr_api.g_varchar2
325: ,p_reporting_name in varchar2 default hr_api.g_varchar2
326: ,p_attribute_category in varchar2 default hr_api.g_varchar2
327: ,p_attribute1 in varchar2 default hr_api.g_varchar2
328: ,p_attribute2 in varchar2 default hr_api.g_varchar2
329: ,p_attribute3 in varchar2 default hr_api.g_varchar2
330: ,p_attribute4 in varchar2 default hr_api.g_varchar2
331: ,p_attribute5 in varchar2 default hr_api.g_varchar2
324: ,p_comments in varchar2 default hr_api.g_varchar2
325: ,p_reporting_name in varchar2 default hr_api.g_varchar2
326: ,p_attribute_category in varchar2 default hr_api.g_varchar2
327: ,p_attribute1 in varchar2 default hr_api.g_varchar2
328: ,p_attribute2 in varchar2 default hr_api.g_varchar2
329: ,p_attribute3 in varchar2 default hr_api.g_varchar2
330: ,p_attribute4 in varchar2 default hr_api.g_varchar2
331: ,p_attribute5 in varchar2 default hr_api.g_varchar2
332: ,p_attribute6 in varchar2 default hr_api.g_varchar2
325: ,p_reporting_name in varchar2 default hr_api.g_varchar2
326: ,p_attribute_category in varchar2 default hr_api.g_varchar2
327: ,p_attribute1 in varchar2 default hr_api.g_varchar2
328: ,p_attribute2 in varchar2 default hr_api.g_varchar2
329: ,p_attribute3 in varchar2 default hr_api.g_varchar2
330: ,p_attribute4 in varchar2 default hr_api.g_varchar2
331: ,p_attribute5 in varchar2 default hr_api.g_varchar2
332: ,p_attribute6 in varchar2 default hr_api.g_varchar2
333: ,p_attribute7 in varchar2 default hr_api.g_varchar2
326: ,p_attribute_category in varchar2 default hr_api.g_varchar2
327: ,p_attribute1 in varchar2 default hr_api.g_varchar2
328: ,p_attribute2 in varchar2 default hr_api.g_varchar2
329: ,p_attribute3 in varchar2 default hr_api.g_varchar2
330: ,p_attribute4 in varchar2 default hr_api.g_varchar2
331: ,p_attribute5 in varchar2 default hr_api.g_varchar2
332: ,p_attribute6 in varchar2 default hr_api.g_varchar2
333: ,p_attribute7 in varchar2 default hr_api.g_varchar2
334: ,p_attribute8 in varchar2 default hr_api.g_varchar2
327: ,p_attribute1 in varchar2 default hr_api.g_varchar2
328: ,p_attribute2 in varchar2 default hr_api.g_varchar2
329: ,p_attribute3 in varchar2 default hr_api.g_varchar2
330: ,p_attribute4 in varchar2 default hr_api.g_varchar2
331: ,p_attribute5 in varchar2 default hr_api.g_varchar2
332: ,p_attribute6 in varchar2 default hr_api.g_varchar2
333: ,p_attribute7 in varchar2 default hr_api.g_varchar2
334: ,p_attribute8 in varchar2 default hr_api.g_varchar2
335: ,p_attribute9 in varchar2 default hr_api.g_varchar2
328: ,p_attribute2 in varchar2 default hr_api.g_varchar2
329: ,p_attribute3 in varchar2 default hr_api.g_varchar2
330: ,p_attribute4 in varchar2 default hr_api.g_varchar2
331: ,p_attribute5 in varchar2 default hr_api.g_varchar2
332: ,p_attribute6 in varchar2 default hr_api.g_varchar2
333: ,p_attribute7 in varchar2 default hr_api.g_varchar2
334: ,p_attribute8 in varchar2 default hr_api.g_varchar2
335: ,p_attribute9 in varchar2 default hr_api.g_varchar2
336: ,p_attribute10 in varchar2 default hr_api.g_varchar2
329: ,p_attribute3 in varchar2 default hr_api.g_varchar2
330: ,p_attribute4 in varchar2 default hr_api.g_varchar2
331: ,p_attribute5 in varchar2 default hr_api.g_varchar2
332: ,p_attribute6 in varchar2 default hr_api.g_varchar2
333: ,p_attribute7 in varchar2 default hr_api.g_varchar2
334: ,p_attribute8 in varchar2 default hr_api.g_varchar2
335: ,p_attribute9 in varchar2 default hr_api.g_varchar2
336: ,p_attribute10 in varchar2 default hr_api.g_varchar2
337: ,p_attribute11 in varchar2 default hr_api.g_varchar2
330: ,p_attribute4 in varchar2 default hr_api.g_varchar2
331: ,p_attribute5 in varchar2 default hr_api.g_varchar2
332: ,p_attribute6 in varchar2 default hr_api.g_varchar2
333: ,p_attribute7 in varchar2 default hr_api.g_varchar2
334: ,p_attribute8 in varchar2 default hr_api.g_varchar2
335: ,p_attribute9 in varchar2 default hr_api.g_varchar2
336: ,p_attribute10 in varchar2 default hr_api.g_varchar2
337: ,p_attribute11 in varchar2 default hr_api.g_varchar2
338: ,p_attribute12 in varchar2 default hr_api.g_varchar2
331: ,p_attribute5 in varchar2 default hr_api.g_varchar2
332: ,p_attribute6 in varchar2 default hr_api.g_varchar2
333: ,p_attribute7 in varchar2 default hr_api.g_varchar2
334: ,p_attribute8 in varchar2 default hr_api.g_varchar2
335: ,p_attribute9 in varchar2 default hr_api.g_varchar2
336: ,p_attribute10 in varchar2 default hr_api.g_varchar2
337: ,p_attribute11 in varchar2 default hr_api.g_varchar2
338: ,p_attribute12 in varchar2 default hr_api.g_varchar2
339: ,p_attribute13 in varchar2 default hr_api.g_varchar2
332: ,p_attribute6 in varchar2 default hr_api.g_varchar2
333: ,p_attribute7 in varchar2 default hr_api.g_varchar2
334: ,p_attribute8 in varchar2 default hr_api.g_varchar2
335: ,p_attribute9 in varchar2 default hr_api.g_varchar2
336: ,p_attribute10 in varchar2 default hr_api.g_varchar2
337: ,p_attribute11 in varchar2 default hr_api.g_varchar2
338: ,p_attribute12 in varchar2 default hr_api.g_varchar2
339: ,p_attribute13 in varchar2 default hr_api.g_varchar2
340: ,p_attribute14 in varchar2 default hr_api.g_varchar2
333: ,p_attribute7 in varchar2 default hr_api.g_varchar2
334: ,p_attribute8 in varchar2 default hr_api.g_varchar2
335: ,p_attribute9 in varchar2 default hr_api.g_varchar2
336: ,p_attribute10 in varchar2 default hr_api.g_varchar2
337: ,p_attribute11 in varchar2 default hr_api.g_varchar2
338: ,p_attribute12 in varchar2 default hr_api.g_varchar2
339: ,p_attribute13 in varchar2 default hr_api.g_varchar2
340: ,p_attribute14 in varchar2 default hr_api.g_varchar2
341: ,p_attribute15 in varchar2 default hr_api.g_varchar2
334: ,p_attribute8 in varchar2 default hr_api.g_varchar2
335: ,p_attribute9 in varchar2 default hr_api.g_varchar2
336: ,p_attribute10 in varchar2 default hr_api.g_varchar2
337: ,p_attribute11 in varchar2 default hr_api.g_varchar2
338: ,p_attribute12 in varchar2 default hr_api.g_varchar2
339: ,p_attribute13 in varchar2 default hr_api.g_varchar2
340: ,p_attribute14 in varchar2 default hr_api.g_varchar2
341: ,p_attribute15 in varchar2 default hr_api.g_varchar2
342: ,p_attribute16 in varchar2 default hr_api.g_varchar2
335: ,p_attribute9 in varchar2 default hr_api.g_varchar2
336: ,p_attribute10 in varchar2 default hr_api.g_varchar2
337: ,p_attribute11 in varchar2 default hr_api.g_varchar2
338: ,p_attribute12 in varchar2 default hr_api.g_varchar2
339: ,p_attribute13 in varchar2 default hr_api.g_varchar2
340: ,p_attribute14 in varchar2 default hr_api.g_varchar2
341: ,p_attribute15 in varchar2 default hr_api.g_varchar2
342: ,p_attribute16 in varchar2 default hr_api.g_varchar2
343: ,p_attribute17 in varchar2 default hr_api.g_varchar2
336: ,p_attribute10 in varchar2 default hr_api.g_varchar2
337: ,p_attribute11 in varchar2 default hr_api.g_varchar2
338: ,p_attribute12 in varchar2 default hr_api.g_varchar2
339: ,p_attribute13 in varchar2 default hr_api.g_varchar2
340: ,p_attribute14 in varchar2 default hr_api.g_varchar2
341: ,p_attribute15 in varchar2 default hr_api.g_varchar2
342: ,p_attribute16 in varchar2 default hr_api.g_varchar2
343: ,p_attribute17 in varchar2 default hr_api.g_varchar2
344: ,p_attribute18 in varchar2 default hr_api.g_varchar2
337: ,p_attribute11 in varchar2 default hr_api.g_varchar2
338: ,p_attribute12 in varchar2 default hr_api.g_varchar2
339: ,p_attribute13 in varchar2 default hr_api.g_varchar2
340: ,p_attribute14 in varchar2 default hr_api.g_varchar2
341: ,p_attribute15 in varchar2 default hr_api.g_varchar2
342: ,p_attribute16 in varchar2 default hr_api.g_varchar2
343: ,p_attribute17 in varchar2 default hr_api.g_varchar2
344: ,p_attribute18 in varchar2 default hr_api.g_varchar2
345: ,p_attribute19 in varchar2 default hr_api.g_varchar2
338: ,p_attribute12 in varchar2 default hr_api.g_varchar2
339: ,p_attribute13 in varchar2 default hr_api.g_varchar2
340: ,p_attribute14 in varchar2 default hr_api.g_varchar2
341: ,p_attribute15 in varchar2 default hr_api.g_varchar2
342: ,p_attribute16 in varchar2 default hr_api.g_varchar2
343: ,p_attribute17 in varchar2 default hr_api.g_varchar2
344: ,p_attribute18 in varchar2 default hr_api.g_varchar2
345: ,p_attribute19 in varchar2 default hr_api.g_varchar2
346: ,p_attribute20 in varchar2 default hr_api.g_varchar2
339: ,p_attribute13 in varchar2 default hr_api.g_varchar2
340: ,p_attribute14 in varchar2 default hr_api.g_varchar2
341: ,p_attribute15 in varchar2 default hr_api.g_varchar2
342: ,p_attribute16 in varchar2 default hr_api.g_varchar2
343: ,p_attribute17 in varchar2 default hr_api.g_varchar2
344: ,p_attribute18 in varchar2 default hr_api.g_varchar2
345: ,p_attribute19 in varchar2 default hr_api.g_varchar2
346: ,p_attribute20 in varchar2 default hr_api.g_varchar2
347: ,p_balance_category_id in number default hr_api.g_number
340: ,p_attribute14 in varchar2 default hr_api.g_varchar2
341: ,p_attribute15 in varchar2 default hr_api.g_varchar2
342: ,p_attribute16 in varchar2 default hr_api.g_varchar2
343: ,p_attribute17 in varchar2 default hr_api.g_varchar2
344: ,p_attribute18 in varchar2 default hr_api.g_varchar2
345: ,p_attribute19 in varchar2 default hr_api.g_varchar2
346: ,p_attribute20 in varchar2 default hr_api.g_varchar2
347: ,p_balance_category_id in number default hr_api.g_number
348: ,p_base_balance_type_id in number default hr_api.g_number
341: ,p_attribute15 in varchar2 default hr_api.g_varchar2
342: ,p_attribute16 in varchar2 default hr_api.g_varchar2
343: ,p_attribute17 in varchar2 default hr_api.g_varchar2
344: ,p_attribute18 in varchar2 default hr_api.g_varchar2
345: ,p_attribute19 in varchar2 default hr_api.g_varchar2
346: ,p_attribute20 in varchar2 default hr_api.g_varchar2
347: ,p_balance_category_id in number default hr_api.g_number
348: ,p_base_balance_type_id in number default hr_api.g_number
349: ,p_input_value_id in number default hr_api.g_number
342: ,p_attribute16 in varchar2 default hr_api.g_varchar2
343: ,p_attribute17 in varchar2 default hr_api.g_varchar2
344: ,p_attribute18 in varchar2 default hr_api.g_varchar2
345: ,p_attribute19 in varchar2 default hr_api.g_varchar2
346: ,p_attribute20 in varchar2 default hr_api.g_varchar2
347: ,p_balance_category_id in number default hr_api.g_number
348: ,p_base_balance_type_id in number default hr_api.g_number
349: ,p_input_value_id in number default hr_api.g_number
350: ,p_balance_name_warning out nocopy number
343: ,p_attribute17 in varchar2 default hr_api.g_varchar2
344: ,p_attribute18 in varchar2 default hr_api.g_varchar2
345: ,p_attribute19 in varchar2 default hr_api.g_varchar2
346: ,p_attribute20 in varchar2 default hr_api.g_varchar2
347: ,p_balance_category_id in number default hr_api.g_number
348: ,p_base_balance_type_id in number default hr_api.g_number
349: ,p_input_value_id in number default hr_api.g_number
350: ,p_balance_name_warning out nocopy number
351: ) is
344: ,p_attribute18 in varchar2 default hr_api.g_varchar2
345: ,p_attribute19 in varchar2 default hr_api.g_varchar2
346: ,p_attribute20 in varchar2 default hr_api.g_varchar2
347: ,p_balance_category_id in number default hr_api.g_number
348: ,p_base_balance_type_id in number default hr_api.g_number
349: ,p_input_value_id in number default hr_api.g_number
350: ,p_balance_name_warning out nocopy number
351: ) is
352: --
345: ,p_attribute19 in varchar2 default hr_api.g_varchar2
346: ,p_attribute20 in varchar2 default hr_api.g_varchar2
347: ,p_balance_category_id in number default hr_api.g_number
348: ,p_base_balance_type_id in number default hr_api.g_number
349: ,p_input_value_id in number default hr_api.g_number
350: ,p_balance_name_warning out nocopy number
351: ) is
352: --
353: -- Declare cursors and local variables
426: ,p_base_balance_type_id => p_base_balance_type_id
427: ,p_input_value_id => p_input_value_id
428: );
429: exception
430: when hr_api.cannot_find_prog_unit then
431: hr_api.cannot_find_prog_unit_error
432: (p_module_name => 'UPDATE_BAL_TYPE'
433: ,p_hook_type => 'BP'
434: );
427: ,p_input_value_id => p_input_value_id
428: );
429: exception
430: when hr_api.cannot_find_prog_unit then
431: hr_api.cannot_find_prog_unit_error
432: (p_module_name => 'UPDATE_BAL_TYPE'
433: ,p_hook_type => 'BP'
434: );
435: end;
571: ,p_input_value_id => p_input_value_id
572: ,p_balance_name_warning => l_balance_name_warning
573: );
574: exception
575: when hr_api.cannot_find_prog_unit then
576: hr_api.cannot_find_prog_unit_error
577: (p_module_name => 'UPDATE_BAL_TYPE'
578: ,p_hook_type => 'AP'
579: );
572: ,p_balance_name_warning => l_balance_name_warning
573: );
574: exception
575: when hr_api.cannot_find_prog_unit then
576: hr_api.cannot_find_prog_unit_error
577: (p_module_name => 'UPDATE_BAL_TYPE'
578: ,p_hook_type => 'AP'
579: );
580: end;
581: --
582: -- When in validation only mode raise the Validate_Enabled exception
583: --
584: if p_validate then
585: raise hr_api.validate_enabled;
586: end if;
587: --
588: -- Set all IN OUT and OUT parameters with out values
589: --
592:
593: --
594: hr_utility.set_location(' Leaving:'||l_proc, 80);
595: exception
596: when hr_api.validate_enabled then
597: --
598: -- As the Validate_Enabled exception has been raised
599: -- we must rollback to the savepoint
600: --
659: (p_balance_type_id => p_balance_type_id
660: ,p_object_version_number => l_object_version_number
661: );
662: exception
663: when hr_api.cannot_find_prog_unit then
664: hr_api.cannot_find_prog_unit_error
665: (p_module_name => 'DELETE_BAL_TYPE'
666: ,p_hook_type => 'BP'
667: );
660: ,p_object_version_number => l_object_version_number
661: );
662: exception
663: when hr_api.cannot_find_prog_unit then
664: hr_api.cannot_find_prog_unit_error
665: (p_module_name => 'DELETE_BAL_TYPE'
666: ,p_hook_type => 'BP'
667: );
668: end;
701: (p_balance_type_id => p_balance_type_id
702: ,p_object_version_number => l_object_version_number
703: );
704: exception
705: when hr_api.cannot_find_prog_unit then
706: hr_api.cannot_find_prog_unit_error
707: (p_module_name => 'DELETE_BAL_TYPE'
708: ,p_hook_type => 'AP'
709: );
702: ,p_object_version_number => l_object_version_number
703: );
704: exception
705: when hr_api.cannot_find_prog_unit then
706: hr_api.cannot_find_prog_unit_error
707: (p_module_name => 'DELETE_BAL_TYPE'
708: ,p_hook_type => 'AP'
709: );
710: end;
711: --
712: -- When in validation only mode raise the Validate_Enabled exception
713: --
714: if p_validate then
715: raise hr_api.validate_enabled;
716: end if;
717: --
718: -- Set all IN OUT and OUT parameters with out values
719: --
720: p_object_version_number := l_object_version_number;
721: --
722: hr_utility.set_location(' Leaving:'||l_proc, 70);
723: exception
724: when hr_api.validate_enabled then
725: --
726: -- As the Validate_Enabled exception has been raised
727: -- we must rollback to the savepoint
728: --