DBA Data[Home] [Help]

APPS.PAY_BALANCE_TYPES_API dependencies on HR_API

Line 41: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function

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.

Line 102: ,p_language_code in varchar2 Default hr_api.userenv_lang

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

Line 172: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function

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,

Line 228: ,p_language_code in varchar2 Default hr_api.userenv_lang

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

Line 231: ,p_balance_name 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

Line 232: ,p_balance_uom 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

Line 233: ,p_currency_code 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

Line 234: ,p_assignment_remuneration_flag 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

Line 235: ,p_comments 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

Line 236: ,p_reporting_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
240: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 237: ,p_attribute_category 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

Line 238: ,p_attribute1 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

Line 239: ,p_attribute2 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

Line 240: ,p_attribute3 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

Line 241: ,p_attribute4 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

Line 242: ,p_attribute5 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

Line 243: ,p_attribute6 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

Line 244: ,p_attribute7 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

Line 245: ,p_attribute8 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

Line 246: ,p_attribute9 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

Line 247: ,p_attribute10 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

Line 248: ,p_attribute11 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

Line 249: ,p_attribute12 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

Line 250: ,p_attribute13 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

Line 251: ,p_attribute14 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

Line 252: ,p_attribute15 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

Line 253: ,p_attribute16 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

Line 254: ,p_attribute17 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

Line 255: ,p_attribute18 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
259: ,p_base_balance_type_id in number default hr_api.g_number

Line 256: ,p_attribute19 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
260: ,p_input_value_id in number default hr_api.g_number

Line 257: ,p_attribute20 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
261: ,p_balance_name_warning out nocopy number

Line 258: ,p_balance_category_id in number default hr_api.g_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: );

Line 259: ,p_base_balance_type_id in number default hr_api.g_number

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: --

Line 260: ,p_input_value_id in number default hr_api.g_number

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: -- ----------------------------------------------------------------------------