DBA Data[Home] [Help]

APPS.GHR_MTI_INT_INSERT dependencies on GHR_MTO_INT

Line 352: ghr_mto_int.insert_people_f

348: l_people_f_rec.WORK_TELEPHONE := p_work_telephone;
349: l_people_f_rec.REHIRE_REASON := p_rehire_reason;
350:
351: if p_action = 'INSERT' then
352: ghr_mto_int.insert_people_f
353: ( p_transfer_name => p_transfer_name,
354: p_inter_bg_transfer => p_inter_bg_transfer,
355: p_effective_date => p_effective_date,
356: ppf => l_people_f_rec);

Line 358: ghr_mto_int.update_people_f

354: p_inter_bg_transfer => p_inter_bg_transfer,
355: p_effective_date => p_effective_date,
356: ppf => l_people_f_rec);
357: else
358: ghr_mto_int.update_people_f
359: ( p_transfer_name => p_transfer_name,
360: p_inter_bg_transfer => p_inter_bg_transfer,
361: p_effective_date => p_effective_date,
362: ppf => l_people_f_rec);

Line 388: ghr_mto_int.insert_people_ei

384: l_people_ei1_rec.PEI_INFORMATION5 := p_veterans_preference_for_RIF;
385: l_people_ei1_rec.PEI_INFORMATION6 := p_veterans_status;
386:
387: if p_action = 'INSERT' then
388: ghr_mto_int.insert_people_ei
389: ( p_transfer_name => p_transfer_name,
390: p_effective_date => p_effective_date,
391: pp_ei => l_people_ei1_rec);
392: else

Line 393: ghr_mto_int.update_people_ei

389: ( p_transfer_name => p_transfer_name,
390: p_effective_date => p_effective_date,
391: pp_ei => l_people_ei1_rec);
392: else
393: ghr_mto_int.update_people_ei
394: ( p_transfer_name => p_transfer_name,
395: p_effective_date => p_effective_date,
396: pp_ei => l_people_ei1_rec);
397: end if;

Line 428: ghr_mto_int.insert_people_ei

424: l_people_ei2_rec.PEI_INFORMATION9 := p_orig_appointment_auth_code_2;
425: l_people_ei2_rec.PEI_INFORMATION11 := p_handicap_code;
426:
427: if p_action = 'INSERT' then
428: ghr_mto_int.insert_people_ei
429: ( p_transfer_name => p_transfer_name,
430: p_effective_date => p_effective_date,
431: pp_ei => l_people_ei2_rec);
432: else

Line 433: ghr_mto_int.update_people_ei

429: ( p_transfer_name => p_transfer_name,
430: p_effective_date => p_effective_date,
431: pp_ei => l_people_ei2_rec);
432: else
433: ghr_mto_int.update_people_ei
434: ( p_transfer_name => p_transfer_name,
435: p_effective_date => p_effective_date,
436: pp_ei => l_people_ei2_rec);
437: end if;

Line 457: ghr_mto_int.insert_people_ei

453: ----l_people_ei3_rec.PEI_INFORMATION3 := to_char(p_service_comp_date, 'DD-MON-YYYY');
454: l_people_ei3_rec.PEI_INFORMATION3 := fnd_date.date_to_canonical(p_service_comp_date);
455:
456: if p_action = 'INSERT' then
457: ghr_mto_int.insert_people_ei
458: ( p_transfer_name => p_transfer_name,
459: p_effective_date => p_effective_date,
460: pp_ei => l_people_ei3_rec);
461: else

Line 462: ghr_mto_int.update_people_ei

458: ( p_transfer_name => p_transfer_name,
459: p_effective_date => p_effective_date,
460: pp_ei => l_people_ei3_rec);
461: else
462: ghr_mto_int.update_people_ei
463: ( p_transfer_name => p_transfer_name,
464: p_effective_date => p_effective_date,
465: pp_ei => l_people_ei3_rec);
466: end if;

Line 490: ghr_mto_int.insert_people_ei

486: l_people_ei4_rec.PEI_INFORMATION4 := p_Previous_Retirement_Coverage;
487: l_people_ei4_rec.PEI_INFORMATION5 := p_Frozen_Service;
488:
489: if p_action = 'INSERT' then
490: ghr_mto_int.insert_people_ei
491: ( p_transfer_name => p_transfer_name,
492: p_effective_date => p_effective_date,
493: pp_ei => l_people_ei4_rec);
494: else

Line 495: ghr_mto_int.update_people_ei

491: ( p_transfer_name => p_transfer_name,
492: p_effective_date => p_effective_date,
493: pp_ei => l_people_ei4_rec);
494: else
495: ghr_mto_int.update_people_ei
496: ( p_transfer_name => p_transfer_name,
497: p_effective_date => p_effective_date,
498: pp_ei => l_people_ei4_rec);
499: end if;

Line 518: ghr_mto_int.insert_people_ei

514: l_people_ei5_rec.PEI_INFORMATION_CATEGORY := 'GHR_US_PER_UNIFORMED_SERVICES';
515: l_people_ei5_rec.PEI_INFORMATION5 := p_Creditable_Military_Service;
516:
517: if p_action = 'INSERT' then
518: ghr_mto_int.insert_people_ei
519: ( p_transfer_name => p_transfer_name,
520: p_effective_date => p_effective_date,
521: pp_ei => l_people_ei5_rec);
522: else

Line 523: ghr_mto_int.update_people_ei

519: ( p_transfer_name => p_transfer_name,
520: p_effective_date => p_effective_date,
521: pp_ei => l_people_ei5_rec);
522: else
523: ghr_mto_int.update_people_ei
524: ( p_transfer_name => p_transfer_name,
525: p_effective_date => p_effective_date,
526: pp_ei => l_people_ei5_rec);
527: end if;

Line 554: ghr_mto_int.insert_position_ei

550: l_position_ei1_rec.POEI_INFORMATION16 := p_supervisory_status;
551:
552: if p_action = 'INSERT' then
553: l_position_ei1_rec.POSITION_ID := p_person_id;
554: ghr_mto_int.insert_position_ei
555: ( p_transfer_name => p_transfer_name,
556: p_person_id => p_person_id,
557: p_effective_date => p_effective_date,
558: p_pos_ei => l_position_ei1_rec);

Line 560: ghr_mto_int.update_position_ei

556: p_person_id => p_person_id,
557: p_effective_date => p_effective_date,
558: p_pos_ei => l_position_ei1_rec);
559: else
560: ghr_mto_int.update_position_ei
561: ( p_transfer_name => p_transfer_name,
562: p_person_id => p_person_id,
563: p_effective_date => p_effective_date,
564: p_pos_ei => l_position_ei1_rec);

Line 588: ghr_mto_int.insert_position_ei

584: l_position_ei2_rec.POEI_INFORMATION14 := p_appropriation_code2;
585:
586: if p_action = 'INSERT' then
587: l_position_ei2_rec.POSITION_ID := p_person_id;
588: ghr_mto_int.insert_position_ei
589: ( p_transfer_name => p_transfer_name,
590: p_person_id => p_person_id,
591: p_effective_date => p_effective_date,
592: p_pos_ei => l_position_ei2_rec);

Line 594: ghr_mto_int.update_position_ei

590: p_person_id => p_person_id,
591: p_effective_date => p_effective_date,
592: p_pos_ei => l_position_ei2_rec);
593: else
594: ghr_mto_int.update_position_ei
595: ( p_transfer_name => p_transfer_name,
596: p_person_id => p_person_id,
597: p_effective_date => p_effective_date,
598: p_pos_ei => l_position_ei2_rec);

Line 659: ghr_mto_int.insert_element_entries

655: l_ghr_mt_ele_rec.to_adjusted_basic_pay := p_to_adjusted_basic_pay;
656: -- End changes 4093771
657:
658: if p_action = 'INSERT' then
659: ghr_mto_int.insert_element_entries
660: ( p_transfer_name => p_transfer_name,
661: p_person_id => p_person_id,
662: p_effective_date => p_effective_date,
663: p_element => l_ghr_mt_ele_rec);

Line 665: ghr_mto_int.update_element_entries

661: p_person_id => p_person_id,
662: p_effective_date => p_effective_date,
663: p_element => l_ghr_mt_ele_rec);
664: else
665: ghr_mto_int.update_element_entries
666: ( p_transfer_name => p_transfer_name,
667: p_person_id => p_person_id,
668: p_effective_date => p_effective_date,
669: p_element => l_ghr_mt_ele_rec);

Line 701: ghr_mto_int.insert_misc

697: l_ghr_mt_misc_rec.duty_station_desc := p_duty_station_desc;
698: l_ghr_mt_misc_rec.from_agency_code := p_from_agency_code;
699:
700: if p_action = 'INSERT' then
701: ghr_mto_int.insert_misc
702: ( p_transfer_name => p_transfer_name,
703: p_person_id => p_person_id,
704: p_effective_date => p_effective_date,
705: p_misc => l_ghr_mt_misc_rec);

Line 707: ghr_mto_int.update_misc

703: p_person_id => p_person_id,
704: p_effective_date => p_effective_date,
705: p_misc => l_ghr_mt_misc_rec);
706: else
707: ghr_mto_int.update_misc
708: ( p_transfer_name => p_transfer_name,
709: p_person_id => p_person_id,
710: p_effective_date => p_effective_date,
711: p_misc => l_ghr_mt_misc_rec);

Line 742: ghr_mto_int.insert_assignment_ei

738: l_assign_ei1_rec.AEI_INFORMATION8 := p_part_time_hours;
739:
740: if p_action = 'INSERT' then
741: l_assign_ei1_rec.ASSIGNMENT_ID := p_person_id;
742: ghr_mto_int.insert_assignment_ei
743: ( p_transfer_name => p_transfer_name,
744: p_person_id => p_person_id,
745: p_effective_date => p_effective_date,
746: p_a_ei => l_assign_ei1_rec);

Line 748: ghr_mto_int.update_assignment_ei

744: p_person_id => p_person_id,
745: p_effective_date => p_effective_date,
746: p_a_ei => l_assign_ei1_rec);
747: else
748: ghr_mto_int.update_assignment_ei
749: ( p_transfer_name => p_transfer_name,
750: p_person_id => p_person_id,
751: p_effective_date => p_effective_date,
752: p_a_ei => l_assign_ei1_rec);

Line 779: ghr_mto_int.insert_assignment_ei

775: l_assign_ei2_rec.AEI_INFORMATION9 := p_qualif_standards_waiver;
776:
777: if p_action = 'INSERT' then
778: l_assign_ei2_rec.ASSIGNMENT_ID := p_person_id;
779: ghr_mto_int.insert_assignment_ei
780: ( p_transfer_name => p_transfer_name,
781: p_person_id => p_person_id,
782: p_effective_date => p_effective_date,
783: p_a_ei => l_assign_ei2_rec);

Line 785: ghr_mto_int.update_assignment_ei

781: p_person_id => p_person_id,
782: p_effective_date => p_effective_date,
783: p_a_ei => l_assign_ei2_rec);
784: else
785: ghr_mto_int.update_assignment_ei
786: ( p_transfer_name => p_transfer_name,
787: p_person_id => p_person_id,
788: p_effective_date => p_effective_date,
789: p_a_ei => l_assign_ei2_rec);

Line 812: ghr_mto_int.insert_special_info(

808: l_si.SEGMENT2 := p_academic_discipline;
809: l_si.SEGMENT3 := p_year_degree_attained;
810:
811: if p_action = 'INSERT' then
812: ghr_mto_int.insert_special_info(
813: p_transfer_name => p_transfer_name,
814: p_effective_date => p_effective_date,
815: p_person_id => p_person_id,
816: p_flex_name => l_flex_name,

Line 822: ghr_mto_int.update_special_info(

818: end if;
819: if p_education_level is not null or
820: p_academic_discipline is not null or
821: p_year_degree_attained is not null then
822: ghr_mto_int.update_special_info(
823: p_transfer_name => p_transfer_name,
824: p_effective_date => p_effective_date,
825: p_person_id => p_person_id,
826: p_flex_name => l_flex_name,

Line 844: ghr_mto_int.insert_assignment_f(

840: begin
841: l_assign_f_rec.ASSIGNMENT_ID := p_assignment_id;
842: l_assign_f_rec.PERSON_ID := p_assignment_id;
843:
844: ghr_mto_int.insert_assignment_f(
845: p_transfer_name => p_transfer_name,
846: p_effective_date => p_effective_date,
847: p_a => l_assign_f_rec );
848: end;

Line 861: ghr_mto_int.insert_position(

857:
858: begin
859: l_position_rec.position_id := p_position_id;
860:
861: ghr_mto_int.insert_position(
862: p_transfer_name => p_transfer_name,
863: p_person_id => p_person_id,
864: p_effective_date => p_effective_date,
865: p_pos => l_position_rec);