APPS.GHR_MTI_INT_INSERT dependencies on PER_PEOPLE_EXTRA_INFO

Line 394: l_people_ei1_rec per_people_extra_info%ROWTYPE;

390: p_veterans_preference_for_RIF IN varchar2,
391: p_veterans_status IN varchar2,
392: p_action IN varchar2 ) is
393:
394: l_people_ei1_rec per_people_extra_info%ROWTYPE;
395:
396: begin
397: l_people_ei1_rec.person_id := p_person_id;
398: l_people_ei1_rec.INFORMATION_TYPE := 'GHR_US_PER_SF52';

Line 433: l_people_ei2_rec per_people_extra_info%ROWTYPE;

429: p_orig_appt_auth_code_2_desc IN varchar2, --Bug# 8724192
430: p_handicap_code IN varchar2,
431: p_action IN varchar2 ) is
432:
433: l_people_ei2_rec per_people_extra_info%ROWTYPE;
434:
435: begin
436: l_people_ei2_rec.person_id := p_person_id;
437: l_people_ei2_rec.INFORMATION_TYPE := 'GHR_US_PER_GROUP1';

Line 469: l_people_ei3_rec per_people_extra_info%ROWTYPE;

465: p_person_id IN number,
466: p_service_comp_date IN date,
467: p_action IN varchar2 ) is
468:
469: l_people_ei3_rec per_people_extra_info%ROWTYPE;
470:
471: begin
472: l_people_ei3_rec.person_id := p_person_id;
473: l_people_ei3_rec.INFORMATION_TYPE := 'GHR_US_PER_SCD_INFORMATION';

Line 500: l_people_ei4_rec per_people_extra_info%ROWTYPE;

496: p_Previous_Retirement_Coverage IN varchar2,
497: p_Frozen_Service IN varchar2,
498: p_action IN varchar2 ) is
499:
500: l_people_ei4_rec per_people_extra_info%ROWTYPE;
501:
502: begin
503: l_people_ei4_rec.person_id := p_person_id;
504: l_people_ei4_rec.INFORMATION_TYPE := 'GHR_US_PER_SEPARATE_RETIRE';

Line 531: l_people_ei5_rec per_people_extra_info%ROWTYPE;

527: p_person_id IN number,
528: p_Creditable_Military_Service IN varchar2,
529: p_action IN varchar2 ) is
530:
531: l_people_ei5_rec per_people_extra_info%ROWTYPE;
532:
533: begin
534: l_people_ei5_rec.person_id := p_person_id;
535: l_people_ei5_rec.INFORMATION_TYPE := 'GHR_US_PER_UNIFORMED_SERVICES';