8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_balance_category >-----------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_balance_category
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_category_name in varchar2
15: ,p_business_group_id in number default null
16: ,p_legislation_code in varchar2 default null
77: --
78: -- Convert constant values to their corresponding boolean value
79: --
80: l_validate :=
81: hr_api.constant_to_boolean
82: (p_constant_value => p_validate);
83: --
84: -- Register Surrogate ID or user key values
85: --
188: -- ----------------------------------------------------------------------------
189: -- |------------------------< update_balance_category >-----------------------|
190: -- ----------------------------------------------------------------------------
191: PROCEDURE update_balance_category
192: (p_validate in number default hr_api.g_false_num
193: ,p_effective_date in date
194: ,p_datetrack_update_mode in varchar2
195: ,p_balance_category_id in number
196: ,p_object_version_number in out nocopy number
193: ,p_effective_date in date
194: ,p_datetrack_update_mode in varchar2
195: ,p_balance_category_id in number
196: ,p_object_version_number in out nocopy number
197: ,p_business_group_id in number default hr_api.g_number
198: ,p_legislation_code in varchar2 default hr_api.g_varchar2
199: ,p_save_run_balance_enabled in varchar2 default hr_api.g_varchar2
200: ,p_user_category_name in varchar2 default hr_api.g_varchar2
201: ,p_pbc_information_category in varchar2 default hr_api.g_varchar2
194: ,p_datetrack_update_mode in varchar2
195: ,p_balance_category_id in number
196: ,p_object_version_number in out nocopy number
197: ,p_business_group_id in number default hr_api.g_number
198: ,p_legislation_code in varchar2 default hr_api.g_varchar2
199: ,p_save_run_balance_enabled in varchar2 default hr_api.g_varchar2
200: ,p_user_category_name in varchar2 default hr_api.g_varchar2
201: ,p_pbc_information_category in varchar2 default hr_api.g_varchar2
202: ,p_pbc_information1 in varchar2 default hr_api.g_varchar2
195: ,p_balance_category_id in number
196: ,p_object_version_number in out nocopy number
197: ,p_business_group_id in number default hr_api.g_number
198: ,p_legislation_code in varchar2 default hr_api.g_varchar2
199: ,p_save_run_balance_enabled in varchar2 default hr_api.g_varchar2
200: ,p_user_category_name in varchar2 default hr_api.g_varchar2
201: ,p_pbc_information_category in varchar2 default hr_api.g_varchar2
202: ,p_pbc_information1 in varchar2 default hr_api.g_varchar2
203: ,p_pbc_information2 in varchar2 default hr_api.g_varchar2
196: ,p_object_version_number in out nocopy number
197: ,p_business_group_id in number default hr_api.g_number
198: ,p_legislation_code in varchar2 default hr_api.g_varchar2
199: ,p_save_run_balance_enabled in varchar2 default hr_api.g_varchar2
200: ,p_user_category_name in varchar2 default hr_api.g_varchar2
201: ,p_pbc_information_category in varchar2 default hr_api.g_varchar2
202: ,p_pbc_information1 in varchar2 default hr_api.g_varchar2
203: ,p_pbc_information2 in varchar2 default hr_api.g_varchar2
204: ,p_pbc_information3 in varchar2 default hr_api.g_varchar2
197: ,p_business_group_id in number default hr_api.g_number
198: ,p_legislation_code in varchar2 default hr_api.g_varchar2
199: ,p_save_run_balance_enabled in varchar2 default hr_api.g_varchar2
200: ,p_user_category_name in varchar2 default hr_api.g_varchar2
201: ,p_pbc_information_category in varchar2 default hr_api.g_varchar2
202: ,p_pbc_information1 in varchar2 default hr_api.g_varchar2
203: ,p_pbc_information2 in varchar2 default hr_api.g_varchar2
204: ,p_pbc_information3 in varchar2 default hr_api.g_varchar2
205: ,p_pbc_information4 in varchar2 default hr_api.g_varchar2
198: ,p_legislation_code in varchar2 default hr_api.g_varchar2
199: ,p_save_run_balance_enabled in varchar2 default hr_api.g_varchar2
200: ,p_user_category_name in varchar2 default hr_api.g_varchar2
201: ,p_pbc_information_category in varchar2 default hr_api.g_varchar2
202: ,p_pbc_information1 in varchar2 default hr_api.g_varchar2
203: ,p_pbc_information2 in varchar2 default hr_api.g_varchar2
204: ,p_pbc_information3 in varchar2 default hr_api.g_varchar2
205: ,p_pbc_information4 in varchar2 default hr_api.g_varchar2
206: ,p_pbc_information5 in varchar2 default hr_api.g_varchar2
199: ,p_save_run_balance_enabled in varchar2 default hr_api.g_varchar2
200: ,p_user_category_name in varchar2 default hr_api.g_varchar2
201: ,p_pbc_information_category in varchar2 default hr_api.g_varchar2
202: ,p_pbc_information1 in varchar2 default hr_api.g_varchar2
203: ,p_pbc_information2 in varchar2 default hr_api.g_varchar2
204: ,p_pbc_information3 in varchar2 default hr_api.g_varchar2
205: ,p_pbc_information4 in varchar2 default hr_api.g_varchar2
206: ,p_pbc_information5 in varchar2 default hr_api.g_varchar2
207: ,p_pbc_information6 in varchar2 default hr_api.g_varchar2
200: ,p_user_category_name in varchar2 default hr_api.g_varchar2
201: ,p_pbc_information_category in varchar2 default hr_api.g_varchar2
202: ,p_pbc_information1 in varchar2 default hr_api.g_varchar2
203: ,p_pbc_information2 in varchar2 default hr_api.g_varchar2
204: ,p_pbc_information3 in varchar2 default hr_api.g_varchar2
205: ,p_pbc_information4 in varchar2 default hr_api.g_varchar2
206: ,p_pbc_information5 in varchar2 default hr_api.g_varchar2
207: ,p_pbc_information6 in varchar2 default hr_api.g_varchar2
208: ,p_pbc_information7 in varchar2 default hr_api.g_varchar2
201: ,p_pbc_information_category in varchar2 default hr_api.g_varchar2
202: ,p_pbc_information1 in varchar2 default hr_api.g_varchar2
203: ,p_pbc_information2 in varchar2 default hr_api.g_varchar2
204: ,p_pbc_information3 in varchar2 default hr_api.g_varchar2
205: ,p_pbc_information4 in varchar2 default hr_api.g_varchar2
206: ,p_pbc_information5 in varchar2 default hr_api.g_varchar2
207: ,p_pbc_information6 in varchar2 default hr_api.g_varchar2
208: ,p_pbc_information7 in varchar2 default hr_api.g_varchar2
209: ,p_pbc_information8 in varchar2 default hr_api.g_varchar2
202: ,p_pbc_information1 in varchar2 default hr_api.g_varchar2
203: ,p_pbc_information2 in varchar2 default hr_api.g_varchar2
204: ,p_pbc_information3 in varchar2 default hr_api.g_varchar2
205: ,p_pbc_information4 in varchar2 default hr_api.g_varchar2
206: ,p_pbc_information5 in varchar2 default hr_api.g_varchar2
207: ,p_pbc_information6 in varchar2 default hr_api.g_varchar2
208: ,p_pbc_information7 in varchar2 default hr_api.g_varchar2
209: ,p_pbc_information8 in varchar2 default hr_api.g_varchar2
210: ,p_pbc_information9 in varchar2 default hr_api.g_varchar2
203: ,p_pbc_information2 in varchar2 default hr_api.g_varchar2
204: ,p_pbc_information3 in varchar2 default hr_api.g_varchar2
205: ,p_pbc_information4 in varchar2 default hr_api.g_varchar2
206: ,p_pbc_information5 in varchar2 default hr_api.g_varchar2
207: ,p_pbc_information6 in varchar2 default hr_api.g_varchar2
208: ,p_pbc_information7 in varchar2 default hr_api.g_varchar2
209: ,p_pbc_information8 in varchar2 default hr_api.g_varchar2
210: ,p_pbc_information9 in varchar2 default hr_api.g_varchar2
211: ,p_pbc_information10 in varchar2 default hr_api.g_varchar2
204: ,p_pbc_information3 in varchar2 default hr_api.g_varchar2
205: ,p_pbc_information4 in varchar2 default hr_api.g_varchar2
206: ,p_pbc_information5 in varchar2 default hr_api.g_varchar2
207: ,p_pbc_information6 in varchar2 default hr_api.g_varchar2
208: ,p_pbc_information7 in varchar2 default hr_api.g_varchar2
209: ,p_pbc_information8 in varchar2 default hr_api.g_varchar2
210: ,p_pbc_information9 in varchar2 default hr_api.g_varchar2
211: ,p_pbc_information10 in varchar2 default hr_api.g_varchar2
212: ,p_pbc_information11 in varchar2 default hr_api.g_varchar2
205: ,p_pbc_information4 in varchar2 default hr_api.g_varchar2
206: ,p_pbc_information5 in varchar2 default hr_api.g_varchar2
207: ,p_pbc_information6 in varchar2 default hr_api.g_varchar2
208: ,p_pbc_information7 in varchar2 default hr_api.g_varchar2
209: ,p_pbc_information8 in varchar2 default hr_api.g_varchar2
210: ,p_pbc_information9 in varchar2 default hr_api.g_varchar2
211: ,p_pbc_information10 in varchar2 default hr_api.g_varchar2
212: ,p_pbc_information11 in varchar2 default hr_api.g_varchar2
213: ,p_pbc_information12 in varchar2 default hr_api.g_varchar2
206: ,p_pbc_information5 in varchar2 default hr_api.g_varchar2
207: ,p_pbc_information6 in varchar2 default hr_api.g_varchar2
208: ,p_pbc_information7 in varchar2 default hr_api.g_varchar2
209: ,p_pbc_information8 in varchar2 default hr_api.g_varchar2
210: ,p_pbc_information9 in varchar2 default hr_api.g_varchar2
211: ,p_pbc_information10 in varchar2 default hr_api.g_varchar2
212: ,p_pbc_information11 in varchar2 default hr_api.g_varchar2
213: ,p_pbc_information12 in varchar2 default hr_api.g_varchar2
214: ,p_pbc_information13 in varchar2 default hr_api.g_varchar2
207: ,p_pbc_information6 in varchar2 default hr_api.g_varchar2
208: ,p_pbc_information7 in varchar2 default hr_api.g_varchar2
209: ,p_pbc_information8 in varchar2 default hr_api.g_varchar2
210: ,p_pbc_information9 in varchar2 default hr_api.g_varchar2
211: ,p_pbc_information10 in varchar2 default hr_api.g_varchar2
212: ,p_pbc_information11 in varchar2 default hr_api.g_varchar2
213: ,p_pbc_information12 in varchar2 default hr_api.g_varchar2
214: ,p_pbc_information13 in varchar2 default hr_api.g_varchar2
215: ,p_pbc_information14 in varchar2 default hr_api.g_varchar2
208: ,p_pbc_information7 in varchar2 default hr_api.g_varchar2
209: ,p_pbc_information8 in varchar2 default hr_api.g_varchar2
210: ,p_pbc_information9 in varchar2 default hr_api.g_varchar2
211: ,p_pbc_information10 in varchar2 default hr_api.g_varchar2
212: ,p_pbc_information11 in varchar2 default hr_api.g_varchar2
213: ,p_pbc_information12 in varchar2 default hr_api.g_varchar2
214: ,p_pbc_information13 in varchar2 default hr_api.g_varchar2
215: ,p_pbc_information14 in varchar2 default hr_api.g_varchar2
216: ,p_pbc_information15 in varchar2 default hr_api.g_varchar2
209: ,p_pbc_information8 in varchar2 default hr_api.g_varchar2
210: ,p_pbc_information9 in varchar2 default hr_api.g_varchar2
211: ,p_pbc_information10 in varchar2 default hr_api.g_varchar2
212: ,p_pbc_information11 in varchar2 default hr_api.g_varchar2
213: ,p_pbc_information12 in varchar2 default hr_api.g_varchar2
214: ,p_pbc_information13 in varchar2 default hr_api.g_varchar2
215: ,p_pbc_information14 in varchar2 default hr_api.g_varchar2
216: ,p_pbc_information15 in varchar2 default hr_api.g_varchar2
217: ,p_pbc_information16 in varchar2 default hr_api.g_varchar2
210: ,p_pbc_information9 in varchar2 default hr_api.g_varchar2
211: ,p_pbc_information10 in varchar2 default hr_api.g_varchar2
212: ,p_pbc_information11 in varchar2 default hr_api.g_varchar2
213: ,p_pbc_information12 in varchar2 default hr_api.g_varchar2
214: ,p_pbc_information13 in varchar2 default hr_api.g_varchar2
215: ,p_pbc_information14 in varchar2 default hr_api.g_varchar2
216: ,p_pbc_information15 in varchar2 default hr_api.g_varchar2
217: ,p_pbc_information16 in varchar2 default hr_api.g_varchar2
218: ,p_pbc_information17 in varchar2 default hr_api.g_varchar2
211: ,p_pbc_information10 in varchar2 default hr_api.g_varchar2
212: ,p_pbc_information11 in varchar2 default hr_api.g_varchar2
213: ,p_pbc_information12 in varchar2 default hr_api.g_varchar2
214: ,p_pbc_information13 in varchar2 default hr_api.g_varchar2
215: ,p_pbc_information14 in varchar2 default hr_api.g_varchar2
216: ,p_pbc_information15 in varchar2 default hr_api.g_varchar2
217: ,p_pbc_information16 in varchar2 default hr_api.g_varchar2
218: ,p_pbc_information17 in varchar2 default hr_api.g_varchar2
219: ,p_pbc_information18 in varchar2 default hr_api.g_varchar2
212: ,p_pbc_information11 in varchar2 default hr_api.g_varchar2
213: ,p_pbc_information12 in varchar2 default hr_api.g_varchar2
214: ,p_pbc_information13 in varchar2 default hr_api.g_varchar2
215: ,p_pbc_information14 in varchar2 default hr_api.g_varchar2
216: ,p_pbc_information15 in varchar2 default hr_api.g_varchar2
217: ,p_pbc_information16 in varchar2 default hr_api.g_varchar2
218: ,p_pbc_information17 in varchar2 default hr_api.g_varchar2
219: ,p_pbc_information18 in varchar2 default hr_api.g_varchar2
220: ,p_pbc_information19 in varchar2 default hr_api.g_varchar2
213: ,p_pbc_information12 in varchar2 default hr_api.g_varchar2
214: ,p_pbc_information13 in varchar2 default hr_api.g_varchar2
215: ,p_pbc_information14 in varchar2 default hr_api.g_varchar2
216: ,p_pbc_information15 in varchar2 default hr_api.g_varchar2
217: ,p_pbc_information16 in varchar2 default hr_api.g_varchar2
218: ,p_pbc_information17 in varchar2 default hr_api.g_varchar2
219: ,p_pbc_information18 in varchar2 default hr_api.g_varchar2
220: ,p_pbc_information19 in varchar2 default hr_api.g_varchar2
221: ,p_pbc_information20 in varchar2 default hr_api.g_varchar2
214: ,p_pbc_information13 in varchar2 default hr_api.g_varchar2
215: ,p_pbc_information14 in varchar2 default hr_api.g_varchar2
216: ,p_pbc_information15 in varchar2 default hr_api.g_varchar2
217: ,p_pbc_information16 in varchar2 default hr_api.g_varchar2
218: ,p_pbc_information17 in varchar2 default hr_api.g_varchar2
219: ,p_pbc_information18 in varchar2 default hr_api.g_varchar2
220: ,p_pbc_information19 in varchar2 default hr_api.g_varchar2
221: ,p_pbc_information20 in varchar2 default hr_api.g_varchar2
222: ,p_pbc_information21 in varchar2 default hr_api.g_varchar2
215: ,p_pbc_information14 in varchar2 default hr_api.g_varchar2
216: ,p_pbc_information15 in varchar2 default hr_api.g_varchar2
217: ,p_pbc_information16 in varchar2 default hr_api.g_varchar2
218: ,p_pbc_information17 in varchar2 default hr_api.g_varchar2
219: ,p_pbc_information18 in varchar2 default hr_api.g_varchar2
220: ,p_pbc_information19 in varchar2 default hr_api.g_varchar2
221: ,p_pbc_information20 in varchar2 default hr_api.g_varchar2
222: ,p_pbc_information21 in varchar2 default hr_api.g_varchar2
223: ,p_pbc_information22 in varchar2 default hr_api.g_varchar2
216: ,p_pbc_information15 in varchar2 default hr_api.g_varchar2
217: ,p_pbc_information16 in varchar2 default hr_api.g_varchar2
218: ,p_pbc_information17 in varchar2 default hr_api.g_varchar2
219: ,p_pbc_information18 in varchar2 default hr_api.g_varchar2
220: ,p_pbc_information19 in varchar2 default hr_api.g_varchar2
221: ,p_pbc_information20 in varchar2 default hr_api.g_varchar2
222: ,p_pbc_information21 in varchar2 default hr_api.g_varchar2
223: ,p_pbc_information22 in varchar2 default hr_api.g_varchar2
224: ,p_pbc_information23 in varchar2 default hr_api.g_varchar2
217: ,p_pbc_information16 in varchar2 default hr_api.g_varchar2
218: ,p_pbc_information17 in varchar2 default hr_api.g_varchar2
219: ,p_pbc_information18 in varchar2 default hr_api.g_varchar2
220: ,p_pbc_information19 in varchar2 default hr_api.g_varchar2
221: ,p_pbc_information20 in varchar2 default hr_api.g_varchar2
222: ,p_pbc_information21 in varchar2 default hr_api.g_varchar2
223: ,p_pbc_information22 in varchar2 default hr_api.g_varchar2
224: ,p_pbc_information23 in varchar2 default hr_api.g_varchar2
225: ,p_pbc_information24 in varchar2 default hr_api.g_varchar2
218: ,p_pbc_information17 in varchar2 default hr_api.g_varchar2
219: ,p_pbc_information18 in varchar2 default hr_api.g_varchar2
220: ,p_pbc_information19 in varchar2 default hr_api.g_varchar2
221: ,p_pbc_information20 in varchar2 default hr_api.g_varchar2
222: ,p_pbc_information21 in varchar2 default hr_api.g_varchar2
223: ,p_pbc_information22 in varchar2 default hr_api.g_varchar2
224: ,p_pbc_information23 in varchar2 default hr_api.g_varchar2
225: ,p_pbc_information24 in varchar2 default hr_api.g_varchar2
226: ,p_pbc_information25 in varchar2 default hr_api.g_varchar2
219: ,p_pbc_information18 in varchar2 default hr_api.g_varchar2
220: ,p_pbc_information19 in varchar2 default hr_api.g_varchar2
221: ,p_pbc_information20 in varchar2 default hr_api.g_varchar2
222: ,p_pbc_information21 in varchar2 default hr_api.g_varchar2
223: ,p_pbc_information22 in varchar2 default hr_api.g_varchar2
224: ,p_pbc_information23 in varchar2 default hr_api.g_varchar2
225: ,p_pbc_information24 in varchar2 default hr_api.g_varchar2
226: ,p_pbc_information25 in varchar2 default hr_api.g_varchar2
227: ,p_pbc_information26 in varchar2 default hr_api.g_varchar2
220: ,p_pbc_information19 in varchar2 default hr_api.g_varchar2
221: ,p_pbc_information20 in varchar2 default hr_api.g_varchar2
222: ,p_pbc_information21 in varchar2 default hr_api.g_varchar2
223: ,p_pbc_information22 in varchar2 default hr_api.g_varchar2
224: ,p_pbc_information23 in varchar2 default hr_api.g_varchar2
225: ,p_pbc_information24 in varchar2 default hr_api.g_varchar2
226: ,p_pbc_information25 in varchar2 default hr_api.g_varchar2
227: ,p_pbc_information26 in varchar2 default hr_api.g_varchar2
228: ,p_pbc_information27 in varchar2 default hr_api.g_varchar2
221: ,p_pbc_information20 in varchar2 default hr_api.g_varchar2
222: ,p_pbc_information21 in varchar2 default hr_api.g_varchar2
223: ,p_pbc_information22 in varchar2 default hr_api.g_varchar2
224: ,p_pbc_information23 in varchar2 default hr_api.g_varchar2
225: ,p_pbc_information24 in varchar2 default hr_api.g_varchar2
226: ,p_pbc_information25 in varchar2 default hr_api.g_varchar2
227: ,p_pbc_information26 in varchar2 default hr_api.g_varchar2
228: ,p_pbc_information27 in varchar2 default hr_api.g_varchar2
229: ,p_pbc_information28 in varchar2 default hr_api.g_varchar2
222: ,p_pbc_information21 in varchar2 default hr_api.g_varchar2
223: ,p_pbc_information22 in varchar2 default hr_api.g_varchar2
224: ,p_pbc_information23 in varchar2 default hr_api.g_varchar2
225: ,p_pbc_information24 in varchar2 default hr_api.g_varchar2
226: ,p_pbc_information25 in varchar2 default hr_api.g_varchar2
227: ,p_pbc_information26 in varchar2 default hr_api.g_varchar2
228: ,p_pbc_information27 in varchar2 default hr_api.g_varchar2
229: ,p_pbc_information28 in varchar2 default hr_api.g_varchar2
230: ,p_pbc_information29 in varchar2 default hr_api.g_varchar2
223: ,p_pbc_information22 in varchar2 default hr_api.g_varchar2
224: ,p_pbc_information23 in varchar2 default hr_api.g_varchar2
225: ,p_pbc_information24 in varchar2 default hr_api.g_varchar2
226: ,p_pbc_information25 in varchar2 default hr_api.g_varchar2
227: ,p_pbc_information26 in varchar2 default hr_api.g_varchar2
228: ,p_pbc_information27 in varchar2 default hr_api.g_varchar2
229: ,p_pbc_information28 in varchar2 default hr_api.g_varchar2
230: ,p_pbc_information29 in varchar2 default hr_api.g_varchar2
231: ,p_pbc_information30 in varchar2 default hr_api.g_varchar2
224: ,p_pbc_information23 in varchar2 default hr_api.g_varchar2
225: ,p_pbc_information24 in varchar2 default hr_api.g_varchar2
226: ,p_pbc_information25 in varchar2 default hr_api.g_varchar2
227: ,p_pbc_information26 in varchar2 default hr_api.g_varchar2
228: ,p_pbc_information27 in varchar2 default hr_api.g_varchar2
229: ,p_pbc_information28 in varchar2 default hr_api.g_varchar2
230: ,p_pbc_information29 in varchar2 default hr_api.g_varchar2
231: ,p_pbc_information30 in varchar2 default hr_api.g_varchar2
232: ,p_effective_start_date out nocopy date
225: ,p_pbc_information24 in varchar2 default hr_api.g_varchar2
226: ,p_pbc_information25 in varchar2 default hr_api.g_varchar2
227: ,p_pbc_information26 in varchar2 default hr_api.g_varchar2
228: ,p_pbc_information27 in varchar2 default hr_api.g_varchar2
229: ,p_pbc_information28 in varchar2 default hr_api.g_varchar2
230: ,p_pbc_information29 in varchar2 default hr_api.g_varchar2
231: ,p_pbc_information30 in varchar2 default hr_api.g_varchar2
232: ,p_effective_start_date out nocopy date
233: ,p_effective_end_date out nocopy date
226: ,p_pbc_information25 in varchar2 default hr_api.g_varchar2
227: ,p_pbc_information26 in varchar2 default hr_api.g_varchar2
228: ,p_pbc_information27 in varchar2 default hr_api.g_varchar2
229: ,p_pbc_information28 in varchar2 default hr_api.g_varchar2
230: ,p_pbc_information29 in varchar2 default hr_api.g_varchar2
231: ,p_pbc_information30 in varchar2 default hr_api.g_varchar2
232: ,p_effective_start_date out nocopy date
233: ,p_effective_end_date out nocopy date
234: ,p_return_status out nocopy varchar2
227: ,p_pbc_information26 in varchar2 default hr_api.g_varchar2
228: ,p_pbc_information27 in varchar2 default hr_api.g_varchar2
229: ,p_pbc_information28 in varchar2 default hr_api.g_varchar2
230: ,p_pbc_information29 in varchar2 default hr_api.g_varchar2
231: ,p_pbc_information30 in varchar2 default hr_api.g_varchar2
232: ,p_effective_start_date out nocopy date
233: ,p_effective_end_date out nocopy date
234: ,p_return_status out nocopy varchar2
235: ) is
259: --
260: -- Convert constant values to their corresponding boolean value
261: --
262: l_validate :=
263: hr_api.constant_to_boolean
264: (p_constant_value => p_validate);
265: --
266: -- Register Surrogate ID or user key values
267: --
368: -- ----------------------------------------------------------------------------
369: -- |------------------------< delete_balance_category >-----------------------|
370: -- ----------------------------------------------------------------------------
371: PROCEDURE delete_balance_category
372: (p_validate in number default hr_api.g_false_num
373: ,p_effective_date in date
374: ,p_datetrack_delete_mode in varchar2
375: ,p_balance_category_id in number
376: ,p_object_version_number in out nocopy number
373: ,p_effective_date in date
374: ,p_datetrack_delete_mode in varchar2
375: ,p_balance_category_id in number
376: ,p_object_version_number in out nocopy number
377: ,p_business_group_id in number default hr_api.g_number
378: ,p_legislation_code in varchar2 default hr_api.g_varchar2
379: ,p_effective_start_date out nocopy date
380: ,p_effective_end_date out nocopy date
381: ,p_return_status out nocopy varchar2
374: ,p_datetrack_delete_mode in varchar2
375: ,p_balance_category_id in number
376: ,p_object_version_number in out nocopy number
377: ,p_business_group_id in number default hr_api.g_number
378: ,p_legislation_code in varchar2 default hr_api.g_varchar2
379: ,p_effective_start_date out nocopy date
380: ,p_effective_end_date out nocopy date
381: ,p_return_status out nocopy varchar2
382: ) is
406: --
407: -- Convert constant values to their corresponding boolean value
408: --
409: l_validate :=
410: hr_api.constant_to_boolean
411: (p_constant_value => p_validate);
412: --
413: -- Register Surrogate ID or user key values
414: --