APPS.PQH_PLG_DEL dependencies on PQH_PLG_SHD

Line 48: Procedure delete_dml(p_rec in pqh_plg_shd.g_rec_type) is

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

Line 67: pqh_plg_shd.constraint_error

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;

Line 105: Procedure pre_delete(p_rec in pqh_plg_shd.g_rec_type) is

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

Line 148: p_effective_date in date,p_rec in pqh_plg_shd.g_rec_type) is

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

Line 163: ,p_module_cd_o =>pqh_plg_shd.g_old_rec.module_cd

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

Line 164: ,p_txn_id_o =>pqh_plg_shd.g_old_rec.txn_id

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

Line 165: ,p_master_process_log_id_o =>pqh_plg_shd.g_old_rec.master_process_log_id

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

Line 166: ,p_message_text_o =>pqh_plg_shd.g_old_rec.message_text

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

Line 167: ,p_message_type_cd_o =>pqh_plg_shd.g_old_rec.message_type_cd

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

Line 168: ,p_batch_status_o =>pqh_plg_shd.g_old_rec.batch_status

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

Line 169: ,p_batch_start_date_o =>pqh_plg_shd.g_old_rec.batch_start_date

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

Line 170: ,p_batch_end_date_o =>pqh_plg_shd.g_old_rec.batch_end_date

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

Line 171: ,p_txn_table_route_id_o =>pqh_plg_shd.g_old_rec.txn_table_route_id

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

Line 172: ,p_log_context_o =>pqh_plg_shd.g_old_rec.log_context

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

Line 173: ,p_information_category_o =>pqh_plg_shd.g_old_rec.information_category

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

Line 174: ,p_information1_o =>pqh_plg_shd.g_old_rec.information1

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

Line 175: ,p_information2_o =>pqh_plg_shd.g_old_rec.information2

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

Line 176: ,p_information3_o =>pqh_plg_shd.g_old_rec.information3

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

Line 177: ,p_information4_o =>pqh_plg_shd.g_old_rec.information4

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

Line 178: ,p_information5_o =>pqh_plg_shd.g_old_rec.information5

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

Line 179: ,p_information6_o =>pqh_plg_shd.g_old_rec.information6

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

Line 180: ,p_information7_o =>pqh_plg_shd.g_old_rec.information7

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

Line 181: ,p_information8_o =>pqh_plg_shd.g_old_rec.information8

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

Line 182: ,p_information9_o =>pqh_plg_shd.g_old_rec.information9

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

Line 183: ,p_information10_o =>pqh_plg_shd.g_old_rec.information10

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

Line 184: ,p_information11_o =>pqh_plg_shd.g_old_rec.information11

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

Line 185: ,p_information12_o =>pqh_plg_shd.g_old_rec.information12

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

Line 186: ,p_information13_o =>pqh_plg_shd.g_old_rec.information13

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

Line 187: ,p_information14_o =>pqh_plg_shd.g_old_rec.information14

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

Line 188: ,p_information15_o =>pqh_plg_shd.g_old_rec.information15

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

Line 189: ,p_information16_o =>pqh_plg_shd.g_old_rec.information16

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

Line 190: ,p_information17_o =>pqh_plg_shd.g_old_rec.information17

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

Line 191: ,p_information18_o =>pqh_plg_shd.g_old_rec.information18

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

Line 192: ,p_information19_o =>pqh_plg_shd.g_old_rec.information19

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

Line 193: ,p_information20_o =>pqh_plg_shd.g_old_rec.information20

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

Line 194: ,p_information21_o =>pqh_plg_shd.g_old_rec.information21

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

Line 195: ,p_information22_o =>pqh_plg_shd.g_old_rec.information22

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

Line 196: ,p_information23_o =>pqh_plg_shd.g_old_rec.information23

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

Line 197: ,p_information24_o =>pqh_plg_shd.g_old_rec.information24

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

Line 198: ,p_information25_o =>pqh_plg_shd.g_old_rec.information25

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

Line 199: ,p_information26_o =>pqh_plg_shd.g_old_rec.information26

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

Line 200: ,p_information27_o =>pqh_plg_shd.g_old_rec.information27

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

Line 201: ,p_information28_o =>pqh_plg_shd.g_old_rec.information28

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: );

Line 202: ,p_information29_o =>pqh_plg_shd.g_old_rec.information29

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: --

Line 203: ,p_information30_o =>pqh_plg_shd.g_old_rec.information30

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

Line 204: ,p_object_version_number_o =>pqh_plg_shd.g_old_rec.object_version_number

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: --

Line 229: p_rec in pqh_plg_shd.g_rec_type

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: --

Line 239: pqh_plg_shd.lck

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: );

Line 274: l_rec pqh_plg_shd.g_rec_type;

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);