48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in pqh_rei_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --
71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: pqh_rei_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: --
79: Raise;
110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in pqh_rei_shd.g_rec_type) is
115: --
116: l_proc varchar2(72) := g_package||'pre_delete';
117: --
118: Begin
152: -- Internal Row Handler Use Only.
153: --
154: -- {End Of Comments}
155: -- -----------------------------------------------------------------------------
156: Procedure post_delete(p_rec in pqh_rei_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin
162: begin
163: --
164: pqh_rei_rkd.after_delete
165: (p_role_extra_info_id => p_rec.role_extra_info_id
166: ,p_role_id_o => pqh_rei_shd.g_old_rec.role_id
167: ,p_information_type_o => pqh_rei_shd.g_old_rec.information_type
168: ,p_request_id_o => pqh_rei_shd.g_old_rec.request_id
169: ,p_program_application_id_o => pqh_rei_shd.g_old_rec.program_application_id
170: ,p_program_id_o => pqh_rei_shd.g_old_rec.program_id
163: --
164: pqh_rei_rkd.after_delete
165: (p_role_extra_info_id => p_rec.role_extra_info_id
166: ,p_role_id_o => pqh_rei_shd.g_old_rec.role_id
167: ,p_information_type_o => pqh_rei_shd.g_old_rec.information_type
168: ,p_request_id_o => pqh_rei_shd.g_old_rec.request_id
169: ,p_program_application_id_o => pqh_rei_shd.g_old_rec.program_application_id
170: ,p_program_id_o => pqh_rei_shd.g_old_rec.program_id
171: ,p_program_update_date_o => pqh_rei_shd.g_old_rec.program_update_date
164: pqh_rei_rkd.after_delete
165: (p_role_extra_info_id => p_rec.role_extra_info_id
166: ,p_role_id_o => pqh_rei_shd.g_old_rec.role_id
167: ,p_information_type_o => pqh_rei_shd.g_old_rec.information_type
168: ,p_request_id_o => pqh_rei_shd.g_old_rec.request_id
169: ,p_program_application_id_o => pqh_rei_shd.g_old_rec.program_application_id
170: ,p_program_id_o => pqh_rei_shd.g_old_rec.program_id
171: ,p_program_update_date_o => pqh_rei_shd.g_old_rec.program_update_date
172: ,p_attribute_category_o => pqh_rei_shd.g_old_rec.attribute_category
165: (p_role_extra_info_id => p_rec.role_extra_info_id
166: ,p_role_id_o => pqh_rei_shd.g_old_rec.role_id
167: ,p_information_type_o => pqh_rei_shd.g_old_rec.information_type
168: ,p_request_id_o => pqh_rei_shd.g_old_rec.request_id
169: ,p_program_application_id_o => pqh_rei_shd.g_old_rec.program_application_id
170: ,p_program_id_o => pqh_rei_shd.g_old_rec.program_id
171: ,p_program_update_date_o => pqh_rei_shd.g_old_rec.program_update_date
172: ,p_attribute_category_o => pqh_rei_shd.g_old_rec.attribute_category
173: ,p_attribute1_o => pqh_rei_shd.g_old_rec.attribute1
166: ,p_role_id_o => pqh_rei_shd.g_old_rec.role_id
167: ,p_information_type_o => pqh_rei_shd.g_old_rec.information_type
168: ,p_request_id_o => pqh_rei_shd.g_old_rec.request_id
169: ,p_program_application_id_o => pqh_rei_shd.g_old_rec.program_application_id
170: ,p_program_id_o => pqh_rei_shd.g_old_rec.program_id
171: ,p_program_update_date_o => pqh_rei_shd.g_old_rec.program_update_date
172: ,p_attribute_category_o => pqh_rei_shd.g_old_rec.attribute_category
173: ,p_attribute1_o => pqh_rei_shd.g_old_rec.attribute1
174: ,p_attribute2_o => pqh_rei_shd.g_old_rec.attribute2
167: ,p_information_type_o => pqh_rei_shd.g_old_rec.information_type
168: ,p_request_id_o => pqh_rei_shd.g_old_rec.request_id
169: ,p_program_application_id_o => pqh_rei_shd.g_old_rec.program_application_id
170: ,p_program_id_o => pqh_rei_shd.g_old_rec.program_id
171: ,p_program_update_date_o => pqh_rei_shd.g_old_rec.program_update_date
172: ,p_attribute_category_o => pqh_rei_shd.g_old_rec.attribute_category
173: ,p_attribute1_o => pqh_rei_shd.g_old_rec.attribute1
174: ,p_attribute2_o => pqh_rei_shd.g_old_rec.attribute2
175: ,p_attribute3_o => pqh_rei_shd.g_old_rec.attribute3
168: ,p_request_id_o => pqh_rei_shd.g_old_rec.request_id
169: ,p_program_application_id_o => pqh_rei_shd.g_old_rec.program_application_id
170: ,p_program_id_o => pqh_rei_shd.g_old_rec.program_id
171: ,p_program_update_date_o => pqh_rei_shd.g_old_rec.program_update_date
172: ,p_attribute_category_o => pqh_rei_shd.g_old_rec.attribute_category
173: ,p_attribute1_o => pqh_rei_shd.g_old_rec.attribute1
174: ,p_attribute2_o => pqh_rei_shd.g_old_rec.attribute2
175: ,p_attribute3_o => pqh_rei_shd.g_old_rec.attribute3
176: ,p_attribute4_o => pqh_rei_shd.g_old_rec.attribute4
169: ,p_program_application_id_o => pqh_rei_shd.g_old_rec.program_application_id
170: ,p_program_id_o => pqh_rei_shd.g_old_rec.program_id
171: ,p_program_update_date_o => pqh_rei_shd.g_old_rec.program_update_date
172: ,p_attribute_category_o => pqh_rei_shd.g_old_rec.attribute_category
173: ,p_attribute1_o => pqh_rei_shd.g_old_rec.attribute1
174: ,p_attribute2_o => pqh_rei_shd.g_old_rec.attribute2
175: ,p_attribute3_o => pqh_rei_shd.g_old_rec.attribute3
176: ,p_attribute4_o => pqh_rei_shd.g_old_rec.attribute4
177: ,p_attribute5_o => pqh_rei_shd.g_old_rec.attribute5
170: ,p_program_id_o => pqh_rei_shd.g_old_rec.program_id
171: ,p_program_update_date_o => pqh_rei_shd.g_old_rec.program_update_date
172: ,p_attribute_category_o => pqh_rei_shd.g_old_rec.attribute_category
173: ,p_attribute1_o => pqh_rei_shd.g_old_rec.attribute1
174: ,p_attribute2_o => pqh_rei_shd.g_old_rec.attribute2
175: ,p_attribute3_o => pqh_rei_shd.g_old_rec.attribute3
176: ,p_attribute4_o => pqh_rei_shd.g_old_rec.attribute4
177: ,p_attribute5_o => pqh_rei_shd.g_old_rec.attribute5
178: ,p_attribute6_o => pqh_rei_shd.g_old_rec.attribute6
171: ,p_program_update_date_o => pqh_rei_shd.g_old_rec.program_update_date
172: ,p_attribute_category_o => pqh_rei_shd.g_old_rec.attribute_category
173: ,p_attribute1_o => pqh_rei_shd.g_old_rec.attribute1
174: ,p_attribute2_o => pqh_rei_shd.g_old_rec.attribute2
175: ,p_attribute3_o => pqh_rei_shd.g_old_rec.attribute3
176: ,p_attribute4_o => pqh_rei_shd.g_old_rec.attribute4
177: ,p_attribute5_o => pqh_rei_shd.g_old_rec.attribute5
178: ,p_attribute6_o => pqh_rei_shd.g_old_rec.attribute6
179: ,p_attribute7_o => pqh_rei_shd.g_old_rec.attribute7
172: ,p_attribute_category_o => pqh_rei_shd.g_old_rec.attribute_category
173: ,p_attribute1_o => pqh_rei_shd.g_old_rec.attribute1
174: ,p_attribute2_o => pqh_rei_shd.g_old_rec.attribute2
175: ,p_attribute3_o => pqh_rei_shd.g_old_rec.attribute3
176: ,p_attribute4_o => pqh_rei_shd.g_old_rec.attribute4
177: ,p_attribute5_o => pqh_rei_shd.g_old_rec.attribute5
178: ,p_attribute6_o => pqh_rei_shd.g_old_rec.attribute6
179: ,p_attribute7_o => pqh_rei_shd.g_old_rec.attribute7
180: ,p_attribute8_o => pqh_rei_shd.g_old_rec.attribute8
173: ,p_attribute1_o => pqh_rei_shd.g_old_rec.attribute1
174: ,p_attribute2_o => pqh_rei_shd.g_old_rec.attribute2
175: ,p_attribute3_o => pqh_rei_shd.g_old_rec.attribute3
176: ,p_attribute4_o => pqh_rei_shd.g_old_rec.attribute4
177: ,p_attribute5_o => pqh_rei_shd.g_old_rec.attribute5
178: ,p_attribute6_o => pqh_rei_shd.g_old_rec.attribute6
179: ,p_attribute7_o => pqh_rei_shd.g_old_rec.attribute7
180: ,p_attribute8_o => pqh_rei_shd.g_old_rec.attribute8
181: ,p_attribute9_o => pqh_rei_shd.g_old_rec.attribute9
174: ,p_attribute2_o => pqh_rei_shd.g_old_rec.attribute2
175: ,p_attribute3_o => pqh_rei_shd.g_old_rec.attribute3
176: ,p_attribute4_o => pqh_rei_shd.g_old_rec.attribute4
177: ,p_attribute5_o => pqh_rei_shd.g_old_rec.attribute5
178: ,p_attribute6_o => pqh_rei_shd.g_old_rec.attribute6
179: ,p_attribute7_o => pqh_rei_shd.g_old_rec.attribute7
180: ,p_attribute8_o => pqh_rei_shd.g_old_rec.attribute8
181: ,p_attribute9_o => pqh_rei_shd.g_old_rec.attribute9
182: ,p_attribute10_o => pqh_rei_shd.g_old_rec.attribute10
175: ,p_attribute3_o => pqh_rei_shd.g_old_rec.attribute3
176: ,p_attribute4_o => pqh_rei_shd.g_old_rec.attribute4
177: ,p_attribute5_o => pqh_rei_shd.g_old_rec.attribute5
178: ,p_attribute6_o => pqh_rei_shd.g_old_rec.attribute6
179: ,p_attribute7_o => pqh_rei_shd.g_old_rec.attribute7
180: ,p_attribute8_o => pqh_rei_shd.g_old_rec.attribute8
181: ,p_attribute9_o => pqh_rei_shd.g_old_rec.attribute9
182: ,p_attribute10_o => pqh_rei_shd.g_old_rec.attribute10
183: ,p_attribute11_o => pqh_rei_shd.g_old_rec.attribute11
176: ,p_attribute4_o => pqh_rei_shd.g_old_rec.attribute4
177: ,p_attribute5_o => pqh_rei_shd.g_old_rec.attribute5
178: ,p_attribute6_o => pqh_rei_shd.g_old_rec.attribute6
179: ,p_attribute7_o => pqh_rei_shd.g_old_rec.attribute7
180: ,p_attribute8_o => pqh_rei_shd.g_old_rec.attribute8
181: ,p_attribute9_o => pqh_rei_shd.g_old_rec.attribute9
182: ,p_attribute10_o => pqh_rei_shd.g_old_rec.attribute10
183: ,p_attribute11_o => pqh_rei_shd.g_old_rec.attribute11
184: ,p_attribute12_o => pqh_rei_shd.g_old_rec.attribute12
177: ,p_attribute5_o => pqh_rei_shd.g_old_rec.attribute5
178: ,p_attribute6_o => pqh_rei_shd.g_old_rec.attribute6
179: ,p_attribute7_o => pqh_rei_shd.g_old_rec.attribute7
180: ,p_attribute8_o => pqh_rei_shd.g_old_rec.attribute8
181: ,p_attribute9_o => pqh_rei_shd.g_old_rec.attribute9
182: ,p_attribute10_o => pqh_rei_shd.g_old_rec.attribute10
183: ,p_attribute11_o => pqh_rei_shd.g_old_rec.attribute11
184: ,p_attribute12_o => pqh_rei_shd.g_old_rec.attribute12
185: ,p_attribute13_o => pqh_rei_shd.g_old_rec.attribute13
178: ,p_attribute6_o => pqh_rei_shd.g_old_rec.attribute6
179: ,p_attribute7_o => pqh_rei_shd.g_old_rec.attribute7
180: ,p_attribute8_o => pqh_rei_shd.g_old_rec.attribute8
181: ,p_attribute9_o => pqh_rei_shd.g_old_rec.attribute9
182: ,p_attribute10_o => pqh_rei_shd.g_old_rec.attribute10
183: ,p_attribute11_o => pqh_rei_shd.g_old_rec.attribute11
184: ,p_attribute12_o => pqh_rei_shd.g_old_rec.attribute12
185: ,p_attribute13_o => pqh_rei_shd.g_old_rec.attribute13
186: ,p_attribute14_o => pqh_rei_shd.g_old_rec.attribute14
179: ,p_attribute7_o => pqh_rei_shd.g_old_rec.attribute7
180: ,p_attribute8_o => pqh_rei_shd.g_old_rec.attribute8
181: ,p_attribute9_o => pqh_rei_shd.g_old_rec.attribute9
182: ,p_attribute10_o => pqh_rei_shd.g_old_rec.attribute10
183: ,p_attribute11_o => pqh_rei_shd.g_old_rec.attribute11
184: ,p_attribute12_o => pqh_rei_shd.g_old_rec.attribute12
185: ,p_attribute13_o => pqh_rei_shd.g_old_rec.attribute13
186: ,p_attribute14_o => pqh_rei_shd.g_old_rec.attribute14
187: ,p_attribute15_o => pqh_rei_shd.g_old_rec.attribute15
180: ,p_attribute8_o => pqh_rei_shd.g_old_rec.attribute8
181: ,p_attribute9_o => pqh_rei_shd.g_old_rec.attribute9
182: ,p_attribute10_o => pqh_rei_shd.g_old_rec.attribute10
183: ,p_attribute11_o => pqh_rei_shd.g_old_rec.attribute11
184: ,p_attribute12_o => pqh_rei_shd.g_old_rec.attribute12
185: ,p_attribute13_o => pqh_rei_shd.g_old_rec.attribute13
186: ,p_attribute14_o => pqh_rei_shd.g_old_rec.attribute14
187: ,p_attribute15_o => pqh_rei_shd.g_old_rec.attribute15
188: ,p_attribute16_o => pqh_rei_shd.g_old_rec.attribute16
181: ,p_attribute9_o => pqh_rei_shd.g_old_rec.attribute9
182: ,p_attribute10_o => pqh_rei_shd.g_old_rec.attribute10
183: ,p_attribute11_o => pqh_rei_shd.g_old_rec.attribute11
184: ,p_attribute12_o => pqh_rei_shd.g_old_rec.attribute12
185: ,p_attribute13_o => pqh_rei_shd.g_old_rec.attribute13
186: ,p_attribute14_o => pqh_rei_shd.g_old_rec.attribute14
187: ,p_attribute15_o => pqh_rei_shd.g_old_rec.attribute15
188: ,p_attribute16_o => pqh_rei_shd.g_old_rec.attribute16
189: ,p_attribute17_o => pqh_rei_shd.g_old_rec.attribute17
182: ,p_attribute10_o => pqh_rei_shd.g_old_rec.attribute10
183: ,p_attribute11_o => pqh_rei_shd.g_old_rec.attribute11
184: ,p_attribute12_o => pqh_rei_shd.g_old_rec.attribute12
185: ,p_attribute13_o => pqh_rei_shd.g_old_rec.attribute13
186: ,p_attribute14_o => pqh_rei_shd.g_old_rec.attribute14
187: ,p_attribute15_o => pqh_rei_shd.g_old_rec.attribute15
188: ,p_attribute16_o => pqh_rei_shd.g_old_rec.attribute16
189: ,p_attribute17_o => pqh_rei_shd.g_old_rec.attribute17
190: ,p_attribute18_o => pqh_rei_shd.g_old_rec.attribute18
183: ,p_attribute11_o => pqh_rei_shd.g_old_rec.attribute11
184: ,p_attribute12_o => pqh_rei_shd.g_old_rec.attribute12
185: ,p_attribute13_o => pqh_rei_shd.g_old_rec.attribute13
186: ,p_attribute14_o => pqh_rei_shd.g_old_rec.attribute14
187: ,p_attribute15_o => pqh_rei_shd.g_old_rec.attribute15
188: ,p_attribute16_o => pqh_rei_shd.g_old_rec.attribute16
189: ,p_attribute17_o => pqh_rei_shd.g_old_rec.attribute17
190: ,p_attribute18_o => pqh_rei_shd.g_old_rec.attribute18
191: ,p_attribute19_o => pqh_rei_shd.g_old_rec.attribute19
184: ,p_attribute12_o => pqh_rei_shd.g_old_rec.attribute12
185: ,p_attribute13_o => pqh_rei_shd.g_old_rec.attribute13
186: ,p_attribute14_o => pqh_rei_shd.g_old_rec.attribute14
187: ,p_attribute15_o => pqh_rei_shd.g_old_rec.attribute15
188: ,p_attribute16_o => pqh_rei_shd.g_old_rec.attribute16
189: ,p_attribute17_o => pqh_rei_shd.g_old_rec.attribute17
190: ,p_attribute18_o => pqh_rei_shd.g_old_rec.attribute18
191: ,p_attribute19_o => pqh_rei_shd.g_old_rec.attribute19
192: ,p_attribute20_o => pqh_rei_shd.g_old_rec.attribute20
185: ,p_attribute13_o => pqh_rei_shd.g_old_rec.attribute13
186: ,p_attribute14_o => pqh_rei_shd.g_old_rec.attribute14
187: ,p_attribute15_o => pqh_rei_shd.g_old_rec.attribute15
188: ,p_attribute16_o => pqh_rei_shd.g_old_rec.attribute16
189: ,p_attribute17_o => pqh_rei_shd.g_old_rec.attribute17
190: ,p_attribute18_o => pqh_rei_shd.g_old_rec.attribute18
191: ,p_attribute19_o => pqh_rei_shd.g_old_rec.attribute19
192: ,p_attribute20_o => pqh_rei_shd.g_old_rec.attribute20
193: ,p_attribute21_o => pqh_rei_shd.g_old_rec.attribute21
186: ,p_attribute14_o => pqh_rei_shd.g_old_rec.attribute14
187: ,p_attribute15_o => pqh_rei_shd.g_old_rec.attribute15
188: ,p_attribute16_o => pqh_rei_shd.g_old_rec.attribute16
189: ,p_attribute17_o => pqh_rei_shd.g_old_rec.attribute17
190: ,p_attribute18_o => pqh_rei_shd.g_old_rec.attribute18
191: ,p_attribute19_o => pqh_rei_shd.g_old_rec.attribute19
192: ,p_attribute20_o => pqh_rei_shd.g_old_rec.attribute20
193: ,p_attribute21_o => pqh_rei_shd.g_old_rec.attribute21
194: ,p_attribute22_o => pqh_rei_shd.g_old_rec.attribute22
187: ,p_attribute15_o => pqh_rei_shd.g_old_rec.attribute15
188: ,p_attribute16_o => pqh_rei_shd.g_old_rec.attribute16
189: ,p_attribute17_o => pqh_rei_shd.g_old_rec.attribute17
190: ,p_attribute18_o => pqh_rei_shd.g_old_rec.attribute18
191: ,p_attribute19_o => pqh_rei_shd.g_old_rec.attribute19
192: ,p_attribute20_o => pqh_rei_shd.g_old_rec.attribute20
193: ,p_attribute21_o => pqh_rei_shd.g_old_rec.attribute21
194: ,p_attribute22_o => pqh_rei_shd.g_old_rec.attribute22
195: ,p_attribute23_o => pqh_rei_shd.g_old_rec.attribute23
188: ,p_attribute16_o => pqh_rei_shd.g_old_rec.attribute16
189: ,p_attribute17_o => pqh_rei_shd.g_old_rec.attribute17
190: ,p_attribute18_o => pqh_rei_shd.g_old_rec.attribute18
191: ,p_attribute19_o => pqh_rei_shd.g_old_rec.attribute19
192: ,p_attribute20_o => pqh_rei_shd.g_old_rec.attribute20
193: ,p_attribute21_o => pqh_rei_shd.g_old_rec.attribute21
194: ,p_attribute22_o => pqh_rei_shd.g_old_rec.attribute22
195: ,p_attribute23_o => pqh_rei_shd.g_old_rec.attribute23
196: ,p_attribute24_o => pqh_rei_shd.g_old_rec.attribute24
189: ,p_attribute17_o => pqh_rei_shd.g_old_rec.attribute17
190: ,p_attribute18_o => pqh_rei_shd.g_old_rec.attribute18
191: ,p_attribute19_o => pqh_rei_shd.g_old_rec.attribute19
192: ,p_attribute20_o => pqh_rei_shd.g_old_rec.attribute20
193: ,p_attribute21_o => pqh_rei_shd.g_old_rec.attribute21
194: ,p_attribute22_o => pqh_rei_shd.g_old_rec.attribute22
195: ,p_attribute23_o => pqh_rei_shd.g_old_rec.attribute23
196: ,p_attribute24_o => pqh_rei_shd.g_old_rec.attribute24
197: ,p_attribute25_o => pqh_rei_shd.g_old_rec.attribute25
190: ,p_attribute18_o => pqh_rei_shd.g_old_rec.attribute18
191: ,p_attribute19_o => pqh_rei_shd.g_old_rec.attribute19
192: ,p_attribute20_o => pqh_rei_shd.g_old_rec.attribute20
193: ,p_attribute21_o => pqh_rei_shd.g_old_rec.attribute21
194: ,p_attribute22_o => pqh_rei_shd.g_old_rec.attribute22
195: ,p_attribute23_o => pqh_rei_shd.g_old_rec.attribute23
196: ,p_attribute24_o => pqh_rei_shd.g_old_rec.attribute24
197: ,p_attribute25_o => pqh_rei_shd.g_old_rec.attribute25
198: ,p_attribute26_o => pqh_rei_shd.g_old_rec.attribute26
191: ,p_attribute19_o => pqh_rei_shd.g_old_rec.attribute19
192: ,p_attribute20_o => pqh_rei_shd.g_old_rec.attribute20
193: ,p_attribute21_o => pqh_rei_shd.g_old_rec.attribute21
194: ,p_attribute22_o => pqh_rei_shd.g_old_rec.attribute22
195: ,p_attribute23_o => pqh_rei_shd.g_old_rec.attribute23
196: ,p_attribute24_o => pqh_rei_shd.g_old_rec.attribute24
197: ,p_attribute25_o => pqh_rei_shd.g_old_rec.attribute25
198: ,p_attribute26_o => pqh_rei_shd.g_old_rec.attribute26
199: ,p_attribute27_o => pqh_rei_shd.g_old_rec.attribute27
192: ,p_attribute20_o => pqh_rei_shd.g_old_rec.attribute20
193: ,p_attribute21_o => pqh_rei_shd.g_old_rec.attribute21
194: ,p_attribute22_o => pqh_rei_shd.g_old_rec.attribute22
195: ,p_attribute23_o => pqh_rei_shd.g_old_rec.attribute23
196: ,p_attribute24_o => pqh_rei_shd.g_old_rec.attribute24
197: ,p_attribute25_o => pqh_rei_shd.g_old_rec.attribute25
198: ,p_attribute26_o => pqh_rei_shd.g_old_rec.attribute26
199: ,p_attribute27_o => pqh_rei_shd.g_old_rec.attribute27
200: ,p_attribute28_o => pqh_rei_shd.g_old_rec.attribute28
193: ,p_attribute21_o => pqh_rei_shd.g_old_rec.attribute21
194: ,p_attribute22_o => pqh_rei_shd.g_old_rec.attribute22
195: ,p_attribute23_o => pqh_rei_shd.g_old_rec.attribute23
196: ,p_attribute24_o => pqh_rei_shd.g_old_rec.attribute24
197: ,p_attribute25_o => pqh_rei_shd.g_old_rec.attribute25
198: ,p_attribute26_o => pqh_rei_shd.g_old_rec.attribute26
199: ,p_attribute27_o => pqh_rei_shd.g_old_rec.attribute27
200: ,p_attribute28_o => pqh_rei_shd.g_old_rec.attribute28
201: ,p_attribute29_o => pqh_rei_shd.g_old_rec.attribute29
194: ,p_attribute22_o => pqh_rei_shd.g_old_rec.attribute22
195: ,p_attribute23_o => pqh_rei_shd.g_old_rec.attribute23
196: ,p_attribute24_o => pqh_rei_shd.g_old_rec.attribute24
197: ,p_attribute25_o => pqh_rei_shd.g_old_rec.attribute25
198: ,p_attribute26_o => pqh_rei_shd.g_old_rec.attribute26
199: ,p_attribute27_o => pqh_rei_shd.g_old_rec.attribute27
200: ,p_attribute28_o => pqh_rei_shd.g_old_rec.attribute28
201: ,p_attribute29_o => pqh_rei_shd.g_old_rec.attribute29
202: ,p_attribute30_o => pqh_rei_shd.g_old_rec.attribute30
195: ,p_attribute23_o => pqh_rei_shd.g_old_rec.attribute23
196: ,p_attribute24_o => pqh_rei_shd.g_old_rec.attribute24
197: ,p_attribute25_o => pqh_rei_shd.g_old_rec.attribute25
198: ,p_attribute26_o => pqh_rei_shd.g_old_rec.attribute26
199: ,p_attribute27_o => pqh_rei_shd.g_old_rec.attribute27
200: ,p_attribute28_o => pqh_rei_shd.g_old_rec.attribute28
201: ,p_attribute29_o => pqh_rei_shd.g_old_rec.attribute29
202: ,p_attribute30_o => pqh_rei_shd.g_old_rec.attribute30
203: ,p_information_category_o => pqh_rei_shd.g_old_rec.information_category
196: ,p_attribute24_o => pqh_rei_shd.g_old_rec.attribute24
197: ,p_attribute25_o => pqh_rei_shd.g_old_rec.attribute25
198: ,p_attribute26_o => pqh_rei_shd.g_old_rec.attribute26
199: ,p_attribute27_o => pqh_rei_shd.g_old_rec.attribute27
200: ,p_attribute28_o => pqh_rei_shd.g_old_rec.attribute28
201: ,p_attribute29_o => pqh_rei_shd.g_old_rec.attribute29
202: ,p_attribute30_o => pqh_rei_shd.g_old_rec.attribute30
203: ,p_information_category_o => pqh_rei_shd.g_old_rec.information_category
204: ,p_information1_o => pqh_rei_shd.g_old_rec.information1
197: ,p_attribute25_o => pqh_rei_shd.g_old_rec.attribute25
198: ,p_attribute26_o => pqh_rei_shd.g_old_rec.attribute26
199: ,p_attribute27_o => pqh_rei_shd.g_old_rec.attribute27
200: ,p_attribute28_o => pqh_rei_shd.g_old_rec.attribute28
201: ,p_attribute29_o => pqh_rei_shd.g_old_rec.attribute29
202: ,p_attribute30_o => pqh_rei_shd.g_old_rec.attribute30
203: ,p_information_category_o => pqh_rei_shd.g_old_rec.information_category
204: ,p_information1_o => pqh_rei_shd.g_old_rec.information1
205: ,p_information2_o => pqh_rei_shd.g_old_rec.information2
198: ,p_attribute26_o => pqh_rei_shd.g_old_rec.attribute26
199: ,p_attribute27_o => pqh_rei_shd.g_old_rec.attribute27
200: ,p_attribute28_o => pqh_rei_shd.g_old_rec.attribute28
201: ,p_attribute29_o => pqh_rei_shd.g_old_rec.attribute29
202: ,p_attribute30_o => pqh_rei_shd.g_old_rec.attribute30
203: ,p_information_category_o => pqh_rei_shd.g_old_rec.information_category
204: ,p_information1_o => pqh_rei_shd.g_old_rec.information1
205: ,p_information2_o => pqh_rei_shd.g_old_rec.information2
206: ,p_information3_o => pqh_rei_shd.g_old_rec.information3
199: ,p_attribute27_o => pqh_rei_shd.g_old_rec.attribute27
200: ,p_attribute28_o => pqh_rei_shd.g_old_rec.attribute28
201: ,p_attribute29_o => pqh_rei_shd.g_old_rec.attribute29
202: ,p_attribute30_o => pqh_rei_shd.g_old_rec.attribute30
203: ,p_information_category_o => pqh_rei_shd.g_old_rec.information_category
204: ,p_information1_o => pqh_rei_shd.g_old_rec.information1
205: ,p_information2_o => pqh_rei_shd.g_old_rec.information2
206: ,p_information3_o => pqh_rei_shd.g_old_rec.information3
207: ,p_information4_o => pqh_rei_shd.g_old_rec.information4
200: ,p_attribute28_o => pqh_rei_shd.g_old_rec.attribute28
201: ,p_attribute29_o => pqh_rei_shd.g_old_rec.attribute29
202: ,p_attribute30_o => pqh_rei_shd.g_old_rec.attribute30
203: ,p_information_category_o => pqh_rei_shd.g_old_rec.information_category
204: ,p_information1_o => pqh_rei_shd.g_old_rec.information1
205: ,p_information2_o => pqh_rei_shd.g_old_rec.information2
206: ,p_information3_o => pqh_rei_shd.g_old_rec.information3
207: ,p_information4_o => pqh_rei_shd.g_old_rec.information4
208: ,p_information5_o => pqh_rei_shd.g_old_rec.information5
201: ,p_attribute29_o => pqh_rei_shd.g_old_rec.attribute29
202: ,p_attribute30_o => pqh_rei_shd.g_old_rec.attribute30
203: ,p_information_category_o => pqh_rei_shd.g_old_rec.information_category
204: ,p_information1_o => pqh_rei_shd.g_old_rec.information1
205: ,p_information2_o => pqh_rei_shd.g_old_rec.information2
206: ,p_information3_o => pqh_rei_shd.g_old_rec.information3
207: ,p_information4_o => pqh_rei_shd.g_old_rec.information4
208: ,p_information5_o => pqh_rei_shd.g_old_rec.information5
209: ,p_information6_o => pqh_rei_shd.g_old_rec.information6
202: ,p_attribute30_o => pqh_rei_shd.g_old_rec.attribute30
203: ,p_information_category_o => pqh_rei_shd.g_old_rec.information_category
204: ,p_information1_o => pqh_rei_shd.g_old_rec.information1
205: ,p_information2_o => pqh_rei_shd.g_old_rec.information2
206: ,p_information3_o => pqh_rei_shd.g_old_rec.information3
207: ,p_information4_o => pqh_rei_shd.g_old_rec.information4
208: ,p_information5_o => pqh_rei_shd.g_old_rec.information5
209: ,p_information6_o => pqh_rei_shd.g_old_rec.information6
210: ,p_information7_o => pqh_rei_shd.g_old_rec.information7
203: ,p_information_category_o => pqh_rei_shd.g_old_rec.information_category
204: ,p_information1_o => pqh_rei_shd.g_old_rec.information1
205: ,p_information2_o => pqh_rei_shd.g_old_rec.information2
206: ,p_information3_o => pqh_rei_shd.g_old_rec.information3
207: ,p_information4_o => pqh_rei_shd.g_old_rec.information4
208: ,p_information5_o => pqh_rei_shd.g_old_rec.information5
209: ,p_information6_o => pqh_rei_shd.g_old_rec.information6
210: ,p_information7_o => pqh_rei_shd.g_old_rec.information7
211: ,p_information8_o => pqh_rei_shd.g_old_rec.information8
204: ,p_information1_o => pqh_rei_shd.g_old_rec.information1
205: ,p_information2_o => pqh_rei_shd.g_old_rec.information2
206: ,p_information3_o => pqh_rei_shd.g_old_rec.information3
207: ,p_information4_o => pqh_rei_shd.g_old_rec.information4
208: ,p_information5_o => pqh_rei_shd.g_old_rec.information5
209: ,p_information6_o => pqh_rei_shd.g_old_rec.information6
210: ,p_information7_o => pqh_rei_shd.g_old_rec.information7
211: ,p_information8_o => pqh_rei_shd.g_old_rec.information8
212: ,p_information9_o => pqh_rei_shd.g_old_rec.information9
205: ,p_information2_o => pqh_rei_shd.g_old_rec.information2
206: ,p_information3_o => pqh_rei_shd.g_old_rec.information3
207: ,p_information4_o => pqh_rei_shd.g_old_rec.information4
208: ,p_information5_o => pqh_rei_shd.g_old_rec.information5
209: ,p_information6_o => pqh_rei_shd.g_old_rec.information6
210: ,p_information7_o => pqh_rei_shd.g_old_rec.information7
211: ,p_information8_o => pqh_rei_shd.g_old_rec.information8
212: ,p_information9_o => pqh_rei_shd.g_old_rec.information9
213: ,p_information10_o => pqh_rei_shd.g_old_rec.information10
206: ,p_information3_o => pqh_rei_shd.g_old_rec.information3
207: ,p_information4_o => pqh_rei_shd.g_old_rec.information4
208: ,p_information5_o => pqh_rei_shd.g_old_rec.information5
209: ,p_information6_o => pqh_rei_shd.g_old_rec.information6
210: ,p_information7_o => pqh_rei_shd.g_old_rec.information7
211: ,p_information8_o => pqh_rei_shd.g_old_rec.information8
212: ,p_information9_o => pqh_rei_shd.g_old_rec.information9
213: ,p_information10_o => pqh_rei_shd.g_old_rec.information10
214: ,p_information11_o => pqh_rei_shd.g_old_rec.information11
207: ,p_information4_o => pqh_rei_shd.g_old_rec.information4
208: ,p_information5_o => pqh_rei_shd.g_old_rec.information5
209: ,p_information6_o => pqh_rei_shd.g_old_rec.information6
210: ,p_information7_o => pqh_rei_shd.g_old_rec.information7
211: ,p_information8_o => pqh_rei_shd.g_old_rec.information8
212: ,p_information9_o => pqh_rei_shd.g_old_rec.information9
213: ,p_information10_o => pqh_rei_shd.g_old_rec.information10
214: ,p_information11_o => pqh_rei_shd.g_old_rec.information11
215: ,p_information12_o => pqh_rei_shd.g_old_rec.information12
208: ,p_information5_o => pqh_rei_shd.g_old_rec.information5
209: ,p_information6_o => pqh_rei_shd.g_old_rec.information6
210: ,p_information7_o => pqh_rei_shd.g_old_rec.information7
211: ,p_information8_o => pqh_rei_shd.g_old_rec.information8
212: ,p_information9_o => pqh_rei_shd.g_old_rec.information9
213: ,p_information10_o => pqh_rei_shd.g_old_rec.information10
214: ,p_information11_o => pqh_rei_shd.g_old_rec.information11
215: ,p_information12_o => pqh_rei_shd.g_old_rec.information12
216: ,p_information13_o => pqh_rei_shd.g_old_rec.information13
209: ,p_information6_o => pqh_rei_shd.g_old_rec.information6
210: ,p_information7_o => pqh_rei_shd.g_old_rec.information7
211: ,p_information8_o => pqh_rei_shd.g_old_rec.information8
212: ,p_information9_o => pqh_rei_shd.g_old_rec.information9
213: ,p_information10_o => pqh_rei_shd.g_old_rec.information10
214: ,p_information11_o => pqh_rei_shd.g_old_rec.information11
215: ,p_information12_o => pqh_rei_shd.g_old_rec.information12
216: ,p_information13_o => pqh_rei_shd.g_old_rec.information13
217: ,p_information14_o => pqh_rei_shd.g_old_rec.information14
210: ,p_information7_o => pqh_rei_shd.g_old_rec.information7
211: ,p_information8_o => pqh_rei_shd.g_old_rec.information8
212: ,p_information9_o => pqh_rei_shd.g_old_rec.information9
213: ,p_information10_o => pqh_rei_shd.g_old_rec.information10
214: ,p_information11_o => pqh_rei_shd.g_old_rec.information11
215: ,p_information12_o => pqh_rei_shd.g_old_rec.information12
216: ,p_information13_o => pqh_rei_shd.g_old_rec.information13
217: ,p_information14_o => pqh_rei_shd.g_old_rec.information14
218: ,p_information15_o => pqh_rei_shd.g_old_rec.information15
211: ,p_information8_o => pqh_rei_shd.g_old_rec.information8
212: ,p_information9_o => pqh_rei_shd.g_old_rec.information9
213: ,p_information10_o => pqh_rei_shd.g_old_rec.information10
214: ,p_information11_o => pqh_rei_shd.g_old_rec.information11
215: ,p_information12_o => pqh_rei_shd.g_old_rec.information12
216: ,p_information13_o => pqh_rei_shd.g_old_rec.information13
217: ,p_information14_o => pqh_rei_shd.g_old_rec.information14
218: ,p_information15_o => pqh_rei_shd.g_old_rec.information15
219: ,p_information16_o => pqh_rei_shd.g_old_rec.information16
212: ,p_information9_o => pqh_rei_shd.g_old_rec.information9
213: ,p_information10_o => pqh_rei_shd.g_old_rec.information10
214: ,p_information11_o => pqh_rei_shd.g_old_rec.information11
215: ,p_information12_o => pqh_rei_shd.g_old_rec.information12
216: ,p_information13_o => pqh_rei_shd.g_old_rec.information13
217: ,p_information14_o => pqh_rei_shd.g_old_rec.information14
218: ,p_information15_o => pqh_rei_shd.g_old_rec.information15
219: ,p_information16_o => pqh_rei_shd.g_old_rec.information16
220: ,p_information17_o => pqh_rei_shd.g_old_rec.information17
213: ,p_information10_o => pqh_rei_shd.g_old_rec.information10
214: ,p_information11_o => pqh_rei_shd.g_old_rec.information11
215: ,p_information12_o => pqh_rei_shd.g_old_rec.information12
216: ,p_information13_o => pqh_rei_shd.g_old_rec.information13
217: ,p_information14_o => pqh_rei_shd.g_old_rec.information14
218: ,p_information15_o => pqh_rei_shd.g_old_rec.information15
219: ,p_information16_o => pqh_rei_shd.g_old_rec.information16
220: ,p_information17_o => pqh_rei_shd.g_old_rec.information17
221: ,p_information18_o => pqh_rei_shd.g_old_rec.information18
214: ,p_information11_o => pqh_rei_shd.g_old_rec.information11
215: ,p_information12_o => pqh_rei_shd.g_old_rec.information12
216: ,p_information13_o => pqh_rei_shd.g_old_rec.information13
217: ,p_information14_o => pqh_rei_shd.g_old_rec.information14
218: ,p_information15_o => pqh_rei_shd.g_old_rec.information15
219: ,p_information16_o => pqh_rei_shd.g_old_rec.information16
220: ,p_information17_o => pqh_rei_shd.g_old_rec.information17
221: ,p_information18_o => pqh_rei_shd.g_old_rec.information18
222: ,p_information19_o => pqh_rei_shd.g_old_rec.information19
215: ,p_information12_o => pqh_rei_shd.g_old_rec.information12
216: ,p_information13_o => pqh_rei_shd.g_old_rec.information13
217: ,p_information14_o => pqh_rei_shd.g_old_rec.information14
218: ,p_information15_o => pqh_rei_shd.g_old_rec.information15
219: ,p_information16_o => pqh_rei_shd.g_old_rec.information16
220: ,p_information17_o => pqh_rei_shd.g_old_rec.information17
221: ,p_information18_o => pqh_rei_shd.g_old_rec.information18
222: ,p_information19_o => pqh_rei_shd.g_old_rec.information19
223: ,p_information20_o => pqh_rei_shd.g_old_rec.information20
216: ,p_information13_o => pqh_rei_shd.g_old_rec.information13
217: ,p_information14_o => pqh_rei_shd.g_old_rec.information14
218: ,p_information15_o => pqh_rei_shd.g_old_rec.information15
219: ,p_information16_o => pqh_rei_shd.g_old_rec.information16
220: ,p_information17_o => pqh_rei_shd.g_old_rec.information17
221: ,p_information18_o => pqh_rei_shd.g_old_rec.information18
222: ,p_information19_o => pqh_rei_shd.g_old_rec.information19
223: ,p_information20_o => pqh_rei_shd.g_old_rec.information20
224: ,p_information21_o => pqh_rei_shd.g_old_rec.information21
217: ,p_information14_o => pqh_rei_shd.g_old_rec.information14
218: ,p_information15_o => pqh_rei_shd.g_old_rec.information15
219: ,p_information16_o => pqh_rei_shd.g_old_rec.information16
220: ,p_information17_o => pqh_rei_shd.g_old_rec.information17
221: ,p_information18_o => pqh_rei_shd.g_old_rec.information18
222: ,p_information19_o => pqh_rei_shd.g_old_rec.information19
223: ,p_information20_o => pqh_rei_shd.g_old_rec.information20
224: ,p_information21_o => pqh_rei_shd.g_old_rec.information21
225: ,p_information22_o => pqh_rei_shd.g_old_rec.information22
218: ,p_information15_o => pqh_rei_shd.g_old_rec.information15
219: ,p_information16_o => pqh_rei_shd.g_old_rec.information16
220: ,p_information17_o => pqh_rei_shd.g_old_rec.information17
221: ,p_information18_o => pqh_rei_shd.g_old_rec.information18
222: ,p_information19_o => pqh_rei_shd.g_old_rec.information19
223: ,p_information20_o => pqh_rei_shd.g_old_rec.information20
224: ,p_information21_o => pqh_rei_shd.g_old_rec.information21
225: ,p_information22_o => pqh_rei_shd.g_old_rec.information22
226: ,p_information23_o => pqh_rei_shd.g_old_rec.information23
219: ,p_information16_o => pqh_rei_shd.g_old_rec.information16
220: ,p_information17_o => pqh_rei_shd.g_old_rec.information17
221: ,p_information18_o => pqh_rei_shd.g_old_rec.information18
222: ,p_information19_o => pqh_rei_shd.g_old_rec.information19
223: ,p_information20_o => pqh_rei_shd.g_old_rec.information20
224: ,p_information21_o => pqh_rei_shd.g_old_rec.information21
225: ,p_information22_o => pqh_rei_shd.g_old_rec.information22
226: ,p_information23_o => pqh_rei_shd.g_old_rec.information23
227: ,p_information24_o => pqh_rei_shd.g_old_rec.information24
220: ,p_information17_o => pqh_rei_shd.g_old_rec.information17
221: ,p_information18_o => pqh_rei_shd.g_old_rec.information18
222: ,p_information19_o => pqh_rei_shd.g_old_rec.information19
223: ,p_information20_o => pqh_rei_shd.g_old_rec.information20
224: ,p_information21_o => pqh_rei_shd.g_old_rec.information21
225: ,p_information22_o => pqh_rei_shd.g_old_rec.information22
226: ,p_information23_o => pqh_rei_shd.g_old_rec.information23
227: ,p_information24_o => pqh_rei_shd.g_old_rec.information24
228: ,p_information25_o => pqh_rei_shd.g_old_rec.information25
221: ,p_information18_o => pqh_rei_shd.g_old_rec.information18
222: ,p_information19_o => pqh_rei_shd.g_old_rec.information19
223: ,p_information20_o => pqh_rei_shd.g_old_rec.information20
224: ,p_information21_o => pqh_rei_shd.g_old_rec.information21
225: ,p_information22_o => pqh_rei_shd.g_old_rec.information22
226: ,p_information23_o => pqh_rei_shd.g_old_rec.information23
227: ,p_information24_o => pqh_rei_shd.g_old_rec.information24
228: ,p_information25_o => pqh_rei_shd.g_old_rec.information25
229: ,p_information26_o => pqh_rei_shd.g_old_rec.information26
222: ,p_information19_o => pqh_rei_shd.g_old_rec.information19
223: ,p_information20_o => pqh_rei_shd.g_old_rec.information20
224: ,p_information21_o => pqh_rei_shd.g_old_rec.information21
225: ,p_information22_o => pqh_rei_shd.g_old_rec.information22
226: ,p_information23_o => pqh_rei_shd.g_old_rec.information23
227: ,p_information24_o => pqh_rei_shd.g_old_rec.information24
228: ,p_information25_o => pqh_rei_shd.g_old_rec.information25
229: ,p_information26_o => pqh_rei_shd.g_old_rec.information26
230: ,p_information27_o => pqh_rei_shd.g_old_rec.information27
223: ,p_information20_o => pqh_rei_shd.g_old_rec.information20
224: ,p_information21_o => pqh_rei_shd.g_old_rec.information21
225: ,p_information22_o => pqh_rei_shd.g_old_rec.information22
226: ,p_information23_o => pqh_rei_shd.g_old_rec.information23
227: ,p_information24_o => pqh_rei_shd.g_old_rec.information24
228: ,p_information25_o => pqh_rei_shd.g_old_rec.information25
229: ,p_information26_o => pqh_rei_shd.g_old_rec.information26
230: ,p_information27_o => pqh_rei_shd.g_old_rec.information27
231: ,p_information28_o => pqh_rei_shd.g_old_rec.information28
224: ,p_information21_o => pqh_rei_shd.g_old_rec.information21
225: ,p_information22_o => pqh_rei_shd.g_old_rec.information22
226: ,p_information23_o => pqh_rei_shd.g_old_rec.information23
227: ,p_information24_o => pqh_rei_shd.g_old_rec.information24
228: ,p_information25_o => pqh_rei_shd.g_old_rec.information25
229: ,p_information26_o => pqh_rei_shd.g_old_rec.information26
230: ,p_information27_o => pqh_rei_shd.g_old_rec.information27
231: ,p_information28_o => pqh_rei_shd.g_old_rec.information28
232: ,p_information29_o => pqh_rei_shd.g_old_rec.information29
225: ,p_information22_o => pqh_rei_shd.g_old_rec.information22
226: ,p_information23_o => pqh_rei_shd.g_old_rec.information23
227: ,p_information24_o => pqh_rei_shd.g_old_rec.information24
228: ,p_information25_o => pqh_rei_shd.g_old_rec.information25
229: ,p_information26_o => pqh_rei_shd.g_old_rec.information26
230: ,p_information27_o => pqh_rei_shd.g_old_rec.information27
231: ,p_information28_o => pqh_rei_shd.g_old_rec.information28
232: ,p_information29_o => pqh_rei_shd.g_old_rec.information29
233: ,p_information30_o => pqh_rei_shd.g_old_rec.information30
226: ,p_information23_o => pqh_rei_shd.g_old_rec.information23
227: ,p_information24_o => pqh_rei_shd.g_old_rec.information24
228: ,p_information25_o => pqh_rei_shd.g_old_rec.information25
229: ,p_information26_o => pqh_rei_shd.g_old_rec.information26
230: ,p_information27_o => pqh_rei_shd.g_old_rec.information27
231: ,p_information28_o => pqh_rei_shd.g_old_rec.information28
232: ,p_information29_o => pqh_rei_shd.g_old_rec.information29
233: ,p_information30_o => pqh_rei_shd.g_old_rec.information30
234: ,p_object_version_number_o => pqh_rei_shd.g_old_rec.object_version_number
227: ,p_information24_o => pqh_rei_shd.g_old_rec.information24
228: ,p_information25_o => pqh_rei_shd.g_old_rec.information25
229: ,p_information26_o => pqh_rei_shd.g_old_rec.information26
230: ,p_information27_o => pqh_rei_shd.g_old_rec.information27
231: ,p_information28_o => pqh_rei_shd.g_old_rec.information28
232: ,p_information29_o => pqh_rei_shd.g_old_rec.information29
233: ,p_information30_o => pqh_rei_shd.g_old_rec.information30
234: ,p_object_version_number_o => pqh_rei_shd.g_old_rec.object_version_number
235: );
228: ,p_information25_o => pqh_rei_shd.g_old_rec.information25
229: ,p_information26_o => pqh_rei_shd.g_old_rec.information26
230: ,p_information27_o => pqh_rei_shd.g_old_rec.information27
231: ,p_information28_o => pqh_rei_shd.g_old_rec.information28
232: ,p_information29_o => pqh_rei_shd.g_old_rec.information29
233: ,p_information30_o => pqh_rei_shd.g_old_rec.information30
234: ,p_object_version_number_o => pqh_rei_shd.g_old_rec.object_version_number
235: );
236: --
229: ,p_information26_o => pqh_rei_shd.g_old_rec.information26
230: ,p_information27_o => pqh_rei_shd.g_old_rec.information27
231: ,p_information28_o => pqh_rei_shd.g_old_rec.information28
232: ,p_information29_o => pqh_rei_shd.g_old_rec.information29
233: ,p_information30_o => pqh_rei_shd.g_old_rec.information30
234: ,p_object_version_number_o => pqh_rei_shd.g_old_rec.object_version_number
235: );
236: --
237: exception
230: ,p_information27_o => pqh_rei_shd.g_old_rec.information27
231: ,p_information28_o => pqh_rei_shd.g_old_rec.information28
232: ,p_information29_o => pqh_rei_shd.g_old_rec.information29
233: ,p_information30_o => pqh_rei_shd.g_old_rec.information30
234: ,p_object_version_number_o => pqh_rei_shd.g_old_rec.object_version_number
235: );
236: --
237: exception
238: --
250: -- ----------------------------------------------------------------------------
251: -- |---------------------------------< del >----------------------------------|
252: -- ----------------------------------------------------------------------------
253: Procedure del
254: (p_rec in pqh_rei_shd.g_rec_type
255: ,p_validate in boolean
256: ) is
257: --
258: l_proc varchar2(72) := g_package||'del';
269: End If;
270: --
271: -- We must lock the row which we need to delete.
272: --
273: pqh_rei_shd.lck
274: (p_rec.role_extra_info_id
275: ,p_rec.object_version_number
276: );
277: --
321: ,p_object_version_number in number
322: ,p_validate in boolean
323: ) is
324: --
325: l_rec pqh_rei_shd.g_rec_type;
326: l_proc varchar2(72) := g_package||'del';
327: --
328: Begin
329: hr_utility.set_location('Entering:'||l_proc, 5);