APPS.GHR_MTI_INT_INSERT dependencies on PER_PEOPLE_EXTRA_INFO

Line 376: l_people_ei1_rec per_people_extra_info%ROWTYPE;

372: p_veterans_preference_for_RIF IN varchar2,
373: p_veterans_status IN varchar2,
374: p_action IN varchar2 ) is
375:
376: l_people_ei1_rec per_people_extra_info%ROWTYPE;
377:
378: begin
379: l_people_ei1_rec.person_id := p_person_id;
380: l_people_ei1_rec.INFORMATION_TYPE := 'GHR_US_PER_SF52';

Line 413: l_people_ei2_rec per_people_extra_info%ROWTYPE;

409: p_orig_appointment_auth_code_2 IN varchar2,
410: p_handicap_code IN varchar2,
411: p_action IN varchar2 ) is
412:
413: l_people_ei2_rec per_people_extra_info%ROWTYPE;
414:
415: begin
416: l_people_ei2_rec.person_id := p_person_id;
417: l_people_ei2_rec.INFORMATION_TYPE := 'GHR_US_PER_GROUP1';

Line 447: l_people_ei3_rec per_people_extra_info%ROWTYPE;

443: p_person_id IN number,
444: p_service_comp_date IN date,
445: p_action IN varchar2 ) is
446:
447: l_people_ei3_rec per_people_extra_info%ROWTYPE;
448:
449: begin
450: l_people_ei3_rec.person_id := p_person_id;
451: l_people_ei3_rec.INFORMATION_TYPE := 'GHR_US_PER_SCD_INFORMATION';

Line 478: l_people_ei4_rec per_people_extra_info%ROWTYPE;

474: p_Previous_Retirement_Coverage IN varchar2,
475: p_Frozen_Service IN varchar2,
476: p_action IN varchar2 ) is
477:
478: l_people_ei4_rec per_people_extra_info%ROWTYPE;
479:
480: begin
481: l_people_ei4_rec.person_id := p_person_id;
482: l_people_ei4_rec.INFORMATION_TYPE := 'GHR_US_PER_SEPARATE_RETIRE';

Line 509: l_people_ei5_rec per_people_extra_info%ROWTYPE;

505: p_person_id IN number,
506: p_Creditable_Military_Service IN varchar2,
507: p_action IN varchar2 ) is
508:
509: l_people_ei5_rec per_people_extra_info%ROWTYPE;
510:
511: begin
512: l_people_ei5_rec.person_id := p_person_id;
513: l_people_ei5_rec.INFORMATION_TYPE := 'GHR_US_PER_UNIFORMED_SERVICES';