eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_PLG_UPD dependencies on PQH_PLG_SHD

Line 51: Procedure update_dml(p_rec in out nocopy pqh_plg_shd.g_rec_type) is

47: -- Internal Row Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure update_dml(p_rec in out nocopy pqh_plg_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'update_dml';
54: --
55: Begin

Line 118: pqh_plg_shd.constraint_error

114: --
115: Exception
116: When hr_api.check_integrity_violated Then
117: -- A check constraint has been violated
118: pqh_plg_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.parent_integrity_violated Then
121: -- Parent integrity has been violated
122: pqh_plg_shd.constraint_error

Line 122: pqh_plg_shd.constraint_error

118: pqh_plg_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.parent_integrity_violated Then
121: -- Parent integrity has been violated
122: pqh_plg_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: pqh_plg_shd.constraint_error

Line 126: pqh_plg_shd.constraint_error

122: pqh_plg_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: pqh_plg_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When Others Then
129: Raise;
130: End update_dml;

Line 164: Procedure pre_update(p_rec in pqh_plg_shd.g_rec_type) is

160: -- Internal Row Handler Use Only.
161: --
162: -- {End Of Comments}
163: -- ----------------------------------------------------------------------------
164: Procedure pre_update(p_rec in pqh_plg_shd.g_rec_type) is
165: --
166: l_proc varchar2(72) := g_package||'pre_update';
167: --
168: Begin

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

203: --
204: -- {End Of Comments}
205: -- ----------------------------------------------------------------------------
206: Procedure post_update(
207: p_effective_date in date,p_rec in pqh_plg_shd.g_rec_type) is
208: --
209: l_proc varchar2(72) := g_package||'post_update';
210: --
211: Begin

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

261: ,p_information29 =>p_rec.information29
262: ,p_information30 =>p_rec.information30
263: ,p_object_version_number =>p_rec.object_version_number
264: ,p_effective_date =>p_effective_date
265: ,p_module_cd_o =>pqh_plg_shd.g_old_rec.module_cd
266: ,p_txn_id_o =>pqh_plg_shd.g_old_rec.txn_id
267: ,p_master_process_log_id_o =>pqh_plg_shd.g_old_rec.master_process_log_id
268: ,p_message_text_o =>pqh_plg_shd.g_old_rec.message_text
269: ,p_message_type_cd_o =>pqh_plg_shd.g_old_rec.message_type_cd

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

262: ,p_information30 =>p_rec.information30
263: ,p_object_version_number =>p_rec.object_version_number
264: ,p_effective_date =>p_effective_date
265: ,p_module_cd_o =>pqh_plg_shd.g_old_rec.module_cd
266: ,p_txn_id_o =>pqh_plg_shd.g_old_rec.txn_id
267: ,p_master_process_log_id_o =>pqh_plg_shd.g_old_rec.master_process_log_id
268: ,p_message_text_o =>pqh_plg_shd.g_old_rec.message_text
269: ,p_message_type_cd_o =>pqh_plg_shd.g_old_rec.message_type_cd
270: ,p_batch_status_o =>pqh_plg_shd.g_old_rec.batch_status

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

263: ,p_object_version_number =>p_rec.object_version_number
264: ,p_effective_date =>p_effective_date
265: ,p_module_cd_o =>pqh_plg_shd.g_old_rec.module_cd
266: ,p_txn_id_o =>pqh_plg_shd.g_old_rec.txn_id
267: ,p_master_process_log_id_o =>pqh_plg_shd.g_old_rec.master_process_log_id
268: ,p_message_text_o =>pqh_plg_shd.g_old_rec.message_text
269: ,p_message_type_cd_o =>pqh_plg_shd.g_old_rec.message_type_cd
270: ,p_batch_status_o =>pqh_plg_shd.g_old_rec.batch_status
271: ,p_batch_start_date_o =>pqh_plg_shd.g_old_rec.batch_start_date

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

264: ,p_effective_date =>p_effective_date
265: ,p_module_cd_o =>pqh_plg_shd.g_old_rec.module_cd
266: ,p_txn_id_o =>pqh_plg_shd.g_old_rec.txn_id
267: ,p_master_process_log_id_o =>pqh_plg_shd.g_old_rec.master_process_log_id
268: ,p_message_text_o =>pqh_plg_shd.g_old_rec.message_text
269: ,p_message_type_cd_o =>pqh_plg_shd.g_old_rec.message_type_cd
270: ,p_batch_status_o =>pqh_plg_shd.g_old_rec.batch_status
271: ,p_batch_start_date_o =>pqh_plg_shd.g_old_rec.batch_start_date
272: ,p_batch_end_date_o =>pqh_plg_shd.g_old_rec.batch_end_date

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

265: ,p_module_cd_o =>pqh_plg_shd.g_old_rec.module_cd
266: ,p_txn_id_o =>pqh_plg_shd.g_old_rec.txn_id
267: ,p_master_process_log_id_o =>pqh_plg_shd.g_old_rec.master_process_log_id
268: ,p_message_text_o =>pqh_plg_shd.g_old_rec.message_text
269: ,p_message_type_cd_o =>pqh_plg_shd.g_old_rec.message_type_cd
270: ,p_batch_status_o =>pqh_plg_shd.g_old_rec.batch_status
271: ,p_batch_start_date_o =>pqh_plg_shd.g_old_rec.batch_start_date
272: ,p_batch_end_date_o =>pqh_plg_shd.g_old_rec.batch_end_date
273: ,p_txn_table_route_id_o =>pqh_plg_shd.g_old_rec.txn_table_route_id

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

266: ,p_txn_id_o =>pqh_plg_shd.g_old_rec.txn_id
267: ,p_master_process_log_id_o =>pqh_plg_shd.g_old_rec.master_process_log_id
268: ,p_message_text_o =>pqh_plg_shd.g_old_rec.message_text
269: ,p_message_type_cd_o =>pqh_plg_shd.g_old_rec.message_type_cd
270: ,p_batch_status_o =>pqh_plg_shd.g_old_rec.batch_status
271: ,p_batch_start_date_o =>pqh_plg_shd.g_old_rec.batch_start_date
272: ,p_batch_end_date_o =>pqh_plg_shd.g_old_rec.batch_end_date
273: ,p_txn_table_route_id_o =>pqh_plg_shd.g_old_rec.txn_table_route_id
274: ,p_log_context_o =>pqh_plg_shd.g_old_rec.log_context

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

267: ,p_master_process_log_id_o =>pqh_plg_shd.g_old_rec.master_process_log_id
268: ,p_message_text_o =>pqh_plg_shd.g_old_rec.message_text
269: ,p_message_type_cd_o =>pqh_plg_shd.g_old_rec.message_type_cd
270: ,p_batch_status_o =>pqh_plg_shd.g_old_rec.batch_status
271: ,p_batch_start_date_o =>pqh_plg_shd.g_old_rec.batch_start_date
272: ,p_batch_end_date_o =>pqh_plg_shd.g_old_rec.batch_end_date
273: ,p_txn_table_route_id_o =>pqh_plg_shd.g_old_rec.txn_table_route_id
274: ,p_log_context_o =>pqh_plg_shd.g_old_rec.log_context
275: ,p_information_category_o =>pqh_plg_shd.g_old_rec.information_category

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

268: ,p_message_text_o =>pqh_plg_shd.g_old_rec.message_text
269: ,p_message_type_cd_o =>pqh_plg_shd.g_old_rec.message_type_cd
270: ,p_batch_status_o =>pqh_plg_shd.g_old_rec.batch_status
271: ,p_batch_start_date_o =>pqh_plg_shd.g_old_rec.batch_start_date
272: ,p_batch_end_date_o =>pqh_plg_shd.g_old_rec.batch_end_date
273: ,p_txn_table_route_id_o =>pqh_plg_shd.g_old_rec.txn_table_route_id
274: ,p_log_context_o =>pqh_plg_shd.g_old_rec.log_context
275: ,p_information_category_o =>pqh_plg_shd.g_old_rec.information_category
276: ,p_information1_o =>pqh_plg_shd.g_old_rec.information1

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

269: ,p_message_type_cd_o =>pqh_plg_shd.g_old_rec.message_type_cd
270: ,p_batch_status_o =>pqh_plg_shd.g_old_rec.batch_status
271: ,p_batch_start_date_o =>pqh_plg_shd.g_old_rec.batch_start_date
272: ,p_batch_end_date_o =>pqh_plg_shd.g_old_rec.batch_end_date
273: ,p_txn_table_route_id_o =>pqh_plg_shd.g_old_rec.txn_table_route_id
274: ,p_log_context_o =>pqh_plg_shd.g_old_rec.log_context
275: ,p_information_category_o =>pqh_plg_shd.g_old_rec.information_category
276: ,p_information1_o =>pqh_plg_shd.g_old_rec.information1
277: ,p_information2_o =>pqh_plg_shd.g_old_rec.information2

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

270: ,p_batch_status_o =>pqh_plg_shd.g_old_rec.batch_status
271: ,p_batch_start_date_o =>pqh_plg_shd.g_old_rec.batch_start_date
272: ,p_batch_end_date_o =>pqh_plg_shd.g_old_rec.batch_end_date
273: ,p_txn_table_route_id_o =>pqh_plg_shd.g_old_rec.txn_table_route_id
274: ,p_log_context_o =>pqh_plg_shd.g_old_rec.log_context
275: ,p_information_category_o =>pqh_plg_shd.g_old_rec.information_category
276: ,p_information1_o =>pqh_plg_shd.g_old_rec.information1
277: ,p_information2_o =>pqh_plg_shd.g_old_rec.information2
278: ,p_information3_o =>pqh_plg_shd.g_old_rec.information3

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

271: ,p_batch_start_date_o =>pqh_plg_shd.g_old_rec.batch_start_date
272: ,p_batch_end_date_o =>pqh_plg_shd.g_old_rec.batch_end_date
273: ,p_txn_table_route_id_o =>pqh_plg_shd.g_old_rec.txn_table_route_id
274: ,p_log_context_o =>pqh_plg_shd.g_old_rec.log_context
275: ,p_information_category_o =>pqh_plg_shd.g_old_rec.information_category
276: ,p_information1_o =>pqh_plg_shd.g_old_rec.information1
277: ,p_information2_o =>pqh_plg_shd.g_old_rec.information2
278: ,p_information3_o =>pqh_plg_shd.g_old_rec.information3
279: ,p_information4_o =>pqh_plg_shd.g_old_rec.information4

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

272: ,p_batch_end_date_o =>pqh_plg_shd.g_old_rec.batch_end_date
273: ,p_txn_table_route_id_o =>pqh_plg_shd.g_old_rec.txn_table_route_id
274: ,p_log_context_o =>pqh_plg_shd.g_old_rec.log_context
275: ,p_information_category_o =>pqh_plg_shd.g_old_rec.information_category
276: ,p_information1_o =>pqh_plg_shd.g_old_rec.information1
277: ,p_information2_o =>pqh_plg_shd.g_old_rec.information2
278: ,p_information3_o =>pqh_plg_shd.g_old_rec.information3
279: ,p_information4_o =>pqh_plg_shd.g_old_rec.information4
280: ,p_information5_o =>pqh_plg_shd.g_old_rec.information5

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

273: ,p_txn_table_route_id_o =>pqh_plg_shd.g_old_rec.txn_table_route_id
274: ,p_log_context_o =>pqh_plg_shd.g_old_rec.log_context
275: ,p_information_category_o =>pqh_plg_shd.g_old_rec.information_category
276: ,p_information1_o =>pqh_plg_shd.g_old_rec.information1
277: ,p_information2_o =>pqh_plg_shd.g_old_rec.information2
278: ,p_information3_o =>pqh_plg_shd.g_old_rec.information3
279: ,p_information4_o =>pqh_plg_shd.g_old_rec.information4
280: ,p_information5_o =>pqh_plg_shd.g_old_rec.information5
281: ,p_information6_o =>pqh_plg_shd.g_old_rec.information6

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

274: ,p_log_context_o =>pqh_plg_shd.g_old_rec.log_context
275: ,p_information_category_o =>pqh_plg_shd.g_old_rec.information_category
276: ,p_information1_o =>pqh_plg_shd.g_old_rec.information1
277: ,p_information2_o =>pqh_plg_shd.g_old_rec.information2
278: ,p_information3_o =>pqh_plg_shd.g_old_rec.information3
279: ,p_information4_o =>pqh_plg_shd.g_old_rec.information4
280: ,p_information5_o =>pqh_plg_shd.g_old_rec.information5
281: ,p_information6_o =>pqh_plg_shd.g_old_rec.information6
282: ,p_information7_o =>pqh_plg_shd.g_old_rec.information7

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

275: ,p_information_category_o =>pqh_plg_shd.g_old_rec.information_category
276: ,p_information1_o =>pqh_plg_shd.g_old_rec.information1
277: ,p_information2_o =>pqh_plg_shd.g_old_rec.information2
278: ,p_information3_o =>pqh_plg_shd.g_old_rec.information3
279: ,p_information4_o =>pqh_plg_shd.g_old_rec.information4
280: ,p_information5_o =>pqh_plg_shd.g_old_rec.information5
281: ,p_information6_o =>pqh_plg_shd.g_old_rec.information6
282: ,p_information7_o =>pqh_plg_shd.g_old_rec.information7
283: ,p_information8_o =>pqh_plg_shd.g_old_rec.information8

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

276: ,p_information1_o =>pqh_plg_shd.g_old_rec.information1
277: ,p_information2_o =>pqh_plg_shd.g_old_rec.information2
278: ,p_information3_o =>pqh_plg_shd.g_old_rec.information3
279: ,p_information4_o =>pqh_plg_shd.g_old_rec.information4
280: ,p_information5_o =>pqh_plg_shd.g_old_rec.information5
281: ,p_information6_o =>pqh_plg_shd.g_old_rec.information6
282: ,p_information7_o =>pqh_plg_shd.g_old_rec.information7
283: ,p_information8_o =>pqh_plg_shd.g_old_rec.information8
284: ,p_information9_o =>pqh_plg_shd.g_old_rec.information9

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

277: ,p_information2_o =>pqh_plg_shd.g_old_rec.information2
278: ,p_information3_o =>pqh_plg_shd.g_old_rec.information3
279: ,p_information4_o =>pqh_plg_shd.g_old_rec.information4
280: ,p_information5_o =>pqh_plg_shd.g_old_rec.information5
281: ,p_information6_o =>pqh_plg_shd.g_old_rec.information6
282: ,p_information7_o =>pqh_plg_shd.g_old_rec.information7
283: ,p_information8_o =>pqh_plg_shd.g_old_rec.information8
284: ,p_information9_o =>pqh_plg_shd.g_old_rec.information9
285: ,p_information10_o =>pqh_plg_shd.g_old_rec.information10

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

278: ,p_information3_o =>pqh_plg_shd.g_old_rec.information3
279: ,p_information4_o =>pqh_plg_shd.g_old_rec.information4
280: ,p_information5_o =>pqh_plg_shd.g_old_rec.information5
281: ,p_information6_o =>pqh_plg_shd.g_old_rec.information6
282: ,p_information7_o =>pqh_plg_shd.g_old_rec.information7
283: ,p_information8_o =>pqh_plg_shd.g_old_rec.information8
284: ,p_information9_o =>pqh_plg_shd.g_old_rec.information9
285: ,p_information10_o =>pqh_plg_shd.g_old_rec.information10
286: ,p_information11_o =>pqh_plg_shd.g_old_rec.information11

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

279: ,p_information4_o =>pqh_plg_shd.g_old_rec.information4
280: ,p_information5_o =>pqh_plg_shd.g_old_rec.information5
281: ,p_information6_o =>pqh_plg_shd.g_old_rec.information6
282: ,p_information7_o =>pqh_plg_shd.g_old_rec.information7
283: ,p_information8_o =>pqh_plg_shd.g_old_rec.information8
284: ,p_information9_o =>pqh_plg_shd.g_old_rec.information9
285: ,p_information10_o =>pqh_plg_shd.g_old_rec.information10
286: ,p_information11_o =>pqh_plg_shd.g_old_rec.information11
287: ,p_information12_o =>pqh_plg_shd.g_old_rec.information12

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

280: ,p_information5_o =>pqh_plg_shd.g_old_rec.information5
281: ,p_information6_o =>pqh_plg_shd.g_old_rec.information6
282: ,p_information7_o =>pqh_plg_shd.g_old_rec.information7
283: ,p_information8_o =>pqh_plg_shd.g_old_rec.information8
284: ,p_information9_o =>pqh_plg_shd.g_old_rec.information9
285: ,p_information10_o =>pqh_plg_shd.g_old_rec.information10
286: ,p_information11_o =>pqh_plg_shd.g_old_rec.information11
287: ,p_information12_o =>pqh_plg_shd.g_old_rec.information12
288: ,p_information13_o =>pqh_plg_shd.g_old_rec.information13

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

281: ,p_information6_o =>pqh_plg_shd.g_old_rec.information6
282: ,p_information7_o =>pqh_plg_shd.g_old_rec.information7
283: ,p_information8_o =>pqh_plg_shd.g_old_rec.information8
284: ,p_information9_o =>pqh_plg_shd.g_old_rec.information9
285: ,p_information10_o =>pqh_plg_shd.g_old_rec.information10
286: ,p_information11_o =>pqh_plg_shd.g_old_rec.information11
287: ,p_information12_o =>pqh_plg_shd.g_old_rec.information12
288: ,p_information13_o =>pqh_plg_shd.g_old_rec.information13
289: ,p_information14_o =>pqh_plg_shd.g_old_rec.information14

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

282: ,p_information7_o =>pqh_plg_shd.g_old_rec.information7
283: ,p_information8_o =>pqh_plg_shd.g_old_rec.information8
284: ,p_information9_o =>pqh_plg_shd.g_old_rec.information9
285: ,p_information10_o =>pqh_plg_shd.g_old_rec.information10
286: ,p_information11_o =>pqh_plg_shd.g_old_rec.information11
287: ,p_information12_o =>pqh_plg_shd.g_old_rec.information12
288: ,p_information13_o =>pqh_plg_shd.g_old_rec.information13
289: ,p_information14_o =>pqh_plg_shd.g_old_rec.information14
290: ,p_information15_o =>pqh_plg_shd.g_old_rec.information15

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

283: ,p_information8_o =>pqh_plg_shd.g_old_rec.information8
284: ,p_information9_o =>pqh_plg_shd.g_old_rec.information9
285: ,p_information10_o =>pqh_plg_shd.g_old_rec.information10
286: ,p_information11_o =>pqh_plg_shd.g_old_rec.information11
287: ,p_information12_o =>pqh_plg_shd.g_old_rec.information12
288: ,p_information13_o =>pqh_plg_shd.g_old_rec.information13
289: ,p_information14_o =>pqh_plg_shd.g_old_rec.information14
290: ,p_information15_o =>pqh_plg_shd.g_old_rec.information15
291: ,p_information16_o =>pqh_plg_shd.g_old_rec.information16

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

284: ,p_information9_o =>pqh_plg_shd.g_old_rec.information9
285: ,p_information10_o =>pqh_plg_shd.g_old_rec.information10
286: ,p_information11_o =>pqh_plg_shd.g_old_rec.information11
287: ,p_information12_o =>pqh_plg_shd.g_old_rec.information12
288: ,p_information13_o =>pqh_plg_shd.g_old_rec.information13
289: ,p_information14_o =>pqh_plg_shd.g_old_rec.information14
290: ,p_information15_o =>pqh_plg_shd.g_old_rec.information15
291: ,p_information16_o =>pqh_plg_shd.g_old_rec.information16
292: ,p_information17_o =>pqh_plg_shd.g_old_rec.information17

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

285: ,p_information10_o =>pqh_plg_shd.g_old_rec.information10
286: ,p_information11_o =>pqh_plg_shd.g_old_rec.information11
287: ,p_information12_o =>pqh_plg_shd.g_old_rec.information12
288: ,p_information13_o =>pqh_plg_shd.g_old_rec.information13
289: ,p_information14_o =>pqh_plg_shd.g_old_rec.information14
290: ,p_information15_o =>pqh_plg_shd.g_old_rec.information15
291: ,p_information16_o =>pqh_plg_shd.g_old_rec.information16
292: ,p_information17_o =>pqh_plg_shd.g_old_rec.information17
293: ,p_information18_o =>pqh_plg_shd.g_old_rec.information18

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

286: ,p_information11_o =>pqh_plg_shd.g_old_rec.information11
287: ,p_information12_o =>pqh_plg_shd.g_old_rec.information12
288: ,p_information13_o =>pqh_plg_shd.g_old_rec.information13
289: ,p_information14_o =>pqh_plg_shd.g_old_rec.information14
290: ,p_information15_o =>pqh_plg_shd.g_old_rec.information15
291: ,p_information16_o =>pqh_plg_shd.g_old_rec.information16
292: ,p_information17_o =>pqh_plg_shd.g_old_rec.information17
293: ,p_information18_o =>pqh_plg_shd.g_old_rec.information18
294: ,p_information19_o =>pqh_plg_shd.g_old_rec.information19

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

287: ,p_information12_o =>pqh_plg_shd.g_old_rec.information12
288: ,p_information13_o =>pqh_plg_shd.g_old_rec.information13
289: ,p_information14_o =>pqh_plg_shd.g_old_rec.information14
290: ,p_information15_o =>pqh_plg_shd.g_old_rec.information15
291: ,p_information16_o =>pqh_plg_shd.g_old_rec.information16
292: ,p_information17_o =>pqh_plg_shd.g_old_rec.information17
293: ,p_information18_o =>pqh_plg_shd.g_old_rec.information18
294: ,p_information19_o =>pqh_plg_shd.g_old_rec.information19
295: ,p_information20_o =>pqh_plg_shd.g_old_rec.information20

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

288: ,p_information13_o =>pqh_plg_shd.g_old_rec.information13
289: ,p_information14_o =>pqh_plg_shd.g_old_rec.information14
290: ,p_information15_o =>pqh_plg_shd.g_old_rec.information15
291: ,p_information16_o =>pqh_plg_shd.g_old_rec.information16
292: ,p_information17_o =>pqh_plg_shd.g_old_rec.information17
293: ,p_information18_o =>pqh_plg_shd.g_old_rec.information18
294: ,p_information19_o =>pqh_plg_shd.g_old_rec.information19
295: ,p_information20_o =>pqh_plg_shd.g_old_rec.information20
296: ,p_information21_o =>pqh_plg_shd.g_old_rec.information21

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

289: ,p_information14_o =>pqh_plg_shd.g_old_rec.information14
290: ,p_information15_o =>pqh_plg_shd.g_old_rec.information15
291: ,p_information16_o =>pqh_plg_shd.g_old_rec.information16
292: ,p_information17_o =>pqh_plg_shd.g_old_rec.information17
293: ,p_information18_o =>pqh_plg_shd.g_old_rec.information18
294: ,p_information19_o =>pqh_plg_shd.g_old_rec.information19
295: ,p_information20_o =>pqh_plg_shd.g_old_rec.information20
296: ,p_information21_o =>pqh_plg_shd.g_old_rec.information21
297: ,p_information22_o =>pqh_plg_shd.g_old_rec.information22

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

290: ,p_information15_o =>pqh_plg_shd.g_old_rec.information15
291: ,p_information16_o =>pqh_plg_shd.g_old_rec.information16
292: ,p_information17_o =>pqh_plg_shd.g_old_rec.information17
293: ,p_information18_o =>pqh_plg_shd.g_old_rec.information18
294: ,p_information19_o =>pqh_plg_shd.g_old_rec.information19
295: ,p_information20_o =>pqh_plg_shd.g_old_rec.information20
296: ,p_information21_o =>pqh_plg_shd.g_old_rec.information21
297: ,p_information22_o =>pqh_plg_shd.g_old_rec.information22
298: ,p_information23_o =>pqh_plg_shd.g_old_rec.information23

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

291: ,p_information16_o =>pqh_plg_shd.g_old_rec.information16
292: ,p_information17_o =>pqh_plg_shd.g_old_rec.information17
293: ,p_information18_o =>pqh_plg_shd.g_old_rec.information18
294: ,p_information19_o =>pqh_plg_shd.g_old_rec.information19
295: ,p_information20_o =>pqh_plg_shd.g_old_rec.information20
296: ,p_information21_o =>pqh_plg_shd.g_old_rec.information21
297: ,p_information22_o =>pqh_plg_shd.g_old_rec.information22
298: ,p_information23_o =>pqh_plg_shd.g_old_rec.information23
299: ,p_information24_o =>pqh_plg_shd.g_old_rec.information24

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

292: ,p_information17_o =>pqh_plg_shd.g_old_rec.information17
293: ,p_information18_o =>pqh_plg_shd.g_old_rec.information18
294: ,p_information19_o =>pqh_plg_shd.g_old_rec.information19
295: ,p_information20_o =>pqh_plg_shd.g_old_rec.information20
296: ,p_information21_o =>pqh_plg_shd.g_old_rec.information21
297: ,p_information22_o =>pqh_plg_shd.g_old_rec.information22
298: ,p_information23_o =>pqh_plg_shd.g_old_rec.information23
299: ,p_information24_o =>pqh_plg_shd.g_old_rec.information24
300: ,p_information25_o =>pqh_plg_shd.g_old_rec.information25

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

293: ,p_information18_o =>pqh_plg_shd.g_old_rec.information18
294: ,p_information19_o =>pqh_plg_shd.g_old_rec.information19
295: ,p_information20_o =>pqh_plg_shd.g_old_rec.information20
296: ,p_information21_o =>pqh_plg_shd.g_old_rec.information21
297: ,p_information22_o =>pqh_plg_shd.g_old_rec.information22
298: ,p_information23_o =>pqh_plg_shd.g_old_rec.information23
299: ,p_information24_o =>pqh_plg_shd.g_old_rec.information24
300: ,p_information25_o =>pqh_plg_shd.g_old_rec.information25
301: ,p_information26_o =>pqh_plg_shd.g_old_rec.information26

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

294: ,p_information19_o =>pqh_plg_shd.g_old_rec.information19
295: ,p_information20_o =>pqh_plg_shd.g_old_rec.information20
296: ,p_information21_o =>pqh_plg_shd.g_old_rec.information21
297: ,p_information22_o =>pqh_plg_shd.g_old_rec.information22
298: ,p_information23_o =>pqh_plg_shd.g_old_rec.information23
299: ,p_information24_o =>pqh_plg_shd.g_old_rec.information24
300: ,p_information25_o =>pqh_plg_shd.g_old_rec.information25
301: ,p_information26_o =>pqh_plg_shd.g_old_rec.information26
302: ,p_information27_o =>pqh_plg_shd.g_old_rec.information27

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

295: ,p_information20_o =>pqh_plg_shd.g_old_rec.information20
296: ,p_information21_o =>pqh_plg_shd.g_old_rec.information21
297: ,p_information22_o =>pqh_plg_shd.g_old_rec.information22
298: ,p_information23_o =>pqh_plg_shd.g_old_rec.information23
299: ,p_information24_o =>pqh_plg_shd.g_old_rec.information24
300: ,p_information25_o =>pqh_plg_shd.g_old_rec.information25
301: ,p_information26_o =>pqh_plg_shd.g_old_rec.information26
302: ,p_information27_o =>pqh_plg_shd.g_old_rec.information27
303: ,p_information28_o =>pqh_plg_shd.g_old_rec.information28

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

296: ,p_information21_o =>pqh_plg_shd.g_old_rec.information21
297: ,p_information22_o =>pqh_plg_shd.g_old_rec.information22
298: ,p_information23_o =>pqh_plg_shd.g_old_rec.information23
299: ,p_information24_o =>pqh_plg_shd.g_old_rec.information24
300: ,p_information25_o =>pqh_plg_shd.g_old_rec.information25
301: ,p_information26_o =>pqh_plg_shd.g_old_rec.information26
302: ,p_information27_o =>pqh_plg_shd.g_old_rec.information27
303: ,p_information28_o =>pqh_plg_shd.g_old_rec.information28
304: ,p_information29_o =>pqh_plg_shd.g_old_rec.information29

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

297: ,p_information22_o =>pqh_plg_shd.g_old_rec.information22
298: ,p_information23_o =>pqh_plg_shd.g_old_rec.information23
299: ,p_information24_o =>pqh_plg_shd.g_old_rec.information24
300: ,p_information25_o =>pqh_plg_shd.g_old_rec.information25
301: ,p_information26_o =>pqh_plg_shd.g_old_rec.information26
302: ,p_information27_o =>pqh_plg_shd.g_old_rec.information27
303: ,p_information28_o =>pqh_plg_shd.g_old_rec.information28
304: ,p_information29_o =>pqh_plg_shd.g_old_rec.information29
305: ,p_information30_o =>pqh_plg_shd.g_old_rec.information30

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

298: ,p_information23_o =>pqh_plg_shd.g_old_rec.information23
299: ,p_information24_o =>pqh_plg_shd.g_old_rec.information24
300: ,p_information25_o =>pqh_plg_shd.g_old_rec.information25
301: ,p_information26_o =>pqh_plg_shd.g_old_rec.information26
302: ,p_information27_o =>pqh_plg_shd.g_old_rec.information27
303: ,p_information28_o =>pqh_plg_shd.g_old_rec.information28
304: ,p_information29_o =>pqh_plg_shd.g_old_rec.information29
305: ,p_information30_o =>pqh_plg_shd.g_old_rec.information30
306: ,p_object_version_number_o =>pqh_plg_shd.g_old_rec.object_version_number

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

299: ,p_information24_o =>pqh_plg_shd.g_old_rec.information24
300: ,p_information25_o =>pqh_plg_shd.g_old_rec.information25
301: ,p_information26_o =>pqh_plg_shd.g_old_rec.information26
302: ,p_information27_o =>pqh_plg_shd.g_old_rec.information27
303: ,p_information28_o =>pqh_plg_shd.g_old_rec.information28
304: ,p_information29_o =>pqh_plg_shd.g_old_rec.information29
305: ,p_information30_o =>pqh_plg_shd.g_old_rec.information30
306: ,p_object_version_number_o =>pqh_plg_shd.g_old_rec.object_version_number
307: );

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

300: ,p_information25_o =>pqh_plg_shd.g_old_rec.information25
301: ,p_information26_o =>pqh_plg_shd.g_old_rec.information26
302: ,p_information27_o =>pqh_plg_shd.g_old_rec.information27
303: ,p_information28_o =>pqh_plg_shd.g_old_rec.information28
304: ,p_information29_o =>pqh_plg_shd.g_old_rec.information29
305: ,p_information30_o =>pqh_plg_shd.g_old_rec.information30
306: ,p_object_version_number_o =>pqh_plg_shd.g_old_rec.object_version_number
307: );
308: --

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

301: ,p_information26_o =>pqh_plg_shd.g_old_rec.information26
302: ,p_information27_o =>pqh_plg_shd.g_old_rec.information27
303: ,p_information28_o =>pqh_plg_shd.g_old_rec.information28
304: ,p_information29_o =>pqh_plg_shd.g_old_rec.information29
305: ,p_information30_o =>pqh_plg_shd.g_old_rec.information30
306: ,p_object_version_number_o =>pqh_plg_shd.g_old_rec.object_version_number
307: );
308: --
309: exception

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

302: ,p_information27_o =>pqh_plg_shd.g_old_rec.information27
303: ,p_information28_o =>pqh_plg_shd.g_old_rec.information28
304: ,p_information29_o =>pqh_plg_shd.g_old_rec.information29
305: ,p_information30_o =>pqh_plg_shd.g_old_rec.information30
306: ,p_object_version_number_o =>pqh_plg_shd.g_old_rec.object_version_number
307: );
308: --
309: exception
310: --

Line 368: Procedure convert_defs(p_rec in out nocopy pqh_plg_shd.g_rec_type) is

364: -- Internal Row Handler Use Only.
365: --
366: -- {End Of Comments}
367: -- ----------------------------------------------------------------------------
368: Procedure convert_defs(p_rec in out nocopy pqh_plg_shd.g_rec_type) is
369: --
370: l_proc varchar2(72) := g_package||'convert_defs';
371: --
372: Begin

Line 383: pqh_plg_shd.g_old_rec.module_cd;

379: -- is being used then we must set to the 'current' argument value.
380: --
381: If (p_rec.module_cd = hr_api.g_varchar2) then
382: p_rec.module_cd :=
383: pqh_plg_shd.g_old_rec.module_cd;
384: End If;
385: If (p_rec.txn_id = hr_api.g_number) then
386: p_rec.txn_id :=
387: pqh_plg_shd.g_old_rec.txn_id;

Line 387: pqh_plg_shd.g_old_rec.txn_id;

383: pqh_plg_shd.g_old_rec.module_cd;
384: End If;
385: If (p_rec.txn_id = hr_api.g_number) then
386: p_rec.txn_id :=
387: pqh_plg_shd.g_old_rec.txn_id;
388: End If;
389: If (p_rec.master_process_log_id = hr_api.g_number) then
390: p_rec.master_process_log_id :=
391: pqh_plg_shd.g_old_rec.master_process_log_id;

Line 391: pqh_plg_shd.g_old_rec.master_process_log_id;

387: pqh_plg_shd.g_old_rec.txn_id;
388: End If;
389: If (p_rec.master_process_log_id = hr_api.g_number) then
390: p_rec.master_process_log_id :=
391: pqh_plg_shd.g_old_rec.master_process_log_id;
392: End If;
393: If (p_rec.message_text = hr_api.g_varchar2) then
394: p_rec.message_text :=
395: pqh_plg_shd.g_old_rec.message_text;

Line 395: pqh_plg_shd.g_old_rec.message_text;

391: pqh_plg_shd.g_old_rec.master_process_log_id;
392: End If;
393: If (p_rec.message_text = hr_api.g_varchar2) then
394: p_rec.message_text :=
395: pqh_plg_shd.g_old_rec.message_text;
396: End If;
397: If (p_rec.message_type_cd = hr_api.g_varchar2) then
398: p_rec.message_type_cd :=
399: pqh_plg_shd.g_old_rec.message_type_cd;

Line 399: pqh_plg_shd.g_old_rec.message_type_cd;

395: pqh_plg_shd.g_old_rec.message_text;
396: End If;
397: If (p_rec.message_type_cd = hr_api.g_varchar2) then
398: p_rec.message_type_cd :=
399: pqh_plg_shd.g_old_rec.message_type_cd;
400: End If;
401: If (p_rec.batch_status = hr_api.g_varchar2) then
402: p_rec.batch_status :=
403: pqh_plg_shd.g_old_rec.batch_status;

Line 403: pqh_plg_shd.g_old_rec.batch_status;

399: pqh_plg_shd.g_old_rec.message_type_cd;
400: End If;
401: If (p_rec.batch_status = hr_api.g_varchar2) then
402: p_rec.batch_status :=
403: pqh_plg_shd.g_old_rec.batch_status;
404: End If;
405: If (p_rec.batch_start_date = hr_api.g_date) then
406: p_rec.batch_start_date :=
407: pqh_plg_shd.g_old_rec.batch_start_date;

Line 407: pqh_plg_shd.g_old_rec.batch_start_date;

403: pqh_plg_shd.g_old_rec.batch_status;
404: End If;
405: If (p_rec.batch_start_date = hr_api.g_date) then
406: p_rec.batch_start_date :=
407: pqh_plg_shd.g_old_rec.batch_start_date;
408: End If;
409: If (p_rec.batch_end_date = hr_api.g_date) then
410: p_rec.batch_end_date :=
411: pqh_plg_shd.g_old_rec.batch_end_date;

Line 411: pqh_plg_shd.g_old_rec.batch_end_date;

407: pqh_plg_shd.g_old_rec.batch_start_date;
408: End If;
409: If (p_rec.batch_end_date = hr_api.g_date) then
410: p_rec.batch_end_date :=
411: pqh_plg_shd.g_old_rec.batch_end_date;
412: End If;
413: If (p_rec.txn_table_route_id = hr_api.g_number) then
414: p_rec.txn_table_route_id :=
415: pqh_plg_shd.g_old_rec.txn_table_route_id;

Line 415: pqh_plg_shd.g_old_rec.txn_table_route_id;

411: pqh_plg_shd.g_old_rec.batch_end_date;
412: End If;
413: If (p_rec.txn_table_route_id = hr_api.g_number) then
414: p_rec.txn_table_route_id :=
415: pqh_plg_shd.g_old_rec.txn_table_route_id;
416: End If;
417: If (p_rec.log_context = hr_api.g_varchar2) then
418: p_rec.log_context :=
419: pqh_plg_shd.g_old_rec.log_context;

Line 419: pqh_plg_shd.g_old_rec.log_context;

415: pqh_plg_shd.g_old_rec.txn_table_route_id;
416: End If;
417: If (p_rec.log_context = hr_api.g_varchar2) then
418: p_rec.log_context :=
419: pqh_plg_shd.g_old_rec.log_context;
420: End If;
421: If (p_rec.information_category = hr_api.g_varchar2) then
422: p_rec.information_category :=
423: pqh_plg_shd.g_old_rec.information_category;

Line 423: pqh_plg_shd.g_old_rec.information_category;

419: pqh_plg_shd.g_old_rec.log_context;
420: End If;
421: If (p_rec.information_category = hr_api.g_varchar2) then
422: p_rec.information_category :=
423: pqh_plg_shd.g_old_rec.information_category;
424: End If;
425: If (p_rec.information1 = hr_api.g_varchar2) then
426: p_rec.information1 :=
427: pqh_plg_shd.g_old_rec.information1;

Line 427: pqh_plg_shd.g_old_rec.information1;

423: pqh_plg_shd.g_old_rec.information_category;
424: End If;
425: If (p_rec.information1 = hr_api.g_varchar2) then
426: p_rec.information1 :=
427: pqh_plg_shd.g_old_rec.information1;
428: End If;
429: If (p_rec.information2 = hr_api.g_varchar2) then
430: p_rec.information2 :=
431: pqh_plg_shd.g_old_rec.information2;

Line 431: pqh_plg_shd.g_old_rec.information2;

427: pqh_plg_shd.g_old_rec.information1;
428: End If;
429: If (p_rec.information2 = hr_api.g_varchar2) then
430: p_rec.information2 :=
431: pqh_plg_shd.g_old_rec.information2;
432: End If;
433: If (p_rec.information3 = hr_api.g_varchar2) then
434: p_rec.information3 :=
435: pqh_plg_shd.g_old_rec.information3;

Line 435: pqh_plg_shd.g_old_rec.information3;

431: pqh_plg_shd.g_old_rec.information2;
432: End If;
433: If (p_rec.information3 = hr_api.g_varchar2) then
434: p_rec.information3 :=
435: pqh_plg_shd.g_old_rec.information3;
436: End If;
437: If (p_rec.information4 = hr_api.g_varchar2) then
438: p_rec.information4 :=
439: pqh_plg_shd.g_old_rec.information4;

Line 439: pqh_plg_shd.g_old_rec.information4;

435: pqh_plg_shd.g_old_rec.information3;
436: End If;
437: If (p_rec.information4 = hr_api.g_varchar2) then
438: p_rec.information4 :=
439: pqh_plg_shd.g_old_rec.information4;
440: End If;
441: If (p_rec.information5 = hr_api.g_varchar2) then
442: p_rec.information5 :=
443: pqh_plg_shd.g_old_rec.information5;

Line 443: pqh_plg_shd.g_old_rec.information5;

439: pqh_plg_shd.g_old_rec.information4;
440: End If;
441: If (p_rec.information5 = hr_api.g_varchar2) then
442: p_rec.information5 :=
443: pqh_plg_shd.g_old_rec.information5;
444: End If;
445: If (p_rec.information6 = hr_api.g_varchar2) then
446: p_rec.information6 :=
447: pqh_plg_shd.g_old_rec.information6;

Line 447: pqh_plg_shd.g_old_rec.information6;

443: pqh_plg_shd.g_old_rec.information5;
444: End If;
445: If (p_rec.information6 = hr_api.g_varchar2) then
446: p_rec.information6 :=
447: pqh_plg_shd.g_old_rec.information6;
448: End If;
449: If (p_rec.information7 = hr_api.g_varchar2) then
450: p_rec.information7 :=
451: pqh_plg_shd.g_old_rec.information7;

Line 451: pqh_plg_shd.g_old_rec.information7;

447: pqh_plg_shd.g_old_rec.information6;
448: End If;
449: If (p_rec.information7 = hr_api.g_varchar2) then
450: p_rec.information7 :=
451: pqh_plg_shd.g_old_rec.information7;
452: End If;
453: If (p_rec.information8 = hr_api.g_varchar2) then
454: p_rec.information8 :=
455: pqh_plg_shd.g_old_rec.information8;

Line 455: pqh_plg_shd.g_old_rec.information8;

451: pqh_plg_shd.g_old_rec.information7;
452: End If;
453: If (p_rec.information8 = hr_api.g_varchar2) then
454: p_rec.information8 :=
455: pqh_plg_shd.g_old_rec.information8;
456: End If;
457: If (p_rec.information9 = hr_api.g_varchar2) then
458: p_rec.information9 :=
459: pqh_plg_shd.g_old_rec.information9;

Line 459: pqh_plg_shd.g_old_rec.information9;

455: pqh_plg_shd.g_old_rec.information8;
456: End If;
457: If (p_rec.information9 = hr_api.g_varchar2) then
458: p_rec.information9 :=
459: pqh_plg_shd.g_old_rec.information9;
460: End If;
461: If (p_rec.information10 = hr_api.g_varchar2) then
462: p_rec.information10 :=
463: pqh_plg_shd.g_old_rec.information10;

Line 463: pqh_plg_shd.g_old_rec.information10;

459: pqh_plg_shd.g_old_rec.information9;
460: End If;
461: If (p_rec.information10 = hr_api.g_varchar2) then
462: p_rec.information10 :=
463: pqh_plg_shd.g_old_rec.information10;
464: End If;
465: If (p_rec.information11 = hr_api.g_varchar2) then
466: p_rec.information11 :=
467: pqh_plg_shd.g_old_rec.information11;

Line 467: pqh_plg_shd.g_old_rec.information11;

463: pqh_plg_shd.g_old_rec.information10;
464: End If;
465: If (p_rec.information11 = hr_api.g_varchar2) then
466: p_rec.information11 :=
467: pqh_plg_shd.g_old_rec.information11;
468: End If;
469: If (p_rec.information12 = hr_api.g_varchar2) then
470: p_rec.information12 :=
471: pqh_plg_shd.g_old_rec.information12;

Line 471: pqh_plg_shd.g_old_rec.information12;

467: pqh_plg_shd.g_old_rec.information11;
468: End If;
469: If (p_rec.information12 = hr_api.g_varchar2) then
470: p_rec.information12 :=
471: pqh_plg_shd.g_old_rec.information12;
472: End If;
473: If (p_rec.information13 = hr_api.g_varchar2) then
474: p_rec.information13 :=
475: pqh_plg_shd.g_old_rec.information13;

Line 475: pqh_plg_shd.g_old_rec.information13;

471: pqh_plg_shd.g_old_rec.information12;
472: End If;
473: If (p_rec.information13 = hr_api.g_varchar2) then
474: p_rec.information13 :=
475: pqh_plg_shd.g_old_rec.information13;
476: End If;
477: If (p_rec.information14 = hr_api.g_varchar2) then
478: p_rec.information14 :=
479: pqh_plg_shd.g_old_rec.information14;

Line 479: pqh_plg_shd.g_old_rec.information14;

475: pqh_plg_shd.g_old_rec.information13;
476: End If;
477: If (p_rec.information14 = hr_api.g_varchar2) then
478: p_rec.information14 :=
479: pqh_plg_shd.g_old_rec.information14;
480: End If;
481: If (p_rec.information15 = hr_api.g_varchar2) then
482: p_rec.information15 :=
483: pqh_plg_shd.g_old_rec.information15;

Line 483: pqh_plg_shd.g_old_rec.information15;

479: pqh_plg_shd.g_old_rec.information14;
480: End If;
481: If (p_rec.information15 = hr_api.g_varchar2) then
482: p_rec.information15 :=
483: pqh_plg_shd.g_old_rec.information15;
484: End If;
485: If (p_rec.information16 = hr_api.g_varchar2) then
486: p_rec.information16 :=
487: pqh_plg_shd.g_old_rec.information16;

Line 487: pqh_plg_shd.g_old_rec.information16;

483: pqh_plg_shd.g_old_rec.information15;
484: End If;
485: If (p_rec.information16 = hr_api.g_varchar2) then
486: p_rec.information16 :=
487: pqh_plg_shd.g_old_rec.information16;
488: End If;
489: If (p_rec.information17 = hr_api.g_varchar2) then
490: p_rec.information17 :=
491: pqh_plg_shd.g_old_rec.information17;

Line 491: pqh_plg_shd.g_old_rec.information17;

487: pqh_plg_shd.g_old_rec.information16;
488: End If;
489: If (p_rec.information17 = hr_api.g_varchar2) then
490: p_rec.information17 :=
491: pqh_plg_shd.g_old_rec.information17;
492: End If;
493: If (p_rec.information18 = hr_api.g_varchar2) then
494: p_rec.information18 :=
495: pqh_plg_shd.g_old_rec.information18;

Line 495: pqh_plg_shd.g_old_rec.information18;

491: pqh_plg_shd.g_old_rec.information17;
492: End If;
493: If (p_rec.information18 = hr_api.g_varchar2) then
494: p_rec.information18 :=
495: pqh_plg_shd.g_old_rec.information18;
496: End If;
497: If (p_rec.information19 = hr_api.g_varchar2) then
498: p_rec.information19 :=
499: pqh_plg_shd.g_old_rec.information19;

Line 499: pqh_plg_shd.g_old_rec.information19;

495: pqh_plg_shd.g_old_rec.information18;
496: End If;
497: If (p_rec.information19 = hr_api.g_varchar2) then
498: p_rec.information19 :=
499: pqh_plg_shd.g_old_rec.information19;
500: End If;
501: If (p_rec.information20 = hr_api.g_varchar2) then
502: p_rec.information20 :=
503: pqh_plg_shd.g_old_rec.information20;

Line 503: pqh_plg_shd.g_old_rec.information20;

499: pqh_plg_shd.g_old_rec.information19;
500: End If;
501: If (p_rec.information20 = hr_api.g_varchar2) then
502: p_rec.information20 :=
503: pqh_plg_shd.g_old_rec.information20;
504: End If;
505: If (p_rec.information21 = hr_api.g_varchar2) then
506: p_rec.information21 :=
507: pqh_plg_shd.g_old_rec.information21;

Line 507: pqh_plg_shd.g_old_rec.information21;

503: pqh_plg_shd.g_old_rec.information20;
504: End If;
505: If (p_rec.information21 = hr_api.g_varchar2) then
506: p_rec.information21 :=
507: pqh_plg_shd.g_old_rec.information21;
508: End If;
509: If (p_rec.information22 = hr_api.g_varchar2) then
510: p_rec.information22 :=
511: pqh_plg_shd.g_old_rec.information22;

Line 511: pqh_plg_shd.g_old_rec.information22;

507: pqh_plg_shd.g_old_rec.information21;
508: End If;
509: If (p_rec.information22 = hr_api.g_varchar2) then
510: p_rec.information22 :=
511: pqh_plg_shd.g_old_rec.information22;
512: End If;
513: If (p_rec.information23 = hr_api.g_varchar2) then
514: p_rec.information23 :=
515: pqh_plg_shd.g_old_rec.information23;

Line 515: pqh_plg_shd.g_old_rec.information23;

511: pqh_plg_shd.g_old_rec.information22;
512: End If;
513: If (p_rec.information23 = hr_api.g_varchar2) then
514: p_rec.information23 :=
515: pqh_plg_shd.g_old_rec.information23;
516: End If;
517: If (p_rec.information24 = hr_api.g_varchar2) then
518: p_rec.information24 :=
519: pqh_plg_shd.g_old_rec.information24;

Line 519: pqh_plg_shd.g_old_rec.information24;

515: pqh_plg_shd.g_old_rec.information23;
516: End If;
517: If (p_rec.information24 = hr_api.g_varchar2) then
518: p_rec.information24 :=
519: pqh_plg_shd.g_old_rec.information24;
520: End If;
521: If (p_rec.information25 = hr_api.g_varchar2) then
522: p_rec.information25 :=
523: pqh_plg_shd.g_old_rec.information25;

Line 523: pqh_plg_shd.g_old_rec.information25;

519: pqh_plg_shd.g_old_rec.information24;
520: End If;
521: If (p_rec.information25 = hr_api.g_varchar2) then
522: p_rec.information25 :=
523: pqh_plg_shd.g_old_rec.information25;
524: End If;
525: If (p_rec.information26 = hr_api.g_varchar2) then
526: p_rec.information26 :=
527: pqh_plg_shd.g_old_rec.information26;

Line 527: pqh_plg_shd.g_old_rec.information26;

523: pqh_plg_shd.g_old_rec.information25;
524: End If;
525: If (p_rec.information26 = hr_api.g_varchar2) then
526: p_rec.information26 :=
527: pqh_plg_shd.g_old_rec.information26;
528: End If;
529: If (p_rec.information27 = hr_api.g_varchar2) then
530: p_rec.information27 :=
531: pqh_plg_shd.g_old_rec.information27;

Line 531: pqh_plg_shd.g_old_rec.information27;

527: pqh_plg_shd.g_old_rec.information26;
528: End If;
529: If (p_rec.information27 = hr_api.g_varchar2) then
530: p_rec.information27 :=
531: pqh_plg_shd.g_old_rec.information27;
532: End If;
533: If (p_rec.information28 = hr_api.g_varchar2) then
534: p_rec.information28 :=
535: pqh_plg_shd.g_old_rec.information28;

Line 535: pqh_plg_shd.g_old_rec.information28;

531: pqh_plg_shd.g_old_rec.information27;
532: End If;
533: If (p_rec.information28 = hr_api.g_varchar2) then
534: p_rec.information28 :=
535: pqh_plg_shd.g_old_rec.information28;
536: End If;
537: If (p_rec.information29 = hr_api.g_varchar2) then
538: p_rec.information29 :=
539: pqh_plg_shd.g_old_rec.information29;

Line 539: pqh_plg_shd.g_old_rec.information29;

535: pqh_plg_shd.g_old_rec.information28;
536: End If;
537: If (p_rec.information29 = hr_api.g_varchar2) then
538: p_rec.information29 :=
539: pqh_plg_shd.g_old_rec.information29;
540: End If;
541: If (p_rec.information30 = hr_api.g_varchar2) then
542: p_rec.information30 :=
543: pqh_plg_shd.g_old_rec.information30;

Line 543: pqh_plg_shd.g_old_rec.information30;

539: pqh_plg_shd.g_old_rec.information29;
540: End If;
541: If (p_rec.information30 = hr_api.g_varchar2) then
542: p_rec.information30 :=
543: pqh_plg_shd.g_old_rec.information30;
544: End If;
545:
546: --
547: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 557: p_rec in out nocopy pqh_plg_shd.g_rec_type

553: -- ----------------------------------------------------------------------------
554: Procedure upd
555: (
556: p_effective_date in date,
557: p_rec in out nocopy pqh_plg_shd.g_rec_type
558: ) is
559: --
560: l_proc varchar2(72) := g_package||'upd';
561: --

Line 567: pqh_plg_shd.lck

563: hr_utility.set_location('Entering:'||l_proc, 5);
564: --
565: -- We must lock the row which we need to update.
566: --
567: pqh_plg_shd.lck
568: (
569: p_rec.process_log_id,
570: p_rec.object_version_number
571: );

Line 648: l_rec pqh_plg_shd.g_rec_type;

644: p_information30 in varchar2 default hr_api.g_varchar2,
645: p_object_version_number in out nocopy number
646: ) is
647: --
648: l_rec pqh_plg_shd.g_rec_type;
649: l_proc varchar2(72) := g_package||'upd';
650: --
651: Begin
652: hr_utility.set_location('Entering:'||l_proc, 5);

Line 658: pqh_plg_shd.convert_args

654: -- Call conversion function to turn arguments into the
655: -- l_rec structure.
656: --
657: l_rec :=
658: pqh_plg_shd.convert_args
659: (
660: p_process_log_id,
661: p_module_cd,
662: p_txn_id,