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.HXC_HPH_UPD dependencies on HXC_HPH_SHD

Line 56: (p_rec in out nocopy hxc_hph_shd.g_rec_type

52: --
53: -- {End Of Comments}
54: -- ----------------------------------------------------------------------------
55: Procedure update_dml
56: (p_rec in out nocopy hxc_hph_shd.g_rec_type
57: ) is
58: --
59: l_proc varchar2(72);
60: --

Line 137: hxc_hph_shd.constraint_error

133: Exception
134: When hr_api.check_integrity_violated Then
135: -- A check constraint has been violated
136: --
137: hxc_hph_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.parent_integrity_violated Then
140: -- Parent integrity has been violated
141: --

Line 142: hxc_hph_shd.constraint_error

138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.parent_integrity_violated Then
140: -- Parent integrity has been violated
141: --
142: hxc_hph_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
146: --

Line 147: hxc_hph_shd.constraint_error

143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
146: --
147: hxc_hph_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When Others Then
150: --
151: Raise;

Line 187: (p_rec in out nocopy hxc_hph_shd.g_rec_type

183: --
184: -- {End Of Comments}
185: -- ----------------------------------------------------------------------------
186: Procedure pre_update
187: (p_rec in out nocopy hxc_hph_shd.g_rec_type
188: ) is
189: --
190: l_proc varchar2(72);
191: --Performance Fix

Line 278: ,p_rec in hxc_hph_shd.g_rec_type

274: -- {End Of Comments}
275: -- ----------------------------------------------------------------------------
276: Procedure post_update
277: (p_effective_date in date
278: ,p_rec in hxc_hph_shd.g_rec_type
279: ) is
280: --
281: l_proc varchar2(72) ;
282:

Line 382: => hxc_hph_shd.g_old_rec.type

378: => p_rec.top_level_parent_id
379: ,p_code
380: => p_rec.code
381: ,p_type_o
382: => hxc_hph_shd.g_old_rec.type
383: ,p_name_o
384: => hxc_hph_shd.g_old_rec.name
385: ,p_business_group_id_o => hxc_ter_shd.g_old_rec.business_group_id
386: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code

Line 384: => hxc_hph_shd.g_old_rec.name

380: => p_rec.code
381: ,p_type_o
382: => hxc_hph_shd.g_old_rec.type
383: ,p_name_o
384: => hxc_hph_shd.g_old_rec.name
385: ,p_business_group_id_o => hxc_ter_shd.g_old_rec.business_group_id
386: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code
387: ,p_parent_pref_hierarchy_id_o
388: => hxc_hph_shd.g_old_rec.parent_pref_hierarchy_id

Line 388: => hxc_hph_shd.g_old_rec.parent_pref_hierarchy_id

384: => hxc_hph_shd.g_old_rec.name
385: ,p_business_group_id_o => hxc_ter_shd.g_old_rec.business_group_id
386: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code
387: ,p_parent_pref_hierarchy_id_o
388: => hxc_hph_shd.g_old_rec.parent_pref_hierarchy_id
389: ,p_edit_allowed_o
390: => hxc_hph_shd.g_old_rec.edit_allowed
391: ,p_displayed_o
392: => hxc_hph_shd.g_old_rec.displayed

Line 390: => hxc_hph_shd.g_old_rec.edit_allowed

386: ,p_legislation_code_o => hxc_ter_shd.g_old_rec.legislation_code
387: ,p_parent_pref_hierarchy_id_o
388: => hxc_hph_shd.g_old_rec.parent_pref_hierarchy_id
389: ,p_edit_allowed_o
390: => hxc_hph_shd.g_old_rec.edit_allowed
391: ,p_displayed_o
392: => hxc_hph_shd.g_old_rec.displayed
393: ,p_pref_definition_id_o
394: => hxc_hph_shd.g_old_rec.pref_definition_id

Line 392: => hxc_hph_shd.g_old_rec.displayed

388: => hxc_hph_shd.g_old_rec.parent_pref_hierarchy_id
389: ,p_edit_allowed_o
390: => hxc_hph_shd.g_old_rec.edit_allowed
391: ,p_displayed_o
392: => hxc_hph_shd.g_old_rec.displayed
393: ,p_pref_definition_id_o
394: => hxc_hph_shd.g_old_rec.pref_definition_id
395: ,p_attribute_category_o
396: => hxc_hph_shd.g_old_rec.attribute_category

Line 394: => hxc_hph_shd.g_old_rec.pref_definition_id

390: => hxc_hph_shd.g_old_rec.edit_allowed
391: ,p_displayed_o
392: => hxc_hph_shd.g_old_rec.displayed
393: ,p_pref_definition_id_o
394: => hxc_hph_shd.g_old_rec.pref_definition_id
395: ,p_attribute_category_o
396: => hxc_hph_shd.g_old_rec.attribute_category
397: ,p_attribute1_o
398: => hxc_hph_shd.g_old_rec.attribute1

Line 396: => hxc_hph_shd.g_old_rec.attribute_category

392: => hxc_hph_shd.g_old_rec.displayed
393: ,p_pref_definition_id_o
394: => hxc_hph_shd.g_old_rec.pref_definition_id
395: ,p_attribute_category_o
396: => hxc_hph_shd.g_old_rec.attribute_category
397: ,p_attribute1_o
398: => hxc_hph_shd.g_old_rec.attribute1
399: ,p_attribute2_o
400: => hxc_hph_shd.g_old_rec.attribute2

Line 398: => hxc_hph_shd.g_old_rec.attribute1

394: => hxc_hph_shd.g_old_rec.pref_definition_id
395: ,p_attribute_category_o
396: => hxc_hph_shd.g_old_rec.attribute_category
397: ,p_attribute1_o
398: => hxc_hph_shd.g_old_rec.attribute1
399: ,p_attribute2_o
400: => hxc_hph_shd.g_old_rec.attribute2
401: ,p_attribute3_o
402: => hxc_hph_shd.g_old_rec.attribute3

Line 400: => hxc_hph_shd.g_old_rec.attribute2

396: => hxc_hph_shd.g_old_rec.attribute_category
397: ,p_attribute1_o
398: => hxc_hph_shd.g_old_rec.attribute1
399: ,p_attribute2_o
400: => hxc_hph_shd.g_old_rec.attribute2
401: ,p_attribute3_o
402: => hxc_hph_shd.g_old_rec.attribute3
403: ,p_attribute4_o
404: => hxc_hph_shd.g_old_rec.attribute4

Line 402: => hxc_hph_shd.g_old_rec.attribute3

398: => hxc_hph_shd.g_old_rec.attribute1
399: ,p_attribute2_o
400: => hxc_hph_shd.g_old_rec.attribute2
401: ,p_attribute3_o
402: => hxc_hph_shd.g_old_rec.attribute3
403: ,p_attribute4_o
404: => hxc_hph_shd.g_old_rec.attribute4
405: ,p_attribute5_o
406: => hxc_hph_shd.g_old_rec.attribute5

Line 404: => hxc_hph_shd.g_old_rec.attribute4

400: => hxc_hph_shd.g_old_rec.attribute2
401: ,p_attribute3_o
402: => hxc_hph_shd.g_old_rec.attribute3
403: ,p_attribute4_o
404: => hxc_hph_shd.g_old_rec.attribute4
405: ,p_attribute5_o
406: => hxc_hph_shd.g_old_rec.attribute5
407: ,p_attribute6_o
408: => hxc_hph_shd.g_old_rec.attribute6

Line 406: => hxc_hph_shd.g_old_rec.attribute5

402: => hxc_hph_shd.g_old_rec.attribute3
403: ,p_attribute4_o
404: => hxc_hph_shd.g_old_rec.attribute4
405: ,p_attribute5_o
406: => hxc_hph_shd.g_old_rec.attribute5
407: ,p_attribute6_o
408: => hxc_hph_shd.g_old_rec.attribute6
409: ,p_attribute7_o
410: => hxc_hph_shd.g_old_rec.attribute7

Line 408: => hxc_hph_shd.g_old_rec.attribute6

404: => hxc_hph_shd.g_old_rec.attribute4
405: ,p_attribute5_o
406: => hxc_hph_shd.g_old_rec.attribute5
407: ,p_attribute6_o
408: => hxc_hph_shd.g_old_rec.attribute6
409: ,p_attribute7_o
410: => hxc_hph_shd.g_old_rec.attribute7
411: ,p_attribute8_o
412: => hxc_hph_shd.g_old_rec.attribute8

Line 410: => hxc_hph_shd.g_old_rec.attribute7

406: => hxc_hph_shd.g_old_rec.attribute5
407: ,p_attribute6_o
408: => hxc_hph_shd.g_old_rec.attribute6
409: ,p_attribute7_o
410: => hxc_hph_shd.g_old_rec.attribute7
411: ,p_attribute8_o
412: => hxc_hph_shd.g_old_rec.attribute8
413: ,p_attribute9_o
414: => hxc_hph_shd.g_old_rec.attribute9

Line 412: => hxc_hph_shd.g_old_rec.attribute8

408: => hxc_hph_shd.g_old_rec.attribute6
409: ,p_attribute7_o
410: => hxc_hph_shd.g_old_rec.attribute7
411: ,p_attribute8_o
412: => hxc_hph_shd.g_old_rec.attribute8
413: ,p_attribute9_o
414: => hxc_hph_shd.g_old_rec.attribute9
415: ,p_attribute10_o
416: => hxc_hph_shd.g_old_rec.attribute10

Line 414: => hxc_hph_shd.g_old_rec.attribute9

410: => hxc_hph_shd.g_old_rec.attribute7
411: ,p_attribute8_o
412: => hxc_hph_shd.g_old_rec.attribute8
413: ,p_attribute9_o
414: => hxc_hph_shd.g_old_rec.attribute9
415: ,p_attribute10_o
416: => hxc_hph_shd.g_old_rec.attribute10
417: ,p_attribute11_o
418: => hxc_hph_shd.g_old_rec.attribute11

Line 416: => hxc_hph_shd.g_old_rec.attribute10

412: => hxc_hph_shd.g_old_rec.attribute8
413: ,p_attribute9_o
414: => hxc_hph_shd.g_old_rec.attribute9
415: ,p_attribute10_o
416: => hxc_hph_shd.g_old_rec.attribute10
417: ,p_attribute11_o
418: => hxc_hph_shd.g_old_rec.attribute11
419: ,p_attribute12_o
420: => hxc_hph_shd.g_old_rec.attribute12

Line 418: => hxc_hph_shd.g_old_rec.attribute11

414: => hxc_hph_shd.g_old_rec.attribute9
415: ,p_attribute10_o
416: => hxc_hph_shd.g_old_rec.attribute10
417: ,p_attribute11_o
418: => hxc_hph_shd.g_old_rec.attribute11
419: ,p_attribute12_o
420: => hxc_hph_shd.g_old_rec.attribute12
421: ,p_attribute13_o
422: => hxc_hph_shd.g_old_rec.attribute13

Line 420: => hxc_hph_shd.g_old_rec.attribute12

416: => hxc_hph_shd.g_old_rec.attribute10
417: ,p_attribute11_o
418: => hxc_hph_shd.g_old_rec.attribute11
419: ,p_attribute12_o
420: => hxc_hph_shd.g_old_rec.attribute12
421: ,p_attribute13_o
422: => hxc_hph_shd.g_old_rec.attribute13
423: ,p_attribute14_o
424: => hxc_hph_shd.g_old_rec.attribute14

Line 422: => hxc_hph_shd.g_old_rec.attribute13

418: => hxc_hph_shd.g_old_rec.attribute11
419: ,p_attribute12_o
420: => hxc_hph_shd.g_old_rec.attribute12
421: ,p_attribute13_o
422: => hxc_hph_shd.g_old_rec.attribute13
423: ,p_attribute14_o
424: => hxc_hph_shd.g_old_rec.attribute14
425: ,p_attribute15_o
426: => hxc_hph_shd.g_old_rec.attribute15

Line 424: => hxc_hph_shd.g_old_rec.attribute14

420: => hxc_hph_shd.g_old_rec.attribute12
421: ,p_attribute13_o
422: => hxc_hph_shd.g_old_rec.attribute13
423: ,p_attribute14_o
424: => hxc_hph_shd.g_old_rec.attribute14
425: ,p_attribute15_o
426: => hxc_hph_shd.g_old_rec.attribute15
427: ,p_attribute16_o
428: => hxc_hph_shd.g_old_rec.attribute16

Line 426: => hxc_hph_shd.g_old_rec.attribute15

422: => hxc_hph_shd.g_old_rec.attribute13
423: ,p_attribute14_o
424: => hxc_hph_shd.g_old_rec.attribute14
425: ,p_attribute15_o
426: => hxc_hph_shd.g_old_rec.attribute15
427: ,p_attribute16_o
428: => hxc_hph_shd.g_old_rec.attribute16
429: ,p_attribute17_o
430: => hxc_hph_shd.g_old_rec.attribute17

Line 428: => hxc_hph_shd.g_old_rec.attribute16

424: => hxc_hph_shd.g_old_rec.attribute14
425: ,p_attribute15_o
426: => hxc_hph_shd.g_old_rec.attribute15
427: ,p_attribute16_o
428: => hxc_hph_shd.g_old_rec.attribute16
429: ,p_attribute17_o
430: => hxc_hph_shd.g_old_rec.attribute17
431: ,p_attribute18_o
432: => hxc_hph_shd.g_old_rec.attribute18

Line 430: => hxc_hph_shd.g_old_rec.attribute17

426: => hxc_hph_shd.g_old_rec.attribute15
427: ,p_attribute16_o
428: => hxc_hph_shd.g_old_rec.attribute16
429: ,p_attribute17_o
430: => hxc_hph_shd.g_old_rec.attribute17
431: ,p_attribute18_o
432: => hxc_hph_shd.g_old_rec.attribute18
433: ,p_attribute19_o
434: => hxc_hph_shd.g_old_rec.attribute19

Line 432: => hxc_hph_shd.g_old_rec.attribute18

428: => hxc_hph_shd.g_old_rec.attribute16
429: ,p_attribute17_o
430: => hxc_hph_shd.g_old_rec.attribute17
431: ,p_attribute18_o
432: => hxc_hph_shd.g_old_rec.attribute18
433: ,p_attribute19_o
434: => hxc_hph_shd.g_old_rec.attribute19
435: ,p_attribute20_o
436: => hxc_hph_shd.g_old_rec.attribute20

Line 434: => hxc_hph_shd.g_old_rec.attribute19

430: => hxc_hph_shd.g_old_rec.attribute17
431: ,p_attribute18_o
432: => hxc_hph_shd.g_old_rec.attribute18
433: ,p_attribute19_o
434: => hxc_hph_shd.g_old_rec.attribute19
435: ,p_attribute20_o
436: => hxc_hph_shd.g_old_rec.attribute20
437: ,p_attribute21_o
438: => hxc_hph_shd.g_old_rec.attribute21

Line 436: => hxc_hph_shd.g_old_rec.attribute20

432: => hxc_hph_shd.g_old_rec.attribute18
433: ,p_attribute19_o
434: => hxc_hph_shd.g_old_rec.attribute19
435: ,p_attribute20_o
436: => hxc_hph_shd.g_old_rec.attribute20
437: ,p_attribute21_o
438: => hxc_hph_shd.g_old_rec.attribute21
439: ,p_attribute22_o
440: => hxc_hph_shd.g_old_rec.attribute22

Line 438: => hxc_hph_shd.g_old_rec.attribute21

434: => hxc_hph_shd.g_old_rec.attribute19
435: ,p_attribute20_o
436: => hxc_hph_shd.g_old_rec.attribute20
437: ,p_attribute21_o
438: => hxc_hph_shd.g_old_rec.attribute21
439: ,p_attribute22_o
440: => hxc_hph_shd.g_old_rec.attribute22
441: ,p_attribute23_o
442: => hxc_hph_shd.g_old_rec.attribute23

Line 440: => hxc_hph_shd.g_old_rec.attribute22

436: => hxc_hph_shd.g_old_rec.attribute20
437: ,p_attribute21_o
438: => hxc_hph_shd.g_old_rec.attribute21
439: ,p_attribute22_o
440: => hxc_hph_shd.g_old_rec.attribute22
441: ,p_attribute23_o
442: => hxc_hph_shd.g_old_rec.attribute23
443: ,p_attribute24_o
444: => hxc_hph_shd.g_old_rec.attribute24

Line 442: => hxc_hph_shd.g_old_rec.attribute23

438: => hxc_hph_shd.g_old_rec.attribute21
439: ,p_attribute22_o
440: => hxc_hph_shd.g_old_rec.attribute22
441: ,p_attribute23_o
442: => hxc_hph_shd.g_old_rec.attribute23
443: ,p_attribute24_o
444: => hxc_hph_shd.g_old_rec.attribute24
445: ,p_attribute25_o
446: => hxc_hph_shd.g_old_rec.attribute25

Line 444: => hxc_hph_shd.g_old_rec.attribute24

440: => hxc_hph_shd.g_old_rec.attribute22
441: ,p_attribute23_o
442: => hxc_hph_shd.g_old_rec.attribute23
443: ,p_attribute24_o
444: => hxc_hph_shd.g_old_rec.attribute24
445: ,p_attribute25_o
446: => hxc_hph_shd.g_old_rec.attribute25
447: ,p_attribute26_o
448: => hxc_hph_shd.g_old_rec.attribute26

Line 446: => hxc_hph_shd.g_old_rec.attribute25

442: => hxc_hph_shd.g_old_rec.attribute23
443: ,p_attribute24_o
444: => hxc_hph_shd.g_old_rec.attribute24
445: ,p_attribute25_o
446: => hxc_hph_shd.g_old_rec.attribute25
447: ,p_attribute26_o
448: => hxc_hph_shd.g_old_rec.attribute26
449: ,p_attribute27_o
450: => hxc_hph_shd.g_old_rec.attribute27

Line 448: => hxc_hph_shd.g_old_rec.attribute26

444: => hxc_hph_shd.g_old_rec.attribute24
445: ,p_attribute25_o
446: => hxc_hph_shd.g_old_rec.attribute25
447: ,p_attribute26_o
448: => hxc_hph_shd.g_old_rec.attribute26
449: ,p_attribute27_o
450: => hxc_hph_shd.g_old_rec.attribute27
451: ,p_attribute28_o
452: => hxc_hph_shd.g_old_rec.attribute28

Line 450: => hxc_hph_shd.g_old_rec.attribute27

446: => hxc_hph_shd.g_old_rec.attribute25
447: ,p_attribute26_o
448: => hxc_hph_shd.g_old_rec.attribute26
449: ,p_attribute27_o
450: => hxc_hph_shd.g_old_rec.attribute27
451: ,p_attribute28_o
452: => hxc_hph_shd.g_old_rec.attribute28
453: ,p_attribute29_o
454: => hxc_hph_shd.g_old_rec.attribute29

Line 452: => hxc_hph_shd.g_old_rec.attribute28

448: => hxc_hph_shd.g_old_rec.attribute26
449: ,p_attribute27_o
450: => hxc_hph_shd.g_old_rec.attribute27
451: ,p_attribute28_o
452: => hxc_hph_shd.g_old_rec.attribute28
453: ,p_attribute29_o
454: => hxc_hph_shd.g_old_rec.attribute29
455: ,p_attribute30_o
456: => hxc_hph_shd.g_old_rec.attribute30

Line 454: => hxc_hph_shd.g_old_rec.attribute29

450: => hxc_hph_shd.g_old_rec.attribute27
451: ,p_attribute28_o
452: => hxc_hph_shd.g_old_rec.attribute28
453: ,p_attribute29_o
454: => hxc_hph_shd.g_old_rec.attribute29
455: ,p_attribute30_o
456: => hxc_hph_shd.g_old_rec.attribute30
457: ,p_object_version_number_o
458: => hxc_hph_shd.g_old_rec.object_version_number

Line 456: => hxc_hph_shd.g_old_rec.attribute30

452: => hxc_hph_shd.g_old_rec.attribute28
453: ,p_attribute29_o
454: => hxc_hph_shd.g_old_rec.attribute29
455: ,p_attribute30_o
456: => hxc_hph_shd.g_old_rec.attribute30
457: ,p_object_version_number_o
458: => hxc_hph_shd.g_old_rec.object_version_number
459: ,p_orig_pref_hierarchy_id_o
460: => hxc_hph_shd.g_old_rec.orig_pref_hierarchy_id

Line 458: => hxc_hph_shd.g_old_rec.object_version_number

454: => hxc_hph_shd.g_old_rec.attribute29
455: ,p_attribute30_o
456: => hxc_hph_shd.g_old_rec.attribute30
457: ,p_object_version_number_o
458: => hxc_hph_shd.g_old_rec.object_version_number
459: ,p_orig_pref_hierarchy_id_o
460: => hxc_hph_shd.g_old_rec.orig_pref_hierarchy_id
461: ,p_orig_parent_hierarchy_id_o
462: => hxc_hph_shd.g_old_rec.orig_parent_hierarchy_id

Line 460: => hxc_hph_shd.g_old_rec.orig_pref_hierarchy_id

456: => hxc_hph_shd.g_old_rec.attribute30
457: ,p_object_version_number_o
458: => hxc_hph_shd.g_old_rec.object_version_number
459: ,p_orig_pref_hierarchy_id_o
460: => hxc_hph_shd.g_old_rec.orig_pref_hierarchy_id
461: ,p_orig_parent_hierarchy_id_o
462: => hxc_hph_shd.g_old_rec.orig_parent_hierarchy_id
463: ,p_top_level_parent_id_o --Performance Fix
464: => hxc_hph_shd.g_old_rec.top_level_parent_id

Line 462: => hxc_hph_shd.g_old_rec.orig_parent_hierarchy_id

458: => hxc_hph_shd.g_old_rec.object_version_number
459: ,p_orig_pref_hierarchy_id_o
460: => hxc_hph_shd.g_old_rec.orig_pref_hierarchy_id
461: ,p_orig_parent_hierarchy_id_o
462: => hxc_hph_shd.g_old_rec.orig_parent_hierarchy_id
463: ,p_top_level_parent_id_o --Performance Fix
464: => hxc_hph_shd.g_old_rec.top_level_parent_id
465: ,p_code_o
466: => hxc_hph_shd.g_old_rec.code

Line 464: => hxc_hph_shd.g_old_rec.top_level_parent_id

460: => hxc_hph_shd.g_old_rec.orig_pref_hierarchy_id
461: ,p_orig_parent_hierarchy_id_o
462: => hxc_hph_shd.g_old_rec.orig_parent_hierarchy_id
463: ,p_top_level_parent_id_o --Performance Fix
464: => hxc_hph_shd.g_old_rec.top_level_parent_id
465: ,p_code_o
466: => hxc_hph_shd.g_old_rec.code
467: );
468: --

Line 466: => hxc_hph_shd.g_old_rec.code

462: => hxc_hph_shd.g_old_rec.orig_parent_hierarchy_id
463: ,p_top_level_parent_id_o --Performance Fix
464: => hxc_hph_shd.g_old_rec.top_level_parent_id
465: ,p_code_o
466: => hxc_hph_shd.g_old_rec.code
467: );
468: --
469: exception
470: --

Line 528: (p_rec in out nocopy hxc_hph_shd.g_rec_type

524: --
525: -- {End Of Comments}
526: -- ----------------------------------------------------------------------------
527: Procedure convert_defs
528: (p_rec in out nocopy hxc_hph_shd.g_rec_type
529: ) is
530: --
531: Begin
532: --

Line 540: hxc_hph_shd.g_old_rec.type;

536: -- is being used then we must set to the 'current' argument value.
537: --
538: If (p_rec.type = hr_api.g_varchar2) then
539: p_rec.type :=
540: hxc_hph_shd.g_old_rec.type;
541: End If;
542: If (p_rec.name = hr_api.g_varchar2) then
543: p_rec.name :=
544: hxc_hph_shd.g_old_rec.name;

Line 544: hxc_hph_shd.g_old_rec.name;

540: hxc_hph_shd.g_old_rec.type;
541: End If;
542: If (p_rec.name = hr_api.g_varchar2) then
543: p_rec.name :=
544: hxc_hph_shd.g_old_rec.name;
545: End If;
546: If (p_rec.business_group_id = hr_api.g_number) then
547: p_rec.business_group_id :=
548: hxc_ter_shd.g_old_rec.business_group_id;

Line 556: hxc_hph_shd.g_old_rec.parent_pref_hierarchy_id;

552: hxc_ter_shd.g_old_rec.legislation_code;
553: End If;
554: If (p_rec.parent_pref_hierarchy_id = hr_api.g_number) then
555: p_rec.parent_pref_hierarchy_id :=
556: hxc_hph_shd.g_old_rec.parent_pref_hierarchy_id;
557: End If;
558: If (p_rec.edit_allowed = hr_api.g_varchar2) then
559: p_rec.edit_allowed :=
560: hxc_hph_shd.g_old_rec.edit_allowed;

Line 560: hxc_hph_shd.g_old_rec.edit_allowed;

556: hxc_hph_shd.g_old_rec.parent_pref_hierarchy_id;
557: End If;
558: If (p_rec.edit_allowed = hr_api.g_varchar2) then
559: p_rec.edit_allowed :=
560: hxc_hph_shd.g_old_rec.edit_allowed;
561: End If;
562: If (p_rec.displayed = hr_api.g_varchar2) then
563: p_rec.displayed :=
564: hxc_hph_shd.g_old_rec.displayed;

Line 564: hxc_hph_shd.g_old_rec.displayed;

560: hxc_hph_shd.g_old_rec.edit_allowed;
561: End If;
562: If (p_rec.displayed = hr_api.g_varchar2) then
563: p_rec.displayed :=
564: hxc_hph_shd.g_old_rec.displayed;
565: End If;
566: If (p_rec.pref_definition_id = hr_api.g_number) then
567: p_rec.pref_definition_id :=
568: hxc_hph_shd.g_old_rec.pref_definition_id;

Line 568: hxc_hph_shd.g_old_rec.pref_definition_id;

564: hxc_hph_shd.g_old_rec.displayed;
565: End If;
566: If (p_rec.pref_definition_id = hr_api.g_number) then
567: p_rec.pref_definition_id :=
568: hxc_hph_shd.g_old_rec.pref_definition_id;
569: End If;
570: If (p_rec.attribute_category = hr_api.g_varchar2) then
571: p_rec.attribute_category :=
572: hxc_hph_shd.g_old_rec.attribute_category;

Line 572: hxc_hph_shd.g_old_rec.attribute_category;

568: hxc_hph_shd.g_old_rec.pref_definition_id;
569: End If;
570: If (p_rec.attribute_category = hr_api.g_varchar2) then
571: p_rec.attribute_category :=
572: hxc_hph_shd.g_old_rec.attribute_category;
573: End If;
574: If (p_rec.attribute1 = hr_api.g_varchar2) then
575: p_rec.attribute1 :=
576: hxc_hph_shd.g_old_rec.attribute1;

Line 576: hxc_hph_shd.g_old_rec.attribute1;

572: hxc_hph_shd.g_old_rec.attribute_category;
573: End If;
574: If (p_rec.attribute1 = hr_api.g_varchar2) then
575: p_rec.attribute1 :=
576: hxc_hph_shd.g_old_rec.attribute1;
577: End If;
578: If (p_rec.attribute2 = hr_api.g_varchar2) then
579: p_rec.attribute2 :=
580: hxc_hph_shd.g_old_rec.attribute2;

Line 580: hxc_hph_shd.g_old_rec.attribute2;

576: hxc_hph_shd.g_old_rec.attribute1;
577: End If;
578: If (p_rec.attribute2 = hr_api.g_varchar2) then
579: p_rec.attribute2 :=
580: hxc_hph_shd.g_old_rec.attribute2;
581: End If;
582: If (p_rec.attribute3 = hr_api.g_varchar2) then
583: p_rec.attribute3 :=
584: hxc_hph_shd.g_old_rec.attribute3;

Line 584: hxc_hph_shd.g_old_rec.attribute3;

580: hxc_hph_shd.g_old_rec.attribute2;
581: End If;
582: If (p_rec.attribute3 = hr_api.g_varchar2) then
583: p_rec.attribute3 :=
584: hxc_hph_shd.g_old_rec.attribute3;
585: End If;
586: If (p_rec.attribute4 = hr_api.g_varchar2) then
587: p_rec.attribute4 :=
588: hxc_hph_shd.g_old_rec.attribute4;

Line 588: hxc_hph_shd.g_old_rec.attribute4;

584: hxc_hph_shd.g_old_rec.attribute3;
585: End If;
586: If (p_rec.attribute4 = hr_api.g_varchar2) then
587: p_rec.attribute4 :=
588: hxc_hph_shd.g_old_rec.attribute4;
589: End If;
590: If (p_rec.attribute5 = hr_api.g_varchar2) then
591: p_rec.attribute5 :=
592: hxc_hph_shd.g_old_rec.attribute5;

Line 592: hxc_hph_shd.g_old_rec.attribute5;

588: hxc_hph_shd.g_old_rec.attribute4;
589: End If;
590: If (p_rec.attribute5 = hr_api.g_varchar2) then
591: p_rec.attribute5 :=
592: hxc_hph_shd.g_old_rec.attribute5;
593: End If;
594: If (p_rec.attribute6 = hr_api.g_varchar2) then
595: p_rec.attribute6 :=
596: hxc_hph_shd.g_old_rec.attribute6;

Line 596: hxc_hph_shd.g_old_rec.attribute6;

592: hxc_hph_shd.g_old_rec.attribute5;
593: End If;
594: If (p_rec.attribute6 = hr_api.g_varchar2) then
595: p_rec.attribute6 :=
596: hxc_hph_shd.g_old_rec.attribute6;
597: End If;
598: If (p_rec.attribute7 = hr_api.g_varchar2) then
599: p_rec.attribute7 :=
600: hxc_hph_shd.g_old_rec.attribute7;

Line 600: hxc_hph_shd.g_old_rec.attribute7;

596: hxc_hph_shd.g_old_rec.attribute6;
597: End If;
598: If (p_rec.attribute7 = hr_api.g_varchar2) then
599: p_rec.attribute7 :=
600: hxc_hph_shd.g_old_rec.attribute7;
601: End If;
602: If (p_rec.attribute8 = hr_api.g_varchar2) then
603: p_rec.attribute8 :=
604: hxc_hph_shd.g_old_rec.attribute8;

Line 604: hxc_hph_shd.g_old_rec.attribute8;

600: hxc_hph_shd.g_old_rec.attribute7;
601: End If;
602: If (p_rec.attribute8 = hr_api.g_varchar2) then
603: p_rec.attribute8 :=
604: hxc_hph_shd.g_old_rec.attribute8;
605: End If;
606: If (p_rec.attribute9 = hr_api.g_varchar2) then
607: p_rec.attribute9 :=
608: hxc_hph_shd.g_old_rec.attribute9;

Line 608: hxc_hph_shd.g_old_rec.attribute9;

604: hxc_hph_shd.g_old_rec.attribute8;
605: End If;
606: If (p_rec.attribute9 = hr_api.g_varchar2) then
607: p_rec.attribute9 :=
608: hxc_hph_shd.g_old_rec.attribute9;
609: End If;
610: If (p_rec.attribute10 = hr_api.g_varchar2) then
611: p_rec.attribute10 :=
612: hxc_hph_shd.g_old_rec.attribute10;

Line 612: hxc_hph_shd.g_old_rec.attribute10;

608: hxc_hph_shd.g_old_rec.attribute9;
609: End If;
610: If (p_rec.attribute10 = hr_api.g_varchar2) then
611: p_rec.attribute10 :=
612: hxc_hph_shd.g_old_rec.attribute10;
613: End If;
614: If (p_rec.attribute11 = hr_api.g_varchar2) then
615: p_rec.attribute11 :=
616: hxc_hph_shd.g_old_rec.attribute11;

Line 616: hxc_hph_shd.g_old_rec.attribute11;

612: hxc_hph_shd.g_old_rec.attribute10;
613: End If;
614: If (p_rec.attribute11 = hr_api.g_varchar2) then
615: p_rec.attribute11 :=
616: hxc_hph_shd.g_old_rec.attribute11;
617: End If;
618: If (p_rec.attribute12 = hr_api.g_varchar2) then
619: p_rec.attribute12 :=
620: hxc_hph_shd.g_old_rec.attribute12;

Line 620: hxc_hph_shd.g_old_rec.attribute12;

616: hxc_hph_shd.g_old_rec.attribute11;
617: End If;
618: If (p_rec.attribute12 = hr_api.g_varchar2) then
619: p_rec.attribute12 :=
620: hxc_hph_shd.g_old_rec.attribute12;
621: End If;
622: If (p_rec.attribute13 = hr_api.g_varchar2) then
623: p_rec.attribute13 :=
624: hxc_hph_shd.g_old_rec.attribute13;

Line 624: hxc_hph_shd.g_old_rec.attribute13;

620: hxc_hph_shd.g_old_rec.attribute12;
621: End If;
622: If (p_rec.attribute13 = hr_api.g_varchar2) then
623: p_rec.attribute13 :=
624: hxc_hph_shd.g_old_rec.attribute13;
625: End If;
626: If (p_rec.attribute14 = hr_api.g_varchar2) then
627: p_rec.attribute14 :=
628: hxc_hph_shd.g_old_rec.attribute14;

Line 628: hxc_hph_shd.g_old_rec.attribute14;

624: hxc_hph_shd.g_old_rec.attribute13;
625: End If;
626: If (p_rec.attribute14 = hr_api.g_varchar2) then
627: p_rec.attribute14 :=
628: hxc_hph_shd.g_old_rec.attribute14;
629: End If;
630: If (p_rec.attribute15 = hr_api.g_varchar2) then
631: p_rec.attribute15 :=
632: hxc_hph_shd.g_old_rec.attribute15;

Line 632: hxc_hph_shd.g_old_rec.attribute15;

628: hxc_hph_shd.g_old_rec.attribute14;
629: End If;
630: If (p_rec.attribute15 = hr_api.g_varchar2) then
631: p_rec.attribute15 :=
632: hxc_hph_shd.g_old_rec.attribute15;
633: End If;
634: If (p_rec.attribute16 = hr_api.g_varchar2) then
635: p_rec.attribute16 :=
636: hxc_hph_shd.g_old_rec.attribute16;

Line 636: hxc_hph_shd.g_old_rec.attribute16;

632: hxc_hph_shd.g_old_rec.attribute15;
633: End If;
634: If (p_rec.attribute16 = hr_api.g_varchar2) then
635: p_rec.attribute16 :=
636: hxc_hph_shd.g_old_rec.attribute16;
637: End If;
638: If (p_rec.attribute17 = hr_api.g_varchar2) then
639: p_rec.attribute17 :=
640: hxc_hph_shd.g_old_rec.attribute17;

Line 640: hxc_hph_shd.g_old_rec.attribute17;

636: hxc_hph_shd.g_old_rec.attribute16;
637: End If;
638: If (p_rec.attribute17 = hr_api.g_varchar2) then
639: p_rec.attribute17 :=
640: hxc_hph_shd.g_old_rec.attribute17;
641: End If;
642: If (p_rec.attribute18 = hr_api.g_varchar2) then
643: p_rec.attribute18 :=
644: hxc_hph_shd.g_old_rec.attribute18;

Line 644: hxc_hph_shd.g_old_rec.attribute18;

640: hxc_hph_shd.g_old_rec.attribute17;
641: End If;
642: If (p_rec.attribute18 = hr_api.g_varchar2) then
643: p_rec.attribute18 :=
644: hxc_hph_shd.g_old_rec.attribute18;
645: End If;
646: If (p_rec.attribute19 = hr_api.g_varchar2) then
647: p_rec.attribute19 :=
648: hxc_hph_shd.g_old_rec.attribute19;

Line 648: hxc_hph_shd.g_old_rec.attribute19;

644: hxc_hph_shd.g_old_rec.attribute18;
645: End If;
646: If (p_rec.attribute19 = hr_api.g_varchar2) then
647: p_rec.attribute19 :=
648: hxc_hph_shd.g_old_rec.attribute19;
649: End If;
650: If (p_rec.attribute20 = hr_api.g_varchar2) then
651: p_rec.attribute20 :=
652: hxc_hph_shd.g_old_rec.attribute20;

Line 652: hxc_hph_shd.g_old_rec.attribute20;

648: hxc_hph_shd.g_old_rec.attribute19;
649: End If;
650: If (p_rec.attribute20 = hr_api.g_varchar2) then
651: p_rec.attribute20 :=
652: hxc_hph_shd.g_old_rec.attribute20;
653: End If;
654: If (p_rec.attribute21 = hr_api.g_varchar2) then
655: p_rec.attribute21 :=
656: hxc_hph_shd.g_old_rec.attribute21;

Line 656: hxc_hph_shd.g_old_rec.attribute21;

652: hxc_hph_shd.g_old_rec.attribute20;
653: End If;
654: If (p_rec.attribute21 = hr_api.g_varchar2) then
655: p_rec.attribute21 :=
656: hxc_hph_shd.g_old_rec.attribute21;
657: End If;
658: If (p_rec.attribute22 = hr_api.g_varchar2) then
659: p_rec.attribute22 :=
660: hxc_hph_shd.g_old_rec.attribute22;

Line 660: hxc_hph_shd.g_old_rec.attribute22;

656: hxc_hph_shd.g_old_rec.attribute21;
657: End If;
658: If (p_rec.attribute22 = hr_api.g_varchar2) then
659: p_rec.attribute22 :=
660: hxc_hph_shd.g_old_rec.attribute22;
661: End If;
662: If (p_rec.attribute23 = hr_api.g_varchar2) then
663: p_rec.attribute23 :=
664: hxc_hph_shd.g_old_rec.attribute23;

Line 664: hxc_hph_shd.g_old_rec.attribute23;

660: hxc_hph_shd.g_old_rec.attribute22;
661: End If;
662: If (p_rec.attribute23 = hr_api.g_varchar2) then
663: p_rec.attribute23 :=
664: hxc_hph_shd.g_old_rec.attribute23;
665: End If;
666: If (p_rec.attribute24 = hr_api.g_varchar2) then
667: p_rec.attribute24 :=
668: hxc_hph_shd.g_old_rec.attribute24;

Line 668: hxc_hph_shd.g_old_rec.attribute24;

664: hxc_hph_shd.g_old_rec.attribute23;
665: End If;
666: If (p_rec.attribute24 = hr_api.g_varchar2) then
667: p_rec.attribute24 :=
668: hxc_hph_shd.g_old_rec.attribute24;
669: End If;
670: If (p_rec.attribute25 = hr_api.g_varchar2) then
671: p_rec.attribute25 :=
672: hxc_hph_shd.g_old_rec.attribute25;

Line 672: hxc_hph_shd.g_old_rec.attribute25;

668: hxc_hph_shd.g_old_rec.attribute24;
669: End If;
670: If (p_rec.attribute25 = hr_api.g_varchar2) then
671: p_rec.attribute25 :=
672: hxc_hph_shd.g_old_rec.attribute25;
673: End If;
674: If (p_rec.attribute26 = hr_api.g_varchar2) then
675: p_rec.attribute26 :=
676: hxc_hph_shd.g_old_rec.attribute26;

Line 676: hxc_hph_shd.g_old_rec.attribute26;

672: hxc_hph_shd.g_old_rec.attribute25;
673: End If;
674: If (p_rec.attribute26 = hr_api.g_varchar2) then
675: p_rec.attribute26 :=
676: hxc_hph_shd.g_old_rec.attribute26;
677: End If;
678: If (p_rec.attribute27 = hr_api.g_varchar2) then
679: p_rec.attribute27 :=
680: hxc_hph_shd.g_old_rec.attribute27;

Line 680: hxc_hph_shd.g_old_rec.attribute27;

676: hxc_hph_shd.g_old_rec.attribute26;
677: End If;
678: If (p_rec.attribute27 = hr_api.g_varchar2) then
679: p_rec.attribute27 :=
680: hxc_hph_shd.g_old_rec.attribute27;
681: End If;
682: If (p_rec.attribute28 = hr_api.g_varchar2) then
683: p_rec.attribute28 :=
684: hxc_hph_shd.g_old_rec.attribute28;

Line 684: hxc_hph_shd.g_old_rec.attribute28;

680: hxc_hph_shd.g_old_rec.attribute27;
681: End If;
682: If (p_rec.attribute28 = hr_api.g_varchar2) then
683: p_rec.attribute28 :=
684: hxc_hph_shd.g_old_rec.attribute28;
685: End If;
686: If (p_rec.attribute29 = hr_api.g_varchar2) then
687: p_rec.attribute29 :=
688: hxc_hph_shd.g_old_rec.attribute29;

Line 688: hxc_hph_shd.g_old_rec.attribute29;

684: hxc_hph_shd.g_old_rec.attribute28;
685: End If;
686: If (p_rec.attribute29 = hr_api.g_varchar2) then
687: p_rec.attribute29 :=
688: hxc_hph_shd.g_old_rec.attribute29;
689: End If;
690: If (p_rec.attribute30 = hr_api.g_varchar2) then
691: p_rec.attribute30 :=
692: hxc_hph_shd.g_old_rec.attribute30;

Line 692: hxc_hph_shd.g_old_rec.attribute30;

688: hxc_hph_shd.g_old_rec.attribute29;
689: End If;
690: If (p_rec.attribute30 = hr_api.g_varchar2) then
691: p_rec.attribute30 :=
692: hxc_hph_shd.g_old_rec.attribute30;
693: End If;
694: If (p_rec.orig_pref_hierarchy_id = hr_api.g_number) then
695: p_rec.orig_pref_hierarchy_id :=
696: hxc_hph_shd.g_old_rec.orig_pref_hierarchy_id;

Line 696: hxc_hph_shd.g_old_rec.orig_pref_hierarchy_id;

692: hxc_hph_shd.g_old_rec.attribute30;
693: End If;
694: If (p_rec.orig_pref_hierarchy_id = hr_api.g_number) then
695: p_rec.orig_pref_hierarchy_id :=
696: hxc_hph_shd.g_old_rec.orig_pref_hierarchy_id;
697: End If;
698: If (p_rec.orig_parent_hierarchy_id = hr_api.g_number) then
699: p_rec.orig_parent_hierarchy_id :=
700: hxc_hph_shd.g_old_rec.orig_parent_hierarchy_id;

Line 700: hxc_hph_shd.g_old_rec.orig_parent_hierarchy_id;

696: hxc_hph_shd.g_old_rec.orig_pref_hierarchy_id;
697: End If;
698: If (p_rec.orig_parent_hierarchy_id = hr_api.g_number) then
699: p_rec.orig_parent_hierarchy_id :=
700: hxc_hph_shd.g_old_rec.orig_parent_hierarchy_id;
701: End If;
702: If (p_rec.top_level_parent_id = hr_api.g_number) then -- Performance Fix
703: p_rec.top_level_parent_id :=
704: hxc_hph_shd.g_old_rec.top_level_parent_id;

Line 704: hxc_hph_shd.g_old_rec.top_level_parent_id;

700: hxc_hph_shd.g_old_rec.orig_parent_hierarchy_id;
701: End If;
702: If (p_rec.top_level_parent_id = hr_api.g_number) then -- Performance Fix
703: p_rec.top_level_parent_id :=
704: hxc_hph_shd.g_old_rec.top_level_parent_id;
705: End If;
706: If (p_rec.code = hr_api.g_varchar2) then
707: p_rec.code :=
708: hxc_hph_shd.g_old_rec.code;

Line 708: hxc_hph_shd.g_old_rec.code;

704: hxc_hph_shd.g_old_rec.top_level_parent_id;
705: End If;
706: If (p_rec.code = hr_api.g_varchar2) then
707: p_rec.code :=
708: hxc_hph_shd.g_old_rec.code;
709: End If;
710: --
711: End convert_defs;
712: --

Line 718: ,p_rec in out nocopy hxc_hph_shd.g_rec_type

714: -- |---------------------------------< upd >----------------------------------|
715: -- ----------------------------------------------------------------------------
716: Procedure upd
717: (p_effective_date in date
718: ,p_rec in out nocopy hxc_hph_shd.g_rec_type
719: ) is
720: --
721: l_proc varchar2(72);
722: --

Line 732: hxc_hph_shd.lck

728: end if;
729: --
730: -- We must lock the row which we need to update.
731: --
732: hxc_hph_shd.lck
733: (p_rec.pref_hierarchy_id
734: ,p_rec.object_version_number
735: );
736: --

Line 817: l_rec hxc_hph_shd.g_rec_type;

813: ,p_top_level_parent_id in number default hr_api.g_number --Performance Fix
814: ,p_code in varchar2 default hr_api.g_varchar2
815: ) is
816: --
817: l_rec hxc_hph_shd.g_rec_type;
818: l_proc varchar2(72);
819: --
820: Begin
821: g_debug:=hr_utility.debug_enabled;

Line 831: hxc_hph_shd.convert_args

827: -- Call conversion function to turn arguments into the
828: -- l_rec structure.
829: --
830: l_rec :=
831: hxc_hph_shd.convert_args
832: (p_pref_hierarchy_id
833: ,p_type
834: ,p_name
835: ,p_business_group_id