37: * applicable during the start to end active date range. This date does not
38: * determine when the changes take effect.
39: * @param p_language_code Specifies to which language the translation values
40: * apply. You can set to the base or any installed language. The default value
41: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
42: * value.
43: * @param p_balance_name Name of the Balance.
44: * @param p_balance_uom Unit of Measure of the Balance. Valid values are
45: * defined by the 'UNITS' lookup type.
98: --
99: procedure create_bal_type
100: (p_validate in boolean default false
101: ,p_effective_date in date
102: ,p_language_code in varchar2 Default hr_api.userenv_lang
103: ,p_balance_name in varchar2
104: ,p_balance_uom in varchar2
105: ,p_business_group_id in number
106: ,p_legislation_code in varchar2 default null
168: * applicable during the start to end active date range. This date does not
169: * determine when the changes take effect.
170: * @param p_language_code Specifies to which language the translation values
171: * apply. You can set to the base or any installed language. The default value
172: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
173: * value.
174: * @param p_balance_type_id primary key.
175: * @param p_object_version_number Pass in the current version number of the
176: * balance type to be updated. When the API completes if p_validate is false,
224: --
225: procedure update_bal_type
226: (p_validate in boolean default false
227: ,p_effective_date in date
228: ,p_language_code in varchar2 Default hr_api.userenv_lang
229: ,p_balance_type_id in number
230: ,p_object_version_number in out nocopy number
231: ,p_balance_name in varchar2 default hr_api.g_varchar2
232: ,p_balance_uom in varchar2 default hr_api.g_varchar2
227: ,p_effective_date in date
228: ,p_language_code in varchar2 Default hr_api.userenv_lang
229: ,p_balance_type_id in number
230: ,p_object_version_number in out nocopy number
231: ,p_balance_name in varchar2 default hr_api.g_varchar2
232: ,p_balance_uom in varchar2 default hr_api.g_varchar2
233: ,p_currency_code in varchar2 default hr_api.g_varchar2
234: ,p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2
235: ,p_comments in varchar2 default hr_api.g_varchar2
228: ,p_language_code in varchar2 Default hr_api.userenv_lang
229: ,p_balance_type_id in number
230: ,p_object_version_number in out nocopy number
231: ,p_balance_name in varchar2 default hr_api.g_varchar2
232: ,p_balance_uom in varchar2 default hr_api.g_varchar2
233: ,p_currency_code in varchar2 default hr_api.g_varchar2
234: ,p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2
235: ,p_comments in varchar2 default hr_api.g_varchar2
236: ,p_reporting_name in varchar2 default hr_api.g_varchar2
229: ,p_balance_type_id in number
230: ,p_object_version_number in out nocopy number
231: ,p_balance_name in varchar2 default hr_api.g_varchar2
232: ,p_balance_uom in varchar2 default hr_api.g_varchar2
233: ,p_currency_code in varchar2 default hr_api.g_varchar2
234: ,p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2
235: ,p_comments in varchar2 default hr_api.g_varchar2
236: ,p_reporting_name in varchar2 default hr_api.g_varchar2
237: ,p_attribute_category in varchar2 default hr_api.g_varchar2
230: ,p_object_version_number in out nocopy number
231: ,p_balance_name in varchar2 default hr_api.g_varchar2
232: ,p_balance_uom in varchar2 default hr_api.g_varchar2
233: ,p_currency_code in varchar2 default hr_api.g_varchar2
234: ,p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2
235: ,p_comments in varchar2 default hr_api.g_varchar2
236: ,p_reporting_name in varchar2 default hr_api.g_varchar2
237: ,p_attribute_category in varchar2 default hr_api.g_varchar2
238: ,p_attribute1 in varchar2 default hr_api.g_varchar2
231: ,p_balance_name in varchar2 default hr_api.g_varchar2
232: ,p_balance_uom in varchar2 default hr_api.g_varchar2
233: ,p_currency_code in varchar2 default hr_api.g_varchar2
234: ,p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2
235: ,p_comments in varchar2 default hr_api.g_varchar2
236: ,p_reporting_name in varchar2 default hr_api.g_varchar2
237: ,p_attribute_category in varchar2 default hr_api.g_varchar2
238: ,p_attribute1 in varchar2 default hr_api.g_varchar2
239: ,p_attribute2 in varchar2 default hr_api.g_varchar2
232: ,p_balance_uom in varchar2 default hr_api.g_varchar2
233: ,p_currency_code in varchar2 default hr_api.g_varchar2
234: ,p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2
235: ,p_comments in varchar2 default hr_api.g_varchar2
236: ,p_reporting_name in varchar2 default hr_api.g_varchar2
237: ,p_attribute_category in varchar2 default hr_api.g_varchar2
238: ,p_attribute1 in varchar2 default hr_api.g_varchar2
239: ,p_attribute2 in varchar2 default hr_api.g_varchar2
240: ,p_attribute3 in varchar2 default hr_api.g_varchar2
233: ,p_currency_code in varchar2 default hr_api.g_varchar2
234: ,p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2
235: ,p_comments in varchar2 default hr_api.g_varchar2
236: ,p_reporting_name in varchar2 default hr_api.g_varchar2
237: ,p_attribute_category in varchar2 default hr_api.g_varchar2
238: ,p_attribute1 in varchar2 default hr_api.g_varchar2
239: ,p_attribute2 in varchar2 default hr_api.g_varchar2
240: ,p_attribute3 in varchar2 default hr_api.g_varchar2
241: ,p_attribute4 in varchar2 default hr_api.g_varchar2
234: ,p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2
235: ,p_comments in varchar2 default hr_api.g_varchar2
236: ,p_reporting_name in varchar2 default hr_api.g_varchar2
237: ,p_attribute_category in varchar2 default hr_api.g_varchar2
238: ,p_attribute1 in varchar2 default hr_api.g_varchar2
239: ,p_attribute2 in varchar2 default hr_api.g_varchar2
240: ,p_attribute3 in varchar2 default hr_api.g_varchar2
241: ,p_attribute4 in varchar2 default hr_api.g_varchar2
242: ,p_attribute5 in varchar2 default hr_api.g_varchar2
235: ,p_comments in varchar2 default hr_api.g_varchar2
236: ,p_reporting_name in varchar2 default hr_api.g_varchar2
237: ,p_attribute_category in varchar2 default hr_api.g_varchar2
238: ,p_attribute1 in varchar2 default hr_api.g_varchar2
239: ,p_attribute2 in varchar2 default hr_api.g_varchar2
240: ,p_attribute3 in varchar2 default hr_api.g_varchar2
241: ,p_attribute4 in varchar2 default hr_api.g_varchar2
242: ,p_attribute5 in varchar2 default hr_api.g_varchar2
243: ,p_attribute6 in varchar2 default hr_api.g_varchar2
236: ,p_reporting_name in varchar2 default hr_api.g_varchar2
237: ,p_attribute_category in varchar2 default hr_api.g_varchar2
238: ,p_attribute1 in varchar2 default hr_api.g_varchar2
239: ,p_attribute2 in varchar2 default hr_api.g_varchar2
240: ,p_attribute3 in varchar2 default hr_api.g_varchar2
241: ,p_attribute4 in varchar2 default hr_api.g_varchar2
242: ,p_attribute5 in varchar2 default hr_api.g_varchar2
243: ,p_attribute6 in varchar2 default hr_api.g_varchar2
244: ,p_attribute7 in varchar2 default hr_api.g_varchar2
237: ,p_attribute_category in varchar2 default hr_api.g_varchar2
238: ,p_attribute1 in varchar2 default hr_api.g_varchar2
239: ,p_attribute2 in varchar2 default hr_api.g_varchar2
240: ,p_attribute3 in varchar2 default hr_api.g_varchar2
241: ,p_attribute4 in varchar2 default hr_api.g_varchar2
242: ,p_attribute5 in varchar2 default hr_api.g_varchar2
243: ,p_attribute6 in varchar2 default hr_api.g_varchar2
244: ,p_attribute7 in varchar2 default hr_api.g_varchar2
245: ,p_attribute8 in varchar2 default hr_api.g_varchar2
238: ,p_attribute1 in varchar2 default hr_api.g_varchar2
239: ,p_attribute2 in varchar2 default hr_api.g_varchar2
240: ,p_attribute3 in varchar2 default hr_api.g_varchar2
241: ,p_attribute4 in varchar2 default hr_api.g_varchar2
242: ,p_attribute5 in varchar2 default hr_api.g_varchar2
243: ,p_attribute6 in varchar2 default hr_api.g_varchar2
244: ,p_attribute7 in varchar2 default hr_api.g_varchar2
245: ,p_attribute8 in varchar2 default hr_api.g_varchar2
246: ,p_attribute9 in varchar2 default hr_api.g_varchar2
239: ,p_attribute2 in varchar2 default hr_api.g_varchar2
240: ,p_attribute3 in varchar2 default hr_api.g_varchar2
241: ,p_attribute4 in varchar2 default hr_api.g_varchar2
242: ,p_attribute5 in varchar2 default hr_api.g_varchar2
243: ,p_attribute6 in varchar2 default hr_api.g_varchar2
244: ,p_attribute7 in varchar2 default hr_api.g_varchar2
245: ,p_attribute8 in varchar2 default hr_api.g_varchar2
246: ,p_attribute9 in varchar2 default hr_api.g_varchar2
247: ,p_attribute10 in varchar2 default hr_api.g_varchar2
240: ,p_attribute3 in varchar2 default hr_api.g_varchar2
241: ,p_attribute4 in varchar2 default hr_api.g_varchar2
242: ,p_attribute5 in varchar2 default hr_api.g_varchar2
243: ,p_attribute6 in varchar2 default hr_api.g_varchar2
244: ,p_attribute7 in varchar2 default hr_api.g_varchar2
245: ,p_attribute8 in varchar2 default hr_api.g_varchar2
246: ,p_attribute9 in varchar2 default hr_api.g_varchar2
247: ,p_attribute10 in varchar2 default hr_api.g_varchar2
248: ,p_attribute11 in varchar2 default hr_api.g_varchar2
241: ,p_attribute4 in varchar2 default hr_api.g_varchar2
242: ,p_attribute5 in varchar2 default hr_api.g_varchar2
243: ,p_attribute6 in varchar2 default hr_api.g_varchar2
244: ,p_attribute7 in varchar2 default hr_api.g_varchar2
245: ,p_attribute8 in varchar2 default hr_api.g_varchar2
246: ,p_attribute9 in varchar2 default hr_api.g_varchar2
247: ,p_attribute10 in varchar2 default hr_api.g_varchar2
248: ,p_attribute11 in varchar2 default hr_api.g_varchar2
249: ,p_attribute12 in varchar2 default hr_api.g_varchar2
242: ,p_attribute5 in varchar2 default hr_api.g_varchar2
243: ,p_attribute6 in varchar2 default hr_api.g_varchar2
244: ,p_attribute7 in varchar2 default hr_api.g_varchar2
245: ,p_attribute8 in varchar2 default hr_api.g_varchar2
246: ,p_attribute9 in varchar2 default hr_api.g_varchar2
247: ,p_attribute10 in varchar2 default hr_api.g_varchar2
248: ,p_attribute11 in varchar2 default hr_api.g_varchar2
249: ,p_attribute12 in varchar2 default hr_api.g_varchar2
250: ,p_attribute13 in varchar2 default hr_api.g_varchar2
243: ,p_attribute6 in varchar2 default hr_api.g_varchar2
244: ,p_attribute7 in varchar2 default hr_api.g_varchar2
245: ,p_attribute8 in varchar2 default hr_api.g_varchar2
246: ,p_attribute9 in varchar2 default hr_api.g_varchar2
247: ,p_attribute10 in varchar2 default hr_api.g_varchar2
248: ,p_attribute11 in varchar2 default hr_api.g_varchar2
249: ,p_attribute12 in varchar2 default hr_api.g_varchar2
250: ,p_attribute13 in varchar2 default hr_api.g_varchar2
251: ,p_attribute14 in varchar2 default hr_api.g_varchar2
244: ,p_attribute7 in varchar2 default hr_api.g_varchar2
245: ,p_attribute8 in varchar2 default hr_api.g_varchar2
246: ,p_attribute9 in varchar2 default hr_api.g_varchar2
247: ,p_attribute10 in varchar2 default hr_api.g_varchar2
248: ,p_attribute11 in varchar2 default hr_api.g_varchar2
249: ,p_attribute12 in varchar2 default hr_api.g_varchar2
250: ,p_attribute13 in varchar2 default hr_api.g_varchar2
251: ,p_attribute14 in varchar2 default hr_api.g_varchar2
252: ,p_attribute15 in varchar2 default hr_api.g_varchar2
245: ,p_attribute8 in varchar2 default hr_api.g_varchar2
246: ,p_attribute9 in varchar2 default hr_api.g_varchar2
247: ,p_attribute10 in varchar2 default hr_api.g_varchar2
248: ,p_attribute11 in varchar2 default hr_api.g_varchar2
249: ,p_attribute12 in varchar2 default hr_api.g_varchar2
250: ,p_attribute13 in varchar2 default hr_api.g_varchar2
251: ,p_attribute14 in varchar2 default hr_api.g_varchar2
252: ,p_attribute15 in varchar2 default hr_api.g_varchar2
253: ,p_attribute16 in varchar2 default hr_api.g_varchar2
246: ,p_attribute9 in varchar2 default hr_api.g_varchar2
247: ,p_attribute10 in varchar2 default hr_api.g_varchar2
248: ,p_attribute11 in varchar2 default hr_api.g_varchar2
249: ,p_attribute12 in varchar2 default hr_api.g_varchar2
250: ,p_attribute13 in varchar2 default hr_api.g_varchar2
251: ,p_attribute14 in varchar2 default hr_api.g_varchar2
252: ,p_attribute15 in varchar2 default hr_api.g_varchar2
253: ,p_attribute16 in varchar2 default hr_api.g_varchar2
254: ,p_attribute17 in varchar2 default hr_api.g_varchar2
247: ,p_attribute10 in varchar2 default hr_api.g_varchar2
248: ,p_attribute11 in varchar2 default hr_api.g_varchar2
249: ,p_attribute12 in varchar2 default hr_api.g_varchar2
250: ,p_attribute13 in varchar2 default hr_api.g_varchar2
251: ,p_attribute14 in varchar2 default hr_api.g_varchar2
252: ,p_attribute15 in varchar2 default hr_api.g_varchar2
253: ,p_attribute16 in varchar2 default hr_api.g_varchar2
254: ,p_attribute17 in varchar2 default hr_api.g_varchar2
255: ,p_attribute18 in varchar2 default hr_api.g_varchar2
248: ,p_attribute11 in varchar2 default hr_api.g_varchar2
249: ,p_attribute12 in varchar2 default hr_api.g_varchar2
250: ,p_attribute13 in varchar2 default hr_api.g_varchar2
251: ,p_attribute14 in varchar2 default hr_api.g_varchar2
252: ,p_attribute15 in varchar2 default hr_api.g_varchar2
253: ,p_attribute16 in varchar2 default hr_api.g_varchar2
254: ,p_attribute17 in varchar2 default hr_api.g_varchar2
255: ,p_attribute18 in varchar2 default hr_api.g_varchar2
256: ,p_attribute19 in varchar2 default hr_api.g_varchar2
249: ,p_attribute12 in varchar2 default hr_api.g_varchar2
250: ,p_attribute13 in varchar2 default hr_api.g_varchar2
251: ,p_attribute14 in varchar2 default hr_api.g_varchar2
252: ,p_attribute15 in varchar2 default hr_api.g_varchar2
253: ,p_attribute16 in varchar2 default hr_api.g_varchar2
254: ,p_attribute17 in varchar2 default hr_api.g_varchar2
255: ,p_attribute18 in varchar2 default hr_api.g_varchar2
256: ,p_attribute19 in varchar2 default hr_api.g_varchar2
257: ,p_attribute20 in varchar2 default hr_api.g_varchar2
250: ,p_attribute13 in varchar2 default hr_api.g_varchar2
251: ,p_attribute14 in varchar2 default hr_api.g_varchar2
252: ,p_attribute15 in varchar2 default hr_api.g_varchar2
253: ,p_attribute16 in varchar2 default hr_api.g_varchar2
254: ,p_attribute17 in varchar2 default hr_api.g_varchar2
255: ,p_attribute18 in varchar2 default hr_api.g_varchar2
256: ,p_attribute19 in varchar2 default hr_api.g_varchar2
257: ,p_attribute20 in varchar2 default hr_api.g_varchar2
258: ,p_balance_category_id in number default hr_api.g_number
251: ,p_attribute14 in varchar2 default hr_api.g_varchar2
252: ,p_attribute15 in varchar2 default hr_api.g_varchar2
253: ,p_attribute16 in varchar2 default hr_api.g_varchar2
254: ,p_attribute17 in varchar2 default hr_api.g_varchar2
255: ,p_attribute18 in varchar2 default hr_api.g_varchar2
256: ,p_attribute19 in varchar2 default hr_api.g_varchar2
257: ,p_attribute20 in varchar2 default hr_api.g_varchar2
258: ,p_balance_category_id in number default hr_api.g_number
259: ,p_base_balance_type_id in number default hr_api.g_number
252: ,p_attribute15 in varchar2 default hr_api.g_varchar2
253: ,p_attribute16 in varchar2 default hr_api.g_varchar2
254: ,p_attribute17 in varchar2 default hr_api.g_varchar2
255: ,p_attribute18 in varchar2 default hr_api.g_varchar2
256: ,p_attribute19 in varchar2 default hr_api.g_varchar2
257: ,p_attribute20 in varchar2 default hr_api.g_varchar2
258: ,p_balance_category_id in number default hr_api.g_number
259: ,p_base_balance_type_id in number default hr_api.g_number
260: ,p_input_value_id in number default hr_api.g_number
253: ,p_attribute16 in varchar2 default hr_api.g_varchar2
254: ,p_attribute17 in varchar2 default hr_api.g_varchar2
255: ,p_attribute18 in varchar2 default hr_api.g_varchar2
256: ,p_attribute19 in varchar2 default hr_api.g_varchar2
257: ,p_attribute20 in varchar2 default hr_api.g_varchar2
258: ,p_balance_category_id in number default hr_api.g_number
259: ,p_base_balance_type_id in number default hr_api.g_number
260: ,p_input_value_id in number default hr_api.g_number
261: ,p_balance_name_warning out nocopy number
254: ,p_attribute17 in varchar2 default hr_api.g_varchar2
255: ,p_attribute18 in varchar2 default hr_api.g_varchar2
256: ,p_attribute19 in varchar2 default hr_api.g_varchar2
257: ,p_attribute20 in varchar2 default hr_api.g_varchar2
258: ,p_balance_category_id in number default hr_api.g_number
259: ,p_base_balance_type_id in number default hr_api.g_number
260: ,p_input_value_id in number default hr_api.g_number
261: ,p_balance_name_warning out nocopy number
262: );
255: ,p_attribute18 in varchar2 default hr_api.g_varchar2
256: ,p_attribute19 in varchar2 default hr_api.g_varchar2
257: ,p_attribute20 in varchar2 default hr_api.g_varchar2
258: ,p_balance_category_id in number default hr_api.g_number
259: ,p_base_balance_type_id in number default hr_api.g_number
260: ,p_input_value_id in number default hr_api.g_number
261: ,p_balance_name_warning out nocopy number
262: );
263: --
256: ,p_attribute19 in varchar2 default hr_api.g_varchar2
257: ,p_attribute20 in varchar2 default hr_api.g_varchar2
258: ,p_balance_category_id in number default hr_api.g_number
259: ,p_base_balance_type_id in number default hr_api.g_number
260: ,p_input_value_id in number default hr_api.g_number
261: ,p_balance_name_warning out nocopy number
262: );
263: --
264: -- ----------------------------------------------------------------------------