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_PA_REQUEST_EXTRA_INFO

Line 40: p_pa_request_id in ghr_pa_request_extra_info.pa_request_id%type

36: -- {End Of Comments}
37: -- ----------------------------------------------------------------------------
38: Procedure chk_pa_request_id
39: (
40: p_pa_request_id in ghr_pa_request_extra_info.pa_request_id%type
41: ) is
42: --
43: l_proc varchar2(72) := g_package||'chk_pa_request_id';
44: l_dummy varchar2(1);

Line 171: -- FK GHR_PA_REQUEST_EXTRA_INFO_FK1, ensures the existence of row in info type table

167: --
168: -- Description:
169: -- This procedure check number of rows against an info type
170: -- Information_type must exist with active_inactive_flag='Y',
171: -- FK GHR_PA_REQUEST_EXTRA_INFO_FK1, ensures the existence of row in info type table
172: -- but it should exist with active_inactive_flag = 'Y'
173: --
174: --
175: -- Pre Conditions:

Line 301: FROM ghr_pa_request_extra_info rei

297: l_failure exception;
298: --
299: CURSOR c_count_rows IS
300: SELECT 'x'
301: FROM ghr_pa_request_extra_info rei
302: WHERE rei.information_type = p_information_type
303: AND rei.pa_request_id = p_pa_request_id ;
304: --
305: Begin

Line 351: (p_pa_request_extra_info_id in ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE

347: -- |----------------------------- < chk_reason_for_submission > ------------|
348: -- -------------------------------------------------------------------------
349: --
350: procedure chk_reason_for_submission
351: (p_pa_request_extra_info_id in ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE
352: ,p_reason_for_submission in ghr_pa_request_extra_info.rei_information3%TYPE
353: ,p_effective_date in date
354: ,p_object_version_number in number
355: ) is

Line 352: ,p_reason_for_submission in ghr_pa_request_extra_info.rei_information3%TYPE

348: -- -------------------------------------------------------------------------
349: --
350: procedure chk_reason_for_submission
351: (p_pa_request_extra_info_id in ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE
352: ,p_reason_for_submission in ghr_pa_request_extra_info.rei_information3%TYPE
353: ,p_effective_date in date
354: ,p_object_version_number in number
355: ) is
356: --

Line 414: (p_reason_for_submission in ghr_pa_request_extra_info.rei_information3%TYPE

410: -- |------------------------------- < chk_explanation > ----------------------------------------------|
411: -- ----------------------------------------------------------------------------------------------------
412: --
413: procedure chk_explanation
414: (p_reason_for_submission in ghr_pa_request_extra_info.rei_information3%TYPE
415: ,p_pa_request_extra_info_id in ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE
416: ,p_explanation in ghr_pa_request_extra_info.rei_information4%TYPE
417: ,p_object_version_number in number
418: ) is

Line 415: ,p_pa_request_extra_info_id in ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE

411: -- ----------------------------------------------------------------------------------------------------
412: --
413: procedure chk_explanation
414: (p_reason_for_submission in ghr_pa_request_extra_info.rei_information3%TYPE
415: ,p_pa_request_extra_info_id in ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE
416: ,p_explanation in ghr_pa_request_extra_info.rei_information4%TYPE
417: ,p_object_version_number in number
418: ) is
419: --

Line 416: ,p_explanation in ghr_pa_request_extra_info.rei_information4%TYPE

412: --
413: procedure chk_explanation
414: (p_reason_for_submission in ghr_pa_request_extra_info.rei_information3%TYPE
415: ,p_pa_request_extra_info_id in ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE
416: ,p_explanation in ghr_pa_request_extra_info.rei_information4%TYPE
417: ,p_object_version_number in number
418: ) is
419: --
420: l_proc varchar2(72) := 'chk_explanation';

Line 463: (p_pa_request_extra_info_id in ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE

459: -- |-------------------------------- < chk_service > ------------------------------------------------|
460: -- ---------------------------------------------------------------------------------------------------
461: --
462: procedure chk_service
463: (p_pa_request_extra_info_id in ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE
464: ,p_service in ghr_pa_request_extra_info.rei_information5%TYPE
465: ,p_effective_date in date
466: ,p_object_version_number in number
467: ) is

Line 464: ,p_service in ghr_pa_request_extra_info.rei_information5%TYPE

460: -- ---------------------------------------------------------------------------------------------------
461: --
462: procedure chk_service
463: (p_pa_request_extra_info_id in ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE
464: ,p_service in ghr_pa_request_extra_info.rei_information5%TYPE
465: ,p_effective_date in date
466: ,p_object_version_number in number
467: ) is
468: --

Line 759: ,p_descflex_name => 'GHR_PA_REQUEST_EXTRA_INFO'

755: ghr_rei_flex.df(p_rec) ;
756: */
757: hr_dflex_utility.ins_or_upd_descflex_attribs
758: (p_appl_short_name => 'GHR'
759: ,p_descflex_name => 'GHR_PA_REQUEST_EXTRA_INFO'
760: ,p_attribute_category => p_rec.rei_attribute_category
761: ,p_attribute1_name => 'REI_ATTRIBUTE1'
762: ,p_attribute1_value => p_rec.REI_ATTRIBUTE1
763: ,p_attribute2_name => 'REI_ATTRIBUTE2'

Line 988: ,p_descflex_name => 'GHR_PA_REQUEST_EXTRA_INFO'

984: ghr_rei_flex.df(p_rec) ;
985: */
986: hr_dflex_utility.ins_or_upd_descflex_attribs
987: (p_appl_short_name => 'GHR'
988: ,p_descflex_name => 'GHR_PA_REQUEST_EXTRA_INFO'
989: ,p_attribute_category => p_rec.rei_attribute_category
990: ,p_attribute1_name => 'REI_ATTRIBUTE1'
991: ,p_attribute1_value => p_rec.REI_ATTRIBUTE1
992: ,p_attribute2_name => 'REI_ATTRIBUTE2'