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.GHR_REI_BUS dependencies on GHR_REI_SHD

Line 111: Procedure chk_non_updateable_args(p_rec in ghr_rei_shd.g_rec_type) is

107: --
108: -- {End Of Comments}
109: -- ----------------------------------------------------------------------------
110: --
111: Procedure chk_non_updateable_args(p_rec in ghr_rei_shd.g_rec_type) is
112: --
113: l_proc varchar2(72) := g_package||'chk_non_updateable_args';
114: l_error exception;
115: l_argument varchar2(30);

Line 123: if not ghr_rei_shd.api_updating

119: hr_utility.set_location('Entering:'|| l_proc,10);
120: --
121: -- Only proceed with validation if a row exists for
122: -- the current record in the HR Schema.
123: if not ghr_rei_shd.api_updating
124: (p_pa_request_extra_info_id => p_rec.pa_request_extra_info_id
125: ,p_object_version_number => p_rec.object_version_number
126: ) then
127: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 135: <> nvl(ghr_rei_shd.g_old_rec.pa_request_id,hr_api.g_number) then

131: --
132: hr_utility.set_location (l_proc, 30);
133: --
134: if nvl(p_rec.pa_request_id,hr_api.g_number)
135: <> nvl(ghr_rei_shd.g_old_rec.pa_request_id,hr_api.g_number) then
136: l_argument := 'pa_request_id';
137: raise l_error;
138: end if;
139: --

Line 141: <> nvl(ghr_rei_shd.g_old_rec.information_type,hr_api.g_varchar2) then

137: raise l_error;
138: end if;
139: --
140: if nvl(p_rec.information_type,hr_api.g_varchar2)
141: <> nvl(ghr_rei_shd.g_old_rec.information_type,hr_api.g_varchar2) then
142: l_argument := 'information_type';
143: raise l_error;
144: end if;
145: --

Line 376: l_api_updating := ghr_rei_shd.api_updating

372: -- a) The current g_old_rec is current and
373: -- b) The reason_for_submission value has changed
374: -- c) A record is being inserted
375: --
376: l_api_updating := ghr_rei_shd.api_updating
377: (p_pa_request_extra_info_id => p_pa_request_extra_info_id
378: ,p_object_version_number => p_object_version_number
379: );
380: if ((l_api_updating and

Line 381: nvl(ghr_rei_shd.g_old_rec.rei_information3,hr_api.g_varchar2)

377: (p_pa_request_extra_info_id => p_pa_request_extra_info_id
378: ,p_object_version_number => p_object_version_number
379: );
380: if ((l_api_updating and
381: nvl(ghr_rei_shd.g_old_rec.rei_information3,hr_api.g_varchar2)
382: <> nvl(p_reason_for_submission, hr_api.g_varchar2)) or
383: (not l_api_updating))
384: then
385: hr_utility.set_location(l_proc, 20);

Line 428: l_api_updating := ghr_rei_shd.api_updating

424: hr_utility.set_location('Entering: '|| l_proc, 10);
425: --
426: -- Only proceed with validation if a record is being inserted
427: --
428: l_api_updating := ghr_rei_shd.api_updating
429: (p_pa_request_extra_info_id => p_pa_request_extra_info_id
430: ,p_object_version_number => p_object_version_number
431: );
432: IF (l_api_updating

Line 434: ((nvl(ghr_rei_shd.g_old_rec.rei_information3,hr_api.g_varchar2)

430: ,p_object_version_number => p_object_version_number
431: );
432: IF (l_api_updating
433: AND
434: ((nvl(ghr_rei_shd.g_old_rec.rei_information3,hr_api.g_varchar2)
435: <> nvl(p_reason_for_submission,hr_api.g_varchar2)))
436: OR
437: ((nvl(ghr_rei_shd.g_old_rec.rei_information4,hr_api.g_varchar2)
438: <> nvl(p_explanation,hr_api.g_varchar2)))

Line 437: ((nvl(ghr_rei_shd.g_old_rec.rei_information4,hr_api.g_varchar2)

433: AND
434: ((nvl(ghr_rei_shd.g_old_rec.rei_information3,hr_api.g_varchar2)
435: <> nvl(p_reason_for_submission,hr_api.g_varchar2)))
436: OR
437: ((nvl(ghr_rei_shd.g_old_rec.rei_information4,hr_api.g_varchar2)
438: <> nvl(p_explanation,hr_api.g_varchar2)))
439: )
440: OR
441: NOT l_api_updating THEN

Line 444: nvl(ghr_rei_shd.g_old_rec.rei_information4,hr_api.g_varchar2)

440: OR
441: NOT l_api_updating THEN
442: /*
443: if ((l_api_updating and
444: nvl(ghr_rei_shd.g_old_rec.rei_information4,hr_api.g_varchar2)
445: <> nvl(p_explanation, hr_api.g_varchar2)) or
446: (not l_api_updating))
447: then
448: */

Line 488: l_api_updating := ghr_rei_shd.api_updating

484: -- a) The current g_old_rec is current and
485: -- b) The service value has changed
486: -- c) A record is being inserted
487: --
488: l_api_updating := ghr_rei_shd.api_updating
489: (p_pa_request_extra_info_id => p_pa_request_extra_info_id
490: ,p_object_version_number => p_object_version_number
491: );
492: --

Line 494: nvl(ghr_rei_shd.g_old_rec.rei_information5,hr_api.g_varchar2)

490: ,p_object_version_number => p_object_version_number
491: );
492: --
493: if ((l_api_updating and
494: nvl(ghr_rei_shd.g_old_rec.rei_information5,hr_api.g_varchar2)
495: <> nvl(p_service, hr_api.g_varchar2)) or
496: (not l_api_updating))
497: then
498: hr_utility.set_location(l_proc, 20);

Line 553: (p_rec in ghr_rei_shd.g_rec_type

549: --
550: -- {End Of Comments}
551: -- ----------------------------------------------------------------------------
552: Procedure chk_ddf_for_866
553: (p_rec in ghr_rei_shd.g_rec_type
554: ) is
555:
556: l_proc varchar2(72) := g_package||'chk_ddf_for_866';
557: l_first_noa_code ghr_pa_requests.first_noa_code%type;

Line 625: (p_rec in ghr_rei_shd.g_rec_type

621: --
622: -- {End Of Comments}
623: -- ----------------------------------------------------------------------------
624: Procedure chk_ddf_for_temp_promo
625: (p_rec in ghr_rei_shd.g_rec_type
626: ) is
627:
628: l_proc varchar2(72) := g_package||'chk_ddf_for_temp_promo';
629: l_first_noa_code ghr_pa_requests.first_noa_code%type;

Line 673: Procedure insert_validate(p_rec in ghr_rei_shd.g_rec_type) is

669: --
670: -- ----------------------------------------------------------------------------
671: -- |---------------------------< insert_validate >----------------------------|
672: -- ----------------------------------------------------------------------------
673: Procedure insert_validate(p_rec in ghr_rei_shd.g_rec_type) is
674: --
675: l_proc varchar2(72) := g_package||'insert_validate';
676: l_multiple_occurrences_flag ghr_pa_request_info_types.multiple_occurrences_flag%type;
677: --

Line 916: Procedure update_validate(p_rec in ghr_rei_shd.g_rec_type) is

912: --
913: -- ----------------------------------------------------------------------------
914: -- |---------------------------< update_validate >----------------------------|
915: -- ----------------------------------------------------------------------------
916: Procedure update_validate(p_rec in ghr_rei_shd.g_rec_type) is
917: --
918: l_proc varchar2(72) := g_package||'update_validate';
919: --
920: l_person_id per_people_f.person_id%type;

Line 1146: Procedure delete_validate(p_rec in ghr_rei_shd.g_rec_type) is

1142: --
1143: -- ----------------------------------------------------------------------------
1144: -- |---------------------------< delete_validate >----------------------------|
1145: -- ----------------------------------------------------------------------------
1146: Procedure delete_validate(p_rec in ghr_rei_shd.g_rec_type) is
1147: --
1148: l_proc varchar2(72) := g_package||'delete_validate';
1149: --
1150: Begin

Line 1159: (p_rec in ghr_rei_shd.g_rec_type) is

1155: hr_utility.set_location(' Leaving:'||l_proc, 10);
1156: End delete_validate;
1157: --
1158: procedure chk_ddf_extra_val
1159: (p_rec in ghr_rei_shd.g_rec_type) is
1160: --
1161: l_proc varchar2(72) := g_package||'chk_ddf_extra_val';
1162: l_error exception;
1163: --