120: ,p_pbc_information29 => p_pbc_information29
121: ,p_pbc_information30 => p_pbc_information30
122: );
123: exception
124: when hr_api.cannot_find_prog_unit then
125: hr_api.cannot_find_prog_unit_error
126: (p_module_name => 'create_balance_category'
127: ,p_hook_type => 'BP'
128: );
121: ,p_pbc_information30 => p_pbc_information30
122: );
123: exception
124: when hr_api.cannot_find_prog_unit then
125: hr_api.cannot_find_prog_unit_error
126: (p_module_name => 'create_balance_category'
127: ,p_hook_type => 'BP'
128: );
129: end;
227: ,p_effective_end_date => l_effective_end_date
228: ,p_object_version_number => l_object_version_number
229: );
230: exception
231: when hr_api.cannot_find_prog_unit then
232: hr_api.cannot_find_prog_unit_error
233: (p_module_name => 'create_balance_category_a'
234: ,p_hook_type => 'AP'
235: );
228: ,p_object_version_number => l_object_version_number
229: );
230: exception
231: when hr_api.cannot_find_prog_unit then
232: hr_api.cannot_find_prog_unit_error
233: (p_module_name => 'create_balance_category_a'
234: ,p_hook_type => 'AP'
235: );
236: end;
238: --
239: -- When in validation only mode raise the Validate_Enabled exception
240: --
241: if p_validate then
242: raise hr_api.validate_enabled;
243: end if;
244: --
245: -- Set all output arguments
246: --
255: --------------------------------------------------------------------------------
256: g_dml_status := FALSE;
257: hr_utility.set_location(' Leaving:'||l_proc, 70);
258: exception
259: when hr_api.validate_enabled then
260: --
261: -- As the Validate_Enabled exception has been raised
262: -- we must rollback to the savepoint
263: --
290: ,p_effective_date in date
291: ,p_datetrack_update_mode in varchar2
292: ,p_balance_category_id in number
293: ,p_object_version_number in out nocopy number
294: ,p_business_group_id in number default hr_api.g_number
295: ,p_legislation_code in varchar2 default hr_api.g_varchar2
296: ,p_save_run_balance_enabled in varchar2 default hr_api.g_varchar2
297: ,p_user_category_name in varchar2 default hr_api.g_varchar2
298: ,p_pbc_information_category in varchar2 default hr_api.g_varchar2
291: ,p_datetrack_update_mode in varchar2
292: ,p_balance_category_id in number
293: ,p_object_version_number in out nocopy number
294: ,p_business_group_id in number default hr_api.g_number
295: ,p_legislation_code in varchar2 default hr_api.g_varchar2
296: ,p_save_run_balance_enabled in varchar2 default hr_api.g_varchar2
297: ,p_user_category_name in varchar2 default hr_api.g_varchar2
298: ,p_pbc_information_category in varchar2 default hr_api.g_varchar2
299: ,p_pbc_information1 in varchar2 default hr_api.g_varchar2
292: ,p_balance_category_id in number
293: ,p_object_version_number in out nocopy number
294: ,p_business_group_id in number default hr_api.g_number
295: ,p_legislation_code in varchar2 default hr_api.g_varchar2
296: ,p_save_run_balance_enabled in varchar2 default hr_api.g_varchar2
297: ,p_user_category_name in varchar2 default hr_api.g_varchar2
298: ,p_pbc_information_category in varchar2 default hr_api.g_varchar2
299: ,p_pbc_information1 in varchar2 default hr_api.g_varchar2
300: ,p_pbc_information2 in varchar2 default hr_api.g_varchar2
293: ,p_object_version_number in out nocopy number
294: ,p_business_group_id in number default hr_api.g_number
295: ,p_legislation_code in varchar2 default hr_api.g_varchar2
296: ,p_save_run_balance_enabled in varchar2 default hr_api.g_varchar2
297: ,p_user_category_name in varchar2 default hr_api.g_varchar2
298: ,p_pbc_information_category in varchar2 default hr_api.g_varchar2
299: ,p_pbc_information1 in varchar2 default hr_api.g_varchar2
300: ,p_pbc_information2 in varchar2 default hr_api.g_varchar2
301: ,p_pbc_information3 in varchar2 default hr_api.g_varchar2
294: ,p_business_group_id in number default hr_api.g_number
295: ,p_legislation_code in varchar2 default hr_api.g_varchar2
296: ,p_save_run_balance_enabled in varchar2 default hr_api.g_varchar2
297: ,p_user_category_name in varchar2 default hr_api.g_varchar2
298: ,p_pbc_information_category in varchar2 default hr_api.g_varchar2
299: ,p_pbc_information1 in varchar2 default hr_api.g_varchar2
300: ,p_pbc_information2 in varchar2 default hr_api.g_varchar2
301: ,p_pbc_information3 in varchar2 default hr_api.g_varchar2
302: ,p_pbc_information4 in varchar2 default hr_api.g_varchar2
295: ,p_legislation_code in varchar2 default hr_api.g_varchar2
296: ,p_save_run_balance_enabled in varchar2 default hr_api.g_varchar2
297: ,p_user_category_name in varchar2 default hr_api.g_varchar2
298: ,p_pbc_information_category in varchar2 default hr_api.g_varchar2
299: ,p_pbc_information1 in varchar2 default hr_api.g_varchar2
300: ,p_pbc_information2 in varchar2 default hr_api.g_varchar2
301: ,p_pbc_information3 in varchar2 default hr_api.g_varchar2
302: ,p_pbc_information4 in varchar2 default hr_api.g_varchar2
303: ,p_pbc_information5 in varchar2 default hr_api.g_varchar2
296: ,p_save_run_balance_enabled in varchar2 default hr_api.g_varchar2
297: ,p_user_category_name in varchar2 default hr_api.g_varchar2
298: ,p_pbc_information_category in varchar2 default hr_api.g_varchar2
299: ,p_pbc_information1 in varchar2 default hr_api.g_varchar2
300: ,p_pbc_information2 in varchar2 default hr_api.g_varchar2
301: ,p_pbc_information3 in varchar2 default hr_api.g_varchar2
302: ,p_pbc_information4 in varchar2 default hr_api.g_varchar2
303: ,p_pbc_information5 in varchar2 default hr_api.g_varchar2
304: ,p_pbc_information6 in varchar2 default hr_api.g_varchar2
297: ,p_user_category_name in varchar2 default hr_api.g_varchar2
298: ,p_pbc_information_category in varchar2 default hr_api.g_varchar2
299: ,p_pbc_information1 in varchar2 default hr_api.g_varchar2
300: ,p_pbc_information2 in varchar2 default hr_api.g_varchar2
301: ,p_pbc_information3 in varchar2 default hr_api.g_varchar2
302: ,p_pbc_information4 in varchar2 default hr_api.g_varchar2
303: ,p_pbc_information5 in varchar2 default hr_api.g_varchar2
304: ,p_pbc_information6 in varchar2 default hr_api.g_varchar2
305: ,p_pbc_information7 in varchar2 default hr_api.g_varchar2
298: ,p_pbc_information_category in varchar2 default hr_api.g_varchar2
299: ,p_pbc_information1 in varchar2 default hr_api.g_varchar2
300: ,p_pbc_information2 in varchar2 default hr_api.g_varchar2
301: ,p_pbc_information3 in varchar2 default hr_api.g_varchar2
302: ,p_pbc_information4 in varchar2 default hr_api.g_varchar2
303: ,p_pbc_information5 in varchar2 default hr_api.g_varchar2
304: ,p_pbc_information6 in varchar2 default hr_api.g_varchar2
305: ,p_pbc_information7 in varchar2 default hr_api.g_varchar2
306: ,p_pbc_information8 in varchar2 default hr_api.g_varchar2
299: ,p_pbc_information1 in varchar2 default hr_api.g_varchar2
300: ,p_pbc_information2 in varchar2 default hr_api.g_varchar2
301: ,p_pbc_information3 in varchar2 default hr_api.g_varchar2
302: ,p_pbc_information4 in varchar2 default hr_api.g_varchar2
303: ,p_pbc_information5 in varchar2 default hr_api.g_varchar2
304: ,p_pbc_information6 in varchar2 default hr_api.g_varchar2
305: ,p_pbc_information7 in varchar2 default hr_api.g_varchar2
306: ,p_pbc_information8 in varchar2 default hr_api.g_varchar2
307: ,p_pbc_information9 in varchar2 default hr_api.g_varchar2
300: ,p_pbc_information2 in varchar2 default hr_api.g_varchar2
301: ,p_pbc_information3 in varchar2 default hr_api.g_varchar2
302: ,p_pbc_information4 in varchar2 default hr_api.g_varchar2
303: ,p_pbc_information5 in varchar2 default hr_api.g_varchar2
304: ,p_pbc_information6 in varchar2 default hr_api.g_varchar2
305: ,p_pbc_information7 in varchar2 default hr_api.g_varchar2
306: ,p_pbc_information8 in varchar2 default hr_api.g_varchar2
307: ,p_pbc_information9 in varchar2 default hr_api.g_varchar2
308: ,p_pbc_information10 in varchar2 default hr_api.g_varchar2
301: ,p_pbc_information3 in varchar2 default hr_api.g_varchar2
302: ,p_pbc_information4 in varchar2 default hr_api.g_varchar2
303: ,p_pbc_information5 in varchar2 default hr_api.g_varchar2
304: ,p_pbc_information6 in varchar2 default hr_api.g_varchar2
305: ,p_pbc_information7 in varchar2 default hr_api.g_varchar2
306: ,p_pbc_information8 in varchar2 default hr_api.g_varchar2
307: ,p_pbc_information9 in varchar2 default hr_api.g_varchar2
308: ,p_pbc_information10 in varchar2 default hr_api.g_varchar2
309: ,p_pbc_information11 in varchar2 default hr_api.g_varchar2
302: ,p_pbc_information4 in varchar2 default hr_api.g_varchar2
303: ,p_pbc_information5 in varchar2 default hr_api.g_varchar2
304: ,p_pbc_information6 in varchar2 default hr_api.g_varchar2
305: ,p_pbc_information7 in varchar2 default hr_api.g_varchar2
306: ,p_pbc_information8 in varchar2 default hr_api.g_varchar2
307: ,p_pbc_information9 in varchar2 default hr_api.g_varchar2
308: ,p_pbc_information10 in varchar2 default hr_api.g_varchar2
309: ,p_pbc_information11 in varchar2 default hr_api.g_varchar2
310: ,p_pbc_information12 in varchar2 default hr_api.g_varchar2
303: ,p_pbc_information5 in varchar2 default hr_api.g_varchar2
304: ,p_pbc_information6 in varchar2 default hr_api.g_varchar2
305: ,p_pbc_information7 in varchar2 default hr_api.g_varchar2
306: ,p_pbc_information8 in varchar2 default hr_api.g_varchar2
307: ,p_pbc_information9 in varchar2 default hr_api.g_varchar2
308: ,p_pbc_information10 in varchar2 default hr_api.g_varchar2
309: ,p_pbc_information11 in varchar2 default hr_api.g_varchar2
310: ,p_pbc_information12 in varchar2 default hr_api.g_varchar2
311: ,p_pbc_information13 in varchar2 default hr_api.g_varchar2
304: ,p_pbc_information6 in varchar2 default hr_api.g_varchar2
305: ,p_pbc_information7 in varchar2 default hr_api.g_varchar2
306: ,p_pbc_information8 in varchar2 default hr_api.g_varchar2
307: ,p_pbc_information9 in varchar2 default hr_api.g_varchar2
308: ,p_pbc_information10 in varchar2 default hr_api.g_varchar2
309: ,p_pbc_information11 in varchar2 default hr_api.g_varchar2
310: ,p_pbc_information12 in varchar2 default hr_api.g_varchar2
311: ,p_pbc_information13 in varchar2 default hr_api.g_varchar2
312: ,p_pbc_information14 in varchar2 default hr_api.g_varchar2
305: ,p_pbc_information7 in varchar2 default hr_api.g_varchar2
306: ,p_pbc_information8 in varchar2 default hr_api.g_varchar2
307: ,p_pbc_information9 in varchar2 default hr_api.g_varchar2
308: ,p_pbc_information10 in varchar2 default hr_api.g_varchar2
309: ,p_pbc_information11 in varchar2 default hr_api.g_varchar2
310: ,p_pbc_information12 in varchar2 default hr_api.g_varchar2
311: ,p_pbc_information13 in varchar2 default hr_api.g_varchar2
312: ,p_pbc_information14 in varchar2 default hr_api.g_varchar2
313: ,p_pbc_information15 in varchar2 default hr_api.g_varchar2
306: ,p_pbc_information8 in varchar2 default hr_api.g_varchar2
307: ,p_pbc_information9 in varchar2 default hr_api.g_varchar2
308: ,p_pbc_information10 in varchar2 default hr_api.g_varchar2
309: ,p_pbc_information11 in varchar2 default hr_api.g_varchar2
310: ,p_pbc_information12 in varchar2 default hr_api.g_varchar2
311: ,p_pbc_information13 in varchar2 default hr_api.g_varchar2
312: ,p_pbc_information14 in varchar2 default hr_api.g_varchar2
313: ,p_pbc_information15 in varchar2 default hr_api.g_varchar2
314: ,p_pbc_information16 in varchar2 default hr_api.g_varchar2
307: ,p_pbc_information9 in varchar2 default hr_api.g_varchar2
308: ,p_pbc_information10 in varchar2 default hr_api.g_varchar2
309: ,p_pbc_information11 in varchar2 default hr_api.g_varchar2
310: ,p_pbc_information12 in varchar2 default hr_api.g_varchar2
311: ,p_pbc_information13 in varchar2 default hr_api.g_varchar2
312: ,p_pbc_information14 in varchar2 default hr_api.g_varchar2
313: ,p_pbc_information15 in varchar2 default hr_api.g_varchar2
314: ,p_pbc_information16 in varchar2 default hr_api.g_varchar2
315: ,p_pbc_information17 in varchar2 default hr_api.g_varchar2
308: ,p_pbc_information10 in varchar2 default hr_api.g_varchar2
309: ,p_pbc_information11 in varchar2 default hr_api.g_varchar2
310: ,p_pbc_information12 in varchar2 default hr_api.g_varchar2
311: ,p_pbc_information13 in varchar2 default hr_api.g_varchar2
312: ,p_pbc_information14 in varchar2 default hr_api.g_varchar2
313: ,p_pbc_information15 in varchar2 default hr_api.g_varchar2
314: ,p_pbc_information16 in varchar2 default hr_api.g_varchar2
315: ,p_pbc_information17 in varchar2 default hr_api.g_varchar2
316: ,p_pbc_information18 in varchar2 default hr_api.g_varchar2
309: ,p_pbc_information11 in varchar2 default hr_api.g_varchar2
310: ,p_pbc_information12 in varchar2 default hr_api.g_varchar2
311: ,p_pbc_information13 in varchar2 default hr_api.g_varchar2
312: ,p_pbc_information14 in varchar2 default hr_api.g_varchar2
313: ,p_pbc_information15 in varchar2 default hr_api.g_varchar2
314: ,p_pbc_information16 in varchar2 default hr_api.g_varchar2
315: ,p_pbc_information17 in varchar2 default hr_api.g_varchar2
316: ,p_pbc_information18 in varchar2 default hr_api.g_varchar2
317: ,p_pbc_information19 in varchar2 default hr_api.g_varchar2
310: ,p_pbc_information12 in varchar2 default hr_api.g_varchar2
311: ,p_pbc_information13 in varchar2 default hr_api.g_varchar2
312: ,p_pbc_information14 in varchar2 default hr_api.g_varchar2
313: ,p_pbc_information15 in varchar2 default hr_api.g_varchar2
314: ,p_pbc_information16 in varchar2 default hr_api.g_varchar2
315: ,p_pbc_information17 in varchar2 default hr_api.g_varchar2
316: ,p_pbc_information18 in varchar2 default hr_api.g_varchar2
317: ,p_pbc_information19 in varchar2 default hr_api.g_varchar2
318: ,p_pbc_information20 in varchar2 default hr_api.g_varchar2
311: ,p_pbc_information13 in varchar2 default hr_api.g_varchar2
312: ,p_pbc_information14 in varchar2 default hr_api.g_varchar2
313: ,p_pbc_information15 in varchar2 default hr_api.g_varchar2
314: ,p_pbc_information16 in varchar2 default hr_api.g_varchar2
315: ,p_pbc_information17 in varchar2 default hr_api.g_varchar2
316: ,p_pbc_information18 in varchar2 default hr_api.g_varchar2
317: ,p_pbc_information19 in varchar2 default hr_api.g_varchar2
318: ,p_pbc_information20 in varchar2 default hr_api.g_varchar2
319: ,p_pbc_information21 in varchar2 default hr_api.g_varchar2
312: ,p_pbc_information14 in varchar2 default hr_api.g_varchar2
313: ,p_pbc_information15 in varchar2 default hr_api.g_varchar2
314: ,p_pbc_information16 in varchar2 default hr_api.g_varchar2
315: ,p_pbc_information17 in varchar2 default hr_api.g_varchar2
316: ,p_pbc_information18 in varchar2 default hr_api.g_varchar2
317: ,p_pbc_information19 in varchar2 default hr_api.g_varchar2
318: ,p_pbc_information20 in varchar2 default hr_api.g_varchar2
319: ,p_pbc_information21 in varchar2 default hr_api.g_varchar2
320: ,p_pbc_information22 in varchar2 default hr_api.g_varchar2
313: ,p_pbc_information15 in varchar2 default hr_api.g_varchar2
314: ,p_pbc_information16 in varchar2 default hr_api.g_varchar2
315: ,p_pbc_information17 in varchar2 default hr_api.g_varchar2
316: ,p_pbc_information18 in varchar2 default hr_api.g_varchar2
317: ,p_pbc_information19 in varchar2 default hr_api.g_varchar2
318: ,p_pbc_information20 in varchar2 default hr_api.g_varchar2
319: ,p_pbc_information21 in varchar2 default hr_api.g_varchar2
320: ,p_pbc_information22 in varchar2 default hr_api.g_varchar2
321: ,p_pbc_information23 in varchar2 default hr_api.g_varchar2
314: ,p_pbc_information16 in varchar2 default hr_api.g_varchar2
315: ,p_pbc_information17 in varchar2 default hr_api.g_varchar2
316: ,p_pbc_information18 in varchar2 default hr_api.g_varchar2
317: ,p_pbc_information19 in varchar2 default hr_api.g_varchar2
318: ,p_pbc_information20 in varchar2 default hr_api.g_varchar2
319: ,p_pbc_information21 in varchar2 default hr_api.g_varchar2
320: ,p_pbc_information22 in varchar2 default hr_api.g_varchar2
321: ,p_pbc_information23 in varchar2 default hr_api.g_varchar2
322: ,p_pbc_information24 in varchar2 default hr_api.g_varchar2
315: ,p_pbc_information17 in varchar2 default hr_api.g_varchar2
316: ,p_pbc_information18 in varchar2 default hr_api.g_varchar2
317: ,p_pbc_information19 in varchar2 default hr_api.g_varchar2
318: ,p_pbc_information20 in varchar2 default hr_api.g_varchar2
319: ,p_pbc_information21 in varchar2 default hr_api.g_varchar2
320: ,p_pbc_information22 in varchar2 default hr_api.g_varchar2
321: ,p_pbc_information23 in varchar2 default hr_api.g_varchar2
322: ,p_pbc_information24 in varchar2 default hr_api.g_varchar2
323: ,p_pbc_information25 in varchar2 default hr_api.g_varchar2
316: ,p_pbc_information18 in varchar2 default hr_api.g_varchar2
317: ,p_pbc_information19 in varchar2 default hr_api.g_varchar2
318: ,p_pbc_information20 in varchar2 default hr_api.g_varchar2
319: ,p_pbc_information21 in varchar2 default hr_api.g_varchar2
320: ,p_pbc_information22 in varchar2 default hr_api.g_varchar2
321: ,p_pbc_information23 in varchar2 default hr_api.g_varchar2
322: ,p_pbc_information24 in varchar2 default hr_api.g_varchar2
323: ,p_pbc_information25 in varchar2 default hr_api.g_varchar2
324: ,p_pbc_information26 in varchar2 default hr_api.g_varchar2
317: ,p_pbc_information19 in varchar2 default hr_api.g_varchar2
318: ,p_pbc_information20 in varchar2 default hr_api.g_varchar2
319: ,p_pbc_information21 in varchar2 default hr_api.g_varchar2
320: ,p_pbc_information22 in varchar2 default hr_api.g_varchar2
321: ,p_pbc_information23 in varchar2 default hr_api.g_varchar2
322: ,p_pbc_information24 in varchar2 default hr_api.g_varchar2
323: ,p_pbc_information25 in varchar2 default hr_api.g_varchar2
324: ,p_pbc_information26 in varchar2 default hr_api.g_varchar2
325: ,p_pbc_information27 in varchar2 default hr_api.g_varchar2
318: ,p_pbc_information20 in varchar2 default hr_api.g_varchar2
319: ,p_pbc_information21 in varchar2 default hr_api.g_varchar2
320: ,p_pbc_information22 in varchar2 default hr_api.g_varchar2
321: ,p_pbc_information23 in varchar2 default hr_api.g_varchar2
322: ,p_pbc_information24 in varchar2 default hr_api.g_varchar2
323: ,p_pbc_information25 in varchar2 default hr_api.g_varchar2
324: ,p_pbc_information26 in varchar2 default hr_api.g_varchar2
325: ,p_pbc_information27 in varchar2 default hr_api.g_varchar2
326: ,p_pbc_information28 in varchar2 default hr_api.g_varchar2
319: ,p_pbc_information21 in varchar2 default hr_api.g_varchar2
320: ,p_pbc_information22 in varchar2 default hr_api.g_varchar2
321: ,p_pbc_information23 in varchar2 default hr_api.g_varchar2
322: ,p_pbc_information24 in varchar2 default hr_api.g_varchar2
323: ,p_pbc_information25 in varchar2 default hr_api.g_varchar2
324: ,p_pbc_information26 in varchar2 default hr_api.g_varchar2
325: ,p_pbc_information27 in varchar2 default hr_api.g_varchar2
326: ,p_pbc_information28 in varchar2 default hr_api.g_varchar2
327: ,p_pbc_information29 in varchar2 default hr_api.g_varchar2
320: ,p_pbc_information22 in varchar2 default hr_api.g_varchar2
321: ,p_pbc_information23 in varchar2 default hr_api.g_varchar2
322: ,p_pbc_information24 in varchar2 default hr_api.g_varchar2
323: ,p_pbc_information25 in varchar2 default hr_api.g_varchar2
324: ,p_pbc_information26 in varchar2 default hr_api.g_varchar2
325: ,p_pbc_information27 in varchar2 default hr_api.g_varchar2
326: ,p_pbc_information28 in varchar2 default hr_api.g_varchar2
327: ,p_pbc_information29 in varchar2 default hr_api.g_varchar2
328: ,p_pbc_information30 in varchar2 default hr_api.g_varchar2
321: ,p_pbc_information23 in varchar2 default hr_api.g_varchar2
322: ,p_pbc_information24 in varchar2 default hr_api.g_varchar2
323: ,p_pbc_information25 in varchar2 default hr_api.g_varchar2
324: ,p_pbc_information26 in varchar2 default hr_api.g_varchar2
325: ,p_pbc_information27 in varchar2 default hr_api.g_varchar2
326: ,p_pbc_information28 in varchar2 default hr_api.g_varchar2
327: ,p_pbc_information29 in varchar2 default hr_api.g_varchar2
328: ,p_pbc_information30 in varchar2 default hr_api.g_varchar2
329: ,p_effective_start_date out nocopy date
322: ,p_pbc_information24 in varchar2 default hr_api.g_varchar2
323: ,p_pbc_information25 in varchar2 default hr_api.g_varchar2
324: ,p_pbc_information26 in varchar2 default hr_api.g_varchar2
325: ,p_pbc_information27 in varchar2 default hr_api.g_varchar2
326: ,p_pbc_information28 in varchar2 default hr_api.g_varchar2
327: ,p_pbc_information29 in varchar2 default hr_api.g_varchar2
328: ,p_pbc_information30 in varchar2 default hr_api.g_varchar2
329: ,p_effective_start_date out nocopy date
330: ,p_effective_end_date out nocopy date
323: ,p_pbc_information25 in varchar2 default hr_api.g_varchar2
324: ,p_pbc_information26 in varchar2 default hr_api.g_varchar2
325: ,p_pbc_information27 in varchar2 default hr_api.g_varchar2
326: ,p_pbc_information28 in varchar2 default hr_api.g_varchar2
327: ,p_pbc_information29 in varchar2 default hr_api.g_varchar2
328: ,p_pbc_information30 in varchar2 default hr_api.g_varchar2
329: ,p_effective_start_date out nocopy date
330: ,p_effective_end_date out nocopy date
331: ) is
324: ,p_pbc_information26 in varchar2 default hr_api.g_varchar2
325: ,p_pbc_information27 in varchar2 default hr_api.g_varchar2
326: ,p_pbc_information28 in varchar2 default hr_api.g_varchar2
327: ,p_pbc_information29 in varchar2 default hr_api.g_varchar2
328: ,p_pbc_information30 in varchar2 default hr_api.g_varchar2
329: ,p_effective_start_date out nocopy date
330: ,p_effective_end_date out nocopy date
331: ) is
332: --
399: ,p_pbc_information29 => p_pbc_information29
400: ,p_pbc_information30 => p_pbc_information30
401: );
402: exception
403: when hr_api.cannot_find_prog_unit then
404: hr_api.cannot_find_prog_unit_error
405: (p_module_name => 'update_balance_category'
406: ,p_hook_type => 'BP'
407: );
400: ,p_pbc_information30 => p_pbc_information30
401: );
402: exception
403: when hr_api.cannot_find_prog_unit then
404: hr_api.cannot_find_prog_unit_error
405: (p_module_name => 'update_balance_category'
406: ,p_hook_type => 'BP'
407: );
408: end;
504: ,p_effective_start_date => l_effective_start_date
505: ,p_effective_end_date => l_effective_end_date
506: );
507: exception
508: when hr_api.cannot_find_prog_unit then
509: hr_api.cannot_find_prog_unit_error
510: (p_module_name => 'update_balance_category'
511: ,p_hook_type => 'AP'
512: );
505: ,p_effective_end_date => l_effective_end_date
506: );
507: exception
508: when hr_api.cannot_find_prog_unit then
509: hr_api.cannot_find_prog_unit_error
510: (p_module_name => 'update_balance_category'
511: ,p_hook_type => 'AP'
512: );
513: 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: --
531: --------------------------------------------------------------------------------
532: g_dml_status := FALSE;
533: hr_utility.set_location(' Leaving:'||l_proc, 70);
534: exception
535: when hr_api.validate_enabled then
536: --
537: -- As the Validate_Enabled exception has been raised
538: -- we must rollback to the savepoint
539: --
566: ,p_effective_date in date
567: ,p_datetrack_delete_mode in varchar2
568: ,p_balance_category_id in number
569: ,p_object_version_number in out nocopy number
570: ,p_business_group_id in number default hr_api.g_number
571: ,p_legislation_code in varchar2 default hr_api.g_varchar2
572: ,p_effective_start_date out nocopy date
573: ,p_effective_end_date out nocopy date
574: ) is
567: ,p_datetrack_delete_mode in varchar2
568: ,p_balance_category_id in number
569: ,p_object_version_number in out nocopy number
570: ,p_business_group_id in number default hr_api.g_number
571: ,p_legislation_code in varchar2 default hr_api.g_varchar2
572: ,p_effective_start_date out nocopy date
573: ,p_effective_end_date out nocopy date
574: ) is
575: --
608: ,p_business_group_id => p_business_group_id
609: ,p_legislation_code => p_legislation_code
610: );
611: exception
612: when hr_api.cannot_find_prog_unit then
613: hr_api.cannot_find_prog_unit_error
614: (p_module_name => 'delete_balance_category'
615: ,p_hook_type => 'BP'
616: );
609: ,p_legislation_code => p_legislation_code
610: );
611: exception
612: when hr_api.cannot_find_prog_unit then
613: hr_api.cannot_find_prog_unit_error
614: (p_module_name => 'delete_balance_category'
615: ,p_hook_type => 'BP'
616: );
617: end;
660: ,p_effective_start_date => l_effective_start_date
661: ,p_effective_end_date => l_effective_end_date
662: );
663: exception
664: when hr_api.cannot_find_prog_unit then
665: hr_api.cannot_find_prog_unit_error
666: (p_module_name => 'delete_balance_category'
667: ,p_hook_type => 'AP'
668: );
661: ,p_effective_end_date => l_effective_end_date
662: );
663: exception
664: when hr_api.cannot_find_prog_unit then
665: hr_api.cannot_find_prog_unit_error
666: (p_module_name => 'delete_balance_category'
667: ,p_hook_type => 'AP'
668: );
669: end;
671: --
672: -- When in validation only mode raise the Validate_Enabled exception
673: --
674: if p_validate then
675: raise hr_api.validate_enabled;
676: end if;
677: --
678: -- Set all output arguments
679: --
682: p_effective_end_date := l_effective_end_date;
683: --
684: hr_utility.set_location(' Leaving:'||l_proc, 70);
685: exception
686: when hr_api.validate_enabled then
687: --
688: -- As the Validate_Enabled exception has been raised
689: -- we must rollback to the savepoint
690: --