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_EHRI_DYNRPT dependencies on GHR_PA_REQUEST_EXTRA_INFO

Line 218: -- Returns the whole ghr_pa_request_extra_info (rei) record for a given info type

214: raise;
215: END get_sex;
216: --
217: ---------------------------------------------------------------------------------------------
218: -- Returns the whole ghr_pa_request_extra_info (rei) record for a given info type
219: ---------------------------------------------------------------------------------------------
220: PROCEDURE get_PAR_EI (p_pa_request_id IN NUMBER
221: ,p_noa_family_code IN VARCHAR2
222: ,p_information_type IN VARCHAR2

Line 223: ,p_rei_rec OUT NOCOPY ghr_pa_request_extra_info%ROWTYPE) IS

219: ---------------------------------------------------------------------------------------------
220: PROCEDURE get_PAR_EI (p_pa_request_id IN NUMBER
221: ,p_noa_family_code IN VARCHAR2
222: ,p_information_type IN VARCHAR2
223: ,p_rei_rec OUT NOCOPY ghr_pa_request_extra_info%ROWTYPE) IS
224: CURSOR c_par IS
225: SELECT par.pa_request_id
226: FROM ghr_pa_requests par
227: CONNECT BY par.pa_request_id = prior par.altered_pa_request_id

Line 232: FROM ghr_pa_request_extra_info rei

228: START WITH par.pa_request_id = p_pa_request_id;
229: --
230: CURSOR cur_rei (cp_pa_request_id IN NUMBER) IS
231: SELECT *
232: FROM ghr_pa_request_extra_info rei
233: WHERE rei.information_type = p_information_type
234: AND rei.pa_request_id = cp_pa_request_id;
235: --
236: l_rei_rec ghr_pa_request_extra_info%ROWTYPE;

Line 236: l_rei_rec ghr_pa_request_extra_info%ROWTYPE;

232: FROM ghr_pa_request_extra_info rei
233: WHERE rei.information_type = p_information_type
234: AND rei.pa_request_id = cp_pa_request_id;
235: --
236: l_rei_rec ghr_pa_request_extra_info%ROWTYPE;
237: BEGIN
238: -- This extra info is actually on all NOAC's
239: -- For corrections, need a different way to get the data form the original 52 being
240: -- corrected since we do not populate the data for a correction!

Line 503: l_information_type ghr_pa_request_extra_info.information_type%TYPE;

499: AND (nfa.nature_of_action_id = p_first_noa_id
500: OR nfa.nature_of_action_id = p_second_noa_id)
501: AND rit.information_type IN ('GHR_US_PAR_BENEFIT_INFO' ,'GHR_US_PAR_RETIRMENT_SYS_INFO');
502: --
503: l_information_type ghr_pa_request_extra_info.information_type%TYPE;
504: l_rei ghr_pa_request_extra_info%ROWTYPE;
505: l_race_national_origin VARCHAR2(150);
506: l_handicap_code VARCHAR2(150);
507: l_per_ei_grp1_data per_people_extra_info%rowtype;

Line 504: l_rei ghr_pa_request_extra_info%ROWTYPE;

500: OR nfa.nature_of_action_id = p_second_noa_id)
501: AND rit.information_type IN ('GHR_US_PAR_BENEFIT_INFO' ,'GHR_US_PAR_RETIRMENT_SYS_INFO');
502: --
503: l_information_type ghr_pa_request_extra_info.information_type%TYPE;
504: l_rei ghr_pa_request_extra_info%ROWTYPE;
505: l_race_national_origin VARCHAR2(150);
506: l_handicap_code VARCHAR2(150);
507: l_per_ei_grp1_data per_people_extra_info%rowtype;
508:

Line 801: l_information_type ghr_pa_request_extra_info.information_type%TYPE;

797: ,p_effective_date IN DATE
798: ,p_appt_nte_date OUT NOCOPY DATE)
799: IS
800: --
801: l_information_type ghr_pa_request_extra_info.information_type%TYPE;
802: l_rei ghr_pa_request_extra_info%ROWTYPE;
803: l_per_ei_grp1_data per_people_extra_info%rowtype;
804: l_appt_nte_date DATE;
805: --per_assignment_extra_info.aei_information4%TYPE;

Line 802: l_rei ghr_pa_request_extra_info%ROWTYPE;

798: ,p_appt_nte_date OUT NOCOPY DATE)
799: IS
800: --
801: l_information_type ghr_pa_request_extra_info.information_type%TYPE;
802: l_rei ghr_pa_request_extra_info%ROWTYPE;
803: l_per_ei_grp1_data per_people_extra_info%rowtype;
804: l_appt_nte_date DATE;
805: --per_assignment_extra_info.aei_information4%TYPE;
806: --

Line 2582: FROM ghr_pa_request_extra_info parei

2578: --
2579: CURSOR cur_scd_dates(p_pa_request_id ghr_pa_requests.pa_request_id%type)
2580: IS
2581: SELECT REI_INFORMATION3 rif ,REI_INFORMATION2 ret
2582: FROM ghr_pa_request_extra_info parei
2583: WHERE parei.pa_request_id=p_pa_request_id
2584: AND parei.information_type='GHR_US_PAR_SCD_INFO'; --Bug# 12557463 modified GHR_US_PAR_CHG_SCD to GHR_US_PAR_SCD_INFO
2585:
2586: --BUG# 6458070 -- ssn corrected issue

Line 2597: l_scd_rif ghr_pa_request_extra_info.rei_information3%type;

2593: AND employee_national_identifier <> p_to_national_identifier;
2594:
2595: l_records_found BOOLEAN;
2596: l_mesgbuff1 VARCHAR2(4000);
2597: l_scd_rif ghr_pa_request_extra_info.rei_information3%type;
2598: l_scd_retirement ghr_pa_request_extra_info.rei_information8%type;
2599: l_scd_tsp ghr_pa_request_extra_info.rei_information8%type;
2600: l_scd_leave ghr_pa_request_extra_info.rei_information8%type;
2601: l_ehri_id ghr_cpdf_temp.ehri_employee_id%TYPE;

Line 2598: l_scd_retirement ghr_pa_request_extra_info.rei_information8%type;

2594:
2595: l_records_found BOOLEAN;
2596: l_mesgbuff1 VARCHAR2(4000);
2597: l_scd_rif ghr_pa_request_extra_info.rei_information3%type;
2598: l_scd_retirement ghr_pa_request_extra_info.rei_information8%type;
2599: l_scd_tsp ghr_pa_request_extra_info.rei_information8%type;
2600: l_scd_leave ghr_pa_request_extra_info.rei_information8%type;
2601: l_ehri_id ghr_cpdf_temp.ehri_employee_id%TYPE;
2602: ll_per_ei_data per_people_extra_info%rowtype;

Line 2599: l_scd_tsp ghr_pa_request_extra_info.rei_information8%type;

2595: l_records_found BOOLEAN;
2596: l_mesgbuff1 VARCHAR2(4000);
2597: l_scd_rif ghr_pa_request_extra_info.rei_information3%type;
2598: l_scd_retirement ghr_pa_request_extra_info.rei_information8%type;
2599: l_scd_tsp ghr_pa_request_extra_info.rei_information8%type;
2600: l_scd_leave ghr_pa_request_extra_info.rei_information8%type;
2601: l_ehri_id ghr_cpdf_temp.ehri_employee_id%TYPE;
2602: ll_per_ei_data per_people_extra_info%rowtype;
2603: l_last_name per_all_people.last_name%type;

Line 2600: l_scd_leave ghr_pa_request_extra_info.rei_information8%type;

2596: l_mesgbuff1 VARCHAR2(4000);
2597: l_scd_rif ghr_pa_request_extra_info.rei_information3%type;
2598: l_scd_retirement ghr_pa_request_extra_info.rei_information8%type;
2599: l_scd_tsp ghr_pa_request_extra_info.rei_information8%type;
2600: l_scd_leave ghr_pa_request_extra_info.rei_information8%type;
2601: l_ehri_id ghr_cpdf_temp.ehri_employee_id%TYPE;
2602: ll_per_ei_data per_people_extra_info%rowtype;
2603: l_last_name per_all_people.last_name%type;
2604: l_suffix ghr_cpdf_temp.prior_name_suffix%type;