[Home] [Help]
44: -- Internal Row Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure update_dml(p_rec in out nocopy pqh_pte_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin
125: --
126: Exception
127: When hr_api.check_integrity_violated Then
128: -- A check constraint has been violated
129: pqh_pte_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: pqh_pte_shd.constraint_error
129: pqh_pte_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: pqh_pte_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.unique_integrity_violated Then
136: -- Unique integrity has been violated
137: pqh_pte_shd.constraint_error
133: pqh_pte_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.unique_integrity_violated Then
136: -- Unique integrity has been violated
137: pqh_pte_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then
140: Raise;
141: End update_dml;
171: -- Internal Row Handler Use Only.
172: --
173: -- {End Of Comments}
174: -- ----------------------------------------------------------------------------
175: Procedure pre_update(p_rec in pqh_pte_shd.g_rec_type) is
176: --
177: l_proc varchar2(72) := g_package||'pre_update';
178: --
179: Begin
213: -- Internal Row Handler Use Only.
214: --
215: -- {End Of Comments}
216: -- ----------------------------------------------------------------------------
217: Procedure post_update(p_rec in pqh_pte_shd.g_rec_type) is
218: --
219: l_proc varchar2(72) := g_package||'post_update';
220: --
221: Begin
284: ,p_attribute18 =>p_rec.attribute18
285: ,p_attribute19 =>p_rec.attribute19
286: ,p_attribute20 =>p_rec.attribute20
287: ,p_object_version_number =>p_rec.object_version_number
288: ,p_information_type_o =>pqh_pte_shd.g_old_rec.information_type
289: ,p_position_transaction_id_o =>pqh_pte_shd.g_old_rec.position_transaction_id
290: ,p_position_extra_info_id_o =>pqh_pte_shd.g_old_rec.position_extra_info_id
291: ,p_information_category_o =>pqh_pte_shd.g_old_rec.information_category
292: ,p_information1_o =>pqh_pte_shd.g_old_rec.information1
285: ,p_attribute19 =>p_rec.attribute19
286: ,p_attribute20 =>p_rec.attribute20
287: ,p_object_version_number =>p_rec.object_version_number
288: ,p_information_type_o =>pqh_pte_shd.g_old_rec.information_type
289: ,p_position_transaction_id_o =>pqh_pte_shd.g_old_rec.position_transaction_id
290: ,p_position_extra_info_id_o =>pqh_pte_shd.g_old_rec.position_extra_info_id
291: ,p_information_category_o =>pqh_pte_shd.g_old_rec.information_category
292: ,p_information1_o =>pqh_pte_shd.g_old_rec.information1
293: ,p_information2_o =>pqh_pte_shd.g_old_rec.information2
286: ,p_attribute20 =>p_rec.attribute20
287: ,p_object_version_number =>p_rec.object_version_number
288: ,p_information_type_o =>pqh_pte_shd.g_old_rec.information_type
289: ,p_position_transaction_id_o =>pqh_pte_shd.g_old_rec.position_transaction_id
290: ,p_position_extra_info_id_o =>pqh_pte_shd.g_old_rec.position_extra_info_id
291: ,p_information_category_o =>pqh_pte_shd.g_old_rec.information_category
292: ,p_information1_o =>pqh_pte_shd.g_old_rec.information1
293: ,p_information2_o =>pqh_pte_shd.g_old_rec.information2
294: ,p_information3_o =>pqh_pte_shd.g_old_rec.information3
287: ,p_object_version_number =>p_rec.object_version_number
288: ,p_information_type_o =>pqh_pte_shd.g_old_rec.information_type
289: ,p_position_transaction_id_o =>pqh_pte_shd.g_old_rec.position_transaction_id
290: ,p_position_extra_info_id_o =>pqh_pte_shd.g_old_rec.position_extra_info_id
291: ,p_information_category_o =>pqh_pte_shd.g_old_rec.information_category
292: ,p_information1_o =>pqh_pte_shd.g_old_rec.information1
293: ,p_information2_o =>pqh_pte_shd.g_old_rec.information2
294: ,p_information3_o =>pqh_pte_shd.g_old_rec.information3
295: ,p_information4_o =>pqh_pte_shd.g_old_rec.information4
288: ,p_information_type_o =>pqh_pte_shd.g_old_rec.information_type
289: ,p_position_transaction_id_o =>pqh_pte_shd.g_old_rec.position_transaction_id
290: ,p_position_extra_info_id_o =>pqh_pte_shd.g_old_rec.position_extra_info_id
291: ,p_information_category_o =>pqh_pte_shd.g_old_rec.information_category
292: ,p_information1_o =>pqh_pte_shd.g_old_rec.information1
293: ,p_information2_o =>pqh_pte_shd.g_old_rec.information2
294: ,p_information3_o =>pqh_pte_shd.g_old_rec.information3
295: ,p_information4_o =>pqh_pte_shd.g_old_rec.information4
296: ,p_information5_o =>pqh_pte_shd.g_old_rec.information5
289: ,p_position_transaction_id_o =>pqh_pte_shd.g_old_rec.position_transaction_id
290: ,p_position_extra_info_id_o =>pqh_pte_shd.g_old_rec.position_extra_info_id
291: ,p_information_category_o =>pqh_pte_shd.g_old_rec.information_category
292: ,p_information1_o =>pqh_pte_shd.g_old_rec.information1
293: ,p_information2_o =>pqh_pte_shd.g_old_rec.information2
294: ,p_information3_o =>pqh_pte_shd.g_old_rec.information3
295: ,p_information4_o =>pqh_pte_shd.g_old_rec.information4
296: ,p_information5_o =>pqh_pte_shd.g_old_rec.information5
297: ,p_information6_o =>pqh_pte_shd.g_old_rec.information6
290: ,p_position_extra_info_id_o =>pqh_pte_shd.g_old_rec.position_extra_info_id
291: ,p_information_category_o =>pqh_pte_shd.g_old_rec.information_category
292: ,p_information1_o =>pqh_pte_shd.g_old_rec.information1
293: ,p_information2_o =>pqh_pte_shd.g_old_rec.information2
294: ,p_information3_o =>pqh_pte_shd.g_old_rec.information3
295: ,p_information4_o =>pqh_pte_shd.g_old_rec.information4
296: ,p_information5_o =>pqh_pte_shd.g_old_rec.information5
297: ,p_information6_o =>pqh_pte_shd.g_old_rec.information6
298: ,p_information7_o =>pqh_pte_shd.g_old_rec.information7
291: ,p_information_category_o =>pqh_pte_shd.g_old_rec.information_category
292: ,p_information1_o =>pqh_pte_shd.g_old_rec.information1
293: ,p_information2_o =>pqh_pte_shd.g_old_rec.information2
294: ,p_information3_o =>pqh_pte_shd.g_old_rec.information3
295: ,p_information4_o =>pqh_pte_shd.g_old_rec.information4
296: ,p_information5_o =>pqh_pte_shd.g_old_rec.information5
297: ,p_information6_o =>pqh_pte_shd.g_old_rec.information6
298: ,p_information7_o =>pqh_pte_shd.g_old_rec.information7
299: ,p_information8_o =>pqh_pte_shd.g_old_rec.information8
292: ,p_information1_o =>pqh_pte_shd.g_old_rec.information1
293: ,p_information2_o =>pqh_pte_shd.g_old_rec.information2
294: ,p_information3_o =>pqh_pte_shd.g_old_rec.information3
295: ,p_information4_o =>pqh_pte_shd.g_old_rec.information4
296: ,p_information5_o =>pqh_pte_shd.g_old_rec.information5
297: ,p_information6_o =>pqh_pte_shd.g_old_rec.information6
298: ,p_information7_o =>pqh_pte_shd.g_old_rec.information7
299: ,p_information8_o =>pqh_pte_shd.g_old_rec.information8
300: ,p_information9_o =>pqh_pte_shd.g_old_rec.information9
293: ,p_information2_o =>pqh_pte_shd.g_old_rec.information2
294: ,p_information3_o =>pqh_pte_shd.g_old_rec.information3
295: ,p_information4_o =>pqh_pte_shd.g_old_rec.information4
296: ,p_information5_o =>pqh_pte_shd.g_old_rec.information5
297: ,p_information6_o =>pqh_pte_shd.g_old_rec.information6
298: ,p_information7_o =>pqh_pte_shd.g_old_rec.information7
299: ,p_information8_o =>pqh_pte_shd.g_old_rec.information8
300: ,p_information9_o =>pqh_pte_shd.g_old_rec.information9
301: ,p_information10_o =>pqh_pte_shd.g_old_rec.information10
294: ,p_information3_o =>pqh_pte_shd.g_old_rec.information3
295: ,p_information4_o =>pqh_pte_shd.g_old_rec.information4
296: ,p_information5_o =>pqh_pte_shd.g_old_rec.information5
297: ,p_information6_o =>pqh_pte_shd.g_old_rec.information6
298: ,p_information7_o =>pqh_pte_shd.g_old_rec.information7
299: ,p_information8_o =>pqh_pte_shd.g_old_rec.information8
300: ,p_information9_o =>pqh_pte_shd.g_old_rec.information9
301: ,p_information10_o =>pqh_pte_shd.g_old_rec.information10
302: ,p_information11_o =>pqh_pte_shd.g_old_rec.information11
295: ,p_information4_o =>pqh_pte_shd.g_old_rec.information4
296: ,p_information5_o =>pqh_pte_shd.g_old_rec.information5
297: ,p_information6_o =>pqh_pte_shd.g_old_rec.information6
298: ,p_information7_o =>pqh_pte_shd.g_old_rec.information7
299: ,p_information8_o =>pqh_pte_shd.g_old_rec.information8
300: ,p_information9_o =>pqh_pte_shd.g_old_rec.information9
301: ,p_information10_o =>pqh_pte_shd.g_old_rec.information10
302: ,p_information11_o =>pqh_pte_shd.g_old_rec.information11
303: ,p_information12_o =>pqh_pte_shd.g_old_rec.information12
296: ,p_information5_o =>pqh_pte_shd.g_old_rec.information5
297: ,p_information6_o =>pqh_pte_shd.g_old_rec.information6
298: ,p_information7_o =>pqh_pte_shd.g_old_rec.information7
299: ,p_information8_o =>pqh_pte_shd.g_old_rec.information8
300: ,p_information9_o =>pqh_pte_shd.g_old_rec.information9
301: ,p_information10_o =>pqh_pte_shd.g_old_rec.information10
302: ,p_information11_o =>pqh_pte_shd.g_old_rec.information11
303: ,p_information12_o =>pqh_pte_shd.g_old_rec.information12
304: ,p_information13_o =>pqh_pte_shd.g_old_rec.information13
297: ,p_information6_o =>pqh_pte_shd.g_old_rec.information6
298: ,p_information7_o =>pqh_pte_shd.g_old_rec.information7
299: ,p_information8_o =>pqh_pte_shd.g_old_rec.information8
300: ,p_information9_o =>pqh_pte_shd.g_old_rec.information9
301: ,p_information10_o =>pqh_pte_shd.g_old_rec.information10
302: ,p_information11_o =>pqh_pte_shd.g_old_rec.information11
303: ,p_information12_o =>pqh_pte_shd.g_old_rec.information12
304: ,p_information13_o =>pqh_pte_shd.g_old_rec.information13
305: ,p_information14_o =>pqh_pte_shd.g_old_rec.information14
298: ,p_information7_o =>pqh_pte_shd.g_old_rec.information7
299: ,p_information8_o =>pqh_pte_shd.g_old_rec.information8
300: ,p_information9_o =>pqh_pte_shd.g_old_rec.information9
301: ,p_information10_o =>pqh_pte_shd.g_old_rec.information10
302: ,p_information11_o =>pqh_pte_shd.g_old_rec.information11
303: ,p_information12_o =>pqh_pte_shd.g_old_rec.information12
304: ,p_information13_o =>pqh_pte_shd.g_old_rec.information13
305: ,p_information14_o =>pqh_pte_shd.g_old_rec.information14
306: ,p_information15_o =>pqh_pte_shd.g_old_rec.information15
299: ,p_information8_o =>pqh_pte_shd.g_old_rec.information8
300: ,p_information9_o =>pqh_pte_shd.g_old_rec.information9
301: ,p_information10_o =>pqh_pte_shd.g_old_rec.information10
302: ,p_information11_o =>pqh_pte_shd.g_old_rec.information11
303: ,p_information12_o =>pqh_pte_shd.g_old_rec.information12
304: ,p_information13_o =>pqh_pte_shd.g_old_rec.information13
305: ,p_information14_o =>pqh_pte_shd.g_old_rec.information14
306: ,p_information15_o =>pqh_pte_shd.g_old_rec.information15
307: ,p_information16_o =>pqh_pte_shd.g_old_rec.information16
300: ,p_information9_o =>pqh_pte_shd.g_old_rec.information9
301: ,p_information10_o =>pqh_pte_shd.g_old_rec.information10
302: ,p_information11_o =>pqh_pte_shd.g_old_rec.information11
303: ,p_information12_o =>pqh_pte_shd.g_old_rec.information12
304: ,p_information13_o =>pqh_pte_shd.g_old_rec.information13
305: ,p_information14_o =>pqh_pte_shd.g_old_rec.information14
306: ,p_information15_o =>pqh_pte_shd.g_old_rec.information15
307: ,p_information16_o =>pqh_pte_shd.g_old_rec.information16
308: ,p_information17_o =>pqh_pte_shd.g_old_rec.information17
301: ,p_information10_o =>pqh_pte_shd.g_old_rec.information10
302: ,p_information11_o =>pqh_pte_shd.g_old_rec.information11
303: ,p_information12_o =>pqh_pte_shd.g_old_rec.information12
304: ,p_information13_o =>pqh_pte_shd.g_old_rec.information13
305: ,p_information14_o =>pqh_pte_shd.g_old_rec.information14
306: ,p_information15_o =>pqh_pte_shd.g_old_rec.information15
307: ,p_information16_o =>pqh_pte_shd.g_old_rec.information16
308: ,p_information17_o =>pqh_pte_shd.g_old_rec.information17
309: ,p_information18_o =>pqh_pte_shd.g_old_rec.information18
302: ,p_information11_o =>pqh_pte_shd.g_old_rec.information11
303: ,p_information12_o =>pqh_pte_shd.g_old_rec.information12
304: ,p_information13_o =>pqh_pte_shd.g_old_rec.information13
305: ,p_information14_o =>pqh_pte_shd.g_old_rec.information14
306: ,p_information15_o =>pqh_pte_shd.g_old_rec.information15
307: ,p_information16_o =>pqh_pte_shd.g_old_rec.information16
308: ,p_information17_o =>pqh_pte_shd.g_old_rec.information17
309: ,p_information18_o =>pqh_pte_shd.g_old_rec.information18
310: ,p_information19_o =>pqh_pte_shd.g_old_rec.information19
303: ,p_information12_o =>pqh_pte_shd.g_old_rec.information12
304: ,p_information13_o =>pqh_pte_shd.g_old_rec.information13
305: ,p_information14_o =>pqh_pte_shd.g_old_rec.information14
306: ,p_information15_o =>pqh_pte_shd.g_old_rec.information15
307: ,p_information16_o =>pqh_pte_shd.g_old_rec.information16
308: ,p_information17_o =>pqh_pte_shd.g_old_rec.information17
309: ,p_information18_o =>pqh_pte_shd.g_old_rec.information18
310: ,p_information19_o =>pqh_pte_shd.g_old_rec.information19
311: ,p_information20_o =>pqh_pte_shd.g_old_rec.information20
304: ,p_information13_o =>pqh_pte_shd.g_old_rec.information13
305: ,p_information14_o =>pqh_pte_shd.g_old_rec.information14
306: ,p_information15_o =>pqh_pte_shd.g_old_rec.information15
307: ,p_information16_o =>pqh_pte_shd.g_old_rec.information16
308: ,p_information17_o =>pqh_pte_shd.g_old_rec.information17
309: ,p_information18_o =>pqh_pte_shd.g_old_rec.information18
310: ,p_information19_o =>pqh_pte_shd.g_old_rec.information19
311: ,p_information20_o =>pqh_pte_shd.g_old_rec.information20
312: ,p_information21_o =>pqh_pte_shd.g_old_rec.information21
305: ,p_information14_o =>pqh_pte_shd.g_old_rec.information14
306: ,p_information15_o =>pqh_pte_shd.g_old_rec.information15
307: ,p_information16_o =>pqh_pte_shd.g_old_rec.information16
308: ,p_information17_o =>pqh_pte_shd.g_old_rec.information17
309: ,p_information18_o =>pqh_pte_shd.g_old_rec.information18
310: ,p_information19_o =>pqh_pte_shd.g_old_rec.information19
311: ,p_information20_o =>pqh_pte_shd.g_old_rec.information20
312: ,p_information21_o =>pqh_pte_shd.g_old_rec.information21
313: ,p_information22_o =>pqh_pte_shd.g_old_rec.information22
306: ,p_information15_o =>pqh_pte_shd.g_old_rec.information15
307: ,p_information16_o =>pqh_pte_shd.g_old_rec.information16
308: ,p_information17_o =>pqh_pte_shd.g_old_rec.information17
309: ,p_information18_o =>pqh_pte_shd.g_old_rec.information18
310: ,p_information19_o =>pqh_pte_shd.g_old_rec.information19
311: ,p_information20_o =>pqh_pte_shd.g_old_rec.information20
312: ,p_information21_o =>pqh_pte_shd.g_old_rec.information21
313: ,p_information22_o =>pqh_pte_shd.g_old_rec.information22
314: ,p_information23_o =>pqh_pte_shd.g_old_rec.information23
307: ,p_information16_o =>pqh_pte_shd.g_old_rec.information16
308: ,p_information17_o =>pqh_pte_shd.g_old_rec.information17
309: ,p_information18_o =>pqh_pte_shd.g_old_rec.information18
310: ,p_information19_o =>pqh_pte_shd.g_old_rec.information19
311: ,p_information20_o =>pqh_pte_shd.g_old_rec.information20
312: ,p_information21_o =>pqh_pte_shd.g_old_rec.information21
313: ,p_information22_o =>pqh_pte_shd.g_old_rec.information22
314: ,p_information23_o =>pqh_pte_shd.g_old_rec.information23
315: ,p_information24_o =>pqh_pte_shd.g_old_rec.information24
308: ,p_information17_o =>pqh_pte_shd.g_old_rec.information17
309: ,p_information18_o =>pqh_pte_shd.g_old_rec.information18
310: ,p_information19_o =>pqh_pte_shd.g_old_rec.information19
311: ,p_information20_o =>pqh_pte_shd.g_old_rec.information20
312: ,p_information21_o =>pqh_pte_shd.g_old_rec.information21
313: ,p_information22_o =>pqh_pte_shd.g_old_rec.information22
314: ,p_information23_o =>pqh_pte_shd.g_old_rec.information23
315: ,p_information24_o =>pqh_pte_shd.g_old_rec.information24
316: ,p_information25_o =>pqh_pte_shd.g_old_rec.information25
309: ,p_information18_o =>pqh_pte_shd.g_old_rec.information18
310: ,p_information19_o =>pqh_pte_shd.g_old_rec.information19
311: ,p_information20_o =>pqh_pte_shd.g_old_rec.information20
312: ,p_information21_o =>pqh_pte_shd.g_old_rec.information21
313: ,p_information22_o =>pqh_pte_shd.g_old_rec.information22
314: ,p_information23_o =>pqh_pte_shd.g_old_rec.information23
315: ,p_information24_o =>pqh_pte_shd.g_old_rec.information24
316: ,p_information25_o =>pqh_pte_shd.g_old_rec.information25
317: ,p_information26_o =>pqh_pte_shd.g_old_rec.information26
310: ,p_information19_o =>pqh_pte_shd.g_old_rec.information19
311: ,p_information20_o =>pqh_pte_shd.g_old_rec.information20
312: ,p_information21_o =>pqh_pte_shd.g_old_rec.information21
313: ,p_information22_o =>pqh_pte_shd.g_old_rec.information22
314: ,p_information23_o =>pqh_pte_shd.g_old_rec.information23
315: ,p_information24_o =>pqh_pte_shd.g_old_rec.information24
316: ,p_information25_o =>pqh_pte_shd.g_old_rec.information25
317: ,p_information26_o =>pqh_pte_shd.g_old_rec.information26
318: ,p_information27_o =>pqh_pte_shd.g_old_rec.information27
311: ,p_information20_o =>pqh_pte_shd.g_old_rec.information20
312: ,p_information21_o =>pqh_pte_shd.g_old_rec.information21
313: ,p_information22_o =>pqh_pte_shd.g_old_rec.information22
314: ,p_information23_o =>pqh_pte_shd.g_old_rec.information23
315: ,p_information24_o =>pqh_pte_shd.g_old_rec.information24
316: ,p_information25_o =>pqh_pte_shd.g_old_rec.information25
317: ,p_information26_o =>pqh_pte_shd.g_old_rec.information26
318: ,p_information27_o =>pqh_pte_shd.g_old_rec.information27
319: ,p_information28_o =>pqh_pte_shd.g_old_rec.information28
312: ,p_information21_o =>pqh_pte_shd.g_old_rec.information21
313: ,p_information22_o =>pqh_pte_shd.g_old_rec.information22
314: ,p_information23_o =>pqh_pte_shd.g_old_rec.information23
315: ,p_information24_o =>pqh_pte_shd.g_old_rec.information24
316: ,p_information25_o =>pqh_pte_shd.g_old_rec.information25
317: ,p_information26_o =>pqh_pte_shd.g_old_rec.information26
318: ,p_information27_o =>pqh_pte_shd.g_old_rec.information27
319: ,p_information28_o =>pqh_pte_shd.g_old_rec.information28
320: ,p_information29_o =>pqh_pte_shd.g_old_rec.information29
313: ,p_information22_o =>pqh_pte_shd.g_old_rec.information22
314: ,p_information23_o =>pqh_pte_shd.g_old_rec.information23
315: ,p_information24_o =>pqh_pte_shd.g_old_rec.information24
316: ,p_information25_o =>pqh_pte_shd.g_old_rec.information25
317: ,p_information26_o =>pqh_pte_shd.g_old_rec.information26
318: ,p_information27_o =>pqh_pte_shd.g_old_rec.information27
319: ,p_information28_o =>pqh_pte_shd.g_old_rec.information28
320: ,p_information29_o =>pqh_pte_shd.g_old_rec.information29
321: ,p_information30_o =>pqh_pte_shd.g_old_rec.information30
314: ,p_information23_o =>pqh_pte_shd.g_old_rec.information23
315: ,p_information24_o =>pqh_pte_shd.g_old_rec.information24
316: ,p_information25_o =>pqh_pte_shd.g_old_rec.information25
317: ,p_information26_o =>pqh_pte_shd.g_old_rec.information26
318: ,p_information27_o =>pqh_pte_shd.g_old_rec.information27
319: ,p_information28_o =>pqh_pte_shd.g_old_rec.information28
320: ,p_information29_o =>pqh_pte_shd.g_old_rec.information29
321: ,p_information30_o =>pqh_pte_shd.g_old_rec.information30
322: ,p_attribute_category_o =>pqh_pte_shd.g_old_rec.attribute_category
315: ,p_information24_o =>pqh_pte_shd.g_old_rec.information24
316: ,p_information25_o =>pqh_pte_shd.g_old_rec.information25
317: ,p_information26_o =>pqh_pte_shd.g_old_rec.information26
318: ,p_information27_o =>pqh_pte_shd.g_old_rec.information27
319: ,p_information28_o =>pqh_pte_shd.g_old_rec.information28
320: ,p_information29_o =>pqh_pte_shd.g_old_rec.information29
321: ,p_information30_o =>pqh_pte_shd.g_old_rec.information30
322: ,p_attribute_category_o =>pqh_pte_shd.g_old_rec.attribute_category
323: ,p_attribute1_o =>pqh_pte_shd.g_old_rec.attribute1
316: ,p_information25_o =>pqh_pte_shd.g_old_rec.information25
317: ,p_information26_o =>pqh_pte_shd.g_old_rec.information26
318: ,p_information27_o =>pqh_pte_shd.g_old_rec.information27
319: ,p_information28_o =>pqh_pte_shd.g_old_rec.information28
320: ,p_information29_o =>pqh_pte_shd.g_old_rec.information29
321: ,p_information30_o =>pqh_pte_shd.g_old_rec.information30
322: ,p_attribute_category_o =>pqh_pte_shd.g_old_rec.attribute_category
323: ,p_attribute1_o =>pqh_pte_shd.g_old_rec.attribute1
324: ,p_attribute2_o =>pqh_pte_shd.g_old_rec.attribute2
317: ,p_information26_o =>pqh_pte_shd.g_old_rec.information26
318: ,p_information27_o =>pqh_pte_shd.g_old_rec.information27
319: ,p_information28_o =>pqh_pte_shd.g_old_rec.information28
320: ,p_information29_o =>pqh_pte_shd.g_old_rec.information29
321: ,p_information30_o =>pqh_pte_shd.g_old_rec.information30
322: ,p_attribute_category_o =>pqh_pte_shd.g_old_rec.attribute_category
323: ,p_attribute1_o =>pqh_pte_shd.g_old_rec.attribute1
324: ,p_attribute2_o =>pqh_pte_shd.g_old_rec.attribute2
325: ,p_attribute3_o =>pqh_pte_shd.g_old_rec.attribute3
318: ,p_information27_o =>pqh_pte_shd.g_old_rec.information27
319: ,p_information28_o =>pqh_pte_shd.g_old_rec.information28
320: ,p_information29_o =>pqh_pte_shd.g_old_rec.information29
321: ,p_information30_o =>pqh_pte_shd.g_old_rec.information30
322: ,p_attribute_category_o =>pqh_pte_shd.g_old_rec.attribute_category
323: ,p_attribute1_o =>pqh_pte_shd.g_old_rec.attribute1
324: ,p_attribute2_o =>pqh_pte_shd.g_old_rec.attribute2
325: ,p_attribute3_o =>pqh_pte_shd.g_old_rec.attribute3
326: ,p_attribute4_o =>pqh_pte_shd.g_old_rec.attribute4
319: ,p_information28_o =>pqh_pte_shd.g_old_rec.information28
320: ,p_information29_o =>pqh_pte_shd.g_old_rec.information29
321: ,p_information30_o =>pqh_pte_shd.g_old_rec.information30
322: ,p_attribute_category_o =>pqh_pte_shd.g_old_rec.attribute_category
323: ,p_attribute1_o =>pqh_pte_shd.g_old_rec.attribute1
324: ,p_attribute2_o =>pqh_pte_shd.g_old_rec.attribute2
325: ,p_attribute3_o =>pqh_pte_shd.g_old_rec.attribute3
326: ,p_attribute4_o =>pqh_pte_shd.g_old_rec.attribute4
327: ,p_attribute5_o =>pqh_pte_shd.g_old_rec.attribute5
320: ,p_information29_o =>pqh_pte_shd.g_old_rec.information29
321: ,p_information30_o =>pqh_pte_shd.g_old_rec.information30
322: ,p_attribute_category_o =>pqh_pte_shd.g_old_rec.attribute_category
323: ,p_attribute1_o =>pqh_pte_shd.g_old_rec.attribute1
324: ,p_attribute2_o =>pqh_pte_shd.g_old_rec.attribute2
325: ,p_attribute3_o =>pqh_pte_shd.g_old_rec.attribute3
326: ,p_attribute4_o =>pqh_pte_shd.g_old_rec.attribute4
327: ,p_attribute5_o =>pqh_pte_shd.g_old_rec.attribute5
328: ,p_attribute6_o =>pqh_pte_shd.g_old_rec.attribute6
321: ,p_information30_o =>pqh_pte_shd.g_old_rec.information30
322: ,p_attribute_category_o =>pqh_pte_shd.g_old_rec.attribute_category
323: ,p_attribute1_o =>pqh_pte_shd.g_old_rec.attribute1
324: ,p_attribute2_o =>pqh_pte_shd.g_old_rec.attribute2
325: ,p_attribute3_o =>pqh_pte_shd.g_old_rec.attribute3
326: ,p_attribute4_o =>pqh_pte_shd.g_old_rec.attribute4
327: ,p_attribute5_o =>pqh_pte_shd.g_old_rec.attribute5
328: ,p_attribute6_o =>pqh_pte_shd.g_old_rec.attribute6
329: ,p_attribute7_o =>pqh_pte_shd.g_old_rec.attribute7
322: ,p_attribute_category_o =>pqh_pte_shd.g_old_rec.attribute_category
323: ,p_attribute1_o =>pqh_pte_shd.g_old_rec.attribute1
324: ,p_attribute2_o =>pqh_pte_shd.g_old_rec.attribute2
325: ,p_attribute3_o =>pqh_pte_shd.g_old_rec.attribute3
326: ,p_attribute4_o =>pqh_pte_shd.g_old_rec.attribute4
327: ,p_attribute5_o =>pqh_pte_shd.g_old_rec.attribute5
328: ,p_attribute6_o =>pqh_pte_shd.g_old_rec.attribute6
329: ,p_attribute7_o =>pqh_pte_shd.g_old_rec.attribute7
330: ,p_attribute8_o =>pqh_pte_shd.g_old_rec.attribute8
323: ,p_attribute1_o =>pqh_pte_shd.g_old_rec.attribute1
324: ,p_attribute2_o =>pqh_pte_shd.g_old_rec.attribute2
325: ,p_attribute3_o =>pqh_pte_shd.g_old_rec.attribute3
326: ,p_attribute4_o =>pqh_pte_shd.g_old_rec.attribute4
327: ,p_attribute5_o =>pqh_pte_shd.g_old_rec.attribute5
328: ,p_attribute6_o =>pqh_pte_shd.g_old_rec.attribute6
329: ,p_attribute7_o =>pqh_pte_shd.g_old_rec.attribute7
330: ,p_attribute8_o =>pqh_pte_shd.g_old_rec.attribute8
331: ,p_attribute9_o =>pqh_pte_shd.g_old_rec.attribute9
324: ,p_attribute2_o =>pqh_pte_shd.g_old_rec.attribute2
325: ,p_attribute3_o =>pqh_pte_shd.g_old_rec.attribute3
326: ,p_attribute4_o =>pqh_pte_shd.g_old_rec.attribute4
327: ,p_attribute5_o =>pqh_pte_shd.g_old_rec.attribute5
328: ,p_attribute6_o =>pqh_pte_shd.g_old_rec.attribute6
329: ,p_attribute7_o =>pqh_pte_shd.g_old_rec.attribute7
330: ,p_attribute8_o =>pqh_pte_shd.g_old_rec.attribute8
331: ,p_attribute9_o =>pqh_pte_shd.g_old_rec.attribute9
332: ,p_attribute10_o =>pqh_pte_shd.g_old_rec.attribute10
325: ,p_attribute3_o =>pqh_pte_shd.g_old_rec.attribute3
326: ,p_attribute4_o =>pqh_pte_shd.g_old_rec.attribute4
327: ,p_attribute5_o =>pqh_pte_shd.g_old_rec.attribute5
328: ,p_attribute6_o =>pqh_pte_shd.g_old_rec.attribute6
329: ,p_attribute7_o =>pqh_pte_shd.g_old_rec.attribute7
330: ,p_attribute8_o =>pqh_pte_shd.g_old_rec.attribute8
331: ,p_attribute9_o =>pqh_pte_shd.g_old_rec.attribute9
332: ,p_attribute10_o =>pqh_pte_shd.g_old_rec.attribute10
333: ,p_attribute11_o =>pqh_pte_shd.g_old_rec.attribute11
326: ,p_attribute4_o =>pqh_pte_shd.g_old_rec.attribute4
327: ,p_attribute5_o =>pqh_pte_shd.g_old_rec.attribute5
328: ,p_attribute6_o =>pqh_pte_shd.g_old_rec.attribute6
329: ,p_attribute7_o =>pqh_pte_shd.g_old_rec.attribute7
330: ,p_attribute8_o =>pqh_pte_shd.g_old_rec.attribute8
331: ,p_attribute9_o =>pqh_pte_shd.g_old_rec.attribute9
332: ,p_attribute10_o =>pqh_pte_shd.g_old_rec.attribute10
333: ,p_attribute11_o =>pqh_pte_shd.g_old_rec.attribute11
334: ,p_attribute12_o =>pqh_pte_shd.g_old_rec.attribute12
327: ,p_attribute5_o =>pqh_pte_shd.g_old_rec.attribute5
328: ,p_attribute6_o =>pqh_pte_shd.g_old_rec.attribute6
329: ,p_attribute7_o =>pqh_pte_shd.g_old_rec.attribute7
330: ,p_attribute8_o =>pqh_pte_shd.g_old_rec.attribute8
331: ,p_attribute9_o =>pqh_pte_shd.g_old_rec.attribute9
332: ,p_attribute10_o =>pqh_pte_shd.g_old_rec.attribute10
333: ,p_attribute11_o =>pqh_pte_shd.g_old_rec.attribute11
334: ,p_attribute12_o =>pqh_pte_shd.g_old_rec.attribute12
335: ,p_attribute13_o =>pqh_pte_shd.g_old_rec.attribute13
328: ,p_attribute6_o =>pqh_pte_shd.g_old_rec.attribute6
329: ,p_attribute7_o =>pqh_pte_shd.g_old_rec.attribute7
330: ,p_attribute8_o =>pqh_pte_shd.g_old_rec.attribute8
331: ,p_attribute9_o =>pqh_pte_shd.g_old_rec.attribute9
332: ,p_attribute10_o =>pqh_pte_shd.g_old_rec.attribute10
333: ,p_attribute11_o =>pqh_pte_shd.g_old_rec.attribute11
334: ,p_attribute12_o =>pqh_pte_shd.g_old_rec.attribute12
335: ,p_attribute13_o =>pqh_pte_shd.g_old_rec.attribute13
336: ,p_attribute14_o =>pqh_pte_shd.g_old_rec.attribute14
329: ,p_attribute7_o =>pqh_pte_shd.g_old_rec.attribute7
330: ,p_attribute8_o =>pqh_pte_shd.g_old_rec.attribute8
331: ,p_attribute9_o =>pqh_pte_shd.g_old_rec.attribute9
332: ,p_attribute10_o =>pqh_pte_shd.g_old_rec.attribute10
333: ,p_attribute11_o =>pqh_pte_shd.g_old_rec.attribute11
334: ,p_attribute12_o =>pqh_pte_shd.g_old_rec.attribute12
335: ,p_attribute13_o =>pqh_pte_shd.g_old_rec.attribute13
336: ,p_attribute14_o =>pqh_pte_shd.g_old_rec.attribute14
337: ,p_attribute15_o =>pqh_pte_shd.g_old_rec.attribute15
330: ,p_attribute8_o =>pqh_pte_shd.g_old_rec.attribute8
331: ,p_attribute9_o =>pqh_pte_shd.g_old_rec.attribute9
332: ,p_attribute10_o =>pqh_pte_shd.g_old_rec.attribute10
333: ,p_attribute11_o =>pqh_pte_shd.g_old_rec.attribute11
334: ,p_attribute12_o =>pqh_pte_shd.g_old_rec.attribute12
335: ,p_attribute13_o =>pqh_pte_shd.g_old_rec.attribute13
336: ,p_attribute14_o =>pqh_pte_shd.g_old_rec.attribute14
337: ,p_attribute15_o =>pqh_pte_shd.g_old_rec.attribute15
338: ,p_attribute16_o =>pqh_pte_shd.g_old_rec.attribute16
331: ,p_attribute9_o =>pqh_pte_shd.g_old_rec.attribute9
332: ,p_attribute10_o =>pqh_pte_shd.g_old_rec.attribute10
333: ,p_attribute11_o =>pqh_pte_shd.g_old_rec.attribute11
334: ,p_attribute12_o =>pqh_pte_shd.g_old_rec.attribute12
335: ,p_attribute13_o =>pqh_pte_shd.g_old_rec.attribute13
336: ,p_attribute14_o =>pqh_pte_shd.g_old_rec.attribute14
337: ,p_attribute15_o =>pqh_pte_shd.g_old_rec.attribute15
338: ,p_attribute16_o =>pqh_pte_shd.g_old_rec.attribute16
339: ,p_attribute17_o =>pqh_pte_shd.g_old_rec.attribute17
332: ,p_attribute10_o =>pqh_pte_shd.g_old_rec.attribute10
333: ,p_attribute11_o =>pqh_pte_shd.g_old_rec.attribute11
334: ,p_attribute12_o =>pqh_pte_shd.g_old_rec.attribute12
335: ,p_attribute13_o =>pqh_pte_shd.g_old_rec.attribute13
336: ,p_attribute14_o =>pqh_pte_shd.g_old_rec.attribute14
337: ,p_attribute15_o =>pqh_pte_shd.g_old_rec.attribute15
338: ,p_attribute16_o =>pqh_pte_shd.g_old_rec.attribute16
339: ,p_attribute17_o =>pqh_pte_shd.g_old_rec.attribute17
340: ,p_attribute18_o =>pqh_pte_shd.g_old_rec.attribute18
333: ,p_attribute11_o =>pqh_pte_shd.g_old_rec.attribute11
334: ,p_attribute12_o =>pqh_pte_shd.g_old_rec.attribute12
335: ,p_attribute13_o =>pqh_pte_shd.g_old_rec.attribute13
336: ,p_attribute14_o =>pqh_pte_shd.g_old_rec.attribute14
337: ,p_attribute15_o =>pqh_pte_shd.g_old_rec.attribute15
338: ,p_attribute16_o =>pqh_pte_shd.g_old_rec.attribute16
339: ,p_attribute17_o =>pqh_pte_shd.g_old_rec.attribute17
340: ,p_attribute18_o =>pqh_pte_shd.g_old_rec.attribute18
341: ,p_attribute19_o =>pqh_pte_shd.g_old_rec.attribute19
334: ,p_attribute12_o =>pqh_pte_shd.g_old_rec.attribute12
335: ,p_attribute13_o =>pqh_pte_shd.g_old_rec.attribute13
336: ,p_attribute14_o =>pqh_pte_shd.g_old_rec.attribute14
337: ,p_attribute15_o =>pqh_pte_shd.g_old_rec.attribute15
338: ,p_attribute16_o =>pqh_pte_shd.g_old_rec.attribute16
339: ,p_attribute17_o =>pqh_pte_shd.g_old_rec.attribute17
340: ,p_attribute18_o =>pqh_pte_shd.g_old_rec.attribute18
341: ,p_attribute19_o =>pqh_pte_shd.g_old_rec.attribute19
342: ,p_attribute20_o =>pqh_pte_shd.g_old_rec.attribute20
335: ,p_attribute13_o =>pqh_pte_shd.g_old_rec.attribute13
336: ,p_attribute14_o =>pqh_pte_shd.g_old_rec.attribute14
337: ,p_attribute15_o =>pqh_pte_shd.g_old_rec.attribute15
338: ,p_attribute16_o =>pqh_pte_shd.g_old_rec.attribute16
339: ,p_attribute17_o =>pqh_pte_shd.g_old_rec.attribute17
340: ,p_attribute18_o =>pqh_pte_shd.g_old_rec.attribute18
341: ,p_attribute19_o =>pqh_pte_shd.g_old_rec.attribute19
342: ,p_attribute20_o =>pqh_pte_shd.g_old_rec.attribute20
343: ,p_object_version_number_o =>pqh_pte_shd.g_old_rec.object_version_number
336: ,p_attribute14_o =>pqh_pte_shd.g_old_rec.attribute14
337: ,p_attribute15_o =>pqh_pte_shd.g_old_rec.attribute15
338: ,p_attribute16_o =>pqh_pte_shd.g_old_rec.attribute16
339: ,p_attribute17_o =>pqh_pte_shd.g_old_rec.attribute17
340: ,p_attribute18_o =>pqh_pte_shd.g_old_rec.attribute18
341: ,p_attribute19_o =>pqh_pte_shd.g_old_rec.attribute19
342: ,p_attribute20_o =>pqh_pte_shd.g_old_rec.attribute20
343: ,p_object_version_number_o =>pqh_pte_shd.g_old_rec.object_version_number
344: );
337: ,p_attribute15_o =>pqh_pte_shd.g_old_rec.attribute15
338: ,p_attribute16_o =>pqh_pte_shd.g_old_rec.attribute16
339: ,p_attribute17_o =>pqh_pte_shd.g_old_rec.attribute17
340: ,p_attribute18_o =>pqh_pte_shd.g_old_rec.attribute18
341: ,p_attribute19_o =>pqh_pte_shd.g_old_rec.attribute19
342: ,p_attribute20_o =>pqh_pte_shd.g_old_rec.attribute20
343: ,p_object_version_number_o =>pqh_pte_shd.g_old_rec.object_version_number
344: );
345: --
338: ,p_attribute16_o =>pqh_pte_shd.g_old_rec.attribute16
339: ,p_attribute17_o =>pqh_pte_shd.g_old_rec.attribute17
340: ,p_attribute18_o =>pqh_pte_shd.g_old_rec.attribute18
341: ,p_attribute19_o =>pqh_pte_shd.g_old_rec.attribute19
342: ,p_attribute20_o =>pqh_pte_shd.g_old_rec.attribute20
343: ,p_object_version_number_o =>pqh_pte_shd.g_old_rec.object_version_number
344: );
345: --
346: exception
339: ,p_attribute17_o =>pqh_pte_shd.g_old_rec.attribute17
340: ,p_attribute18_o =>pqh_pte_shd.g_old_rec.attribute18
341: ,p_attribute19_o =>pqh_pte_shd.g_old_rec.attribute19
342: ,p_attribute20_o =>pqh_pte_shd.g_old_rec.attribute20
343: ,p_object_version_number_o =>pqh_pte_shd.g_old_rec.object_version_number
344: );
345: --
346: exception
347: --
401: -- Internal Row Handler Use Only.
402: --
403: -- {End Of Comments}
404: -- ----------------------------------------------------------------------------
405: Procedure convert_defs(p_rec in out nocopy pqh_pte_shd.g_rec_type) is
406: --
407: l_proc varchar2(72) := g_package||'convert_defs';
408: --
409: Begin
416: -- is being used then we must set to the 'current' argument value.
417: --
418: If (p_rec.information_type = hr_api.g_varchar2) then
419: p_rec.information_type :=
420: pqh_pte_shd.g_old_rec.information_type;
421: End If;
422: If (p_rec.position_transaction_id = hr_api.g_number) then
423: p_rec.position_transaction_id :=
424: pqh_pte_shd.g_old_rec.position_transaction_id;
420: pqh_pte_shd.g_old_rec.information_type;
421: End If;
422: If (p_rec.position_transaction_id = hr_api.g_number) then
423: p_rec.position_transaction_id :=
424: pqh_pte_shd.g_old_rec.position_transaction_id;
425: End If;
426: If (p_rec.position_extra_info_id = hr_api.g_number) then
427: p_rec.position_extra_info_id :=
428: pqh_pte_shd.g_old_rec.position_extra_info_id;
424: pqh_pte_shd.g_old_rec.position_transaction_id;
425: End If;
426: If (p_rec.position_extra_info_id = hr_api.g_number) then
427: p_rec.position_extra_info_id :=
428: pqh_pte_shd.g_old_rec.position_extra_info_id;
429: End If;
430: If (p_rec.information_category = hr_api.g_varchar2) then
431: p_rec.information_category :=
432: pqh_pte_shd.g_old_rec.information_category;
428: pqh_pte_shd.g_old_rec.position_extra_info_id;
429: End If;
430: If (p_rec.information_category = hr_api.g_varchar2) then
431: p_rec.information_category :=
432: pqh_pte_shd.g_old_rec.information_category;
433: End If;
434: If (p_rec.information1 = hr_api.g_varchar2) then
435: p_rec.information1 :=
436: pqh_pte_shd.g_old_rec.information1;
432: pqh_pte_shd.g_old_rec.information_category;
433: End If;
434: If (p_rec.information1 = hr_api.g_varchar2) then
435: p_rec.information1 :=
436: pqh_pte_shd.g_old_rec.information1;
437: End If;
438: If (p_rec.information2 = hr_api.g_varchar2) then
439: p_rec.information2 :=
440: pqh_pte_shd.g_old_rec.information2;
436: pqh_pte_shd.g_old_rec.information1;
437: End If;
438: If (p_rec.information2 = hr_api.g_varchar2) then
439: p_rec.information2 :=
440: pqh_pte_shd.g_old_rec.information2;
441: End If;
442: If (p_rec.information3 = hr_api.g_varchar2) then
443: p_rec.information3 :=
444: pqh_pte_shd.g_old_rec.information3;
440: pqh_pte_shd.g_old_rec.information2;
441: End If;
442: If (p_rec.information3 = hr_api.g_varchar2) then
443: p_rec.information3 :=
444: pqh_pte_shd.g_old_rec.information3;
445: End If;
446: If (p_rec.information4 = hr_api.g_varchar2) then
447: p_rec.information4 :=
448: pqh_pte_shd.g_old_rec.information4;
444: pqh_pte_shd.g_old_rec.information3;
445: End If;
446: If (p_rec.information4 = hr_api.g_varchar2) then
447: p_rec.information4 :=
448: pqh_pte_shd.g_old_rec.information4;
449: End If;
450: If (p_rec.information5 = hr_api.g_varchar2) then
451: p_rec.information5 :=
452: pqh_pte_shd.g_old_rec.information5;
448: pqh_pte_shd.g_old_rec.information4;
449: End If;
450: If (p_rec.information5 = hr_api.g_varchar2) then
451: p_rec.information5 :=
452: pqh_pte_shd.g_old_rec.information5;
453: End If;
454: If (p_rec.information6 = hr_api.g_varchar2) then
455: p_rec.information6 :=
456: pqh_pte_shd.g_old_rec.information6;
452: pqh_pte_shd.g_old_rec.information5;
453: End If;
454: If (p_rec.information6 = hr_api.g_varchar2) then
455: p_rec.information6 :=
456: pqh_pte_shd.g_old_rec.information6;
457: End If;
458: If (p_rec.information7 = hr_api.g_varchar2) then
459: p_rec.information7 :=
460: pqh_pte_shd.g_old_rec.information7;
456: pqh_pte_shd.g_old_rec.information6;
457: End If;
458: If (p_rec.information7 = hr_api.g_varchar2) then
459: p_rec.information7 :=
460: pqh_pte_shd.g_old_rec.information7;
461: End If;
462: If (p_rec.information8 = hr_api.g_varchar2) then
463: p_rec.information8 :=
464: pqh_pte_shd.g_old_rec.information8;
460: pqh_pte_shd.g_old_rec.information7;
461: End If;
462: If (p_rec.information8 = hr_api.g_varchar2) then
463: p_rec.information8 :=
464: pqh_pte_shd.g_old_rec.information8;
465: End If;
466: If (p_rec.information9 = hr_api.g_varchar2) then
467: p_rec.information9 :=
468: pqh_pte_shd.g_old_rec.information9;
464: pqh_pte_shd.g_old_rec.information8;
465: End If;
466: If (p_rec.information9 = hr_api.g_varchar2) then
467: p_rec.information9 :=
468: pqh_pte_shd.g_old_rec.information9;
469: End If;
470: If (p_rec.information10 = hr_api.g_varchar2) then
471: p_rec.information10 :=
472: pqh_pte_shd.g_old_rec.information10;
468: pqh_pte_shd.g_old_rec.information9;
469: End If;
470: If (p_rec.information10 = hr_api.g_varchar2) then
471: p_rec.information10 :=
472: pqh_pte_shd.g_old_rec.information10;
473: End If;
474: If (p_rec.information11 = hr_api.g_varchar2) then
475: p_rec.information11 :=
476: pqh_pte_shd.g_old_rec.information11;
472: pqh_pte_shd.g_old_rec.information10;
473: End If;
474: If (p_rec.information11 = hr_api.g_varchar2) then
475: p_rec.information11 :=
476: pqh_pte_shd.g_old_rec.information11;
477: End If;
478: If (p_rec.information12 = hr_api.g_varchar2) then
479: p_rec.information12 :=
480: pqh_pte_shd.g_old_rec.information12;
476: pqh_pte_shd.g_old_rec.information11;
477: End If;
478: If (p_rec.information12 = hr_api.g_varchar2) then
479: p_rec.information12 :=
480: pqh_pte_shd.g_old_rec.information12;
481: End If;
482: If (p_rec.information13 = hr_api.g_varchar2) then
483: p_rec.information13 :=
484: pqh_pte_shd.g_old_rec.information13;
480: pqh_pte_shd.g_old_rec.information12;
481: End If;
482: If (p_rec.information13 = hr_api.g_varchar2) then
483: p_rec.information13 :=
484: pqh_pte_shd.g_old_rec.information13;
485: End If;
486: If (p_rec.information14 = hr_api.g_varchar2) then
487: p_rec.information14 :=
488: pqh_pte_shd.g_old_rec.information14;
484: pqh_pte_shd.g_old_rec.information13;
485: End If;
486: If (p_rec.information14 = hr_api.g_varchar2) then
487: p_rec.information14 :=
488: pqh_pte_shd.g_old_rec.information14;
489: End If;
490: If (p_rec.information15 = hr_api.g_varchar2) then
491: p_rec.information15 :=
492: pqh_pte_shd.g_old_rec.information15;
488: pqh_pte_shd.g_old_rec.information14;
489: End If;
490: If (p_rec.information15 = hr_api.g_varchar2) then
491: p_rec.information15 :=
492: pqh_pte_shd.g_old_rec.information15;
493: End If;
494: If (p_rec.information16 = hr_api.g_varchar2) then
495: p_rec.information16 :=
496: pqh_pte_shd.g_old_rec.information16;
492: pqh_pte_shd.g_old_rec.information15;
493: End If;
494: If (p_rec.information16 = hr_api.g_varchar2) then
495: p_rec.information16 :=
496: pqh_pte_shd.g_old_rec.information16;
497: End If;
498: If (p_rec.information17 = hr_api.g_varchar2) then
499: p_rec.information17 :=
500: pqh_pte_shd.g_old_rec.information17;
496: pqh_pte_shd.g_old_rec.information16;
497: End If;
498: If (p_rec.information17 = hr_api.g_varchar2) then
499: p_rec.information17 :=
500: pqh_pte_shd.g_old_rec.information17;
501: End If;
502: If (p_rec.information18 = hr_api.g_varchar2) then
503: p_rec.information18 :=
504: pqh_pte_shd.g_old_rec.information18;
500: pqh_pte_shd.g_old_rec.information17;
501: End If;
502: If (p_rec.information18 = hr_api.g_varchar2) then
503: p_rec.information18 :=
504: pqh_pte_shd.g_old_rec.information18;
505: End If;
506: If (p_rec.information19 = hr_api.g_varchar2) then
507: p_rec.information19 :=
508: pqh_pte_shd.g_old_rec.information19;
504: pqh_pte_shd.g_old_rec.information18;
505: End If;
506: If (p_rec.information19 = hr_api.g_varchar2) then
507: p_rec.information19 :=
508: pqh_pte_shd.g_old_rec.information19;
509: End If;
510: If (p_rec.information20 = hr_api.g_varchar2) then
511: p_rec.information20 :=
512: pqh_pte_shd.g_old_rec.information20;
508: pqh_pte_shd.g_old_rec.information19;
509: End If;
510: If (p_rec.information20 = hr_api.g_varchar2) then
511: p_rec.information20 :=
512: pqh_pte_shd.g_old_rec.information20;
513: End If;
514: If (p_rec.information21 = hr_api.g_varchar2) then
515: p_rec.information21 :=
516: pqh_pte_shd.g_old_rec.information21;
512: pqh_pte_shd.g_old_rec.information20;
513: End If;
514: If (p_rec.information21 = hr_api.g_varchar2) then
515: p_rec.information21 :=
516: pqh_pte_shd.g_old_rec.information21;
517: End If;
518: If (p_rec.information22 = hr_api.g_varchar2) then
519: p_rec.information22 :=
520: pqh_pte_shd.g_old_rec.information22;
516: pqh_pte_shd.g_old_rec.information21;
517: End If;
518: If (p_rec.information22 = hr_api.g_varchar2) then
519: p_rec.information22 :=
520: pqh_pte_shd.g_old_rec.information22;
521: End If;
522: If (p_rec.information23 = hr_api.g_varchar2) then
523: p_rec.information23 :=
524: pqh_pte_shd.g_old_rec.information23;
520: pqh_pte_shd.g_old_rec.information22;
521: End If;
522: If (p_rec.information23 = hr_api.g_varchar2) then
523: p_rec.information23 :=
524: pqh_pte_shd.g_old_rec.information23;
525: End If;
526: If (p_rec.information24 = hr_api.g_varchar2) then
527: p_rec.information24 :=
528: pqh_pte_shd.g_old_rec.information24;
524: pqh_pte_shd.g_old_rec.information23;
525: End If;
526: If (p_rec.information24 = hr_api.g_varchar2) then
527: p_rec.information24 :=
528: pqh_pte_shd.g_old_rec.information24;
529: End If;
530: If (p_rec.information25 = hr_api.g_varchar2) then
531: p_rec.information25 :=
532: pqh_pte_shd.g_old_rec.information25;
528: pqh_pte_shd.g_old_rec.information24;
529: End If;
530: If (p_rec.information25 = hr_api.g_varchar2) then
531: p_rec.information25 :=
532: pqh_pte_shd.g_old_rec.information25;
533: End If;
534: If (p_rec.information26 = hr_api.g_varchar2) then
535: p_rec.information26 :=
536: pqh_pte_shd.g_old_rec.information26;
532: pqh_pte_shd.g_old_rec.information25;
533: End If;
534: If (p_rec.information26 = hr_api.g_varchar2) then
535: p_rec.information26 :=
536: pqh_pte_shd.g_old_rec.information26;
537: End If;
538: If (p_rec.information27 = hr_api.g_varchar2) then
539: p_rec.information27 :=
540: pqh_pte_shd.g_old_rec.information27;
536: pqh_pte_shd.g_old_rec.information26;
537: End If;
538: If (p_rec.information27 = hr_api.g_varchar2) then
539: p_rec.information27 :=
540: pqh_pte_shd.g_old_rec.information27;
541: End If;
542: If (p_rec.information28 = hr_api.g_varchar2) then
543: p_rec.information28 :=
544: pqh_pte_shd.g_old_rec.information28;
540: pqh_pte_shd.g_old_rec.information27;
541: End If;
542: If (p_rec.information28 = hr_api.g_varchar2) then
543: p_rec.information28 :=
544: pqh_pte_shd.g_old_rec.information28;
545: End If;
546: If (p_rec.information29 = hr_api.g_varchar2) then
547: p_rec.information29 :=
548: pqh_pte_shd.g_old_rec.information29;
544: pqh_pte_shd.g_old_rec.information28;
545: End If;
546: If (p_rec.information29 = hr_api.g_varchar2) then
547: p_rec.information29 :=
548: pqh_pte_shd.g_old_rec.information29;
549: End If;
550: If (p_rec.information30 = hr_api.g_varchar2) then
551: p_rec.information30 :=
552: pqh_pte_shd.g_old_rec.information30;
548: pqh_pte_shd.g_old_rec.information29;
549: End If;
550: If (p_rec.information30 = hr_api.g_varchar2) then
551: p_rec.information30 :=
552: pqh_pte_shd.g_old_rec.information30;
553: End If;
554: If (p_rec.attribute_category = hr_api.g_varchar2) then
555: p_rec.attribute_category :=
556: pqh_pte_shd.g_old_rec.attribute_category;
552: pqh_pte_shd.g_old_rec.information30;
553: End If;
554: If (p_rec.attribute_category = hr_api.g_varchar2) then
555: p_rec.attribute_category :=
556: pqh_pte_shd.g_old_rec.attribute_category;
557: End If;
558: If (p_rec.attribute1 = hr_api.g_varchar2) then
559: p_rec.attribute1 :=
560: pqh_pte_shd.g_old_rec.attribute1;
556: pqh_pte_shd.g_old_rec.attribute_category;
557: End If;
558: If (p_rec.attribute1 = hr_api.g_varchar2) then
559: p_rec.attribute1 :=
560: pqh_pte_shd.g_old_rec.attribute1;
561: End If;
562: If (p_rec.attribute2 = hr_api.g_varchar2) then
563: p_rec.attribute2 :=
564: pqh_pte_shd.g_old_rec.attribute2;
560: pqh_pte_shd.g_old_rec.attribute1;
561: End If;
562: If (p_rec.attribute2 = hr_api.g_varchar2) then
563: p_rec.attribute2 :=
564: pqh_pte_shd.g_old_rec.attribute2;
565: End If;
566: If (p_rec.attribute3 = hr_api.g_varchar2) then
567: p_rec.attribute3 :=
568: pqh_pte_shd.g_old_rec.attribute3;
564: pqh_pte_shd.g_old_rec.attribute2;
565: End If;
566: If (p_rec.attribute3 = hr_api.g_varchar2) then
567: p_rec.attribute3 :=
568: pqh_pte_shd.g_old_rec.attribute3;
569: End If;
570: If (p_rec.attribute4 = hr_api.g_varchar2) then
571: p_rec.attribute4 :=
572: pqh_pte_shd.g_old_rec.attribute4;
568: pqh_pte_shd.g_old_rec.attribute3;
569: End If;
570: If (p_rec.attribute4 = hr_api.g_varchar2) then
571: p_rec.attribute4 :=
572: pqh_pte_shd.g_old_rec.attribute4;
573: End If;
574: If (p_rec.attribute5 = hr_api.g_varchar2) then
575: p_rec.attribute5 :=
576: pqh_pte_shd.g_old_rec.attribute5;
572: pqh_pte_shd.g_old_rec.attribute4;
573: End If;
574: If (p_rec.attribute5 = hr_api.g_varchar2) then
575: p_rec.attribute5 :=
576: pqh_pte_shd.g_old_rec.attribute5;
577: End If;
578: If (p_rec.attribute6 = hr_api.g_varchar2) then
579: p_rec.attribute6 :=
580: pqh_pte_shd.g_old_rec.attribute6;
576: pqh_pte_shd.g_old_rec.attribute5;
577: End If;
578: If (p_rec.attribute6 = hr_api.g_varchar2) then
579: p_rec.attribute6 :=
580: pqh_pte_shd.g_old_rec.attribute6;
581: End If;
582: If (p_rec.attribute7 = hr_api.g_varchar2) then
583: p_rec.attribute7 :=
584: pqh_pte_shd.g_old_rec.attribute7;
580: pqh_pte_shd.g_old_rec.attribute6;
581: End If;
582: If (p_rec.attribute7 = hr_api.g_varchar2) then
583: p_rec.attribute7 :=
584: pqh_pte_shd.g_old_rec.attribute7;
585: End If;
586: If (p_rec.attribute8 = hr_api.g_varchar2) then
587: p_rec.attribute8 :=
588: pqh_pte_shd.g_old_rec.attribute8;
584: pqh_pte_shd.g_old_rec.attribute7;
585: End If;
586: If (p_rec.attribute8 = hr_api.g_varchar2) then
587: p_rec.attribute8 :=
588: pqh_pte_shd.g_old_rec.attribute8;
589: End If;
590: If (p_rec.attribute9 = hr_api.g_varchar2) then
591: p_rec.attribute9 :=
592: pqh_pte_shd.g_old_rec.attribute9;
588: pqh_pte_shd.g_old_rec.attribute8;
589: End If;
590: If (p_rec.attribute9 = hr_api.g_varchar2) then
591: p_rec.attribute9 :=
592: pqh_pte_shd.g_old_rec.attribute9;
593: End If;
594: If (p_rec.attribute10 = hr_api.g_varchar2) then
595: p_rec.attribute10 :=
596: pqh_pte_shd.g_old_rec.attribute10;
592: pqh_pte_shd.g_old_rec.attribute9;
593: End If;
594: If (p_rec.attribute10 = hr_api.g_varchar2) then
595: p_rec.attribute10 :=
596: pqh_pte_shd.g_old_rec.attribute10;
597: End If;
598: If (p_rec.attribute11 = hr_api.g_varchar2) then
599: p_rec.attribute11 :=
600: pqh_pte_shd.g_old_rec.attribute11;
596: pqh_pte_shd.g_old_rec.attribute10;
597: End If;
598: If (p_rec.attribute11 = hr_api.g_varchar2) then
599: p_rec.attribute11 :=
600: pqh_pte_shd.g_old_rec.attribute11;
601: End If;
602: If (p_rec.attribute12 = hr_api.g_varchar2) then
603: p_rec.attribute12 :=
604: pqh_pte_shd.g_old_rec.attribute12;
600: pqh_pte_shd.g_old_rec.attribute11;
601: End If;
602: If (p_rec.attribute12 = hr_api.g_varchar2) then
603: p_rec.attribute12 :=
604: pqh_pte_shd.g_old_rec.attribute12;
605: End If;
606: If (p_rec.attribute13 = hr_api.g_varchar2) then
607: p_rec.attribute13 :=
608: pqh_pte_shd.g_old_rec.attribute13;
604: pqh_pte_shd.g_old_rec.attribute12;
605: End If;
606: If (p_rec.attribute13 = hr_api.g_varchar2) then
607: p_rec.attribute13 :=
608: pqh_pte_shd.g_old_rec.attribute13;
609: End If;
610: If (p_rec.attribute14 = hr_api.g_varchar2) then
611: p_rec.attribute14 :=
612: pqh_pte_shd.g_old_rec.attribute14;
608: pqh_pte_shd.g_old_rec.attribute13;
609: End If;
610: If (p_rec.attribute14 = hr_api.g_varchar2) then
611: p_rec.attribute14 :=
612: pqh_pte_shd.g_old_rec.attribute14;
613: End If;
614: If (p_rec.attribute15 = hr_api.g_varchar2) then
615: p_rec.attribute15 :=
616: pqh_pte_shd.g_old_rec.attribute15;
612: pqh_pte_shd.g_old_rec.attribute14;
613: End If;
614: If (p_rec.attribute15 = hr_api.g_varchar2) then
615: p_rec.attribute15 :=
616: pqh_pte_shd.g_old_rec.attribute15;
617: End If;
618: If (p_rec.attribute16 = hr_api.g_varchar2) then
619: p_rec.attribute16 :=
620: pqh_pte_shd.g_old_rec.attribute16;
616: pqh_pte_shd.g_old_rec.attribute15;
617: End If;
618: If (p_rec.attribute16 = hr_api.g_varchar2) then
619: p_rec.attribute16 :=
620: pqh_pte_shd.g_old_rec.attribute16;
621: End If;
622: If (p_rec.attribute17 = hr_api.g_varchar2) then
623: p_rec.attribute17 :=
624: pqh_pte_shd.g_old_rec.attribute17;
620: pqh_pte_shd.g_old_rec.attribute16;
621: End If;
622: If (p_rec.attribute17 = hr_api.g_varchar2) then
623: p_rec.attribute17 :=
624: pqh_pte_shd.g_old_rec.attribute17;
625: End If;
626: If (p_rec.attribute18 = hr_api.g_varchar2) then
627: p_rec.attribute18 :=
628: pqh_pte_shd.g_old_rec.attribute18;
624: pqh_pte_shd.g_old_rec.attribute17;
625: End If;
626: If (p_rec.attribute18 = hr_api.g_varchar2) then
627: p_rec.attribute18 :=
628: pqh_pte_shd.g_old_rec.attribute18;
629: End If;
630: If (p_rec.attribute19 = hr_api.g_varchar2) then
631: p_rec.attribute19 :=
632: pqh_pte_shd.g_old_rec.attribute19;
628: pqh_pte_shd.g_old_rec.attribute18;
629: End If;
630: If (p_rec.attribute19 = hr_api.g_varchar2) then
631: p_rec.attribute19 :=
632: pqh_pte_shd.g_old_rec.attribute19;
633: End If;
634: If (p_rec.attribute20 = hr_api.g_varchar2) then
635: p_rec.attribute20 :=
636: pqh_pte_shd.g_old_rec.attribute20;
632: pqh_pte_shd.g_old_rec.attribute19;
633: End If;
634: If (p_rec.attribute20 = hr_api.g_varchar2) then
635: p_rec.attribute20 :=
636: pqh_pte_shd.g_old_rec.attribute20;
637: End If;
638:
639: --
640: hr_utility.set_location(' Leaving:'||l_proc, 10);
645: -- |---------------------------------< upd >----------------------------------|
646: -- ----------------------------------------------------------------------------
647: Procedure upd
648: (
649: p_rec in out nocopy pqh_pte_shd.g_rec_type
650: ) is
651: --
652: l_proc varchar2(72) := g_package||'upd';
653: --
655: hr_utility.set_location('Entering:'||l_proc, 5);
656: --
657: -- We must lock the row which we need to update.
658: --
659: pqh_pte_shd.lck
660: (
661: p_rec.ptx_extra_info_id,
662: p_rec.object_version_number
663: );
747: p_attribute20 in varchar2 default hr_api.g_varchar2,
748: p_object_version_number in out nocopy number
749: ) is
750: --
751: l_rec pqh_pte_shd.g_rec_type;
752: l_proc varchar2(72) := g_package||'upd';
753: --
754: Begin
755: hr_utility.set_location('Entering:'||l_proc, 5);
757: -- Call conversion function to turn arguments into the
758: -- l_rec structure.
759: --
760: l_rec :=
761: pqh_pte_shd.convert_args
762: (
763: p_ptx_extra_info_id,
764: p_information_type,
765: p_position_transaction_id,