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 216: -- Returns the whole ghr_pa_request_extra_info (rei) record for a given info type

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

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

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

Line 230: FROM ghr_pa_request_extra_info rei

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

Line 234: l_rei_rec ghr_pa_request_extra_info%ROWTYPE;

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

Line 501: l_information_type ghr_pa_request_extra_info.information_type%TYPE;

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

Line 502: l_rei ghr_pa_request_extra_info%ROWTYPE;

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

Line 797: l_information_type ghr_pa_request_extra_info.information_type%TYPE;

793: ,p_effective_date IN DATE
794: ,p_appt_nte_date OUT NOCOPY DATE)
795: IS
796: --
797: l_information_type ghr_pa_request_extra_info.information_type%TYPE;
798: l_rei ghr_pa_request_extra_info%ROWTYPE;
799: l_per_ei_grp1_data per_people_extra_info%rowtype;
800: l_appt_nte_date DATE;
801: --per_assignment_extra_info.aei_information4%TYPE;

Line 798: l_rei ghr_pa_request_extra_info%ROWTYPE;

794: ,p_appt_nte_date OUT NOCOPY DATE)
795: IS
796: --
797: l_information_type ghr_pa_request_extra_info.information_type%TYPE;
798: l_rei ghr_pa_request_extra_info%ROWTYPE;
799: l_per_ei_grp1_data per_people_extra_info%rowtype;
800: l_appt_nte_date DATE;
801: --per_assignment_extra_info.aei_information4%TYPE;
802: --

Line 2428: FROM ghr_pa_request_extra_info parei

2424: --
2425: CURSOR cur_scd_dates(p_pa_request_id ghr_pa_requests.pa_request_id%type)
2426: IS
2427: SELECT REI_INFORMATION3 rif ,REI_INFORMATION8 ret
2428: FROM ghr_pa_request_extra_info parei
2429: WHERE parei.pa_request_id=p_pa_request_id
2430: AND parei.information_type='GHR_US_PAR_CHG_SCD';
2431:
2432: --BUG# 6458070 -- ssn corrected issue

Line 2443: l_scd_rif ghr_pa_request_extra_info.rei_information3%type;

2439: AND employee_national_identifier <> p_to_national_identifier;
2440:
2441: l_records_found BOOLEAN;
2442: l_mesgbuff1 VARCHAR2(4000);
2443: l_scd_rif ghr_pa_request_extra_info.rei_information3%type;
2444: l_scd_retirement ghr_pa_request_extra_info.rei_information8%type;
2445: l_scd_tsp ghr_pa_request_extra_info.rei_information8%type;
2446: l_scd_leave ghr_pa_request_extra_info.rei_information8%type;
2447: l_ehri_id ghr_cpdf_temp.ehri_employee_id%TYPE;

Line 2444: l_scd_retirement ghr_pa_request_extra_info.rei_information8%type;

2440:
2441: l_records_found BOOLEAN;
2442: l_mesgbuff1 VARCHAR2(4000);
2443: l_scd_rif ghr_pa_request_extra_info.rei_information3%type;
2444: l_scd_retirement ghr_pa_request_extra_info.rei_information8%type;
2445: l_scd_tsp ghr_pa_request_extra_info.rei_information8%type;
2446: l_scd_leave ghr_pa_request_extra_info.rei_information8%type;
2447: l_ehri_id ghr_cpdf_temp.ehri_employee_id%TYPE;
2448: ll_per_ei_data per_people_extra_info%rowtype;

Line 2445: l_scd_tsp ghr_pa_request_extra_info.rei_information8%type;

2441: l_records_found BOOLEAN;
2442: l_mesgbuff1 VARCHAR2(4000);
2443: l_scd_rif ghr_pa_request_extra_info.rei_information3%type;
2444: l_scd_retirement ghr_pa_request_extra_info.rei_information8%type;
2445: l_scd_tsp ghr_pa_request_extra_info.rei_information8%type;
2446: l_scd_leave ghr_pa_request_extra_info.rei_information8%type;
2447: l_ehri_id ghr_cpdf_temp.ehri_employee_id%TYPE;
2448: ll_per_ei_data per_people_extra_info%rowtype;
2449: l_last_name per_all_people.last_name%type;

Line 2446: l_scd_leave ghr_pa_request_extra_info.rei_information8%type;

2442: l_mesgbuff1 VARCHAR2(4000);
2443: l_scd_rif ghr_pa_request_extra_info.rei_information3%type;
2444: l_scd_retirement ghr_pa_request_extra_info.rei_information8%type;
2445: l_scd_tsp ghr_pa_request_extra_info.rei_information8%type;
2446: l_scd_leave ghr_pa_request_extra_info.rei_information8%type;
2447: l_ehri_id ghr_cpdf_temp.ehri_employee_id%TYPE;
2448: ll_per_ei_data per_people_extra_info%rowtype;
2449: l_last_name per_all_people.last_name%type;
2450: l_suffix ghr_cpdf_temp.prior_name_suffix%type;