[Home] [Help]
44: -- Internal Row Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure update_dml(p_rec in out nocopy pqh_cea_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin
104: --
105: Exception
106: When hr_api.check_integrity_violated Then
107: -- A check constraint has been violated
108: pqh_cea_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: pqh_cea_shd.constraint_error
108: pqh_cea_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: pqh_cea_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: pqh_cea_shd.constraint_error
112: pqh_cea_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: pqh_cea_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When Others Then
119: Raise;
120: End update_dml;
150: -- Internal Row Handler Use Only.
151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure pre_update(p_rec in pqh_cea_shd.g_rec_type) is
155: --
156: l_proc varchar2(72) := g_package||'pre_update';
157: --
158: Begin
193: --
194: -- {End Of Comments}
195: -- ----------------------------------------------------------------------------
196: Procedure post_update(
197: p_effective_date in date,p_rec in pqh_cea_shd.g_rec_type) is
198: --
199: l_proc varchar2(72) := g_package||'post_update';
200: --
201: Begin
246: ,p_check_information2 =>p_rec.check_information2
247: ,p_check_information3 =>p_rec.check_information3
248: ,p_object_version_number =>p_rec.object_version_number
249: ,p_effective_date =>p_effective_date
250: ,p_copy_entity_txn_id_o =>pqh_cea_shd.g_old_rec.copy_entity_txn_id
251: ,p_row_type_cd_o =>pqh_cea_shd.g_old_rec.row_type_cd
252: ,p_information_category_o =>pqh_cea_shd.g_old_rec.information_category
253: ,p_information1_o =>pqh_cea_shd.g_old_rec.information1
254: ,p_information2_o =>pqh_cea_shd.g_old_rec.information2
247: ,p_check_information3 =>p_rec.check_information3
248: ,p_object_version_number =>p_rec.object_version_number
249: ,p_effective_date =>p_effective_date
250: ,p_copy_entity_txn_id_o =>pqh_cea_shd.g_old_rec.copy_entity_txn_id
251: ,p_row_type_cd_o =>pqh_cea_shd.g_old_rec.row_type_cd
252: ,p_information_category_o =>pqh_cea_shd.g_old_rec.information_category
253: ,p_information1_o =>pqh_cea_shd.g_old_rec.information1
254: ,p_information2_o =>pqh_cea_shd.g_old_rec.information2
255: ,p_information3_o =>pqh_cea_shd.g_old_rec.information3
248: ,p_object_version_number =>p_rec.object_version_number
249: ,p_effective_date =>p_effective_date
250: ,p_copy_entity_txn_id_o =>pqh_cea_shd.g_old_rec.copy_entity_txn_id
251: ,p_row_type_cd_o =>pqh_cea_shd.g_old_rec.row_type_cd
252: ,p_information_category_o =>pqh_cea_shd.g_old_rec.information_category
253: ,p_information1_o =>pqh_cea_shd.g_old_rec.information1
254: ,p_information2_o =>pqh_cea_shd.g_old_rec.information2
255: ,p_information3_o =>pqh_cea_shd.g_old_rec.information3
256: ,p_information4_o =>pqh_cea_shd.g_old_rec.information4
249: ,p_effective_date =>p_effective_date
250: ,p_copy_entity_txn_id_o =>pqh_cea_shd.g_old_rec.copy_entity_txn_id
251: ,p_row_type_cd_o =>pqh_cea_shd.g_old_rec.row_type_cd
252: ,p_information_category_o =>pqh_cea_shd.g_old_rec.information_category
253: ,p_information1_o =>pqh_cea_shd.g_old_rec.information1
254: ,p_information2_o =>pqh_cea_shd.g_old_rec.information2
255: ,p_information3_o =>pqh_cea_shd.g_old_rec.information3
256: ,p_information4_o =>pqh_cea_shd.g_old_rec.information4
257: ,p_information5_o =>pqh_cea_shd.g_old_rec.information5
250: ,p_copy_entity_txn_id_o =>pqh_cea_shd.g_old_rec.copy_entity_txn_id
251: ,p_row_type_cd_o =>pqh_cea_shd.g_old_rec.row_type_cd
252: ,p_information_category_o =>pqh_cea_shd.g_old_rec.information_category
253: ,p_information1_o =>pqh_cea_shd.g_old_rec.information1
254: ,p_information2_o =>pqh_cea_shd.g_old_rec.information2
255: ,p_information3_o =>pqh_cea_shd.g_old_rec.information3
256: ,p_information4_o =>pqh_cea_shd.g_old_rec.information4
257: ,p_information5_o =>pqh_cea_shd.g_old_rec.information5
258: ,p_information6_o =>pqh_cea_shd.g_old_rec.information6
251: ,p_row_type_cd_o =>pqh_cea_shd.g_old_rec.row_type_cd
252: ,p_information_category_o =>pqh_cea_shd.g_old_rec.information_category
253: ,p_information1_o =>pqh_cea_shd.g_old_rec.information1
254: ,p_information2_o =>pqh_cea_shd.g_old_rec.information2
255: ,p_information3_o =>pqh_cea_shd.g_old_rec.information3
256: ,p_information4_o =>pqh_cea_shd.g_old_rec.information4
257: ,p_information5_o =>pqh_cea_shd.g_old_rec.information5
258: ,p_information6_o =>pqh_cea_shd.g_old_rec.information6
259: ,p_information7_o =>pqh_cea_shd.g_old_rec.information7
252: ,p_information_category_o =>pqh_cea_shd.g_old_rec.information_category
253: ,p_information1_o =>pqh_cea_shd.g_old_rec.information1
254: ,p_information2_o =>pqh_cea_shd.g_old_rec.information2
255: ,p_information3_o =>pqh_cea_shd.g_old_rec.information3
256: ,p_information4_o =>pqh_cea_shd.g_old_rec.information4
257: ,p_information5_o =>pqh_cea_shd.g_old_rec.information5
258: ,p_information6_o =>pqh_cea_shd.g_old_rec.information6
259: ,p_information7_o =>pqh_cea_shd.g_old_rec.information7
260: ,p_information8_o =>pqh_cea_shd.g_old_rec.information8
253: ,p_information1_o =>pqh_cea_shd.g_old_rec.information1
254: ,p_information2_o =>pqh_cea_shd.g_old_rec.information2
255: ,p_information3_o =>pqh_cea_shd.g_old_rec.information3
256: ,p_information4_o =>pqh_cea_shd.g_old_rec.information4
257: ,p_information5_o =>pqh_cea_shd.g_old_rec.information5
258: ,p_information6_o =>pqh_cea_shd.g_old_rec.information6
259: ,p_information7_o =>pqh_cea_shd.g_old_rec.information7
260: ,p_information8_o =>pqh_cea_shd.g_old_rec.information8
261: ,p_information9_o =>pqh_cea_shd.g_old_rec.information9
254: ,p_information2_o =>pqh_cea_shd.g_old_rec.information2
255: ,p_information3_o =>pqh_cea_shd.g_old_rec.information3
256: ,p_information4_o =>pqh_cea_shd.g_old_rec.information4
257: ,p_information5_o =>pqh_cea_shd.g_old_rec.information5
258: ,p_information6_o =>pqh_cea_shd.g_old_rec.information6
259: ,p_information7_o =>pqh_cea_shd.g_old_rec.information7
260: ,p_information8_o =>pqh_cea_shd.g_old_rec.information8
261: ,p_information9_o =>pqh_cea_shd.g_old_rec.information9
262: ,p_information10_o =>pqh_cea_shd.g_old_rec.information10
255: ,p_information3_o =>pqh_cea_shd.g_old_rec.information3
256: ,p_information4_o =>pqh_cea_shd.g_old_rec.information4
257: ,p_information5_o =>pqh_cea_shd.g_old_rec.information5
258: ,p_information6_o =>pqh_cea_shd.g_old_rec.information6
259: ,p_information7_o =>pqh_cea_shd.g_old_rec.information7
260: ,p_information8_o =>pqh_cea_shd.g_old_rec.information8
261: ,p_information9_o =>pqh_cea_shd.g_old_rec.information9
262: ,p_information10_o =>pqh_cea_shd.g_old_rec.information10
263: ,p_information11_o =>pqh_cea_shd.g_old_rec.information11
256: ,p_information4_o =>pqh_cea_shd.g_old_rec.information4
257: ,p_information5_o =>pqh_cea_shd.g_old_rec.information5
258: ,p_information6_o =>pqh_cea_shd.g_old_rec.information6
259: ,p_information7_o =>pqh_cea_shd.g_old_rec.information7
260: ,p_information8_o =>pqh_cea_shd.g_old_rec.information8
261: ,p_information9_o =>pqh_cea_shd.g_old_rec.information9
262: ,p_information10_o =>pqh_cea_shd.g_old_rec.information10
263: ,p_information11_o =>pqh_cea_shd.g_old_rec.information11
264: ,p_information12_o =>pqh_cea_shd.g_old_rec.information12
257: ,p_information5_o =>pqh_cea_shd.g_old_rec.information5
258: ,p_information6_o =>pqh_cea_shd.g_old_rec.information6
259: ,p_information7_o =>pqh_cea_shd.g_old_rec.information7
260: ,p_information8_o =>pqh_cea_shd.g_old_rec.information8
261: ,p_information9_o =>pqh_cea_shd.g_old_rec.information9
262: ,p_information10_o =>pqh_cea_shd.g_old_rec.information10
263: ,p_information11_o =>pqh_cea_shd.g_old_rec.information11
264: ,p_information12_o =>pqh_cea_shd.g_old_rec.information12
265: ,p_information13_o =>pqh_cea_shd.g_old_rec.information13
258: ,p_information6_o =>pqh_cea_shd.g_old_rec.information6
259: ,p_information7_o =>pqh_cea_shd.g_old_rec.information7
260: ,p_information8_o =>pqh_cea_shd.g_old_rec.information8
261: ,p_information9_o =>pqh_cea_shd.g_old_rec.information9
262: ,p_information10_o =>pqh_cea_shd.g_old_rec.information10
263: ,p_information11_o =>pqh_cea_shd.g_old_rec.information11
264: ,p_information12_o =>pqh_cea_shd.g_old_rec.information12
265: ,p_information13_o =>pqh_cea_shd.g_old_rec.information13
266: ,p_information14_o =>pqh_cea_shd.g_old_rec.information14
259: ,p_information7_o =>pqh_cea_shd.g_old_rec.information7
260: ,p_information8_o =>pqh_cea_shd.g_old_rec.information8
261: ,p_information9_o =>pqh_cea_shd.g_old_rec.information9
262: ,p_information10_o =>pqh_cea_shd.g_old_rec.information10
263: ,p_information11_o =>pqh_cea_shd.g_old_rec.information11
264: ,p_information12_o =>pqh_cea_shd.g_old_rec.information12
265: ,p_information13_o =>pqh_cea_shd.g_old_rec.information13
266: ,p_information14_o =>pqh_cea_shd.g_old_rec.information14
267: ,p_information15_o =>pqh_cea_shd.g_old_rec.information15
260: ,p_information8_o =>pqh_cea_shd.g_old_rec.information8
261: ,p_information9_o =>pqh_cea_shd.g_old_rec.information9
262: ,p_information10_o =>pqh_cea_shd.g_old_rec.information10
263: ,p_information11_o =>pqh_cea_shd.g_old_rec.information11
264: ,p_information12_o =>pqh_cea_shd.g_old_rec.information12
265: ,p_information13_o =>pqh_cea_shd.g_old_rec.information13
266: ,p_information14_o =>pqh_cea_shd.g_old_rec.information14
267: ,p_information15_o =>pqh_cea_shd.g_old_rec.information15
268: ,p_information16_o =>pqh_cea_shd.g_old_rec.information16
261: ,p_information9_o =>pqh_cea_shd.g_old_rec.information9
262: ,p_information10_o =>pqh_cea_shd.g_old_rec.information10
263: ,p_information11_o =>pqh_cea_shd.g_old_rec.information11
264: ,p_information12_o =>pqh_cea_shd.g_old_rec.information12
265: ,p_information13_o =>pqh_cea_shd.g_old_rec.information13
266: ,p_information14_o =>pqh_cea_shd.g_old_rec.information14
267: ,p_information15_o =>pqh_cea_shd.g_old_rec.information15
268: ,p_information16_o =>pqh_cea_shd.g_old_rec.information16
269: ,p_information17_o =>pqh_cea_shd.g_old_rec.information17
262: ,p_information10_o =>pqh_cea_shd.g_old_rec.information10
263: ,p_information11_o =>pqh_cea_shd.g_old_rec.information11
264: ,p_information12_o =>pqh_cea_shd.g_old_rec.information12
265: ,p_information13_o =>pqh_cea_shd.g_old_rec.information13
266: ,p_information14_o =>pqh_cea_shd.g_old_rec.information14
267: ,p_information15_o =>pqh_cea_shd.g_old_rec.information15
268: ,p_information16_o =>pqh_cea_shd.g_old_rec.information16
269: ,p_information17_o =>pqh_cea_shd.g_old_rec.information17
270: ,p_information18_o =>pqh_cea_shd.g_old_rec.information18
263: ,p_information11_o =>pqh_cea_shd.g_old_rec.information11
264: ,p_information12_o =>pqh_cea_shd.g_old_rec.information12
265: ,p_information13_o =>pqh_cea_shd.g_old_rec.information13
266: ,p_information14_o =>pqh_cea_shd.g_old_rec.information14
267: ,p_information15_o =>pqh_cea_shd.g_old_rec.information15
268: ,p_information16_o =>pqh_cea_shd.g_old_rec.information16
269: ,p_information17_o =>pqh_cea_shd.g_old_rec.information17
270: ,p_information18_o =>pqh_cea_shd.g_old_rec.information18
271: ,p_information19_o =>pqh_cea_shd.g_old_rec.information19
264: ,p_information12_o =>pqh_cea_shd.g_old_rec.information12
265: ,p_information13_o =>pqh_cea_shd.g_old_rec.information13
266: ,p_information14_o =>pqh_cea_shd.g_old_rec.information14
267: ,p_information15_o =>pqh_cea_shd.g_old_rec.information15
268: ,p_information16_o =>pqh_cea_shd.g_old_rec.information16
269: ,p_information17_o =>pqh_cea_shd.g_old_rec.information17
270: ,p_information18_o =>pqh_cea_shd.g_old_rec.information18
271: ,p_information19_o =>pqh_cea_shd.g_old_rec.information19
272: ,p_information20_o =>pqh_cea_shd.g_old_rec.information20
265: ,p_information13_o =>pqh_cea_shd.g_old_rec.information13
266: ,p_information14_o =>pqh_cea_shd.g_old_rec.information14
267: ,p_information15_o =>pqh_cea_shd.g_old_rec.information15
268: ,p_information16_o =>pqh_cea_shd.g_old_rec.information16
269: ,p_information17_o =>pqh_cea_shd.g_old_rec.information17
270: ,p_information18_o =>pqh_cea_shd.g_old_rec.information18
271: ,p_information19_o =>pqh_cea_shd.g_old_rec.information19
272: ,p_information20_o =>pqh_cea_shd.g_old_rec.information20
273: ,p_information21_o =>pqh_cea_shd.g_old_rec.information21
266: ,p_information14_o =>pqh_cea_shd.g_old_rec.information14
267: ,p_information15_o =>pqh_cea_shd.g_old_rec.information15
268: ,p_information16_o =>pqh_cea_shd.g_old_rec.information16
269: ,p_information17_o =>pqh_cea_shd.g_old_rec.information17
270: ,p_information18_o =>pqh_cea_shd.g_old_rec.information18
271: ,p_information19_o =>pqh_cea_shd.g_old_rec.information19
272: ,p_information20_o =>pqh_cea_shd.g_old_rec.information20
273: ,p_information21_o =>pqh_cea_shd.g_old_rec.information21
274: ,p_information22_o =>pqh_cea_shd.g_old_rec.information22
267: ,p_information15_o =>pqh_cea_shd.g_old_rec.information15
268: ,p_information16_o =>pqh_cea_shd.g_old_rec.information16
269: ,p_information17_o =>pqh_cea_shd.g_old_rec.information17
270: ,p_information18_o =>pqh_cea_shd.g_old_rec.information18
271: ,p_information19_o =>pqh_cea_shd.g_old_rec.information19
272: ,p_information20_o =>pqh_cea_shd.g_old_rec.information20
273: ,p_information21_o =>pqh_cea_shd.g_old_rec.information21
274: ,p_information22_o =>pqh_cea_shd.g_old_rec.information22
275: ,p_information23_o =>pqh_cea_shd.g_old_rec.information23
268: ,p_information16_o =>pqh_cea_shd.g_old_rec.information16
269: ,p_information17_o =>pqh_cea_shd.g_old_rec.information17
270: ,p_information18_o =>pqh_cea_shd.g_old_rec.information18
271: ,p_information19_o =>pqh_cea_shd.g_old_rec.information19
272: ,p_information20_o =>pqh_cea_shd.g_old_rec.information20
273: ,p_information21_o =>pqh_cea_shd.g_old_rec.information21
274: ,p_information22_o =>pqh_cea_shd.g_old_rec.information22
275: ,p_information23_o =>pqh_cea_shd.g_old_rec.information23
276: ,p_information24_o =>pqh_cea_shd.g_old_rec.information24
269: ,p_information17_o =>pqh_cea_shd.g_old_rec.information17
270: ,p_information18_o =>pqh_cea_shd.g_old_rec.information18
271: ,p_information19_o =>pqh_cea_shd.g_old_rec.information19
272: ,p_information20_o =>pqh_cea_shd.g_old_rec.information20
273: ,p_information21_o =>pqh_cea_shd.g_old_rec.information21
274: ,p_information22_o =>pqh_cea_shd.g_old_rec.information22
275: ,p_information23_o =>pqh_cea_shd.g_old_rec.information23
276: ,p_information24_o =>pqh_cea_shd.g_old_rec.information24
277: ,p_information25_o =>pqh_cea_shd.g_old_rec.information25
270: ,p_information18_o =>pqh_cea_shd.g_old_rec.information18
271: ,p_information19_o =>pqh_cea_shd.g_old_rec.information19
272: ,p_information20_o =>pqh_cea_shd.g_old_rec.information20
273: ,p_information21_o =>pqh_cea_shd.g_old_rec.information21
274: ,p_information22_o =>pqh_cea_shd.g_old_rec.information22
275: ,p_information23_o =>pqh_cea_shd.g_old_rec.information23
276: ,p_information24_o =>pqh_cea_shd.g_old_rec.information24
277: ,p_information25_o =>pqh_cea_shd.g_old_rec.information25
278: ,p_information26_o =>pqh_cea_shd.g_old_rec.information26
271: ,p_information19_o =>pqh_cea_shd.g_old_rec.information19
272: ,p_information20_o =>pqh_cea_shd.g_old_rec.information20
273: ,p_information21_o =>pqh_cea_shd.g_old_rec.information21
274: ,p_information22_o =>pqh_cea_shd.g_old_rec.information22
275: ,p_information23_o =>pqh_cea_shd.g_old_rec.information23
276: ,p_information24_o =>pqh_cea_shd.g_old_rec.information24
277: ,p_information25_o =>pqh_cea_shd.g_old_rec.information25
278: ,p_information26_o =>pqh_cea_shd.g_old_rec.information26
279: ,p_information27_o =>pqh_cea_shd.g_old_rec.information27
272: ,p_information20_o =>pqh_cea_shd.g_old_rec.information20
273: ,p_information21_o =>pqh_cea_shd.g_old_rec.information21
274: ,p_information22_o =>pqh_cea_shd.g_old_rec.information22
275: ,p_information23_o =>pqh_cea_shd.g_old_rec.information23
276: ,p_information24_o =>pqh_cea_shd.g_old_rec.information24
277: ,p_information25_o =>pqh_cea_shd.g_old_rec.information25
278: ,p_information26_o =>pqh_cea_shd.g_old_rec.information26
279: ,p_information27_o =>pqh_cea_shd.g_old_rec.information27
280: ,p_information28_o =>pqh_cea_shd.g_old_rec.information28
273: ,p_information21_o =>pqh_cea_shd.g_old_rec.information21
274: ,p_information22_o =>pqh_cea_shd.g_old_rec.information22
275: ,p_information23_o =>pqh_cea_shd.g_old_rec.information23
276: ,p_information24_o =>pqh_cea_shd.g_old_rec.information24
277: ,p_information25_o =>pqh_cea_shd.g_old_rec.information25
278: ,p_information26_o =>pqh_cea_shd.g_old_rec.information26
279: ,p_information27_o =>pqh_cea_shd.g_old_rec.information27
280: ,p_information28_o =>pqh_cea_shd.g_old_rec.information28
281: ,p_information29_o =>pqh_cea_shd.g_old_rec.information29
274: ,p_information22_o =>pqh_cea_shd.g_old_rec.information22
275: ,p_information23_o =>pqh_cea_shd.g_old_rec.information23
276: ,p_information24_o =>pqh_cea_shd.g_old_rec.information24
277: ,p_information25_o =>pqh_cea_shd.g_old_rec.information25
278: ,p_information26_o =>pqh_cea_shd.g_old_rec.information26
279: ,p_information27_o =>pqh_cea_shd.g_old_rec.information27
280: ,p_information28_o =>pqh_cea_shd.g_old_rec.information28
281: ,p_information29_o =>pqh_cea_shd.g_old_rec.information29
282: ,p_information30_o =>pqh_cea_shd.g_old_rec.information30
275: ,p_information23_o =>pqh_cea_shd.g_old_rec.information23
276: ,p_information24_o =>pqh_cea_shd.g_old_rec.information24
277: ,p_information25_o =>pqh_cea_shd.g_old_rec.information25
278: ,p_information26_o =>pqh_cea_shd.g_old_rec.information26
279: ,p_information27_o =>pqh_cea_shd.g_old_rec.information27
280: ,p_information28_o =>pqh_cea_shd.g_old_rec.information28
281: ,p_information29_o =>pqh_cea_shd.g_old_rec.information29
282: ,p_information30_o =>pqh_cea_shd.g_old_rec.information30
283: ,p_check_information1_o =>pqh_cea_shd.g_old_rec.check_information1
276: ,p_information24_o =>pqh_cea_shd.g_old_rec.information24
277: ,p_information25_o =>pqh_cea_shd.g_old_rec.information25
278: ,p_information26_o =>pqh_cea_shd.g_old_rec.information26
279: ,p_information27_o =>pqh_cea_shd.g_old_rec.information27
280: ,p_information28_o =>pqh_cea_shd.g_old_rec.information28
281: ,p_information29_o =>pqh_cea_shd.g_old_rec.information29
282: ,p_information30_o =>pqh_cea_shd.g_old_rec.information30
283: ,p_check_information1_o =>pqh_cea_shd.g_old_rec.check_information1
284: ,p_check_information2_o =>pqh_cea_shd.g_old_rec.check_information2
277: ,p_information25_o =>pqh_cea_shd.g_old_rec.information25
278: ,p_information26_o =>pqh_cea_shd.g_old_rec.information26
279: ,p_information27_o =>pqh_cea_shd.g_old_rec.information27
280: ,p_information28_o =>pqh_cea_shd.g_old_rec.information28
281: ,p_information29_o =>pqh_cea_shd.g_old_rec.information29
282: ,p_information30_o =>pqh_cea_shd.g_old_rec.information30
283: ,p_check_information1_o =>pqh_cea_shd.g_old_rec.check_information1
284: ,p_check_information2_o =>pqh_cea_shd.g_old_rec.check_information2
285: ,p_check_information3_o =>pqh_cea_shd.g_old_rec.check_information3
278: ,p_information26_o =>pqh_cea_shd.g_old_rec.information26
279: ,p_information27_o =>pqh_cea_shd.g_old_rec.information27
280: ,p_information28_o =>pqh_cea_shd.g_old_rec.information28
281: ,p_information29_o =>pqh_cea_shd.g_old_rec.information29
282: ,p_information30_o =>pqh_cea_shd.g_old_rec.information30
283: ,p_check_information1_o =>pqh_cea_shd.g_old_rec.check_information1
284: ,p_check_information2_o =>pqh_cea_shd.g_old_rec.check_information2
285: ,p_check_information3_o =>pqh_cea_shd.g_old_rec.check_information3
286: ,p_object_version_number_o =>pqh_cea_shd.g_old_rec.object_version_number
279: ,p_information27_o =>pqh_cea_shd.g_old_rec.information27
280: ,p_information28_o =>pqh_cea_shd.g_old_rec.information28
281: ,p_information29_o =>pqh_cea_shd.g_old_rec.information29
282: ,p_information30_o =>pqh_cea_shd.g_old_rec.information30
283: ,p_check_information1_o =>pqh_cea_shd.g_old_rec.check_information1
284: ,p_check_information2_o =>pqh_cea_shd.g_old_rec.check_information2
285: ,p_check_information3_o =>pqh_cea_shd.g_old_rec.check_information3
286: ,p_object_version_number_o =>pqh_cea_shd.g_old_rec.object_version_number
287: );
280: ,p_information28_o =>pqh_cea_shd.g_old_rec.information28
281: ,p_information29_o =>pqh_cea_shd.g_old_rec.information29
282: ,p_information30_o =>pqh_cea_shd.g_old_rec.information30
283: ,p_check_information1_o =>pqh_cea_shd.g_old_rec.check_information1
284: ,p_check_information2_o =>pqh_cea_shd.g_old_rec.check_information2
285: ,p_check_information3_o =>pqh_cea_shd.g_old_rec.check_information3
286: ,p_object_version_number_o =>pqh_cea_shd.g_old_rec.object_version_number
287: );
288: --
281: ,p_information29_o =>pqh_cea_shd.g_old_rec.information29
282: ,p_information30_o =>pqh_cea_shd.g_old_rec.information30
283: ,p_check_information1_o =>pqh_cea_shd.g_old_rec.check_information1
284: ,p_check_information2_o =>pqh_cea_shd.g_old_rec.check_information2
285: ,p_check_information3_o =>pqh_cea_shd.g_old_rec.check_information3
286: ,p_object_version_number_o =>pqh_cea_shd.g_old_rec.object_version_number
287: );
288: --
289: exception
282: ,p_information30_o =>pqh_cea_shd.g_old_rec.information30
283: ,p_check_information1_o =>pqh_cea_shd.g_old_rec.check_information1
284: ,p_check_information2_o =>pqh_cea_shd.g_old_rec.check_information2
285: ,p_check_information3_o =>pqh_cea_shd.g_old_rec.check_information3
286: ,p_object_version_number_o =>pqh_cea_shd.g_old_rec.object_version_number
287: );
288: --
289: exception
290: --
344: -- Internal Row Handler Use Only.
345: --
346: -- {End Of Comments}
347: -- ----------------------------------------------------------------------------
348: Procedure convert_defs(p_rec in out nocopy pqh_cea_shd.g_rec_type) is
349: --
350: l_proc varchar2(72) := g_package||'convert_defs';
351: --
352: Begin
359: -- is being used then we must set to the 'current' argument value.
360: --
361: If (p_rec.copy_entity_txn_id = hr_api.g_number) then
362: p_rec.copy_entity_txn_id :=
363: pqh_cea_shd.g_old_rec.copy_entity_txn_id;
364: End If;
365: If (p_rec.row_type_cd = hr_api.g_varchar2) then
366: p_rec.row_type_cd :=
367: pqh_cea_shd.g_old_rec.row_type_cd;
363: pqh_cea_shd.g_old_rec.copy_entity_txn_id;
364: End If;
365: If (p_rec.row_type_cd = hr_api.g_varchar2) then
366: p_rec.row_type_cd :=
367: pqh_cea_shd.g_old_rec.row_type_cd;
368: End If;
369: If (p_rec.information_category = hr_api.g_varchar2) then
370: p_rec.information_category :=
371: pqh_cea_shd.g_old_rec.information_category;
367: pqh_cea_shd.g_old_rec.row_type_cd;
368: End If;
369: If (p_rec.information_category = hr_api.g_varchar2) then
370: p_rec.information_category :=
371: pqh_cea_shd.g_old_rec.information_category;
372: End If;
373: If (p_rec.information1 = hr_api.g_varchar2) then
374: p_rec.information1 :=
375: pqh_cea_shd.g_old_rec.information1;
371: pqh_cea_shd.g_old_rec.information_category;
372: End If;
373: If (p_rec.information1 = hr_api.g_varchar2) then
374: p_rec.information1 :=
375: pqh_cea_shd.g_old_rec.information1;
376: End If;
377: If (p_rec.information2 = hr_api.g_varchar2) then
378: p_rec.information2 :=
379: pqh_cea_shd.g_old_rec.information2;
375: pqh_cea_shd.g_old_rec.information1;
376: End If;
377: If (p_rec.information2 = hr_api.g_varchar2) then
378: p_rec.information2 :=
379: pqh_cea_shd.g_old_rec.information2;
380: End If;
381: If (p_rec.information3 = hr_api.g_varchar2) then
382: p_rec.information3 :=
383: pqh_cea_shd.g_old_rec.information3;
379: pqh_cea_shd.g_old_rec.information2;
380: End If;
381: If (p_rec.information3 = hr_api.g_varchar2) then
382: p_rec.information3 :=
383: pqh_cea_shd.g_old_rec.information3;
384: End If;
385: If (p_rec.information4 = hr_api.g_varchar2) then
386: p_rec.information4 :=
387: pqh_cea_shd.g_old_rec.information4;
383: pqh_cea_shd.g_old_rec.information3;
384: End If;
385: If (p_rec.information4 = hr_api.g_varchar2) then
386: p_rec.information4 :=
387: pqh_cea_shd.g_old_rec.information4;
388: End If;
389: If (p_rec.information5 = hr_api.g_varchar2) then
390: p_rec.information5 :=
391: pqh_cea_shd.g_old_rec.information5;
387: pqh_cea_shd.g_old_rec.information4;
388: End If;
389: If (p_rec.information5 = hr_api.g_varchar2) then
390: p_rec.information5 :=
391: pqh_cea_shd.g_old_rec.information5;
392: End If;
393: If (p_rec.information6 = hr_api.g_varchar2) then
394: p_rec.information6 :=
395: pqh_cea_shd.g_old_rec.information6;
391: pqh_cea_shd.g_old_rec.information5;
392: End If;
393: If (p_rec.information6 = hr_api.g_varchar2) then
394: p_rec.information6 :=
395: pqh_cea_shd.g_old_rec.information6;
396: End If;
397: If (p_rec.information7 = hr_api.g_varchar2) then
398: p_rec.information7 :=
399: pqh_cea_shd.g_old_rec.information7;
395: pqh_cea_shd.g_old_rec.information6;
396: End If;
397: If (p_rec.information7 = hr_api.g_varchar2) then
398: p_rec.information7 :=
399: pqh_cea_shd.g_old_rec.information7;
400: End If;
401: If (p_rec.information8 = hr_api.g_varchar2) then
402: p_rec.information8 :=
403: pqh_cea_shd.g_old_rec.information8;
399: pqh_cea_shd.g_old_rec.information7;
400: End If;
401: If (p_rec.information8 = hr_api.g_varchar2) then
402: p_rec.information8 :=
403: pqh_cea_shd.g_old_rec.information8;
404: End If;
405: If (p_rec.information9 = hr_api.g_varchar2) then
406: p_rec.information9 :=
407: pqh_cea_shd.g_old_rec.information9;
403: pqh_cea_shd.g_old_rec.information8;
404: End If;
405: If (p_rec.information9 = hr_api.g_varchar2) then
406: p_rec.information9 :=
407: pqh_cea_shd.g_old_rec.information9;
408: End If;
409: If (p_rec.information10 = hr_api.g_varchar2) then
410: p_rec.information10 :=
411: pqh_cea_shd.g_old_rec.information10;
407: pqh_cea_shd.g_old_rec.information9;
408: End If;
409: If (p_rec.information10 = hr_api.g_varchar2) then
410: p_rec.information10 :=
411: pqh_cea_shd.g_old_rec.information10;
412: End If;
413: If (p_rec.information11 = hr_api.g_varchar2) then
414: p_rec.information11 :=
415: pqh_cea_shd.g_old_rec.information11;
411: pqh_cea_shd.g_old_rec.information10;
412: End If;
413: If (p_rec.information11 = hr_api.g_varchar2) then
414: p_rec.information11 :=
415: pqh_cea_shd.g_old_rec.information11;
416: End If;
417: If (p_rec.information12 = hr_api.g_varchar2) then
418: p_rec.information12 :=
419: pqh_cea_shd.g_old_rec.information12;
415: pqh_cea_shd.g_old_rec.information11;
416: End If;
417: If (p_rec.information12 = hr_api.g_varchar2) then
418: p_rec.information12 :=
419: pqh_cea_shd.g_old_rec.information12;
420: End If;
421: If (p_rec.information13 = hr_api.g_varchar2) then
422: p_rec.information13 :=
423: pqh_cea_shd.g_old_rec.information13;
419: pqh_cea_shd.g_old_rec.information12;
420: End If;
421: If (p_rec.information13 = hr_api.g_varchar2) then
422: p_rec.information13 :=
423: pqh_cea_shd.g_old_rec.information13;
424: End If;
425: If (p_rec.information14 = hr_api.g_varchar2) then
426: p_rec.information14 :=
427: pqh_cea_shd.g_old_rec.information14;
423: pqh_cea_shd.g_old_rec.information13;
424: End If;
425: If (p_rec.information14 = hr_api.g_varchar2) then
426: p_rec.information14 :=
427: pqh_cea_shd.g_old_rec.information14;
428: End If;
429: If (p_rec.information15 = hr_api.g_varchar2) then
430: p_rec.information15 :=
431: pqh_cea_shd.g_old_rec.information15;
427: pqh_cea_shd.g_old_rec.information14;
428: End If;
429: If (p_rec.information15 = hr_api.g_varchar2) then
430: p_rec.information15 :=
431: pqh_cea_shd.g_old_rec.information15;
432: End If;
433: If (p_rec.information16 = hr_api.g_varchar2) then
434: p_rec.information16 :=
435: pqh_cea_shd.g_old_rec.information16;
431: pqh_cea_shd.g_old_rec.information15;
432: End If;
433: If (p_rec.information16 = hr_api.g_varchar2) then
434: p_rec.information16 :=
435: pqh_cea_shd.g_old_rec.information16;
436: End If;
437: If (p_rec.information17 = hr_api.g_varchar2) then
438: p_rec.information17 :=
439: pqh_cea_shd.g_old_rec.information17;
435: pqh_cea_shd.g_old_rec.information16;
436: End If;
437: If (p_rec.information17 = hr_api.g_varchar2) then
438: p_rec.information17 :=
439: pqh_cea_shd.g_old_rec.information17;
440: End If;
441: If (p_rec.information18 = hr_api.g_varchar2) then
442: p_rec.information18 :=
443: pqh_cea_shd.g_old_rec.information18;
439: pqh_cea_shd.g_old_rec.information17;
440: End If;
441: If (p_rec.information18 = hr_api.g_varchar2) then
442: p_rec.information18 :=
443: pqh_cea_shd.g_old_rec.information18;
444: End If;
445: If (p_rec.information19 = hr_api.g_varchar2) then
446: p_rec.information19 :=
447: pqh_cea_shd.g_old_rec.information19;
443: pqh_cea_shd.g_old_rec.information18;
444: End If;
445: If (p_rec.information19 = hr_api.g_varchar2) then
446: p_rec.information19 :=
447: pqh_cea_shd.g_old_rec.information19;
448: End If;
449: If (p_rec.information20 = hr_api.g_varchar2) then
450: p_rec.information20 :=
451: pqh_cea_shd.g_old_rec.information20;
447: pqh_cea_shd.g_old_rec.information19;
448: End If;
449: If (p_rec.information20 = hr_api.g_varchar2) then
450: p_rec.information20 :=
451: pqh_cea_shd.g_old_rec.information20;
452: End If;
453: If (p_rec.information21 = hr_api.g_varchar2) then
454: p_rec.information21 :=
455: pqh_cea_shd.g_old_rec.information21;
451: pqh_cea_shd.g_old_rec.information20;
452: End If;
453: If (p_rec.information21 = hr_api.g_varchar2) then
454: p_rec.information21 :=
455: pqh_cea_shd.g_old_rec.information21;
456: End If;
457: If (p_rec.information22 = hr_api.g_varchar2) then
458: p_rec.information22 :=
459: pqh_cea_shd.g_old_rec.information22;
455: pqh_cea_shd.g_old_rec.information21;
456: End If;
457: If (p_rec.information22 = hr_api.g_varchar2) then
458: p_rec.information22 :=
459: pqh_cea_shd.g_old_rec.information22;
460: End If;
461: If (p_rec.information23 = hr_api.g_varchar2) then
462: p_rec.information23 :=
463: pqh_cea_shd.g_old_rec.information23;
459: pqh_cea_shd.g_old_rec.information22;
460: End If;
461: If (p_rec.information23 = hr_api.g_varchar2) then
462: p_rec.information23 :=
463: pqh_cea_shd.g_old_rec.information23;
464: End If;
465: If (p_rec.information24 = hr_api.g_varchar2) then
466: p_rec.information24 :=
467: pqh_cea_shd.g_old_rec.information24;
463: pqh_cea_shd.g_old_rec.information23;
464: End If;
465: If (p_rec.information24 = hr_api.g_varchar2) then
466: p_rec.information24 :=
467: pqh_cea_shd.g_old_rec.information24;
468: End If;
469: If (p_rec.information25 = hr_api.g_varchar2) then
470: p_rec.information25 :=
471: pqh_cea_shd.g_old_rec.information25;
467: pqh_cea_shd.g_old_rec.information24;
468: End If;
469: If (p_rec.information25 = hr_api.g_varchar2) then
470: p_rec.information25 :=
471: pqh_cea_shd.g_old_rec.information25;
472: End If;
473: If (p_rec.information26 = hr_api.g_varchar2) then
474: p_rec.information26 :=
475: pqh_cea_shd.g_old_rec.information26;
471: pqh_cea_shd.g_old_rec.information25;
472: End If;
473: If (p_rec.information26 = hr_api.g_varchar2) then
474: p_rec.information26 :=
475: pqh_cea_shd.g_old_rec.information26;
476: End If;
477: If (p_rec.information27 = hr_api.g_varchar2) then
478: p_rec.information27 :=
479: pqh_cea_shd.g_old_rec.information27;
475: pqh_cea_shd.g_old_rec.information26;
476: End If;
477: If (p_rec.information27 = hr_api.g_varchar2) then
478: p_rec.information27 :=
479: pqh_cea_shd.g_old_rec.information27;
480: End If;
481: If (p_rec.information28 = hr_api.g_varchar2) then
482: p_rec.information28 :=
483: pqh_cea_shd.g_old_rec.information28;
479: pqh_cea_shd.g_old_rec.information27;
480: End If;
481: If (p_rec.information28 = hr_api.g_varchar2) then
482: p_rec.information28 :=
483: pqh_cea_shd.g_old_rec.information28;
484: End If;
485: If (p_rec.information29 = hr_api.g_varchar2) then
486: p_rec.information29 :=
487: pqh_cea_shd.g_old_rec.information29;
483: pqh_cea_shd.g_old_rec.information28;
484: End If;
485: If (p_rec.information29 = hr_api.g_varchar2) then
486: p_rec.information29 :=
487: pqh_cea_shd.g_old_rec.information29;
488: End If;
489: If (p_rec.information30 = hr_api.g_varchar2) then
490: p_rec.information30 :=
491: pqh_cea_shd.g_old_rec.information30;
487: pqh_cea_shd.g_old_rec.information29;
488: End If;
489: If (p_rec.information30 = hr_api.g_varchar2) then
490: p_rec.information30 :=
491: pqh_cea_shd.g_old_rec.information30;
492: End If;
493: If (p_rec.check_information1 = hr_api.g_varchar2) then
494: p_rec.check_information1 :=
495: pqh_cea_shd.g_old_rec.check_information1;
491: pqh_cea_shd.g_old_rec.information30;
492: End If;
493: If (p_rec.check_information1 = hr_api.g_varchar2) then
494: p_rec.check_information1 :=
495: pqh_cea_shd.g_old_rec.check_information1;
496: End If;
497: If (p_rec.check_information2 = hr_api.g_varchar2) then
498: p_rec.check_information2 :=
499: pqh_cea_shd.g_old_rec.check_information2;
495: pqh_cea_shd.g_old_rec.check_information1;
496: End If;
497: If (p_rec.check_information2 = hr_api.g_varchar2) then
498: p_rec.check_information2 :=
499: pqh_cea_shd.g_old_rec.check_information2;
500: End If;
501: If (p_rec.check_information3 = hr_api.g_varchar2) then
502: p_rec.check_information3 :=
503: pqh_cea_shd.g_old_rec.check_information3;
499: pqh_cea_shd.g_old_rec.check_information2;
500: End If;
501: If (p_rec.check_information3 = hr_api.g_varchar2) then
502: p_rec.check_information3 :=
503: pqh_cea_shd.g_old_rec.check_information3;
504: End If;
505:
506: --
507: hr_utility.set_location(' Leaving:'||l_proc, 10);
513: -- ----------------------------------------------------------------------------
514: Procedure upd
515: (
516: p_effective_date in date,
517: p_rec in out nocopy pqh_cea_shd.g_rec_type
518: ) is
519: --
520: l_proc varchar2(72) := g_package||'upd';
521: --
523: hr_utility.set_location('Entering:'||l_proc, 5);
524: --
525: -- We must lock the row which we need to update.
526: --
527: pqh_cea_shd.lck
528: (
529: p_rec.copy_entity_attrib_id,
530: p_rec.object_version_number
531: );
599: p_check_information3 in varchar2 default hr_api.g_varchar2,
600: p_object_version_number in out nocopy number
601: ) is
602: --
603: l_rec pqh_cea_shd.g_rec_type;
604: l_proc varchar2(72) := g_package||'upd';
605: --
606: Begin
607: hr_utility.set_location('Entering:'||l_proc, 5);
609: -- Call conversion function to turn arguments into the
610: -- l_rec structure.
611: --
612: l_rec :=
613: pqh_cea_shd.convert_args
614: (
615: p_copy_entity_attrib_id,
616: p_copy_entity_txn_id,
617: p_row_type_cd,