8: -- ----------------------------------------------------------------------------
9: -- |-----------------------< create_copy_entity_attrib >----------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_copy_entity_attrib
12: (p_validate in number default hr_api.g_false_num
13: ,p_copy_entity_attrib_id out nocopy number
14: ,p_copy_entity_txn_id in number default null
15: ,p_row_type_cd in varchar2 default null
16: ,p_information_category in varchar2 default null
72: --
73: -- Convert constant values to their corresponding boolean value
74: --
75: l_validate :=
76: hr_api.constant_to_boolean
77: (p_constant_value => p_validate);
78: --
79: -- Register Surrogate ID or user key values
80: --
174: -- ----------------------------------------------------------------------------
175: -- |-----------------------< delete_copy_entity_attrib >----------------------|
176: -- ----------------------------------------------------------------------------
177: PROCEDURE delete_copy_entity_attrib
178: (p_validate in number default hr_api.g_false_num
179: ,p_copy_entity_attrib_id in number
180: ,p_object_version_number in number
181: ,p_effective_date in date
182: ,p_return_status out nocopy varchar2
205: --
206: -- Convert constant values to their corresponding boolean value
207: --
208: l_validate :=
209: hr_api.constant_to_boolean
210: (p_constant_value => p_validate);
211: --
212: -- Register Surrogate ID or user key values
213: --
270: -- ----------------------------------------------------------------------------
271: -- |-----------------------< update_copy_entity_attrib >----------------------|
272: -- ----------------------------------------------------------------------------
273: PROCEDURE update_copy_entity_attrib
274: (p_validate in number default hr_api.g_false_num
275: ,p_copy_entity_attrib_id in number
276: ,p_copy_entity_txn_id in number default hr_api.g_number
277: ,p_row_type_cd in varchar2 default hr_api.g_varchar2
278: ,p_information_category in varchar2 default hr_api.g_varchar2
272: -- ----------------------------------------------------------------------------
273: PROCEDURE update_copy_entity_attrib
274: (p_validate in number default hr_api.g_false_num
275: ,p_copy_entity_attrib_id in number
276: ,p_copy_entity_txn_id in number default hr_api.g_number
277: ,p_row_type_cd in varchar2 default hr_api.g_varchar2
278: ,p_information_category in varchar2 default hr_api.g_varchar2
279: ,p_information1 in varchar2 default hr_api.g_varchar2
280: ,p_information2 in varchar2 default hr_api.g_varchar2
273: PROCEDURE update_copy_entity_attrib
274: (p_validate in number default hr_api.g_false_num
275: ,p_copy_entity_attrib_id in number
276: ,p_copy_entity_txn_id in number default hr_api.g_number
277: ,p_row_type_cd in varchar2 default hr_api.g_varchar2
278: ,p_information_category in varchar2 default hr_api.g_varchar2
279: ,p_information1 in varchar2 default hr_api.g_varchar2
280: ,p_information2 in varchar2 default hr_api.g_varchar2
281: ,p_information3 in varchar2 default hr_api.g_varchar2
274: (p_validate in number default hr_api.g_false_num
275: ,p_copy_entity_attrib_id in number
276: ,p_copy_entity_txn_id in number default hr_api.g_number
277: ,p_row_type_cd in varchar2 default hr_api.g_varchar2
278: ,p_information_category in varchar2 default hr_api.g_varchar2
279: ,p_information1 in varchar2 default hr_api.g_varchar2
280: ,p_information2 in varchar2 default hr_api.g_varchar2
281: ,p_information3 in varchar2 default hr_api.g_varchar2
282: ,p_information4 in varchar2 default hr_api.g_varchar2
275: ,p_copy_entity_attrib_id in number
276: ,p_copy_entity_txn_id in number default hr_api.g_number
277: ,p_row_type_cd in varchar2 default hr_api.g_varchar2
278: ,p_information_category in varchar2 default hr_api.g_varchar2
279: ,p_information1 in varchar2 default hr_api.g_varchar2
280: ,p_information2 in varchar2 default hr_api.g_varchar2
281: ,p_information3 in varchar2 default hr_api.g_varchar2
282: ,p_information4 in varchar2 default hr_api.g_varchar2
283: ,p_information5 in varchar2 default hr_api.g_varchar2
276: ,p_copy_entity_txn_id in number default hr_api.g_number
277: ,p_row_type_cd in varchar2 default hr_api.g_varchar2
278: ,p_information_category in varchar2 default hr_api.g_varchar2
279: ,p_information1 in varchar2 default hr_api.g_varchar2
280: ,p_information2 in varchar2 default hr_api.g_varchar2
281: ,p_information3 in varchar2 default hr_api.g_varchar2
282: ,p_information4 in varchar2 default hr_api.g_varchar2
283: ,p_information5 in varchar2 default hr_api.g_varchar2
284: ,p_information6 in varchar2 default hr_api.g_varchar2
277: ,p_row_type_cd in varchar2 default hr_api.g_varchar2
278: ,p_information_category in varchar2 default hr_api.g_varchar2
279: ,p_information1 in varchar2 default hr_api.g_varchar2
280: ,p_information2 in varchar2 default hr_api.g_varchar2
281: ,p_information3 in varchar2 default hr_api.g_varchar2
282: ,p_information4 in varchar2 default hr_api.g_varchar2
283: ,p_information5 in varchar2 default hr_api.g_varchar2
284: ,p_information6 in varchar2 default hr_api.g_varchar2
285: ,p_information7 in varchar2 default hr_api.g_varchar2
278: ,p_information_category in varchar2 default hr_api.g_varchar2
279: ,p_information1 in varchar2 default hr_api.g_varchar2
280: ,p_information2 in varchar2 default hr_api.g_varchar2
281: ,p_information3 in varchar2 default hr_api.g_varchar2
282: ,p_information4 in varchar2 default hr_api.g_varchar2
283: ,p_information5 in varchar2 default hr_api.g_varchar2
284: ,p_information6 in varchar2 default hr_api.g_varchar2
285: ,p_information7 in varchar2 default hr_api.g_varchar2
286: ,p_information8 in varchar2 default hr_api.g_varchar2
279: ,p_information1 in varchar2 default hr_api.g_varchar2
280: ,p_information2 in varchar2 default hr_api.g_varchar2
281: ,p_information3 in varchar2 default hr_api.g_varchar2
282: ,p_information4 in varchar2 default hr_api.g_varchar2
283: ,p_information5 in varchar2 default hr_api.g_varchar2
284: ,p_information6 in varchar2 default hr_api.g_varchar2
285: ,p_information7 in varchar2 default hr_api.g_varchar2
286: ,p_information8 in varchar2 default hr_api.g_varchar2
287: ,p_information9 in varchar2 default hr_api.g_varchar2
280: ,p_information2 in varchar2 default hr_api.g_varchar2
281: ,p_information3 in varchar2 default hr_api.g_varchar2
282: ,p_information4 in varchar2 default hr_api.g_varchar2
283: ,p_information5 in varchar2 default hr_api.g_varchar2
284: ,p_information6 in varchar2 default hr_api.g_varchar2
285: ,p_information7 in varchar2 default hr_api.g_varchar2
286: ,p_information8 in varchar2 default hr_api.g_varchar2
287: ,p_information9 in varchar2 default hr_api.g_varchar2
288: ,p_information10 in varchar2 default hr_api.g_varchar2
281: ,p_information3 in varchar2 default hr_api.g_varchar2
282: ,p_information4 in varchar2 default hr_api.g_varchar2
283: ,p_information5 in varchar2 default hr_api.g_varchar2
284: ,p_information6 in varchar2 default hr_api.g_varchar2
285: ,p_information7 in varchar2 default hr_api.g_varchar2
286: ,p_information8 in varchar2 default hr_api.g_varchar2
287: ,p_information9 in varchar2 default hr_api.g_varchar2
288: ,p_information10 in varchar2 default hr_api.g_varchar2
289: ,p_information11 in varchar2 default hr_api.g_varchar2
282: ,p_information4 in varchar2 default hr_api.g_varchar2
283: ,p_information5 in varchar2 default hr_api.g_varchar2
284: ,p_information6 in varchar2 default hr_api.g_varchar2
285: ,p_information7 in varchar2 default hr_api.g_varchar2
286: ,p_information8 in varchar2 default hr_api.g_varchar2
287: ,p_information9 in varchar2 default hr_api.g_varchar2
288: ,p_information10 in varchar2 default hr_api.g_varchar2
289: ,p_information11 in varchar2 default hr_api.g_varchar2
290: ,p_information12 in varchar2 default hr_api.g_varchar2
283: ,p_information5 in varchar2 default hr_api.g_varchar2
284: ,p_information6 in varchar2 default hr_api.g_varchar2
285: ,p_information7 in varchar2 default hr_api.g_varchar2
286: ,p_information8 in varchar2 default hr_api.g_varchar2
287: ,p_information9 in varchar2 default hr_api.g_varchar2
288: ,p_information10 in varchar2 default hr_api.g_varchar2
289: ,p_information11 in varchar2 default hr_api.g_varchar2
290: ,p_information12 in varchar2 default hr_api.g_varchar2
291: ,p_information13 in varchar2 default hr_api.g_varchar2
284: ,p_information6 in varchar2 default hr_api.g_varchar2
285: ,p_information7 in varchar2 default hr_api.g_varchar2
286: ,p_information8 in varchar2 default hr_api.g_varchar2
287: ,p_information9 in varchar2 default hr_api.g_varchar2
288: ,p_information10 in varchar2 default hr_api.g_varchar2
289: ,p_information11 in varchar2 default hr_api.g_varchar2
290: ,p_information12 in varchar2 default hr_api.g_varchar2
291: ,p_information13 in varchar2 default hr_api.g_varchar2
292: ,p_information14 in varchar2 default hr_api.g_varchar2
285: ,p_information7 in varchar2 default hr_api.g_varchar2
286: ,p_information8 in varchar2 default hr_api.g_varchar2
287: ,p_information9 in varchar2 default hr_api.g_varchar2
288: ,p_information10 in varchar2 default hr_api.g_varchar2
289: ,p_information11 in varchar2 default hr_api.g_varchar2
290: ,p_information12 in varchar2 default hr_api.g_varchar2
291: ,p_information13 in varchar2 default hr_api.g_varchar2
292: ,p_information14 in varchar2 default hr_api.g_varchar2
293: ,p_information15 in varchar2 default hr_api.g_varchar2
286: ,p_information8 in varchar2 default hr_api.g_varchar2
287: ,p_information9 in varchar2 default hr_api.g_varchar2
288: ,p_information10 in varchar2 default hr_api.g_varchar2
289: ,p_information11 in varchar2 default hr_api.g_varchar2
290: ,p_information12 in varchar2 default hr_api.g_varchar2
291: ,p_information13 in varchar2 default hr_api.g_varchar2
292: ,p_information14 in varchar2 default hr_api.g_varchar2
293: ,p_information15 in varchar2 default hr_api.g_varchar2
294: ,p_information16 in varchar2 default hr_api.g_varchar2
287: ,p_information9 in varchar2 default hr_api.g_varchar2
288: ,p_information10 in varchar2 default hr_api.g_varchar2
289: ,p_information11 in varchar2 default hr_api.g_varchar2
290: ,p_information12 in varchar2 default hr_api.g_varchar2
291: ,p_information13 in varchar2 default hr_api.g_varchar2
292: ,p_information14 in varchar2 default hr_api.g_varchar2
293: ,p_information15 in varchar2 default hr_api.g_varchar2
294: ,p_information16 in varchar2 default hr_api.g_varchar2
295: ,p_information17 in varchar2 default hr_api.g_varchar2
288: ,p_information10 in varchar2 default hr_api.g_varchar2
289: ,p_information11 in varchar2 default hr_api.g_varchar2
290: ,p_information12 in varchar2 default hr_api.g_varchar2
291: ,p_information13 in varchar2 default hr_api.g_varchar2
292: ,p_information14 in varchar2 default hr_api.g_varchar2
293: ,p_information15 in varchar2 default hr_api.g_varchar2
294: ,p_information16 in varchar2 default hr_api.g_varchar2
295: ,p_information17 in varchar2 default hr_api.g_varchar2
296: ,p_information18 in varchar2 default hr_api.g_varchar2
289: ,p_information11 in varchar2 default hr_api.g_varchar2
290: ,p_information12 in varchar2 default hr_api.g_varchar2
291: ,p_information13 in varchar2 default hr_api.g_varchar2
292: ,p_information14 in varchar2 default hr_api.g_varchar2
293: ,p_information15 in varchar2 default hr_api.g_varchar2
294: ,p_information16 in varchar2 default hr_api.g_varchar2
295: ,p_information17 in varchar2 default hr_api.g_varchar2
296: ,p_information18 in varchar2 default hr_api.g_varchar2
297: ,p_information19 in varchar2 default hr_api.g_varchar2
290: ,p_information12 in varchar2 default hr_api.g_varchar2
291: ,p_information13 in varchar2 default hr_api.g_varchar2
292: ,p_information14 in varchar2 default hr_api.g_varchar2
293: ,p_information15 in varchar2 default hr_api.g_varchar2
294: ,p_information16 in varchar2 default hr_api.g_varchar2
295: ,p_information17 in varchar2 default hr_api.g_varchar2
296: ,p_information18 in varchar2 default hr_api.g_varchar2
297: ,p_information19 in varchar2 default hr_api.g_varchar2
298: ,p_information20 in varchar2 default hr_api.g_varchar2
291: ,p_information13 in varchar2 default hr_api.g_varchar2
292: ,p_information14 in varchar2 default hr_api.g_varchar2
293: ,p_information15 in varchar2 default hr_api.g_varchar2
294: ,p_information16 in varchar2 default hr_api.g_varchar2
295: ,p_information17 in varchar2 default hr_api.g_varchar2
296: ,p_information18 in varchar2 default hr_api.g_varchar2
297: ,p_information19 in varchar2 default hr_api.g_varchar2
298: ,p_information20 in varchar2 default hr_api.g_varchar2
299: ,p_information21 in varchar2 default hr_api.g_varchar2
292: ,p_information14 in varchar2 default hr_api.g_varchar2
293: ,p_information15 in varchar2 default hr_api.g_varchar2
294: ,p_information16 in varchar2 default hr_api.g_varchar2
295: ,p_information17 in varchar2 default hr_api.g_varchar2
296: ,p_information18 in varchar2 default hr_api.g_varchar2
297: ,p_information19 in varchar2 default hr_api.g_varchar2
298: ,p_information20 in varchar2 default hr_api.g_varchar2
299: ,p_information21 in varchar2 default hr_api.g_varchar2
300: ,p_information22 in varchar2 default hr_api.g_varchar2
293: ,p_information15 in varchar2 default hr_api.g_varchar2
294: ,p_information16 in varchar2 default hr_api.g_varchar2
295: ,p_information17 in varchar2 default hr_api.g_varchar2
296: ,p_information18 in varchar2 default hr_api.g_varchar2
297: ,p_information19 in varchar2 default hr_api.g_varchar2
298: ,p_information20 in varchar2 default hr_api.g_varchar2
299: ,p_information21 in varchar2 default hr_api.g_varchar2
300: ,p_information22 in varchar2 default hr_api.g_varchar2
301: ,p_information23 in varchar2 default hr_api.g_varchar2
294: ,p_information16 in varchar2 default hr_api.g_varchar2
295: ,p_information17 in varchar2 default hr_api.g_varchar2
296: ,p_information18 in varchar2 default hr_api.g_varchar2
297: ,p_information19 in varchar2 default hr_api.g_varchar2
298: ,p_information20 in varchar2 default hr_api.g_varchar2
299: ,p_information21 in varchar2 default hr_api.g_varchar2
300: ,p_information22 in varchar2 default hr_api.g_varchar2
301: ,p_information23 in varchar2 default hr_api.g_varchar2
302: ,p_information24 in varchar2 default hr_api.g_varchar2
295: ,p_information17 in varchar2 default hr_api.g_varchar2
296: ,p_information18 in varchar2 default hr_api.g_varchar2
297: ,p_information19 in varchar2 default hr_api.g_varchar2
298: ,p_information20 in varchar2 default hr_api.g_varchar2
299: ,p_information21 in varchar2 default hr_api.g_varchar2
300: ,p_information22 in varchar2 default hr_api.g_varchar2
301: ,p_information23 in varchar2 default hr_api.g_varchar2
302: ,p_information24 in varchar2 default hr_api.g_varchar2
303: ,p_information25 in varchar2 default hr_api.g_varchar2
296: ,p_information18 in varchar2 default hr_api.g_varchar2
297: ,p_information19 in varchar2 default hr_api.g_varchar2
298: ,p_information20 in varchar2 default hr_api.g_varchar2
299: ,p_information21 in varchar2 default hr_api.g_varchar2
300: ,p_information22 in varchar2 default hr_api.g_varchar2
301: ,p_information23 in varchar2 default hr_api.g_varchar2
302: ,p_information24 in varchar2 default hr_api.g_varchar2
303: ,p_information25 in varchar2 default hr_api.g_varchar2
304: ,p_information26 in varchar2 default hr_api.g_varchar2
297: ,p_information19 in varchar2 default hr_api.g_varchar2
298: ,p_information20 in varchar2 default hr_api.g_varchar2
299: ,p_information21 in varchar2 default hr_api.g_varchar2
300: ,p_information22 in varchar2 default hr_api.g_varchar2
301: ,p_information23 in varchar2 default hr_api.g_varchar2
302: ,p_information24 in varchar2 default hr_api.g_varchar2
303: ,p_information25 in varchar2 default hr_api.g_varchar2
304: ,p_information26 in varchar2 default hr_api.g_varchar2
305: ,p_information27 in varchar2 default hr_api.g_varchar2
298: ,p_information20 in varchar2 default hr_api.g_varchar2
299: ,p_information21 in varchar2 default hr_api.g_varchar2
300: ,p_information22 in varchar2 default hr_api.g_varchar2
301: ,p_information23 in varchar2 default hr_api.g_varchar2
302: ,p_information24 in varchar2 default hr_api.g_varchar2
303: ,p_information25 in varchar2 default hr_api.g_varchar2
304: ,p_information26 in varchar2 default hr_api.g_varchar2
305: ,p_information27 in varchar2 default hr_api.g_varchar2
306: ,p_information28 in varchar2 default hr_api.g_varchar2
299: ,p_information21 in varchar2 default hr_api.g_varchar2
300: ,p_information22 in varchar2 default hr_api.g_varchar2
301: ,p_information23 in varchar2 default hr_api.g_varchar2
302: ,p_information24 in varchar2 default hr_api.g_varchar2
303: ,p_information25 in varchar2 default hr_api.g_varchar2
304: ,p_information26 in varchar2 default hr_api.g_varchar2
305: ,p_information27 in varchar2 default hr_api.g_varchar2
306: ,p_information28 in varchar2 default hr_api.g_varchar2
307: ,p_information29 in varchar2 default hr_api.g_varchar2
300: ,p_information22 in varchar2 default hr_api.g_varchar2
301: ,p_information23 in varchar2 default hr_api.g_varchar2
302: ,p_information24 in varchar2 default hr_api.g_varchar2
303: ,p_information25 in varchar2 default hr_api.g_varchar2
304: ,p_information26 in varchar2 default hr_api.g_varchar2
305: ,p_information27 in varchar2 default hr_api.g_varchar2
306: ,p_information28 in varchar2 default hr_api.g_varchar2
307: ,p_information29 in varchar2 default hr_api.g_varchar2
308: ,p_information30 in varchar2 default hr_api.g_varchar2
301: ,p_information23 in varchar2 default hr_api.g_varchar2
302: ,p_information24 in varchar2 default hr_api.g_varchar2
303: ,p_information25 in varchar2 default hr_api.g_varchar2
304: ,p_information26 in varchar2 default hr_api.g_varchar2
305: ,p_information27 in varchar2 default hr_api.g_varchar2
306: ,p_information28 in varchar2 default hr_api.g_varchar2
307: ,p_information29 in varchar2 default hr_api.g_varchar2
308: ,p_information30 in varchar2 default hr_api.g_varchar2
309: ,p_object_version_number in out nocopy number
302: ,p_information24 in varchar2 default hr_api.g_varchar2
303: ,p_information25 in varchar2 default hr_api.g_varchar2
304: ,p_information26 in varchar2 default hr_api.g_varchar2
305: ,p_information27 in varchar2 default hr_api.g_varchar2
306: ,p_information28 in varchar2 default hr_api.g_varchar2
307: ,p_information29 in varchar2 default hr_api.g_varchar2
308: ,p_information30 in varchar2 default hr_api.g_varchar2
309: ,p_object_version_number in out nocopy number
310: ,p_effective_date in date
303: ,p_information25 in varchar2 default hr_api.g_varchar2
304: ,p_information26 in varchar2 default hr_api.g_varchar2
305: ,p_information27 in varchar2 default hr_api.g_varchar2
306: ,p_information28 in varchar2 default hr_api.g_varchar2
307: ,p_information29 in varchar2 default hr_api.g_varchar2
308: ,p_information30 in varchar2 default hr_api.g_varchar2
309: ,p_object_version_number in out nocopy number
310: ,p_effective_date in date
311: ,p_return_status out nocopy varchar2
304: ,p_information26 in varchar2 default hr_api.g_varchar2
305: ,p_information27 in varchar2 default hr_api.g_varchar2
306: ,p_information28 in varchar2 default hr_api.g_varchar2
307: ,p_information29 in varchar2 default hr_api.g_varchar2
308: ,p_information30 in varchar2 default hr_api.g_varchar2
309: ,p_object_version_number in out nocopy number
310: ,p_effective_date in date
311: ,p_return_status out nocopy varchar2
312: ) is
336: --
337: -- Convert constant values to their corresponding boolean value
338: --
339: l_validate :=
340: hr_api.constant_to_boolean
341: (p_constant_value => p_validate);
342: --
343: -- Register Surrogate ID or user key values
344: --