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

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

182: raise;
183: END get_sex;
184: --
185: ---------------------------------------------------------------------------------------------
186: -- Returns the whole ghr_pa_request_extra_info (rei) record for a given info type
187: ---------------------------------------------------------------------------------------------
188: PROCEDURE get_PAR_EI (p_pa_request_id IN NUMBER
189: ,p_noa_family_code IN VARCHAR2
190: ,p_information_type IN VARCHAR2

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

187: ---------------------------------------------------------------------------------------------
188: PROCEDURE get_PAR_EI (p_pa_request_id IN NUMBER
189: ,p_noa_family_code IN VARCHAR2
190: ,p_information_type IN VARCHAR2
191: ,p_rei_rec OUT NOCOPY ghr_pa_request_extra_info%ROWTYPE) IS
192: CURSOR c_par IS
193: SELECT par.pa_request_id
194: FROM ghr_pa_requests par
195: CONNECT BY par.pa_request_id = prior par.altered_pa_request_id

Line 200: FROM ghr_pa_request_extra_info rei

196: START WITH par.pa_request_id = p_pa_request_id;
197: --
198: CURSOR cur_rei (cp_pa_request_id IN NUMBER) IS
199: SELECT *
200: FROM ghr_pa_request_extra_info rei
201: WHERE rei.information_type = p_information_type
202: AND rei.pa_request_id = cp_pa_request_id;
203: --
204: l_rei_rec ghr_pa_request_extra_info%ROWTYPE;

Line 204: l_rei_rec ghr_pa_request_extra_info%ROWTYPE;

200: FROM ghr_pa_request_extra_info rei
201: WHERE rei.information_type = p_information_type
202: AND rei.pa_request_id = cp_pa_request_id;
203: --
204: l_rei_rec ghr_pa_request_extra_info%ROWTYPE;
205: BEGIN
206: -- This extra info is actually on all NOAC's
207: -- For corrections, need a different way to get the data form the original 52 being
208: -- corrected since we do not populate the data for a correction!

Line 418: l_information_type ghr_pa_request_extra_info.information_type%TYPE;

414: ,'GHR_US_PAR_APPT_TRANSFER' ,'GHR_US_PAR_CONV_APP'
415: ,'GHR_US_PAR_RETURN_TO_DUTY','GHR_US_PAR_CHG_RETIRE_PLAN'
416: ,'GHR_US_PAR_CHG_SCD');
417: --
418: l_information_type ghr_pa_request_extra_info.information_type%TYPE;
419: l_rei ghr_pa_request_extra_info%ROWTYPE;
420: l_race_national_origin VARCHAR2(150);
421: l_handicap_code VARCHAR2(150);
422: l_per_ei_grp1_data per_people_extra_info%rowtype;

Line 419: l_rei ghr_pa_request_extra_info%ROWTYPE;

415: ,'GHR_US_PAR_RETURN_TO_DUTY','GHR_US_PAR_CHG_RETIRE_PLAN'
416: ,'GHR_US_PAR_CHG_SCD');
417: --
418: l_information_type ghr_pa_request_extra_info.information_type%TYPE;
419: l_rei ghr_pa_request_extra_info%ROWTYPE;
420: l_race_national_origin VARCHAR2(150);
421: l_handicap_code VARCHAR2(150);
422: l_per_ei_grp1_data per_people_extra_info%rowtype;
423:

Line 1209: FROM ghr_pa_request_extra_info parei

1205:
1206: CURSOR cur_scd_dates(p_pa_request_id ghr_pa_requests.pa_request_id%type)
1207: IS
1208: SELECT REI_INFORMATION3 rif ,REI_INFORMATION8 ret
1209: FROM ghr_pa_request_extra_info parei
1210: WHERE parei.pa_request_id=p_pa_request_id
1211: AND parei.information_type='GHR_US_PAR_CHG_SCD';
1212:
1213: l_records_found BOOLEAN;

Line 1215: l_scd_rif ghr_pa_request_extra_info.rei_information3%type;

1211: AND parei.information_type='GHR_US_PAR_CHG_SCD';
1212:
1213: l_records_found BOOLEAN;
1214: l_mesgbuff1 VARCHAR2(4000);
1215: l_scd_rif ghr_pa_request_extra_info.rei_information3%type;
1216: l_scd_ret ghr_pa_request_extra_info.rei_information8%type;
1217: ll_per_ei_data per_people_extra_info%rowtype;
1218: l_last_name per_all_people_f.last_name%type;
1219: l_suffix per_all_people_f.title%type;

Line 1216: l_scd_ret ghr_pa_request_extra_info.rei_information8%type;

1212:
1213: l_records_found BOOLEAN;
1214: l_mesgbuff1 VARCHAR2(4000);
1215: l_scd_rif ghr_pa_request_extra_info.rei_information3%type;
1216: l_scd_ret ghr_pa_request_extra_info.rei_information8%type;
1217: ll_per_ei_data per_people_extra_info%rowtype;
1218: l_last_name per_all_people_f.last_name%type;
1219: l_suffix per_all_people_f.title%type;
1220: