44: -- Internal Row Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure delete_dml(p_rec in pqh_plg_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'delete_dml';
51: --
52: Begin
63: --
64: Exception
65: When hr_api.child_integrity_violated then
66: -- Child integrity has been violated
67: pqh_plg_shd.constraint_error
68: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
69: When Others Then
70: Raise;
71: End delete_dml;
101: -- Internal Row Handler Use Only.
102: --
103: -- {End Of Comments}
104: -- ----------------------------------------------------------------------------
105: Procedure pre_delete(p_rec in pqh_plg_shd.g_rec_type) is
106: --
107: l_proc varchar2(72) := g_package||'pre_delete';
108: --
109: Begin
144: --
145: -- {End Of Comments}
146: -- ----------------------------------------------------------------------------
147: Procedure post_delete(
148: p_effective_date in date,p_rec in pqh_plg_shd.g_rec_type) is
149: --
150: l_proc varchar2(72) := g_package||'post_delete';
151: --
152: Begin
159: --
160: pqh_plg_rkd.after_delete
161: (
162: p_process_log_id =>p_rec.process_log_id
163: ,p_module_cd_o =>pqh_plg_shd.g_old_rec.module_cd
164: ,p_txn_id_o =>pqh_plg_shd.g_old_rec.txn_id
165: ,p_master_process_log_id_o =>pqh_plg_shd.g_old_rec.master_process_log_id
166: ,p_message_text_o =>pqh_plg_shd.g_old_rec.message_text
167: ,p_message_type_cd_o =>pqh_plg_shd.g_old_rec.message_type_cd
160: pqh_plg_rkd.after_delete
161: (
162: p_process_log_id =>p_rec.process_log_id
163: ,p_module_cd_o =>pqh_plg_shd.g_old_rec.module_cd
164: ,p_txn_id_o =>pqh_plg_shd.g_old_rec.txn_id
165: ,p_master_process_log_id_o =>pqh_plg_shd.g_old_rec.master_process_log_id
166: ,p_message_text_o =>pqh_plg_shd.g_old_rec.message_text
167: ,p_message_type_cd_o =>pqh_plg_shd.g_old_rec.message_type_cd
168: ,p_batch_status_o =>pqh_plg_shd.g_old_rec.batch_status
161: (
162: p_process_log_id =>p_rec.process_log_id
163: ,p_module_cd_o =>pqh_plg_shd.g_old_rec.module_cd
164: ,p_txn_id_o =>pqh_plg_shd.g_old_rec.txn_id
165: ,p_master_process_log_id_o =>pqh_plg_shd.g_old_rec.master_process_log_id
166: ,p_message_text_o =>pqh_plg_shd.g_old_rec.message_text
167: ,p_message_type_cd_o =>pqh_plg_shd.g_old_rec.message_type_cd
168: ,p_batch_status_o =>pqh_plg_shd.g_old_rec.batch_status
169: ,p_batch_start_date_o =>pqh_plg_shd.g_old_rec.batch_start_date
162: p_process_log_id =>p_rec.process_log_id
163: ,p_module_cd_o =>pqh_plg_shd.g_old_rec.module_cd
164: ,p_txn_id_o =>pqh_plg_shd.g_old_rec.txn_id
165: ,p_master_process_log_id_o =>pqh_plg_shd.g_old_rec.master_process_log_id
166: ,p_message_text_o =>pqh_plg_shd.g_old_rec.message_text
167: ,p_message_type_cd_o =>pqh_plg_shd.g_old_rec.message_type_cd
168: ,p_batch_status_o =>pqh_plg_shd.g_old_rec.batch_status
169: ,p_batch_start_date_o =>pqh_plg_shd.g_old_rec.batch_start_date
170: ,p_batch_end_date_o =>pqh_plg_shd.g_old_rec.batch_end_date
163: ,p_module_cd_o =>pqh_plg_shd.g_old_rec.module_cd
164: ,p_txn_id_o =>pqh_plg_shd.g_old_rec.txn_id
165: ,p_master_process_log_id_o =>pqh_plg_shd.g_old_rec.master_process_log_id
166: ,p_message_text_o =>pqh_plg_shd.g_old_rec.message_text
167: ,p_message_type_cd_o =>pqh_plg_shd.g_old_rec.message_type_cd
168: ,p_batch_status_o =>pqh_plg_shd.g_old_rec.batch_status
169: ,p_batch_start_date_o =>pqh_plg_shd.g_old_rec.batch_start_date
170: ,p_batch_end_date_o =>pqh_plg_shd.g_old_rec.batch_end_date
171: ,p_txn_table_route_id_o =>pqh_plg_shd.g_old_rec.txn_table_route_id
164: ,p_txn_id_o =>pqh_plg_shd.g_old_rec.txn_id
165: ,p_master_process_log_id_o =>pqh_plg_shd.g_old_rec.master_process_log_id
166: ,p_message_text_o =>pqh_plg_shd.g_old_rec.message_text
167: ,p_message_type_cd_o =>pqh_plg_shd.g_old_rec.message_type_cd
168: ,p_batch_status_o =>pqh_plg_shd.g_old_rec.batch_status
169: ,p_batch_start_date_o =>pqh_plg_shd.g_old_rec.batch_start_date
170: ,p_batch_end_date_o =>pqh_plg_shd.g_old_rec.batch_end_date
171: ,p_txn_table_route_id_o =>pqh_plg_shd.g_old_rec.txn_table_route_id
172: ,p_log_context_o =>pqh_plg_shd.g_old_rec.log_context
165: ,p_master_process_log_id_o =>pqh_plg_shd.g_old_rec.master_process_log_id
166: ,p_message_text_o =>pqh_plg_shd.g_old_rec.message_text
167: ,p_message_type_cd_o =>pqh_plg_shd.g_old_rec.message_type_cd
168: ,p_batch_status_o =>pqh_plg_shd.g_old_rec.batch_status
169: ,p_batch_start_date_o =>pqh_plg_shd.g_old_rec.batch_start_date
170: ,p_batch_end_date_o =>pqh_plg_shd.g_old_rec.batch_end_date
171: ,p_txn_table_route_id_o =>pqh_plg_shd.g_old_rec.txn_table_route_id
172: ,p_log_context_o =>pqh_plg_shd.g_old_rec.log_context
173: ,p_information_category_o =>pqh_plg_shd.g_old_rec.information_category
166: ,p_message_text_o =>pqh_plg_shd.g_old_rec.message_text
167: ,p_message_type_cd_o =>pqh_plg_shd.g_old_rec.message_type_cd
168: ,p_batch_status_o =>pqh_plg_shd.g_old_rec.batch_status
169: ,p_batch_start_date_o =>pqh_plg_shd.g_old_rec.batch_start_date
170: ,p_batch_end_date_o =>pqh_plg_shd.g_old_rec.batch_end_date
171: ,p_txn_table_route_id_o =>pqh_plg_shd.g_old_rec.txn_table_route_id
172: ,p_log_context_o =>pqh_plg_shd.g_old_rec.log_context
173: ,p_information_category_o =>pqh_plg_shd.g_old_rec.information_category
174: ,p_information1_o =>pqh_plg_shd.g_old_rec.information1
167: ,p_message_type_cd_o =>pqh_plg_shd.g_old_rec.message_type_cd
168: ,p_batch_status_o =>pqh_plg_shd.g_old_rec.batch_status
169: ,p_batch_start_date_o =>pqh_plg_shd.g_old_rec.batch_start_date
170: ,p_batch_end_date_o =>pqh_plg_shd.g_old_rec.batch_end_date
171: ,p_txn_table_route_id_o =>pqh_plg_shd.g_old_rec.txn_table_route_id
172: ,p_log_context_o =>pqh_plg_shd.g_old_rec.log_context
173: ,p_information_category_o =>pqh_plg_shd.g_old_rec.information_category
174: ,p_information1_o =>pqh_plg_shd.g_old_rec.information1
175: ,p_information2_o =>pqh_plg_shd.g_old_rec.information2
168: ,p_batch_status_o =>pqh_plg_shd.g_old_rec.batch_status
169: ,p_batch_start_date_o =>pqh_plg_shd.g_old_rec.batch_start_date
170: ,p_batch_end_date_o =>pqh_plg_shd.g_old_rec.batch_end_date
171: ,p_txn_table_route_id_o =>pqh_plg_shd.g_old_rec.txn_table_route_id
172: ,p_log_context_o =>pqh_plg_shd.g_old_rec.log_context
173: ,p_information_category_o =>pqh_plg_shd.g_old_rec.information_category
174: ,p_information1_o =>pqh_plg_shd.g_old_rec.information1
175: ,p_information2_o =>pqh_plg_shd.g_old_rec.information2
176: ,p_information3_o =>pqh_plg_shd.g_old_rec.information3
169: ,p_batch_start_date_o =>pqh_plg_shd.g_old_rec.batch_start_date
170: ,p_batch_end_date_o =>pqh_plg_shd.g_old_rec.batch_end_date
171: ,p_txn_table_route_id_o =>pqh_plg_shd.g_old_rec.txn_table_route_id
172: ,p_log_context_o =>pqh_plg_shd.g_old_rec.log_context
173: ,p_information_category_o =>pqh_plg_shd.g_old_rec.information_category
174: ,p_information1_o =>pqh_plg_shd.g_old_rec.information1
175: ,p_information2_o =>pqh_plg_shd.g_old_rec.information2
176: ,p_information3_o =>pqh_plg_shd.g_old_rec.information3
177: ,p_information4_o =>pqh_plg_shd.g_old_rec.information4
170: ,p_batch_end_date_o =>pqh_plg_shd.g_old_rec.batch_end_date
171: ,p_txn_table_route_id_o =>pqh_plg_shd.g_old_rec.txn_table_route_id
172: ,p_log_context_o =>pqh_plg_shd.g_old_rec.log_context
173: ,p_information_category_o =>pqh_plg_shd.g_old_rec.information_category
174: ,p_information1_o =>pqh_plg_shd.g_old_rec.information1
175: ,p_information2_o =>pqh_plg_shd.g_old_rec.information2
176: ,p_information3_o =>pqh_plg_shd.g_old_rec.information3
177: ,p_information4_o =>pqh_plg_shd.g_old_rec.information4
178: ,p_information5_o =>pqh_plg_shd.g_old_rec.information5
171: ,p_txn_table_route_id_o =>pqh_plg_shd.g_old_rec.txn_table_route_id
172: ,p_log_context_o =>pqh_plg_shd.g_old_rec.log_context
173: ,p_information_category_o =>pqh_plg_shd.g_old_rec.information_category
174: ,p_information1_o =>pqh_plg_shd.g_old_rec.information1
175: ,p_information2_o =>pqh_plg_shd.g_old_rec.information2
176: ,p_information3_o =>pqh_plg_shd.g_old_rec.information3
177: ,p_information4_o =>pqh_plg_shd.g_old_rec.information4
178: ,p_information5_o =>pqh_plg_shd.g_old_rec.information5
179: ,p_information6_o =>pqh_plg_shd.g_old_rec.information6
172: ,p_log_context_o =>pqh_plg_shd.g_old_rec.log_context
173: ,p_information_category_o =>pqh_plg_shd.g_old_rec.information_category
174: ,p_information1_o =>pqh_plg_shd.g_old_rec.information1
175: ,p_information2_o =>pqh_plg_shd.g_old_rec.information2
176: ,p_information3_o =>pqh_plg_shd.g_old_rec.information3
177: ,p_information4_o =>pqh_plg_shd.g_old_rec.information4
178: ,p_information5_o =>pqh_plg_shd.g_old_rec.information5
179: ,p_information6_o =>pqh_plg_shd.g_old_rec.information6
180: ,p_information7_o =>pqh_plg_shd.g_old_rec.information7
173: ,p_information_category_o =>pqh_plg_shd.g_old_rec.information_category
174: ,p_information1_o =>pqh_plg_shd.g_old_rec.information1
175: ,p_information2_o =>pqh_plg_shd.g_old_rec.information2
176: ,p_information3_o =>pqh_plg_shd.g_old_rec.information3
177: ,p_information4_o =>pqh_plg_shd.g_old_rec.information4
178: ,p_information5_o =>pqh_plg_shd.g_old_rec.information5
179: ,p_information6_o =>pqh_plg_shd.g_old_rec.information6
180: ,p_information7_o =>pqh_plg_shd.g_old_rec.information7
181: ,p_information8_o =>pqh_plg_shd.g_old_rec.information8
174: ,p_information1_o =>pqh_plg_shd.g_old_rec.information1
175: ,p_information2_o =>pqh_plg_shd.g_old_rec.information2
176: ,p_information3_o =>pqh_plg_shd.g_old_rec.information3
177: ,p_information4_o =>pqh_plg_shd.g_old_rec.information4
178: ,p_information5_o =>pqh_plg_shd.g_old_rec.information5
179: ,p_information6_o =>pqh_plg_shd.g_old_rec.information6
180: ,p_information7_o =>pqh_plg_shd.g_old_rec.information7
181: ,p_information8_o =>pqh_plg_shd.g_old_rec.information8
182: ,p_information9_o =>pqh_plg_shd.g_old_rec.information9
175: ,p_information2_o =>pqh_plg_shd.g_old_rec.information2
176: ,p_information3_o =>pqh_plg_shd.g_old_rec.information3
177: ,p_information4_o =>pqh_plg_shd.g_old_rec.information4
178: ,p_information5_o =>pqh_plg_shd.g_old_rec.information5
179: ,p_information6_o =>pqh_plg_shd.g_old_rec.information6
180: ,p_information7_o =>pqh_plg_shd.g_old_rec.information7
181: ,p_information8_o =>pqh_plg_shd.g_old_rec.information8
182: ,p_information9_o =>pqh_plg_shd.g_old_rec.information9
183: ,p_information10_o =>pqh_plg_shd.g_old_rec.information10
176: ,p_information3_o =>pqh_plg_shd.g_old_rec.information3
177: ,p_information4_o =>pqh_plg_shd.g_old_rec.information4
178: ,p_information5_o =>pqh_plg_shd.g_old_rec.information5
179: ,p_information6_o =>pqh_plg_shd.g_old_rec.information6
180: ,p_information7_o =>pqh_plg_shd.g_old_rec.information7
181: ,p_information8_o =>pqh_plg_shd.g_old_rec.information8
182: ,p_information9_o =>pqh_plg_shd.g_old_rec.information9
183: ,p_information10_o =>pqh_plg_shd.g_old_rec.information10
184: ,p_information11_o =>pqh_plg_shd.g_old_rec.information11
177: ,p_information4_o =>pqh_plg_shd.g_old_rec.information4
178: ,p_information5_o =>pqh_plg_shd.g_old_rec.information5
179: ,p_information6_o =>pqh_plg_shd.g_old_rec.information6
180: ,p_information7_o =>pqh_plg_shd.g_old_rec.information7
181: ,p_information8_o =>pqh_plg_shd.g_old_rec.information8
182: ,p_information9_o =>pqh_plg_shd.g_old_rec.information9
183: ,p_information10_o =>pqh_plg_shd.g_old_rec.information10
184: ,p_information11_o =>pqh_plg_shd.g_old_rec.information11
185: ,p_information12_o =>pqh_plg_shd.g_old_rec.information12
178: ,p_information5_o =>pqh_plg_shd.g_old_rec.information5
179: ,p_information6_o =>pqh_plg_shd.g_old_rec.information6
180: ,p_information7_o =>pqh_plg_shd.g_old_rec.information7
181: ,p_information8_o =>pqh_plg_shd.g_old_rec.information8
182: ,p_information9_o =>pqh_plg_shd.g_old_rec.information9
183: ,p_information10_o =>pqh_plg_shd.g_old_rec.information10
184: ,p_information11_o =>pqh_plg_shd.g_old_rec.information11
185: ,p_information12_o =>pqh_plg_shd.g_old_rec.information12
186: ,p_information13_o =>pqh_plg_shd.g_old_rec.information13
179: ,p_information6_o =>pqh_plg_shd.g_old_rec.information6
180: ,p_information7_o =>pqh_plg_shd.g_old_rec.information7
181: ,p_information8_o =>pqh_plg_shd.g_old_rec.information8
182: ,p_information9_o =>pqh_plg_shd.g_old_rec.information9
183: ,p_information10_o =>pqh_plg_shd.g_old_rec.information10
184: ,p_information11_o =>pqh_plg_shd.g_old_rec.information11
185: ,p_information12_o =>pqh_plg_shd.g_old_rec.information12
186: ,p_information13_o =>pqh_plg_shd.g_old_rec.information13
187: ,p_information14_o =>pqh_plg_shd.g_old_rec.information14
180: ,p_information7_o =>pqh_plg_shd.g_old_rec.information7
181: ,p_information8_o =>pqh_plg_shd.g_old_rec.information8
182: ,p_information9_o =>pqh_plg_shd.g_old_rec.information9
183: ,p_information10_o =>pqh_plg_shd.g_old_rec.information10
184: ,p_information11_o =>pqh_plg_shd.g_old_rec.information11
185: ,p_information12_o =>pqh_plg_shd.g_old_rec.information12
186: ,p_information13_o =>pqh_plg_shd.g_old_rec.information13
187: ,p_information14_o =>pqh_plg_shd.g_old_rec.information14
188: ,p_information15_o =>pqh_plg_shd.g_old_rec.information15
181: ,p_information8_o =>pqh_plg_shd.g_old_rec.information8
182: ,p_information9_o =>pqh_plg_shd.g_old_rec.information9
183: ,p_information10_o =>pqh_plg_shd.g_old_rec.information10
184: ,p_information11_o =>pqh_plg_shd.g_old_rec.information11
185: ,p_information12_o =>pqh_plg_shd.g_old_rec.information12
186: ,p_information13_o =>pqh_plg_shd.g_old_rec.information13
187: ,p_information14_o =>pqh_plg_shd.g_old_rec.information14
188: ,p_information15_o =>pqh_plg_shd.g_old_rec.information15
189: ,p_information16_o =>pqh_plg_shd.g_old_rec.information16
182: ,p_information9_o =>pqh_plg_shd.g_old_rec.information9
183: ,p_information10_o =>pqh_plg_shd.g_old_rec.information10
184: ,p_information11_o =>pqh_plg_shd.g_old_rec.information11
185: ,p_information12_o =>pqh_plg_shd.g_old_rec.information12
186: ,p_information13_o =>pqh_plg_shd.g_old_rec.information13
187: ,p_information14_o =>pqh_plg_shd.g_old_rec.information14
188: ,p_information15_o =>pqh_plg_shd.g_old_rec.information15
189: ,p_information16_o =>pqh_plg_shd.g_old_rec.information16
190: ,p_information17_o =>pqh_plg_shd.g_old_rec.information17
183: ,p_information10_o =>pqh_plg_shd.g_old_rec.information10
184: ,p_information11_o =>pqh_plg_shd.g_old_rec.information11
185: ,p_information12_o =>pqh_plg_shd.g_old_rec.information12
186: ,p_information13_o =>pqh_plg_shd.g_old_rec.information13
187: ,p_information14_o =>pqh_plg_shd.g_old_rec.information14
188: ,p_information15_o =>pqh_plg_shd.g_old_rec.information15
189: ,p_information16_o =>pqh_plg_shd.g_old_rec.information16
190: ,p_information17_o =>pqh_plg_shd.g_old_rec.information17
191: ,p_information18_o =>pqh_plg_shd.g_old_rec.information18
184: ,p_information11_o =>pqh_plg_shd.g_old_rec.information11
185: ,p_information12_o =>pqh_plg_shd.g_old_rec.information12
186: ,p_information13_o =>pqh_plg_shd.g_old_rec.information13
187: ,p_information14_o =>pqh_plg_shd.g_old_rec.information14
188: ,p_information15_o =>pqh_plg_shd.g_old_rec.information15
189: ,p_information16_o =>pqh_plg_shd.g_old_rec.information16
190: ,p_information17_o =>pqh_plg_shd.g_old_rec.information17
191: ,p_information18_o =>pqh_plg_shd.g_old_rec.information18
192: ,p_information19_o =>pqh_plg_shd.g_old_rec.information19
185: ,p_information12_o =>pqh_plg_shd.g_old_rec.information12
186: ,p_information13_o =>pqh_plg_shd.g_old_rec.information13
187: ,p_information14_o =>pqh_plg_shd.g_old_rec.information14
188: ,p_information15_o =>pqh_plg_shd.g_old_rec.information15
189: ,p_information16_o =>pqh_plg_shd.g_old_rec.information16
190: ,p_information17_o =>pqh_plg_shd.g_old_rec.information17
191: ,p_information18_o =>pqh_plg_shd.g_old_rec.information18
192: ,p_information19_o =>pqh_plg_shd.g_old_rec.information19
193: ,p_information20_o =>pqh_plg_shd.g_old_rec.information20
186: ,p_information13_o =>pqh_plg_shd.g_old_rec.information13
187: ,p_information14_o =>pqh_plg_shd.g_old_rec.information14
188: ,p_information15_o =>pqh_plg_shd.g_old_rec.information15
189: ,p_information16_o =>pqh_plg_shd.g_old_rec.information16
190: ,p_information17_o =>pqh_plg_shd.g_old_rec.information17
191: ,p_information18_o =>pqh_plg_shd.g_old_rec.information18
192: ,p_information19_o =>pqh_plg_shd.g_old_rec.information19
193: ,p_information20_o =>pqh_plg_shd.g_old_rec.information20
194: ,p_information21_o =>pqh_plg_shd.g_old_rec.information21
187: ,p_information14_o =>pqh_plg_shd.g_old_rec.information14
188: ,p_information15_o =>pqh_plg_shd.g_old_rec.information15
189: ,p_information16_o =>pqh_plg_shd.g_old_rec.information16
190: ,p_information17_o =>pqh_plg_shd.g_old_rec.information17
191: ,p_information18_o =>pqh_plg_shd.g_old_rec.information18
192: ,p_information19_o =>pqh_plg_shd.g_old_rec.information19
193: ,p_information20_o =>pqh_plg_shd.g_old_rec.information20
194: ,p_information21_o =>pqh_plg_shd.g_old_rec.information21
195: ,p_information22_o =>pqh_plg_shd.g_old_rec.information22
188: ,p_information15_o =>pqh_plg_shd.g_old_rec.information15
189: ,p_information16_o =>pqh_plg_shd.g_old_rec.information16
190: ,p_information17_o =>pqh_plg_shd.g_old_rec.information17
191: ,p_information18_o =>pqh_plg_shd.g_old_rec.information18
192: ,p_information19_o =>pqh_plg_shd.g_old_rec.information19
193: ,p_information20_o =>pqh_plg_shd.g_old_rec.information20
194: ,p_information21_o =>pqh_plg_shd.g_old_rec.information21
195: ,p_information22_o =>pqh_plg_shd.g_old_rec.information22
196: ,p_information23_o =>pqh_plg_shd.g_old_rec.information23
189: ,p_information16_o =>pqh_plg_shd.g_old_rec.information16
190: ,p_information17_o =>pqh_plg_shd.g_old_rec.information17
191: ,p_information18_o =>pqh_plg_shd.g_old_rec.information18
192: ,p_information19_o =>pqh_plg_shd.g_old_rec.information19
193: ,p_information20_o =>pqh_plg_shd.g_old_rec.information20
194: ,p_information21_o =>pqh_plg_shd.g_old_rec.information21
195: ,p_information22_o =>pqh_plg_shd.g_old_rec.information22
196: ,p_information23_o =>pqh_plg_shd.g_old_rec.information23
197: ,p_information24_o =>pqh_plg_shd.g_old_rec.information24
190: ,p_information17_o =>pqh_plg_shd.g_old_rec.information17
191: ,p_information18_o =>pqh_plg_shd.g_old_rec.information18
192: ,p_information19_o =>pqh_plg_shd.g_old_rec.information19
193: ,p_information20_o =>pqh_plg_shd.g_old_rec.information20
194: ,p_information21_o =>pqh_plg_shd.g_old_rec.information21
195: ,p_information22_o =>pqh_plg_shd.g_old_rec.information22
196: ,p_information23_o =>pqh_plg_shd.g_old_rec.information23
197: ,p_information24_o =>pqh_plg_shd.g_old_rec.information24
198: ,p_information25_o =>pqh_plg_shd.g_old_rec.information25
191: ,p_information18_o =>pqh_plg_shd.g_old_rec.information18
192: ,p_information19_o =>pqh_plg_shd.g_old_rec.information19
193: ,p_information20_o =>pqh_plg_shd.g_old_rec.information20
194: ,p_information21_o =>pqh_plg_shd.g_old_rec.information21
195: ,p_information22_o =>pqh_plg_shd.g_old_rec.information22
196: ,p_information23_o =>pqh_plg_shd.g_old_rec.information23
197: ,p_information24_o =>pqh_plg_shd.g_old_rec.information24
198: ,p_information25_o =>pqh_plg_shd.g_old_rec.information25
199: ,p_information26_o =>pqh_plg_shd.g_old_rec.information26
192: ,p_information19_o =>pqh_plg_shd.g_old_rec.information19
193: ,p_information20_o =>pqh_plg_shd.g_old_rec.information20
194: ,p_information21_o =>pqh_plg_shd.g_old_rec.information21
195: ,p_information22_o =>pqh_plg_shd.g_old_rec.information22
196: ,p_information23_o =>pqh_plg_shd.g_old_rec.information23
197: ,p_information24_o =>pqh_plg_shd.g_old_rec.information24
198: ,p_information25_o =>pqh_plg_shd.g_old_rec.information25
199: ,p_information26_o =>pqh_plg_shd.g_old_rec.information26
200: ,p_information27_o =>pqh_plg_shd.g_old_rec.information27
193: ,p_information20_o =>pqh_plg_shd.g_old_rec.information20
194: ,p_information21_o =>pqh_plg_shd.g_old_rec.information21
195: ,p_information22_o =>pqh_plg_shd.g_old_rec.information22
196: ,p_information23_o =>pqh_plg_shd.g_old_rec.information23
197: ,p_information24_o =>pqh_plg_shd.g_old_rec.information24
198: ,p_information25_o =>pqh_plg_shd.g_old_rec.information25
199: ,p_information26_o =>pqh_plg_shd.g_old_rec.information26
200: ,p_information27_o =>pqh_plg_shd.g_old_rec.information27
201: ,p_information28_o =>pqh_plg_shd.g_old_rec.information28
194: ,p_information21_o =>pqh_plg_shd.g_old_rec.information21
195: ,p_information22_o =>pqh_plg_shd.g_old_rec.information22
196: ,p_information23_o =>pqh_plg_shd.g_old_rec.information23
197: ,p_information24_o =>pqh_plg_shd.g_old_rec.information24
198: ,p_information25_o =>pqh_plg_shd.g_old_rec.information25
199: ,p_information26_o =>pqh_plg_shd.g_old_rec.information26
200: ,p_information27_o =>pqh_plg_shd.g_old_rec.information27
201: ,p_information28_o =>pqh_plg_shd.g_old_rec.information28
202: ,p_information29_o =>pqh_plg_shd.g_old_rec.information29
195: ,p_information22_o =>pqh_plg_shd.g_old_rec.information22
196: ,p_information23_o =>pqh_plg_shd.g_old_rec.information23
197: ,p_information24_o =>pqh_plg_shd.g_old_rec.information24
198: ,p_information25_o =>pqh_plg_shd.g_old_rec.information25
199: ,p_information26_o =>pqh_plg_shd.g_old_rec.information26
200: ,p_information27_o =>pqh_plg_shd.g_old_rec.information27
201: ,p_information28_o =>pqh_plg_shd.g_old_rec.information28
202: ,p_information29_o =>pqh_plg_shd.g_old_rec.information29
203: ,p_information30_o =>pqh_plg_shd.g_old_rec.information30
196: ,p_information23_o =>pqh_plg_shd.g_old_rec.information23
197: ,p_information24_o =>pqh_plg_shd.g_old_rec.information24
198: ,p_information25_o =>pqh_plg_shd.g_old_rec.information25
199: ,p_information26_o =>pqh_plg_shd.g_old_rec.information26
200: ,p_information27_o =>pqh_plg_shd.g_old_rec.information27
201: ,p_information28_o =>pqh_plg_shd.g_old_rec.information28
202: ,p_information29_o =>pqh_plg_shd.g_old_rec.information29
203: ,p_information30_o =>pqh_plg_shd.g_old_rec.information30
204: ,p_object_version_number_o =>pqh_plg_shd.g_old_rec.object_version_number
197: ,p_information24_o =>pqh_plg_shd.g_old_rec.information24
198: ,p_information25_o =>pqh_plg_shd.g_old_rec.information25
199: ,p_information26_o =>pqh_plg_shd.g_old_rec.information26
200: ,p_information27_o =>pqh_plg_shd.g_old_rec.information27
201: ,p_information28_o =>pqh_plg_shd.g_old_rec.information28
202: ,p_information29_o =>pqh_plg_shd.g_old_rec.information29
203: ,p_information30_o =>pqh_plg_shd.g_old_rec.information30
204: ,p_object_version_number_o =>pqh_plg_shd.g_old_rec.object_version_number
205: );
198: ,p_information25_o =>pqh_plg_shd.g_old_rec.information25
199: ,p_information26_o =>pqh_plg_shd.g_old_rec.information26
200: ,p_information27_o =>pqh_plg_shd.g_old_rec.information27
201: ,p_information28_o =>pqh_plg_shd.g_old_rec.information28
202: ,p_information29_o =>pqh_plg_shd.g_old_rec.information29
203: ,p_information30_o =>pqh_plg_shd.g_old_rec.information30
204: ,p_object_version_number_o =>pqh_plg_shd.g_old_rec.object_version_number
205: );
206: --
199: ,p_information26_o =>pqh_plg_shd.g_old_rec.information26
200: ,p_information27_o =>pqh_plg_shd.g_old_rec.information27
201: ,p_information28_o =>pqh_plg_shd.g_old_rec.information28
202: ,p_information29_o =>pqh_plg_shd.g_old_rec.information29
203: ,p_information30_o =>pqh_plg_shd.g_old_rec.information30
204: ,p_object_version_number_o =>pqh_plg_shd.g_old_rec.object_version_number
205: );
206: --
207: exception
200: ,p_information27_o =>pqh_plg_shd.g_old_rec.information27
201: ,p_information28_o =>pqh_plg_shd.g_old_rec.information28
202: ,p_information29_o =>pqh_plg_shd.g_old_rec.information29
203: ,p_information30_o =>pqh_plg_shd.g_old_rec.information30
204: ,p_object_version_number_o =>pqh_plg_shd.g_old_rec.object_version_number
205: );
206: --
207: exception
208: --
225: -- ----------------------------------------------------------------------------
226: Procedure del
227: (
228: p_effective_date in date,
229: p_rec in pqh_plg_shd.g_rec_type
230: ) is
231: --
232: l_proc varchar2(72) := g_package||'del';
233: --
235: hr_utility.set_location('Entering:'||l_proc, 5);
236: --
237: -- We must lock the row which we need to delete.
238: --
239: pqh_plg_shd.lck
240: (
241: p_rec.process_log_id,
242: p_rec.object_version_number
243: );
270: p_process_log_id in number,
271: p_object_version_number in number
272: ) is
273: --
274: l_rec pqh_plg_shd.g_rec_type;
275: l_proc varchar2(72) := g_package||'del';
276: --
277: Begin
278: hr_utility.set_location('Entering:'||l_proc, 5);