219: procedure update_role
220: (
221: p_validate in boolean default false
222: ,p_role_id in number
223: ,p_role_name in varchar2 default hr_api.g_varchar2
224: ,p_role_type_cd in varchar2 default hr_api.g_varchar2
225: ,p_enable_flag in varchar2 default hr_api.g_varchar2
226: ,p_object_version_number in out nocopy number
227: ,p_business_group_id in number default hr_api.g_number
220: (
221: p_validate in boolean default false
222: ,p_role_id in number
223: ,p_role_name in varchar2 default hr_api.g_varchar2
224: ,p_role_type_cd in varchar2 default hr_api.g_varchar2
225: ,p_enable_flag in varchar2 default hr_api.g_varchar2
226: ,p_object_version_number in out nocopy number
227: ,p_business_group_id in number default hr_api.g_number
228: ,p_effective_date in date
221: p_validate in boolean default false
222: ,p_role_id in number
223: ,p_role_name in varchar2 default hr_api.g_varchar2
224: ,p_role_type_cd in varchar2 default hr_api.g_varchar2
225: ,p_enable_flag in varchar2 default hr_api.g_varchar2
226: ,p_object_version_number in out nocopy number
227: ,p_business_group_id in number default hr_api.g_number
228: ,p_effective_date in date
229: ,p_information_category in varchar2 default hr_api.g_varchar2
223: ,p_role_name in varchar2 default hr_api.g_varchar2
224: ,p_role_type_cd in varchar2 default hr_api.g_varchar2
225: ,p_enable_flag in varchar2 default hr_api.g_varchar2
226: ,p_object_version_number in out nocopy number
227: ,p_business_group_id in number default hr_api.g_number
228: ,p_effective_date in date
229: ,p_information_category in varchar2 default hr_api.g_varchar2
230: ,p_information1 in varchar2 default hr_api.g_varchar2
231: ,p_information2 in varchar2 default hr_api.g_varchar2
225: ,p_enable_flag in varchar2 default hr_api.g_varchar2
226: ,p_object_version_number in out nocopy number
227: ,p_business_group_id in number default hr_api.g_number
228: ,p_effective_date in date
229: ,p_information_category in varchar2 default hr_api.g_varchar2
230: ,p_information1 in varchar2 default hr_api.g_varchar2
231: ,p_information2 in varchar2 default hr_api.g_varchar2
232: ,p_information3 in varchar2 default hr_api.g_varchar2
233: ,p_information4 in varchar2 default hr_api.g_varchar2
226: ,p_object_version_number in out nocopy number
227: ,p_business_group_id in number default hr_api.g_number
228: ,p_effective_date in date
229: ,p_information_category in varchar2 default hr_api.g_varchar2
230: ,p_information1 in varchar2 default hr_api.g_varchar2
231: ,p_information2 in varchar2 default hr_api.g_varchar2
232: ,p_information3 in varchar2 default hr_api.g_varchar2
233: ,p_information4 in varchar2 default hr_api.g_varchar2
234: ,p_information5 in varchar2 default hr_api.g_varchar2
227: ,p_business_group_id in number default hr_api.g_number
228: ,p_effective_date in date
229: ,p_information_category in varchar2 default hr_api.g_varchar2
230: ,p_information1 in varchar2 default hr_api.g_varchar2
231: ,p_information2 in varchar2 default hr_api.g_varchar2
232: ,p_information3 in varchar2 default hr_api.g_varchar2
233: ,p_information4 in varchar2 default hr_api.g_varchar2
234: ,p_information5 in varchar2 default hr_api.g_varchar2
235: ,p_information6 in varchar2 default hr_api.g_varchar2
228: ,p_effective_date in date
229: ,p_information_category in varchar2 default hr_api.g_varchar2
230: ,p_information1 in varchar2 default hr_api.g_varchar2
231: ,p_information2 in varchar2 default hr_api.g_varchar2
232: ,p_information3 in varchar2 default hr_api.g_varchar2
233: ,p_information4 in varchar2 default hr_api.g_varchar2
234: ,p_information5 in varchar2 default hr_api.g_varchar2
235: ,p_information6 in varchar2 default hr_api.g_varchar2
236: ,p_information7 in varchar2 default hr_api.g_varchar2
229: ,p_information_category in varchar2 default hr_api.g_varchar2
230: ,p_information1 in varchar2 default hr_api.g_varchar2
231: ,p_information2 in varchar2 default hr_api.g_varchar2
232: ,p_information3 in varchar2 default hr_api.g_varchar2
233: ,p_information4 in varchar2 default hr_api.g_varchar2
234: ,p_information5 in varchar2 default hr_api.g_varchar2
235: ,p_information6 in varchar2 default hr_api.g_varchar2
236: ,p_information7 in varchar2 default hr_api.g_varchar2
237: ,p_information8 in varchar2 default hr_api.g_varchar2
230: ,p_information1 in varchar2 default hr_api.g_varchar2
231: ,p_information2 in varchar2 default hr_api.g_varchar2
232: ,p_information3 in varchar2 default hr_api.g_varchar2
233: ,p_information4 in varchar2 default hr_api.g_varchar2
234: ,p_information5 in varchar2 default hr_api.g_varchar2
235: ,p_information6 in varchar2 default hr_api.g_varchar2
236: ,p_information7 in varchar2 default hr_api.g_varchar2
237: ,p_information8 in varchar2 default hr_api.g_varchar2
238: ,p_information9 in varchar2 default hr_api.g_varchar2
231: ,p_information2 in varchar2 default hr_api.g_varchar2
232: ,p_information3 in varchar2 default hr_api.g_varchar2
233: ,p_information4 in varchar2 default hr_api.g_varchar2
234: ,p_information5 in varchar2 default hr_api.g_varchar2
235: ,p_information6 in varchar2 default hr_api.g_varchar2
236: ,p_information7 in varchar2 default hr_api.g_varchar2
237: ,p_information8 in varchar2 default hr_api.g_varchar2
238: ,p_information9 in varchar2 default hr_api.g_varchar2
239: ,p_information10 in varchar2 default hr_api.g_varchar2
232: ,p_information3 in varchar2 default hr_api.g_varchar2
233: ,p_information4 in varchar2 default hr_api.g_varchar2
234: ,p_information5 in varchar2 default hr_api.g_varchar2
235: ,p_information6 in varchar2 default hr_api.g_varchar2
236: ,p_information7 in varchar2 default hr_api.g_varchar2
237: ,p_information8 in varchar2 default hr_api.g_varchar2
238: ,p_information9 in varchar2 default hr_api.g_varchar2
239: ,p_information10 in varchar2 default hr_api.g_varchar2
240: ,p_information11 in varchar2 default hr_api.g_varchar2
233: ,p_information4 in varchar2 default hr_api.g_varchar2
234: ,p_information5 in varchar2 default hr_api.g_varchar2
235: ,p_information6 in varchar2 default hr_api.g_varchar2
236: ,p_information7 in varchar2 default hr_api.g_varchar2
237: ,p_information8 in varchar2 default hr_api.g_varchar2
238: ,p_information9 in varchar2 default hr_api.g_varchar2
239: ,p_information10 in varchar2 default hr_api.g_varchar2
240: ,p_information11 in varchar2 default hr_api.g_varchar2
241: ,p_information12 in varchar2 default hr_api.g_varchar2
234: ,p_information5 in varchar2 default hr_api.g_varchar2
235: ,p_information6 in varchar2 default hr_api.g_varchar2
236: ,p_information7 in varchar2 default hr_api.g_varchar2
237: ,p_information8 in varchar2 default hr_api.g_varchar2
238: ,p_information9 in varchar2 default hr_api.g_varchar2
239: ,p_information10 in varchar2 default hr_api.g_varchar2
240: ,p_information11 in varchar2 default hr_api.g_varchar2
241: ,p_information12 in varchar2 default hr_api.g_varchar2
242: ,p_information13 in varchar2 default hr_api.g_varchar2
235: ,p_information6 in varchar2 default hr_api.g_varchar2
236: ,p_information7 in varchar2 default hr_api.g_varchar2
237: ,p_information8 in varchar2 default hr_api.g_varchar2
238: ,p_information9 in varchar2 default hr_api.g_varchar2
239: ,p_information10 in varchar2 default hr_api.g_varchar2
240: ,p_information11 in varchar2 default hr_api.g_varchar2
241: ,p_information12 in varchar2 default hr_api.g_varchar2
242: ,p_information13 in varchar2 default hr_api.g_varchar2
243: ,p_information14 in varchar2 default hr_api.g_varchar2
236: ,p_information7 in varchar2 default hr_api.g_varchar2
237: ,p_information8 in varchar2 default hr_api.g_varchar2
238: ,p_information9 in varchar2 default hr_api.g_varchar2
239: ,p_information10 in varchar2 default hr_api.g_varchar2
240: ,p_information11 in varchar2 default hr_api.g_varchar2
241: ,p_information12 in varchar2 default hr_api.g_varchar2
242: ,p_information13 in varchar2 default hr_api.g_varchar2
243: ,p_information14 in varchar2 default hr_api.g_varchar2
244: ,p_information15 in varchar2 default hr_api.g_varchar2
237: ,p_information8 in varchar2 default hr_api.g_varchar2
238: ,p_information9 in varchar2 default hr_api.g_varchar2
239: ,p_information10 in varchar2 default hr_api.g_varchar2
240: ,p_information11 in varchar2 default hr_api.g_varchar2
241: ,p_information12 in varchar2 default hr_api.g_varchar2
242: ,p_information13 in varchar2 default hr_api.g_varchar2
243: ,p_information14 in varchar2 default hr_api.g_varchar2
244: ,p_information15 in varchar2 default hr_api.g_varchar2
245: ,p_information16 in varchar2 default hr_api.g_varchar2
238: ,p_information9 in varchar2 default hr_api.g_varchar2
239: ,p_information10 in varchar2 default hr_api.g_varchar2
240: ,p_information11 in varchar2 default hr_api.g_varchar2
241: ,p_information12 in varchar2 default hr_api.g_varchar2
242: ,p_information13 in varchar2 default hr_api.g_varchar2
243: ,p_information14 in varchar2 default hr_api.g_varchar2
244: ,p_information15 in varchar2 default hr_api.g_varchar2
245: ,p_information16 in varchar2 default hr_api.g_varchar2
246: ,p_information17 in varchar2 default hr_api.g_varchar2
239: ,p_information10 in varchar2 default hr_api.g_varchar2
240: ,p_information11 in varchar2 default hr_api.g_varchar2
241: ,p_information12 in varchar2 default hr_api.g_varchar2
242: ,p_information13 in varchar2 default hr_api.g_varchar2
243: ,p_information14 in varchar2 default hr_api.g_varchar2
244: ,p_information15 in varchar2 default hr_api.g_varchar2
245: ,p_information16 in varchar2 default hr_api.g_varchar2
246: ,p_information17 in varchar2 default hr_api.g_varchar2
247: ,p_information18 in varchar2 default hr_api.g_varchar2
240: ,p_information11 in varchar2 default hr_api.g_varchar2
241: ,p_information12 in varchar2 default hr_api.g_varchar2
242: ,p_information13 in varchar2 default hr_api.g_varchar2
243: ,p_information14 in varchar2 default hr_api.g_varchar2
244: ,p_information15 in varchar2 default hr_api.g_varchar2
245: ,p_information16 in varchar2 default hr_api.g_varchar2
246: ,p_information17 in varchar2 default hr_api.g_varchar2
247: ,p_information18 in varchar2 default hr_api.g_varchar2
248: ,p_information19 in varchar2 default hr_api.g_varchar2
241: ,p_information12 in varchar2 default hr_api.g_varchar2
242: ,p_information13 in varchar2 default hr_api.g_varchar2
243: ,p_information14 in varchar2 default hr_api.g_varchar2
244: ,p_information15 in varchar2 default hr_api.g_varchar2
245: ,p_information16 in varchar2 default hr_api.g_varchar2
246: ,p_information17 in varchar2 default hr_api.g_varchar2
247: ,p_information18 in varchar2 default hr_api.g_varchar2
248: ,p_information19 in varchar2 default hr_api.g_varchar2
249: ,p_information20 in varchar2 default hr_api.g_varchar2
242: ,p_information13 in varchar2 default hr_api.g_varchar2
243: ,p_information14 in varchar2 default hr_api.g_varchar2
244: ,p_information15 in varchar2 default hr_api.g_varchar2
245: ,p_information16 in varchar2 default hr_api.g_varchar2
246: ,p_information17 in varchar2 default hr_api.g_varchar2
247: ,p_information18 in varchar2 default hr_api.g_varchar2
248: ,p_information19 in varchar2 default hr_api.g_varchar2
249: ,p_information20 in varchar2 default hr_api.g_varchar2
250: ,p_information21 in varchar2 default hr_api.g_varchar2
243: ,p_information14 in varchar2 default hr_api.g_varchar2
244: ,p_information15 in varchar2 default hr_api.g_varchar2
245: ,p_information16 in varchar2 default hr_api.g_varchar2
246: ,p_information17 in varchar2 default hr_api.g_varchar2
247: ,p_information18 in varchar2 default hr_api.g_varchar2
248: ,p_information19 in varchar2 default hr_api.g_varchar2
249: ,p_information20 in varchar2 default hr_api.g_varchar2
250: ,p_information21 in varchar2 default hr_api.g_varchar2
251: ,p_information22 in varchar2 default hr_api.g_varchar2
244: ,p_information15 in varchar2 default hr_api.g_varchar2
245: ,p_information16 in varchar2 default hr_api.g_varchar2
246: ,p_information17 in varchar2 default hr_api.g_varchar2
247: ,p_information18 in varchar2 default hr_api.g_varchar2
248: ,p_information19 in varchar2 default hr_api.g_varchar2
249: ,p_information20 in varchar2 default hr_api.g_varchar2
250: ,p_information21 in varchar2 default hr_api.g_varchar2
251: ,p_information22 in varchar2 default hr_api.g_varchar2
252: ,p_information23 in varchar2 default hr_api.g_varchar2
245: ,p_information16 in varchar2 default hr_api.g_varchar2
246: ,p_information17 in varchar2 default hr_api.g_varchar2
247: ,p_information18 in varchar2 default hr_api.g_varchar2
248: ,p_information19 in varchar2 default hr_api.g_varchar2
249: ,p_information20 in varchar2 default hr_api.g_varchar2
250: ,p_information21 in varchar2 default hr_api.g_varchar2
251: ,p_information22 in varchar2 default hr_api.g_varchar2
252: ,p_information23 in varchar2 default hr_api.g_varchar2
253: ,p_information24 in varchar2 default hr_api.g_varchar2
246: ,p_information17 in varchar2 default hr_api.g_varchar2
247: ,p_information18 in varchar2 default hr_api.g_varchar2
248: ,p_information19 in varchar2 default hr_api.g_varchar2
249: ,p_information20 in varchar2 default hr_api.g_varchar2
250: ,p_information21 in varchar2 default hr_api.g_varchar2
251: ,p_information22 in varchar2 default hr_api.g_varchar2
252: ,p_information23 in varchar2 default hr_api.g_varchar2
253: ,p_information24 in varchar2 default hr_api.g_varchar2
254: ,p_information25 in varchar2 default hr_api.g_varchar2
247: ,p_information18 in varchar2 default hr_api.g_varchar2
248: ,p_information19 in varchar2 default hr_api.g_varchar2
249: ,p_information20 in varchar2 default hr_api.g_varchar2
250: ,p_information21 in varchar2 default hr_api.g_varchar2
251: ,p_information22 in varchar2 default hr_api.g_varchar2
252: ,p_information23 in varchar2 default hr_api.g_varchar2
253: ,p_information24 in varchar2 default hr_api.g_varchar2
254: ,p_information25 in varchar2 default hr_api.g_varchar2
255: ,p_information26 in varchar2 default hr_api.g_varchar2
248: ,p_information19 in varchar2 default hr_api.g_varchar2
249: ,p_information20 in varchar2 default hr_api.g_varchar2
250: ,p_information21 in varchar2 default hr_api.g_varchar2
251: ,p_information22 in varchar2 default hr_api.g_varchar2
252: ,p_information23 in varchar2 default hr_api.g_varchar2
253: ,p_information24 in varchar2 default hr_api.g_varchar2
254: ,p_information25 in varchar2 default hr_api.g_varchar2
255: ,p_information26 in varchar2 default hr_api.g_varchar2
256: ,p_information27 in varchar2 default hr_api.g_varchar2
249: ,p_information20 in varchar2 default hr_api.g_varchar2
250: ,p_information21 in varchar2 default hr_api.g_varchar2
251: ,p_information22 in varchar2 default hr_api.g_varchar2
252: ,p_information23 in varchar2 default hr_api.g_varchar2
253: ,p_information24 in varchar2 default hr_api.g_varchar2
254: ,p_information25 in varchar2 default hr_api.g_varchar2
255: ,p_information26 in varchar2 default hr_api.g_varchar2
256: ,p_information27 in varchar2 default hr_api.g_varchar2
257: ,p_information28 in varchar2 default hr_api.g_varchar2
250: ,p_information21 in varchar2 default hr_api.g_varchar2
251: ,p_information22 in varchar2 default hr_api.g_varchar2
252: ,p_information23 in varchar2 default hr_api.g_varchar2
253: ,p_information24 in varchar2 default hr_api.g_varchar2
254: ,p_information25 in varchar2 default hr_api.g_varchar2
255: ,p_information26 in varchar2 default hr_api.g_varchar2
256: ,p_information27 in varchar2 default hr_api.g_varchar2
257: ,p_information28 in varchar2 default hr_api.g_varchar2
258: ,p_information29 in varchar2 default hr_api.g_varchar2
251: ,p_information22 in varchar2 default hr_api.g_varchar2
252: ,p_information23 in varchar2 default hr_api.g_varchar2
253: ,p_information24 in varchar2 default hr_api.g_varchar2
254: ,p_information25 in varchar2 default hr_api.g_varchar2
255: ,p_information26 in varchar2 default hr_api.g_varchar2
256: ,p_information27 in varchar2 default hr_api.g_varchar2
257: ,p_information28 in varchar2 default hr_api.g_varchar2
258: ,p_information29 in varchar2 default hr_api.g_varchar2
259: ,p_information30 in varchar2 default hr_api.g_varchar2
252: ,p_information23 in varchar2 default hr_api.g_varchar2
253: ,p_information24 in varchar2 default hr_api.g_varchar2
254: ,p_information25 in varchar2 default hr_api.g_varchar2
255: ,p_information26 in varchar2 default hr_api.g_varchar2
256: ,p_information27 in varchar2 default hr_api.g_varchar2
257: ,p_information28 in varchar2 default hr_api.g_varchar2
258: ,p_information29 in varchar2 default hr_api.g_varchar2
259: ,p_information30 in varchar2 default hr_api.g_varchar2
260: );
253: ,p_information24 in varchar2 default hr_api.g_varchar2
254: ,p_information25 in varchar2 default hr_api.g_varchar2
255: ,p_information26 in varchar2 default hr_api.g_varchar2
256: ,p_information27 in varchar2 default hr_api.g_varchar2
257: ,p_information28 in varchar2 default hr_api.g_varchar2
258: ,p_information29 in varchar2 default hr_api.g_varchar2
259: ,p_information30 in varchar2 default hr_api.g_varchar2
260: );
261: --
254: ,p_information25 in varchar2 default hr_api.g_varchar2
255: ,p_information26 in varchar2 default hr_api.g_varchar2
256: ,p_information27 in varchar2 default hr_api.g_varchar2
257: ,p_information28 in varchar2 default hr_api.g_varchar2
258: ,p_information29 in varchar2 default hr_api.g_varchar2
259: ,p_information30 in varchar2 default hr_api.g_varchar2
260: );
261: --
262: -- ----------------------------------------------------------------------------
255: ,p_information26 in varchar2 default hr_api.g_varchar2
256: ,p_information27 in varchar2 default hr_api.g_varchar2
257: ,p_information28 in varchar2 default hr_api.g_varchar2
258: ,p_information29 in varchar2 default hr_api.g_varchar2
259: ,p_information30 in varchar2 default hr_api.g_varchar2
260: );
261: --
262: -- ----------------------------------------------------------------------------
263: -- |-------------------------------< delete_role >----------------------------|