8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< create_salary_basis >-------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_salary_basis
12: (p_validate in number default hr_api.g_false_num
13: ,p_business_group_id in number
14: ,p_input_value_id in number
15: ,p_rate_id in number default null
16: ,p_name in varchar2
93: --
94: -- Convert constant values to their corresponding boolean value
95: --
96: l_validate :=
97: hr_api.constant_to_boolean
98: (p_constant_value => p_validate);
99: --
100: -- Register Surrogate ID or user key values
101: --
216: -- ----------------------------------------------------------------------------
217: -- |--------------------------< delete_salary_basis >-------------------------|
218: -- ----------------------------------------------------------------------------
219: PROCEDURE delete_salary_basis
220: (p_validate in number default hr_api.g_false_num
221: ,p_pay_basis_id in number
222: ,p_object_version_number in out nocopy number
223: ,p_return_status out nocopy varchar2
224: ) is
248: --
249: -- Convert constant values to their corresponding boolean value
250: --
251: l_validate :=
252: hr_api.constant_to_boolean
253: (p_constant_value => p_validate);
254: --
255: -- Register Surrogate ID or user key values
256: --
314: -- ----------------------------------------------------------------------------
315: -- |--------------------------< update_salary_basis >-------------------------|
316: -- ----------------------------------------------------------------------------
317: PROCEDURE update_salary_basis
318: (p_validate in number default hr_api.g_false_num
319: ,p_pay_basis_id in number
320: ,p_input_value_id in number default hr_api.g_number
321: ,p_rate_id in number default hr_api.g_number
322: ,p_name in varchar2 default hr_api.g_varchar2
316: -- ----------------------------------------------------------------------------
317: PROCEDURE update_salary_basis
318: (p_validate in number default hr_api.g_false_num
319: ,p_pay_basis_id in number
320: ,p_input_value_id in number default hr_api.g_number
321: ,p_rate_id in number default hr_api.g_number
322: ,p_name in varchar2 default hr_api.g_varchar2
323: ,p_pay_basis in varchar2 default hr_api.g_varchar2
324: ,p_rate_basis in varchar2 default hr_api.g_varchar2
317: PROCEDURE update_salary_basis
318: (p_validate in number default hr_api.g_false_num
319: ,p_pay_basis_id in number
320: ,p_input_value_id in number default hr_api.g_number
321: ,p_rate_id in number default hr_api.g_number
322: ,p_name in varchar2 default hr_api.g_varchar2
323: ,p_pay_basis in varchar2 default hr_api.g_varchar2
324: ,p_rate_basis in varchar2 default hr_api.g_varchar2
325: ,p_pay_annualization_factor in number default hr_api.g_number
318: (p_validate in number default hr_api.g_false_num
319: ,p_pay_basis_id in number
320: ,p_input_value_id in number default hr_api.g_number
321: ,p_rate_id in number default hr_api.g_number
322: ,p_name in varchar2 default hr_api.g_varchar2
323: ,p_pay_basis in varchar2 default hr_api.g_varchar2
324: ,p_rate_basis in varchar2 default hr_api.g_varchar2
325: ,p_pay_annualization_factor in number default hr_api.g_number
326: ,p_grade_annualization_factor in number default hr_api.g_number
319: ,p_pay_basis_id in number
320: ,p_input_value_id in number default hr_api.g_number
321: ,p_rate_id in number default hr_api.g_number
322: ,p_name in varchar2 default hr_api.g_varchar2
323: ,p_pay_basis in varchar2 default hr_api.g_varchar2
324: ,p_rate_basis in varchar2 default hr_api.g_varchar2
325: ,p_pay_annualization_factor in number default hr_api.g_number
326: ,p_grade_annualization_factor in number default hr_api.g_number
327: ,p_attribute_category in varchar2 default hr_api.g_varchar2
320: ,p_input_value_id in number default hr_api.g_number
321: ,p_rate_id in number default hr_api.g_number
322: ,p_name in varchar2 default hr_api.g_varchar2
323: ,p_pay_basis in varchar2 default hr_api.g_varchar2
324: ,p_rate_basis in varchar2 default hr_api.g_varchar2
325: ,p_pay_annualization_factor in number default hr_api.g_number
326: ,p_grade_annualization_factor in number default hr_api.g_number
327: ,p_attribute_category in varchar2 default hr_api.g_varchar2
328: ,p_attribute1 in varchar2 default hr_api.g_varchar2
321: ,p_rate_id in number default hr_api.g_number
322: ,p_name in varchar2 default hr_api.g_varchar2
323: ,p_pay_basis in varchar2 default hr_api.g_varchar2
324: ,p_rate_basis in varchar2 default hr_api.g_varchar2
325: ,p_pay_annualization_factor in number default hr_api.g_number
326: ,p_grade_annualization_factor in number default hr_api.g_number
327: ,p_attribute_category in varchar2 default hr_api.g_varchar2
328: ,p_attribute1 in varchar2 default hr_api.g_varchar2
329: ,p_attribute2 in varchar2 default hr_api.g_varchar2
322: ,p_name in varchar2 default hr_api.g_varchar2
323: ,p_pay_basis in varchar2 default hr_api.g_varchar2
324: ,p_rate_basis in varchar2 default hr_api.g_varchar2
325: ,p_pay_annualization_factor in number default hr_api.g_number
326: ,p_grade_annualization_factor in number default hr_api.g_number
327: ,p_attribute_category in varchar2 default hr_api.g_varchar2
328: ,p_attribute1 in varchar2 default hr_api.g_varchar2
329: ,p_attribute2 in varchar2 default hr_api.g_varchar2
330: ,p_attribute3 in varchar2 default hr_api.g_varchar2
323: ,p_pay_basis in varchar2 default hr_api.g_varchar2
324: ,p_rate_basis in varchar2 default hr_api.g_varchar2
325: ,p_pay_annualization_factor in number default hr_api.g_number
326: ,p_grade_annualization_factor in number default hr_api.g_number
327: ,p_attribute_category in varchar2 default hr_api.g_varchar2
328: ,p_attribute1 in varchar2 default hr_api.g_varchar2
329: ,p_attribute2 in varchar2 default hr_api.g_varchar2
330: ,p_attribute3 in varchar2 default hr_api.g_varchar2
331: ,p_attribute4 in varchar2 default hr_api.g_varchar2
324: ,p_rate_basis in varchar2 default hr_api.g_varchar2
325: ,p_pay_annualization_factor in number default hr_api.g_number
326: ,p_grade_annualization_factor in number default hr_api.g_number
327: ,p_attribute_category in varchar2 default hr_api.g_varchar2
328: ,p_attribute1 in varchar2 default hr_api.g_varchar2
329: ,p_attribute2 in varchar2 default hr_api.g_varchar2
330: ,p_attribute3 in varchar2 default hr_api.g_varchar2
331: ,p_attribute4 in varchar2 default hr_api.g_varchar2
332: ,p_attribute5 in varchar2 default hr_api.g_varchar2
325: ,p_pay_annualization_factor in number default hr_api.g_number
326: ,p_grade_annualization_factor in number default hr_api.g_number
327: ,p_attribute_category in varchar2 default hr_api.g_varchar2
328: ,p_attribute1 in varchar2 default hr_api.g_varchar2
329: ,p_attribute2 in varchar2 default hr_api.g_varchar2
330: ,p_attribute3 in varchar2 default hr_api.g_varchar2
331: ,p_attribute4 in varchar2 default hr_api.g_varchar2
332: ,p_attribute5 in varchar2 default hr_api.g_varchar2
333: ,p_attribute6 in varchar2 default hr_api.g_varchar2
326: ,p_grade_annualization_factor in number default hr_api.g_number
327: ,p_attribute_category in varchar2 default hr_api.g_varchar2
328: ,p_attribute1 in varchar2 default hr_api.g_varchar2
329: ,p_attribute2 in varchar2 default hr_api.g_varchar2
330: ,p_attribute3 in varchar2 default hr_api.g_varchar2
331: ,p_attribute4 in varchar2 default hr_api.g_varchar2
332: ,p_attribute5 in varchar2 default hr_api.g_varchar2
333: ,p_attribute6 in varchar2 default hr_api.g_varchar2
334: ,p_attribute7 in varchar2 default hr_api.g_varchar2
327: ,p_attribute_category in varchar2 default hr_api.g_varchar2
328: ,p_attribute1 in varchar2 default hr_api.g_varchar2
329: ,p_attribute2 in varchar2 default hr_api.g_varchar2
330: ,p_attribute3 in varchar2 default hr_api.g_varchar2
331: ,p_attribute4 in varchar2 default hr_api.g_varchar2
332: ,p_attribute5 in varchar2 default hr_api.g_varchar2
333: ,p_attribute6 in varchar2 default hr_api.g_varchar2
334: ,p_attribute7 in varchar2 default hr_api.g_varchar2
335: ,p_attribute8 in varchar2 default hr_api.g_varchar2
328: ,p_attribute1 in varchar2 default hr_api.g_varchar2
329: ,p_attribute2 in varchar2 default hr_api.g_varchar2
330: ,p_attribute3 in varchar2 default hr_api.g_varchar2
331: ,p_attribute4 in varchar2 default hr_api.g_varchar2
332: ,p_attribute5 in varchar2 default hr_api.g_varchar2
333: ,p_attribute6 in varchar2 default hr_api.g_varchar2
334: ,p_attribute7 in varchar2 default hr_api.g_varchar2
335: ,p_attribute8 in varchar2 default hr_api.g_varchar2
336: ,p_attribute9 in varchar2 default hr_api.g_varchar2
329: ,p_attribute2 in varchar2 default hr_api.g_varchar2
330: ,p_attribute3 in varchar2 default hr_api.g_varchar2
331: ,p_attribute4 in varchar2 default hr_api.g_varchar2
332: ,p_attribute5 in varchar2 default hr_api.g_varchar2
333: ,p_attribute6 in varchar2 default hr_api.g_varchar2
334: ,p_attribute7 in varchar2 default hr_api.g_varchar2
335: ,p_attribute8 in varchar2 default hr_api.g_varchar2
336: ,p_attribute9 in varchar2 default hr_api.g_varchar2
337: ,p_attribute10 in varchar2 default hr_api.g_varchar2
330: ,p_attribute3 in varchar2 default hr_api.g_varchar2
331: ,p_attribute4 in varchar2 default hr_api.g_varchar2
332: ,p_attribute5 in varchar2 default hr_api.g_varchar2
333: ,p_attribute6 in varchar2 default hr_api.g_varchar2
334: ,p_attribute7 in varchar2 default hr_api.g_varchar2
335: ,p_attribute8 in varchar2 default hr_api.g_varchar2
336: ,p_attribute9 in varchar2 default hr_api.g_varchar2
337: ,p_attribute10 in varchar2 default hr_api.g_varchar2
338: ,p_attribute11 in varchar2 default hr_api.g_varchar2
331: ,p_attribute4 in varchar2 default hr_api.g_varchar2
332: ,p_attribute5 in varchar2 default hr_api.g_varchar2
333: ,p_attribute6 in varchar2 default hr_api.g_varchar2
334: ,p_attribute7 in varchar2 default hr_api.g_varchar2
335: ,p_attribute8 in varchar2 default hr_api.g_varchar2
336: ,p_attribute9 in varchar2 default hr_api.g_varchar2
337: ,p_attribute10 in varchar2 default hr_api.g_varchar2
338: ,p_attribute11 in varchar2 default hr_api.g_varchar2
339: ,p_attribute12 in varchar2 default hr_api.g_varchar2
332: ,p_attribute5 in varchar2 default hr_api.g_varchar2
333: ,p_attribute6 in varchar2 default hr_api.g_varchar2
334: ,p_attribute7 in varchar2 default hr_api.g_varchar2
335: ,p_attribute8 in varchar2 default hr_api.g_varchar2
336: ,p_attribute9 in varchar2 default hr_api.g_varchar2
337: ,p_attribute10 in varchar2 default hr_api.g_varchar2
338: ,p_attribute11 in varchar2 default hr_api.g_varchar2
339: ,p_attribute12 in varchar2 default hr_api.g_varchar2
340: ,p_attribute13 in varchar2 default hr_api.g_varchar2
333: ,p_attribute6 in varchar2 default hr_api.g_varchar2
334: ,p_attribute7 in varchar2 default hr_api.g_varchar2
335: ,p_attribute8 in varchar2 default hr_api.g_varchar2
336: ,p_attribute9 in varchar2 default hr_api.g_varchar2
337: ,p_attribute10 in varchar2 default hr_api.g_varchar2
338: ,p_attribute11 in varchar2 default hr_api.g_varchar2
339: ,p_attribute12 in varchar2 default hr_api.g_varchar2
340: ,p_attribute13 in varchar2 default hr_api.g_varchar2
341: ,p_attribute14 in varchar2 default hr_api.g_varchar2
334: ,p_attribute7 in varchar2 default hr_api.g_varchar2
335: ,p_attribute8 in varchar2 default hr_api.g_varchar2
336: ,p_attribute9 in varchar2 default hr_api.g_varchar2
337: ,p_attribute10 in varchar2 default hr_api.g_varchar2
338: ,p_attribute11 in varchar2 default hr_api.g_varchar2
339: ,p_attribute12 in varchar2 default hr_api.g_varchar2
340: ,p_attribute13 in varchar2 default hr_api.g_varchar2
341: ,p_attribute14 in varchar2 default hr_api.g_varchar2
342: ,p_attribute15 in varchar2 default hr_api.g_varchar2
335: ,p_attribute8 in varchar2 default hr_api.g_varchar2
336: ,p_attribute9 in varchar2 default hr_api.g_varchar2
337: ,p_attribute10 in varchar2 default hr_api.g_varchar2
338: ,p_attribute11 in varchar2 default hr_api.g_varchar2
339: ,p_attribute12 in varchar2 default hr_api.g_varchar2
340: ,p_attribute13 in varchar2 default hr_api.g_varchar2
341: ,p_attribute14 in varchar2 default hr_api.g_varchar2
342: ,p_attribute15 in varchar2 default hr_api.g_varchar2
343: ,p_attribute16 in varchar2 default hr_api.g_varchar2
336: ,p_attribute9 in varchar2 default hr_api.g_varchar2
337: ,p_attribute10 in varchar2 default hr_api.g_varchar2
338: ,p_attribute11 in varchar2 default hr_api.g_varchar2
339: ,p_attribute12 in varchar2 default hr_api.g_varchar2
340: ,p_attribute13 in varchar2 default hr_api.g_varchar2
341: ,p_attribute14 in varchar2 default hr_api.g_varchar2
342: ,p_attribute15 in varchar2 default hr_api.g_varchar2
343: ,p_attribute16 in varchar2 default hr_api.g_varchar2
344: ,p_attribute17 in varchar2 default hr_api.g_varchar2
337: ,p_attribute10 in varchar2 default hr_api.g_varchar2
338: ,p_attribute11 in varchar2 default hr_api.g_varchar2
339: ,p_attribute12 in varchar2 default hr_api.g_varchar2
340: ,p_attribute13 in varchar2 default hr_api.g_varchar2
341: ,p_attribute14 in varchar2 default hr_api.g_varchar2
342: ,p_attribute15 in varchar2 default hr_api.g_varchar2
343: ,p_attribute16 in varchar2 default hr_api.g_varchar2
344: ,p_attribute17 in varchar2 default hr_api.g_varchar2
345: ,p_attribute18 in varchar2 default hr_api.g_varchar2
338: ,p_attribute11 in varchar2 default hr_api.g_varchar2
339: ,p_attribute12 in varchar2 default hr_api.g_varchar2
340: ,p_attribute13 in varchar2 default hr_api.g_varchar2
341: ,p_attribute14 in varchar2 default hr_api.g_varchar2
342: ,p_attribute15 in varchar2 default hr_api.g_varchar2
343: ,p_attribute16 in varchar2 default hr_api.g_varchar2
344: ,p_attribute17 in varchar2 default hr_api.g_varchar2
345: ,p_attribute18 in varchar2 default hr_api.g_varchar2
346: ,p_attribute19 in varchar2 default hr_api.g_varchar2
339: ,p_attribute12 in varchar2 default hr_api.g_varchar2
340: ,p_attribute13 in varchar2 default hr_api.g_varchar2
341: ,p_attribute14 in varchar2 default hr_api.g_varchar2
342: ,p_attribute15 in varchar2 default hr_api.g_varchar2
343: ,p_attribute16 in varchar2 default hr_api.g_varchar2
344: ,p_attribute17 in varchar2 default hr_api.g_varchar2
345: ,p_attribute18 in varchar2 default hr_api.g_varchar2
346: ,p_attribute19 in varchar2 default hr_api.g_varchar2
347: ,p_attribute20 in varchar2 default hr_api.g_varchar2
340: ,p_attribute13 in varchar2 default hr_api.g_varchar2
341: ,p_attribute14 in varchar2 default hr_api.g_varchar2
342: ,p_attribute15 in varchar2 default hr_api.g_varchar2
343: ,p_attribute16 in varchar2 default hr_api.g_varchar2
344: ,p_attribute17 in varchar2 default hr_api.g_varchar2
345: ,p_attribute18 in varchar2 default hr_api.g_varchar2
346: ,p_attribute19 in varchar2 default hr_api.g_varchar2
347: ,p_attribute20 in varchar2 default hr_api.g_varchar2
348: ,p_information_category in varchar2 default hr_api.g_varchar2
341: ,p_attribute14 in varchar2 default hr_api.g_varchar2
342: ,p_attribute15 in varchar2 default hr_api.g_varchar2
343: ,p_attribute16 in varchar2 default hr_api.g_varchar2
344: ,p_attribute17 in varchar2 default hr_api.g_varchar2
345: ,p_attribute18 in varchar2 default hr_api.g_varchar2
346: ,p_attribute19 in varchar2 default hr_api.g_varchar2
347: ,p_attribute20 in varchar2 default hr_api.g_varchar2
348: ,p_information_category in varchar2 default hr_api.g_varchar2
349: ,p_information1 in varchar2 default hr_api.g_varchar2
342: ,p_attribute15 in varchar2 default hr_api.g_varchar2
343: ,p_attribute16 in varchar2 default hr_api.g_varchar2
344: ,p_attribute17 in varchar2 default hr_api.g_varchar2
345: ,p_attribute18 in varchar2 default hr_api.g_varchar2
346: ,p_attribute19 in varchar2 default hr_api.g_varchar2
347: ,p_attribute20 in varchar2 default hr_api.g_varchar2
348: ,p_information_category in varchar2 default hr_api.g_varchar2
349: ,p_information1 in varchar2 default hr_api.g_varchar2
350: ,p_information2 in varchar2 default hr_api.g_varchar2
343: ,p_attribute16 in varchar2 default hr_api.g_varchar2
344: ,p_attribute17 in varchar2 default hr_api.g_varchar2
345: ,p_attribute18 in varchar2 default hr_api.g_varchar2
346: ,p_attribute19 in varchar2 default hr_api.g_varchar2
347: ,p_attribute20 in varchar2 default hr_api.g_varchar2
348: ,p_information_category in varchar2 default hr_api.g_varchar2
349: ,p_information1 in varchar2 default hr_api.g_varchar2
350: ,p_information2 in varchar2 default hr_api.g_varchar2
351: ,p_information3 in varchar2 default hr_api.g_varchar2
344: ,p_attribute17 in varchar2 default hr_api.g_varchar2
345: ,p_attribute18 in varchar2 default hr_api.g_varchar2
346: ,p_attribute19 in varchar2 default hr_api.g_varchar2
347: ,p_attribute20 in varchar2 default hr_api.g_varchar2
348: ,p_information_category in varchar2 default hr_api.g_varchar2
349: ,p_information1 in varchar2 default hr_api.g_varchar2
350: ,p_information2 in varchar2 default hr_api.g_varchar2
351: ,p_information3 in varchar2 default hr_api.g_varchar2
352: ,p_information4 in varchar2 default hr_api.g_varchar2
345: ,p_attribute18 in varchar2 default hr_api.g_varchar2
346: ,p_attribute19 in varchar2 default hr_api.g_varchar2
347: ,p_attribute20 in varchar2 default hr_api.g_varchar2
348: ,p_information_category in varchar2 default hr_api.g_varchar2
349: ,p_information1 in varchar2 default hr_api.g_varchar2
350: ,p_information2 in varchar2 default hr_api.g_varchar2
351: ,p_information3 in varchar2 default hr_api.g_varchar2
352: ,p_information4 in varchar2 default hr_api.g_varchar2
353: ,p_information5 in varchar2 default hr_api.g_varchar2
346: ,p_attribute19 in varchar2 default hr_api.g_varchar2
347: ,p_attribute20 in varchar2 default hr_api.g_varchar2
348: ,p_information_category in varchar2 default hr_api.g_varchar2
349: ,p_information1 in varchar2 default hr_api.g_varchar2
350: ,p_information2 in varchar2 default hr_api.g_varchar2
351: ,p_information3 in varchar2 default hr_api.g_varchar2
352: ,p_information4 in varchar2 default hr_api.g_varchar2
353: ,p_information5 in varchar2 default hr_api.g_varchar2
354: ,p_information6 in varchar2 default hr_api.g_varchar2
347: ,p_attribute20 in varchar2 default hr_api.g_varchar2
348: ,p_information_category in varchar2 default hr_api.g_varchar2
349: ,p_information1 in varchar2 default hr_api.g_varchar2
350: ,p_information2 in varchar2 default hr_api.g_varchar2
351: ,p_information3 in varchar2 default hr_api.g_varchar2
352: ,p_information4 in varchar2 default hr_api.g_varchar2
353: ,p_information5 in varchar2 default hr_api.g_varchar2
354: ,p_information6 in varchar2 default hr_api.g_varchar2
355: ,p_information7 in varchar2 default hr_api.g_varchar2
348: ,p_information_category in varchar2 default hr_api.g_varchar2
349: ,p_information1 in varchar2 default hr_api.g_varchar2
350: ,p_information2 in varchar2 default hr_api.g_varchar2
351: ,p_information3 in varchar2 default hr_api.g_varchar2
352: ,p_information4 in varchar2 default hr_api.g_varchar2
353: ,p_information5 in varchar2 default hr_api.g_varchar2
354: ,p_information6 in varchar2 default hr_api.g_varchar2
355: ,p_information7 in varchar2 default hr_api.g_varchar2
356: ,p_information8 in varchar2 default hr_api.g_varchar2
349: ,p_information1 in varchar2 default hr_api.g_varchar2
350: ,p_information2 in varchar2 default hr_api.g_varchar2
351: ,p_information3 in varchar2 default hr_api.g_varchar2
352: ,p_information4 in varchar2 default hr_api.g_varchar2
353: ,p_information5 in varchar2 default hr_api.g_varchar2
354: ,p_information6 in varchar2 default hr_api.g_varchar2
355: ,p_information7 in varchar2 default hr_api.g_varchar2
356: ,p_information8 in varchar2 default hr_api.g_varchar2
357: ,p_information9 in varchar2 default hr_api.g_varchar2
350: ,p_information2 in varchar2 default hr_api.g_varchar2
351: ,p_information3 in varchar2 default hr_api.g_varchar2
352: ,p_information4 in varchar2 default hr_api.g_varchar2
353: ,p_information5 in varchar2 default hr_api.g_varchar2
354: ,p_information6 in varchar2 default hr_api.g_varchar2
355: ,p_information7 in varchar2 default hr_api.g_varchar2
356: ,p_information8 in varchar2 default hr_api.g_varchar2
357: ,p_information9 in varchar2 default hr_api.g_varchar2
358: ,p_information10 in varchar2 default hr_api.g_varchar2
351: ,p_information3 in varchar2 default hr_api.g_varchar2
352: ,p_information4 in varchar2 default hr_api.g_varchar2
353: ,p_information5 in varchar2 default hr_api.g_varchar2
354: ,p_information6 in varchar2 default hr_api.g_varchar2
355: ,p_information7 in varchar2 default hr_api.g_varchar2
356: ,p_information8 in varchar2 default hr_api.g_varchar2
357: ,p_information9 in varchar2 default hr_api.g_varchar2
358: ,p_information10 in varchar2 default hr_api.g_varchar2
359: ,p_information11 in varchar2 default hr_api.g_varchar2
352: ,p_information4 in varchar2 default hr_api.g_varchar2
353: ,p_information5 in varchar2 default hr_api.g_varchar2
354: ,p_information6 in varchar2 default hr_api.g_varchar2
355: ,p_information7 in varchar2 default hr_api.g_varchar2
356: ,p_information8 in varchar2 default hr_api.g_varchar2
357: ,p_information9 in varchar2 default hr_api.g_varchar2
358: ,p_information10 in varchar2 default hr_api.g_varchar2
359: ,p_information11 in varchar2 default hr_api.g_varchar2
360: ,p_information12 in varchar2 default hr_api.g_varchar2
353: ,p_information5 in varchar2 default hr_api.g_varchar2
354: ,p_information6 in varchar2 default hr_api.g_varchar2
355: ,p_information7 in varchar2 default hr_api.g_varchar2
356: ,p_information8 in varchar2 default hr_api.g_varchar2
357: ,p_information9 in varchar2 default hr_api.g_varchar2
358: ,p_information10 in varchar2 default hr_api.g_varchar2
359: ,p_information11 in varchar2 default hr_api.g_varchar2
360: ,p_information12 in varchar2 default hr_api.g_varchar2
361: ,p_information13 in varchar2 default hr_api.g_varchar2
354: ,p_information6 in varchar2 default hr_api.g_varchar2
355: ,p_information7 in varchar2 default hr_api.g_varchar2
356: ,p_information8 in varchar2 default hr_api.g_varchar2
357: ,p_information9 in varchar2 default hr_api.g_varchar2
358: ,p_information10 in varchar2 default hr_api.g_varchar2
359: ,p_information11 in varchar2 default hr_api.g_varchar2
360: ,p_information12 in varchar2 default hr_api.g_varchar2
361: ,p_information13 in varchar2 default hr_api.g_varchar2
362: ,p_information14 in varchar2 default hr_api.g_varchar2
355: ,p_information7 in varchar2 default hr_api.g_varchar2
356: ,p_information8 in varchar2 default hr_api.g_varchar2
357: ,p_information9 in varchar2 default hr_api.g_varchar2
358: ,p_information10 in varchar2 default hr_api.g_varchar2
359: ,p_information11 in varchar2 default hr_api.g_varchar2
360: ,p_information12 in varchar2 default hr_api.g_varchar2
361: ,p_information13 in varchar2 default hr_api.g_varchar2
362: ,p_information14 in varchar2 default hr_api.g_varchar2
363: ,p_information15 in varchar2 default hr_api.g_varchar2
356: ,p_information8 in varchar2 default hr_api.g_varchar2
357: ,p_information9 in varchar2 default hr_api.g_varchar2
358: ,p_information10 in varchar2 default hr_api.g_varchar2
359: ,p_information11 in varchar2 default hr_api.g_varchar2
360: ,p_information12 in varchar2 default hr_api.g_varchar2
361: ,p_information13 in varchar2 default hr_api.g_varchar2
362: ,p_information14 in varchar2 default hr_api.g_varchar2
363: ,p_information15 in varchar2 default hr_api.g_varchar2
364: ,p_information16 in varchar2 default hr_api.g_varchar2
357: ,p_information9 in varchar2 default hr_api.g_varchar2
358: ,p_information10 in varchar2 default hr_api.g_varchar2
359: ,p_information11 in varchar2 default hr_api.g_varchar2
360: ,p_information12 in varchar2 default hr_api.g_varchar2
361: ,p_information13 in varchar2 default hr_api.g_varchar2
362: ,p_information14 in varchar2 default hr_api.g_varchar2
363: ,p_information15 in varchar2 default hr_api.g_varchar2
364: ,p_information16 in varchar2 default hr_api.g_varchar2
365: ,p_information17 in varchar2 default hr_api.g_varchar2
358: ,p_information10 in varchar2 default hr_api.g_varchar2
359: ,p_information11 in varchar2 default hr_api.g_varchar2
360: ,p_information12 in varchar2 default hr_api.g_varchar2
361: ,p_information13 in varchar2 default hr_api.g_varchar2
362: ,p_information14 in varchar2 default hr_api.g_varchar2
363: ,p_information15 in varchar2 default hr_api.g_varchar2
364: ,p_information16 in varchar2 default hr_api.g_varchar2
365: ,p_information17 in varchar2 default hr_api.g_varchar2
366: ,p_information18 in varchar2 default hr_api.g_varchar2
359: ,p_information11 in varchar2 default hr_api.g_varchar2
360: ,p_information12 in varchar2 default hr_api.g_varchar2
361: ,p_information13 in varchar2 default hr_api.g_varchar2
362: ,p_information14 in varchar2 default hr_api.g_varchar2
363: ,p_information15 in varchar2 default hr_api.g_varchar2
364: ,p_information16 in varchar2 default hr_api.g_varchar2
365: ,p_information17 in varchar2 default hr_api.g_varchar2
366: ,p_information18 in varchar2 default hr_api.g_varchar2
367: ,p_information19 in varchar2 default hr_api.g_varchar2
360: ,p_information12 in varchar2 default hr_api.g_varchar2
361: ,p_information13 in varchar2 default hr_api.g_varchar2
362: ,p_information14 in varchar2 default hr_api.g_varchar2
363: ,p_information15 in varchar2 default hr_api.g_varchar2
364: ,p_information16 in varchar2 default hr_api.g_varchar2
365: ,p_information17 in varchar2 default hr_api.g_varchar2
366: ,p_information18 in varchar2 default hr_api.g_varchar2
367: ,p_information19 in varchar2 default hr_api.g_varchar2
368: ,p_information20 in varchar2 default hr_api.g_varchar2
361: ,p_information13 in varchar2 default hr_api.g_varchar2
362: ,p_information14 in varchar2 default hr_api.g_varchar2
363: ,p_information15 in varchar2 default hr_api.g_varchar2
364: ,p_information16 in varchar2 default hr_api.g_varchar2
365: ,p_information17 in varchar2 default hr_api.g_varchar2
366: ,p_information18 in varchar2 default hr_api.g_varchar2
367: ,p_information19 in varchar2 default hr_api.g_varchar2
368: ,p_information20 in varchar2 default hr_api.g_varchar2
369: ,p_last_update_date in date default hr_api.g_date
362: ,p_information14 in varchar2 default hr_api.g_varchar2
363: ,p_information15 in varchar2 default hr_api.g_varchar2
364: ,p_information16 in varchar2 default hr_api.g_varchar2
365: ,p_information17 in varchar2 default hr_api.g_varchar2
366: ,p_information18 in varchar2 default hr_api.g_varchar2
367: ,p_information19 in varchar2 default hr_api.g_varchar2
368: ,p_information20 in varchar2 default hr_api.g_varchar2
369: ,p_last_update_date in date default hr_api.g_date
370: ,p_last_updated_by in number default hr_api.g_number
363: ,p_information15 in varchar2 default hr_api.g_varchar2
364: ,p_information16 in varchar2 default hr_api.g_varchar2
365: ,p_information17 in varchar2 default hr_api.g_varchar2
366: ,p_information18 in varchar2 default hr_api.g_varchar2
367: ,p_information19 in varchar2 default hr_api.g_varchar2
368: ,p_information20 in varchar2 default hr_api.g_varchar2
369: ,p_last_update_date in date default hr_api.g_date
370: ,p_last_updated_by in number default hr_api.g_number
371: ,p_last_update_login in number default hr_api.g_number
364: ,p_information16 in varchar2 default hr_api.g_varchar2
365: ,p_information17 in varchar2 default hr_api.g_varchar2
366: ,p_information18 in varchar2 default hr_api.g_varchar2
367: ,p_information19 in varchar2 default hr_api.g_varchar2
368: ,p_information20 in varchar2 default hr_api.g_varchar2
369: ,p_last_update_date in date default hr_api.g_date
370: ,p_last_updated_by in number default hr_api.g_number
371: ,p_last_update_login in number default hr_api.g_number
372: ,p_created_by in number default hr_api.g_number
365: ,p_information17 in varchar2 default hr_api.g_varchar2
366: ,p_information18 in varchar2 default hr_api.g_varchar2
367: ,p_information19 in varchar2 default hr_api.g_varchar2
368: ,p_information20 in varchar2 default hr_api.g_varchar2
369: ,p_last_update_date in date default hr_api.g_date
370: ,p_last_updated_by in number default hr_api.g_number
371: ,p_last_update_login in number default hr_api.g_number
372: ,p_created_by in number default hr_api.g_number
373: ,p_creation_date in date default hr_api.g_date
366: ,p_information18 in varchar2 default hr_api.g_varchar2
367: ,p_information19 in varchar2 default hr_api.g_varchar2
368: ,p_information20 in varchar2 default hr_api.g_varchar2
369: ,p_last_update_date in date default hr_api.g_date
370: ,p_last_updated_by in number default hr_api.g_number
371: ,p_last_update_login in number default hr_api.g_number
372: ,p_created_by in number default hr_api.g_number
373: ,p_creation_date in date default hr_api.g_date
374: ,p_object_version_number in out nocopy number
367: ,p_information19 in varchar2 default hr_api.g_varchar2
368: ,p_information20 in varchar2 default hr_api.g_varchar2
369: ,p_last_update_date in date default hr_api.g_date
370: ,p_last_updated_by in number default hr_api.g_number
371: ,p_last_update_login in number default hr_api.g_number
372: ,p_created_by in number default hr_api.g_number
373: ,p_creation_date in date default hr_api.g_date
374: ,p_object_version_number in out nocopy number
375: ,p_return_status out nocopy varchar2
368: ,p_information20 in varchar2 default hr_api.g_varchar2
369: ,p_last_update_date in date default hr_api.g_date
370: ,p_last_updated_by in number default hr_api.g_number
371: ,p_last_update_login in number default hr_api.g_number
372: ,p_created_by in number default hr_api.g_number
373: ,p_creation_date in date default hr_api.g_date
374: ,p_object_version_number in out nocopy number
375: ,p_return_status out nocopy varchar2
376: ) is
369: ,p_last_update_date in date default hr_api.g_date
370: ,p_last_updated_by in number default hr_api.g_number
371: ,p_last_update_login in number default hr_api.g_number
372: ,p_created_by in number default hr_api.g_number
373: ,p_creation_date in date default hr_api.g_date
374: ,p_object_version_number in out nocopy number
375: ,p_return_status out nocopy varchar2
376: ) is
377: --
400: --
401: -- Convert constant values to their corresponding boolean value
402: --
403: l_validate :=
404: hr_api.constant_to_boolean
405: (p_constant_value => p_validate);
406: --
407: -- Register Surrogate ID or user key values
408: --