APPS.GHR_CPDF_DYNRPT dependencies on GHR_PA_REQUEST_EXTRA_INFO

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

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

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

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

Line 201: FROM ghr_pa_request_extra_info rei

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

Line 205: l_rei_rec ghr_pa_request_extra_info%ROWTYPE;

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

Line 419: l_information_type ghr_pa_request_extra_info.information_type%TYPE;

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

Line 420: l_rei ghr_pa_request_extra_info%ROWTYPE;

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

Line 1274: FROM ghr_pa_request_extra_info parei

1270:
1271: CURSOR cur_scd_dates(p_pa_request_id ghr_pa_requests.pa_request_id%type)
1272: IS
1273: SELECT REI_INFORMATION3 rif ,REI_INFORMATION8 ret
1274: FROM ghr_pa_request_extra_info parei
1275: WHERE parei.pa_request_id=p_pa_request_id
1276: AND parei.information_type='GHR_US_PAR_CHG_SCD';
1277:
1278: --8275231

Line 1297: l_scd_rif ghr_pa_request_extra_info.rei_information3%type;

1293: --8275231
1294:
1295: l_records_found BOOLEAN;
1296: l_mesgbuff1 VARCHAR2(4000);
1297: l_scd_rif ghr_pa_request_extra_info.rei_information3%type;
1298: l_scd_ret ghr_pa_request_extra_info.rei_information8%type;
1299: ll_per_ei_data per_people_extra_info%rowtype;
1300: l_last_name per_all_people_f.last_name%type;
1301: l_suffix per_all_people_f.title%type;

Line 1298: l_scd_ret ghr_pa_request_extra_info.rei_information8%type;

1294:
1295: l_records_found BOOLEAN;
1296: l_mesgbuff1 VARCHAR2(4000);
1297: l_scd_rif ghr_pa_request_extra_info.rei_information3%type;
1298: l_scd_ret ghr_pa_request_extra_info.rei_information8%type;
1299: ll_per_ei_data per_people_extra_info%rowtype;
1300: l_last_name per_all_people_f.last_name%type;
1301: l_suffix per_all_people_f.title%type;
1302: