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_RHA_UPD dependencies on PQH_RHA_SHD

Line 55: (p_rec in out nocopy pqh_rha_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pqh_rha_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 96: pqh_rha_shd.constraint_error

92: Exception
93: When hr_api.check_integrity_violated Then
94: -- A check constraint has been violated
95: --
96: pqh_rha_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.parent_integrity_violated Then
99: -- Parent integrity has been violated
100: --

Line 101: pqh_rha_shd.constraint_error

97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.parent_integrity_violated Then
99: -- Parent integrity has been violated
100: --
101: pqh_rha_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.unique_integrity_violated Then
104: -- Unique integrity has been violated
105: --

Line 106: pqh_rha_shd.constraint_error

102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.unique_integrity_violated Then
104: -- Unique integrity has been violated
105: --
106: pqh_rha_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When Others Then
109: --
110: Raise;

Line 146: (p_rec in pqh_rha_shd.g_rec_type

142: --
143: -- {End Of Comments}
144: -- ----------------------------------------------------------------------------
145: Procedure pre_update
146: (p_rec in pqh_rha_shd.g_rec_type
147: ) is
148: --
149: l_proc varchar2(72) := g_package||'pre_update';
150: --

Line 191: ,p_rec in pqh_rha_shd.g_rec_type

187: -- {End Of Comments}
188: -- ----------------------------------------------------------------------------
189: Procedure post_update
190: (p_effective_date in date
191: ,p_rec in pqh_rha_shd.g_rec_type
192: ) is
193: --
194: l_proc varchar2(72) := g_package||'post_update';
195: --

Line 231: => pqh_rha_shd.g_old_rec.routing_history_id

227: => p_rec.value_number
228: ,p_value_char
229: => p_rec.value_char
230: ,p_routing_history_id_o
231: => pqh_rha_shd.g_old_rec.routing_history_id
232: ,p_attribute_id_o
233: => pqh_rha_shd.g_old_rec.attribute_id
234: ,p_from_char_o
235: => pqh_rha_shd.g_old_rec.from_char

Line 233: => pqh_rha_shd.g_old_rec.attribute_id

229: => p_rec.value_char
230: ,p_routing_history_id_o
231: => pqh_rha_shd.g_old_rec.routing_history_id
232: ,p_attribute_id_o
233: => pqh_rha_shd.g_old_rec.attribute_id
234: ,p_from_char_o
235: => pqh_rha_shd.g_old_rec.from_char
236: ,p_from_date_o
237: => pqh_rha_shd.g_old_rec.from_date

Line 235: => pqh_rha_shd.g_old_rec.from_char

231: => pqh_rha_shd.g_old_rec.routing_history_id
232: ,p_attribute_id_o
233: => pqh_rha_shd.g_old_rec.attribute_id
234: ,p_from_char_o
235: => pqh_rha_shd.g_old_rec.from_char
236: ,p_from_date_o
237: => pqh_rha_shd.g_old_rec.from_date
238: ,p_from_number_o
239: => pqh_rha_shd.g_old_rec.from_number

Line 237: => pqh_rha_shd.g_old_rec.from_date

233: => pqh_rha_shd.g_old_rec.attribute_id
234: ,p_from_char_o
235: => pqh_rha_shd.g_old_rec.from_char
236: ,p_from_date_o
237: => pqh_rha_shd.g_old_rec.from_date
238: ,p_from_number_o
239: => pqh_rha_shd.g_old_rec.from_number
240: ,p_to_char_o
241: => pqh_rha_shd.g_old_rec.to_char

Line 239: => pqh_rha_shd.g_old_rec.from_number

235: => pqh_rha_shd.g_old_rec.from_char
236: ,p_from_date_o
237: => pqh_rha_shd.g_old_rec.from_date
238: ,p_from_number_o
239: => pqh_rha_shd.g_old_rec.from_number
240: ,p_to_char_o
241: => pqh_rha_shd.g_old_rec.to_char
242: ,p_to_date_o
243: => pqh_rha_shd.g_old_rec.to_date

Line 241: => pqh_rha_shd.g_old_rec.to_char

237: => pqh_rha_shd.g_old_rec.from_date
238: ,p_from_number_o
239: => pqh_rha_shd.g_old_rec.from_number
240: ,p_to_char_o
241: => pqh_rha_shd.g_old_rec.to_char
242: ,p_to_date_o
243: => pqh_rha_shd.g_old_rec.to_date
244: ,p_to_number_o
245: => pqh_rha_shd.g_old_rec.to_number

Line 243: => pqh_rha_shd.g_old_rec.to_date

239: => pqh_rha_shd.g_old_rec.from_number
240: ,p_to_char_o
241: => pqh_rha_shd.g_old_rec.to_char
242: ,p_to_date_o
243: => pqh_rha_shd.g_old_rec.to_date
244: ,p_to_number_o
245: => pqh_rha_shd.g_old_rec.to_number
246: ,p_object_version_number_o
247: => pqh_rha_shd.g_old_rec.object_version_number

Line 245: => pqh_rha_shd.g_old_rec.to_number

241: => pqh_rha_shd.g_old_rec.to_char
242: ,p_to_date_o
243: => pqh_rha_shd.g_old_rec.to_date
244: ,p_to_number_o
245: => pqh_rha_shd.g_old_rec.to_number
246: ,p_object_version_number_o
247: => pqh_rha_shd.g_old_rec.object_version_number
248: ,p_range_type_cd_o
249: => pqh_rha_shd.g_old_rec.range_type_cd

Line 247: => pqh_rha_shd.g_old_rec.object_version_number

243: => pqh_rha_shd.g_old_rec.to_date
244: ,p_to_number_o
245: => pqh_rha_shd.g_old_rec.to_number
246: ,p_object_version_number_o
247: => pqh_rha_shd.g_old_rec.object_version_number
248: ,p_range_type_cd_o
249: => pqh_rha_shd.g_old_rec.range_type_cd
250: ,p_value_date_o
251: => pqh_rha_shd.g_old_rec.value_date

Line 249: => pqh_rha_shd.g_old_rec.range_type_cd

245: => pqh_rha_shd.g_old_rec.to_number
246: ,p_object_version_number_o
247: => pqh_rha_shd.g_old_rec.object_version_number
248: ,p_range_type_cd_o
249: => pqh_rha_shd.g_old_rec.range_type_cd
250: ,p_value_date_o
251: => pqh_rha_shd.g_old_rec.value_date
252: ,p_value_number_o
253: => pqh_rha_shd.g_old_rec.value_number

Line 251: => pqh_rha_shd.g_old_rec.value_date

247: => pqh_rha_shd.g_old_rec.object_version_number
248: ,p_range_type_cd_o
249: => pqh_rha_shd.g_old_rec.range_type_cd
250: ,p_value_date_o
251: => pqh_rha_shd.g_old_rec.value_date
252: ,p_value_number_o
253: => pqh_rha_shd.g_old_rec.value_number
254: ,p_value_char_o
255: => pqh_rha_shd.g_old_rec.value_char

Line 253: => pqh_rha_shd.g_old_rec.value_number

249: => pqh_rha_shd.g_old_rec.range_type_cd
250: ,p_value_date_o
251: => pqh_rha_shd.g_old_rec.value_date
252: ,p_value_number_o
253: => pqh_rha_shd.g_old_rec.value_number
254: ,p_value_char_o
255: => pqh_rha_shd.g_old_rec.value_char
256: );
257: --

Line 255: => pqh_rha_shd.g_old_rec.value_char

251: => pqh_rha_shd.g_old_rec.value_date
252: ,p_value_number_o
253: => pqh_rha_shd.g_old_rec.value_number
254: ,p_value_char_o
255: => pqh_rha_shd.g_old_rec.value_char
256: );
257: --
258: exception
259: --

Line 315: (p_rec in out nocopy pqh_rha_shd.g_rec_type

311: --
312: -- {End Of Comments}
313: -- ----------------------------------------------------------------------------
314: Procedure convert_defs
315: (p_rec in out nocopy pqh_rha_shd.g_rec_type
316: ) is
317: --
318: Begin
319: --

Line 327: pqh_rha_shd.g_old_rec.routing_history_id;

323: -- is being used then we must set to the 'current' argument value.
324: --
325: If (p_rec.routing_history_id = hr_api.g_number) then
326: p_rec.routing_history_id :=
327: pqh_rha_shd.g_old_rec.routing_history_id;
328: End If;
329: If (p_rec.attribute_id = hr_api.g_number) then
330: p_rec.attribute_id :=
331: pqh_rha_shd.g_old_rec.attribute_id;

Line 331: pqh_rha_shd.g_old_rec.attribute_id;

327: pqh_rha_shd.g_old_rec.routing_history_id;
328: End If;
329: If (p_rec.attribute_id = hr_api.g_number) then
330: p_rec.attribute_id :=
331: pqh_rha_shd.g_old_rec.attribute_id;
332: End If;
333: If (p_rec.from_char = hr_api.g_varchar2) then
334: p_rec.from_char :=
335: pqh_rha_shd.g_old_rec.from_char;

Line 335: pqh_rha_shd.g_old_rec.from_char;

331: pqh_rha_shd.g_old_rec.attribute_id;
332: End If;
333: If (p_rec.from_char = hr_api.g_varchar2) then
334: p_rec.from_char :=
335: pqh_rha_shd.g_old_rec.from_char;
336: End If;
337: If (p_rec.from_date = hr_api.g_date) then
338: p_rec.from_date :=
339: pqh_rha_shd.g_old_rec.from_date;

Line 339: pqh_rha_shd.g_old_rec.from_date;

335: pqh_rha_shd.g_old_rec.from_char;
336: End If;
337: If (p_rec.from_date = hr_api.g_date) then
338: p_rec.from_date :=
339: pqh_rha_shd.g_old_rec.from_date;
340: End If;
341: If (p_rec.from_number = hr_api.g_number) then
342: p_rec.from_number :=
343: pqh_rha_shd.g_old_rec.from_number;

Line 343: pqh_rha_shd.g_old_rec.from_number;

339: pqh_rha_shd.g_old_rec.from_date;
340: End If;
341: If (p_rec.from_number = hr_api.g_number) then
342: p_rec.from_number :=
343: pqh_rha_shd.g_old_rec.from_number;
344: End If;
345: If (p_rec.to_char = hr_api.g_varchar2) then
346: p_rec.to_char :=
347: pqh_rha_shd.g_old_rec.to_char;

Line 347: pqh_rha_shd.g_old_rec.to_char;

343: pqh_rha_shd.g_old_rec.from_number;
344: End If;
345: If (p_rec.to_char = hr_api.g_varchar2) then
346: p_rec.to_char :=
347: pqh_rha_shd.g_old_rec.to_char;
348: End If;
349: If (p_rec.to_date = hr_api.g_date) then
350: p_rec.to_date :=
351: pqh_rha_shd.g_old_rec.to_date;

Line 351: pqh_rha_shd.g_old_rec.to_date;

347: pqh_rha_shd.g_old_rec.to_char;
348: End If;
349: If (p_rec.to_date = hr_api.g_date) then
350: p_rec.to_date :=
351: pqh_rha_shd.g_old_rec.to_date;
352: End If;
353: If (p_rec.to_number = hr_api.g_number) then
354: p_rec.to_number :=
355: pqh_rha_shd.g_old_rec.to_number;

Line 355: pqh_rha_shd.g_old_rec.to_number;

351: pqh_rha_shd.g_old_rec.to_date;
352: End If;
353: If (p_rec.to_number = hr_api.g_number) then
354: p_rec.to_number :=
355: pqh_rha_shd.g_old_rec.to_number;
356: End If;
357: If (p_rec.range_type_cd = hr_api.g_varchar2) then
358: p_rec.range_type_cd :=
359: pqh_rha_shd.g_old_rec.range_type_cd;

Line 359: pqh_rha_shd.g_old_rec.range_type_cd;

355: pqh_rha_shd.g_old_rec.to_number;
356: End If;
357: If (p_rec.range_type_cd = hr_api.g_varchar2) then
358: p_rec.range_type_cd :=
359: pqh_rha_shd.g_old_rec.range_type_cd;
360: End If;
361: If (p_rec.value_date = hr_api.g_date) then
362: p_rec.value_date :=
363: pqh_rha_shd.g_old_rec.value_date;

Line 363: pqh_rha_shd.g_old_rec.value_date;

359: pqh_rha_shd.g_old_rec.range_type_cd;
360: End If;
361: If (p_rec.value_date = hr_api.g_date) then
362: p_rec.value_date :=
363: pqh_rha_shd.g_old_rec.value_date;
364: End If;
365: If (p_rec.value_number = hr_api.g_number) then
366: p_rec.value_number :=
367: pqh_rha_shd.g_old_rec.value_number;

Line 367: pqh_rha_shd.g_old_rec.value_number;

363: pqh_rha_shd.g_old_rec.value_date;
364: End If;
365: If (p_rec.value_number = hr_api.g_number) then
366: p_rec.value_number :=
367: pqh_rha_shd.g_old_rec.value_number;
368: End If;
369: If (p_rec.value_char = hr_api.g_varchar2) then
370: p_rec.value_char :=
371: pqh_rha_shd.g_old_rec.value_char;

Line 371: pqh_rha_shd.g_old_rec.value_char;

367: pqh_rha_shd.g_old_rec.value_number;
368: End If;
369: If (p_rec.value_char = hr_api.g_varchar2) then
370: p_rec.value_char :=
371: pqh_rha_shd.g_old_rec.value_char;
372: End If;
373: --
374: End convert_defs;
375: --

Line 381: ,p_rec in out nocopy pqh_rha_shd.g_rec_type

377: -- |---------------------------------< upd >----------------------------------|
378: -- ----------------------------------------------------------------------------
379: Procedure upd
380: (p_effective_date in date
381: ,p_rec in out nocopy pqh_rha_shd.g_rec_type
382: ) is
383: --
384: l_proc varchar2(72) := g_package||'upd';
385: --

Line 391: pqh_rha_shd.lck

387: hr_utility.set_location('Entering:'||l_proc, 5);
388: --
389: -- We must lock the row which we need to update.
390: --
391: pqh_rha_shd.lck
392: (p_rec.routing_hist_attrib_id
393: ,p_rec.object_version_number
394: );
395: --

Line 445: l_rec pqh_rha_shd.g_rec_type;

441: ,p_value_number in number default hr_api.g_number
442: ,p_value_char in varchar2 default hr_api.g_varchar2
443: ) is
444: --
445: l_rec pqh_rha_shd.g_rec_type;
446: l_proc varchar2(72) := g_package||'upd';
447: --
448: Begin
449: hr_utility.set_location('Entering:'||l_proc, 5);

Line 455: pqh_rha_shd.convert_args

451: -- Call conversion function to turn arguments into the
452: -- l_rec structure.
453: --
454: l_rec :=
455: pqh_rha_shd.convert_args
456: (p_routing_hist_attrib_id
457: ,p_routing_history_id
458: ,p_attribute_id
459: ,p_from_char