DBA Data[Home] [Help]

APPS.GHR_MTI_INT_INSERT dependencies on GHR_MTO_INT

Line 370: ghr_mto_int.insert_people_f

366: l_people_f_rec.WORK_TELEPHONE := p_work_telephone;
367: l_people_f_rec.REHIRE_REASON := p_rehire_reason;
368:
369: if p_action = 'INSERT' then
370: ghr_mto_int.insert_people_f
371: ( p_transfer_name => p_transfer_name,
372: p_inter_bg_transfer => p_inter_bg_transfer,
373: p_effective_date => p_effective_date,
374: ppf => l_people_f_rec);

Line 376: ghr_mto_int.update_people_f

372: p_inter_bg_transfer => p_inter_bg_transfer,
373: p_effective_date => p_effective_date,
374: ppf => l_people_f_rec);
375: else
376: ghr_mto_int.update_people_f
377: ( p_transfer_name => p_transfer_name,
378: p_inter_bg_transfer => p_inter_bg_transfer,
379: p_effective_date => p_effective_date,
380: ppf => l_people_f_rec);

Line 406: ghr_mto_int.insert_people_ei

402: l_people_ei1_rec.PEI_INFORMATION5 := p_veterans_preference_for_RIF;
403: l_people_ei1_rec.PEI_INFORMATION6 := p_veterans_status;
404:
405: if p_action = 'INSERT' then
406: ghr_mto_int.insert_people_ei
407: ( p_transfer_name => p_transfer_name,
408: p_effective_date => p_effective_date,
409: pp_ei => l_people_ei1_rec);
410: else

Line 411: ghr_mto_int.update_people_ei

407: ( p_transfer_name => p_transfer_name,
408: p_effective_date => p_effective_date,
409: pp_ei => l_people_ei1_rec);
410: else
411: ghr_mto_int.update_people_ei
412: ( p_transfer_name => p_transfer_name,
413: p_effective_date => p_effective_date,
414: pp_ei => l_people_ei1_rec);
415: end if;

Line 450: ghr_mto_int.insert_people_ei

446: l_people_ei2_rec.PEI_INFORMATION22 := p_orig_appt_auth_code_1_desc;--Bug# 8724192
447: l_people_ei2_rec.PEI_INFORMATION23 := p_orig_appt_auth_code_2_desc;--Bug# 8724192
448:
449: if p_action = 'INSERT' then
450: ghr_mto_int.insert_people_ei
451: ( p_transfer_name => p_transfer_name,
452: p_effective_date => p_effective_date,
453: pp_ei => l_people_ei2_rec);
454: else

Line 455: ghr_mto_int.update_people_ei

451: ( p_transfer_name => p_transfer_name,
452: p_effective_date => p_effective_date,
453: pp_ei => l_people_ei2_rec);
454: else
455: ghr_mto_int.update_people_ei
456: ( p_transfer_name => p_transfer_name,
457: p_effective_date => p_effective_date,
458: pp_ei => l_people_ei2_rec);
459: end if;

Line 479: ghr_mto_int.insert_people_ei

475: ----l_people_ei3_rec.PEI_INFORMATION3 := to_char(p_service_comp_date, 'DD-MON-YYYY');
476: l_people_ei3_rec.PEI_INFORMATION3 := fnd_date.date_to_canonical(p_service_comp_date);
477:
478: if p_action = 'INSERT' then
479: ghr_mto_int.insert_people_ei
480: ( p_transfer_name => p_transfer_name,
481: p_effective_date => p_effective_date,
482: pp_ei => l_people_ei3_rec);
483: else

Line 484: ghr_mto_int.update_people_ei

480: ( p_transfer_name => p_transfer_name,
481: p_effective_date => p_effective_date,
482: pp_ei => l_people_ei3_rec);
483: else
484: ghr_mto_int.update_people_ei
485: ( p_transfer_name => p_transfer_name,
486: p_effective_date => p_effective_date,
487: pp_ei => l_people_ei3_rec);
488: end if;

Line 512: ghr_mto_int.insert_people_ei

508: l_people_ei4_rec.PEI_INFORMATION4 := p_Previous_Retirement_Coverage;
509: l_people_ei4_rec.PEI_INFORMATION5 := p_Frozen_Service;
510:
511: if p_action = 'INSERT' then
512: ghr_mto_int.insert_people_ei
513: ( p_transfer_name => p_transfer_name,
514: p_effective_date => p_effective_date,
515: pp_ei => l_people_ei4_rec);
516: else

Line 517: ghr_mto_int.update_people_ei

513: ( p_transfer_name => p_transfer_name,
514: p_effective_date => p_effective_date,
515: pp_ei => l_people_ei4_rec);
516: else
517: ghr_mto_int.update_people_ei
518: ( p_transfer_name => p_transfer_name,
519: p_effective_date => p_effective_date,
520: pp_ei => l_people_ei4_rec);
521: end if;

Line 540: ghr_mto_int.insert_people_ei

536: l_people_ei5_rec.PEI_INFORMATION_CATEGORY := 'GHR_US_PER_UNIFORMED_SERVICES';
537: l_people_ei5_rec.PEI_INFORMATION5 := p_Creditable_Military_Service;
538:
539: if p_action = 'INSERT' then
540: ghr_mto_int.insert_people_ei
541: ( p_transfer_name => p_transfer_name,
542: p_effective_date => p_effective_date,
543: pp_ei => l_people_ei5_rec);
544: else

Line 545: ghr_mto_int.update_people_ei

541: ( p_transfer_name => p_transfer_name,
542: p_effective_date => p_effective_date,
543: pp_ei => l_people_ei5_rec);
544: else
545: ghr_mto_int.update_people_ei
546: ( p_transfer_name => p_transfer_name,
547: p_effective_date => p_effective_date,
548: pp_ei => l_people_ei5_rec);
549: end if;

Line 576: ghr_mto_int.insert_position_ei

572: l_position_ei1_rec.POEI_INFORMATION16 := p_supervisory_status;
573:
574: if p_action = 'INSERT' then
575: l_position_ei1_rec.POSITION_ID := p_person_id;
576: ghr_mto_int.insert_position_ei
577: ( p_transfer_name => p_transfer_name,
578: p_person_id => p_person_id,
579: p_effective_date => p_effective_date,
580: p_pos_ei => l_position_ei1_rec);

Line 582: ghr_mto_int.update_position_ei

578: p_person_id => p_person_id,
579: p_effective_date => p_effective_date,
580: p_pos_ei => l_position_ei1_rec);
581: else
582: ghr_mto_int.update_position_ei
583: ( p_transfer_name => p_transfer_name,
584: p_person_id => p_person_id,
585: p_effective_date => p_effective_date,
586: p_pos_ei => l_position_ei1_rec);

Line 610: ghr_mto_int.insert_position_ei

606: l_position_ei2_rec.POEI_INFORMATION14 := p_appropriation_code2;
607:
608: if p_action = 'INSERT' then
609: l_position_ei2_rec.POSITION_ID := p_person_id;
610: ghr_mto_int.insert_position_ei
611: ( p_transfer_name => p_transfer_name,
612: p_person_id => p_person_id,
613: p_effective_date => p_effective_date,
614: p_pos_ei => l_position_ei2_rec);

Line 616: ghr_mto_int.update_position_ei

612: p_person_id => p_person_id,
613: p_effective_date => p_effective_date,
614: p_pos_ei => l_position_ei2_rec);
615: else
616: ghr_mto_int.update_position_ei
617: ( p_transfer_name => p_transfer_name,
618: p_person_id => p_person_id,
619: p_effective_date => p_effective_date,
620: p_pos_ei => l_position_ei2_rec);

Line 681: ghr_mto_int.insert_element_entries

677: l_ghr_mt_ele_rec.to_adjusted_basic_pay := p_to_adjusted_basic_pay;
678: -- End changes 4093771
679:
680: if p_action = 'INSERT' then
681: ghr_mto_int.insert_element_entries
682: ( p_transfer_name => p_transfer_name,
683: p_person_id => p_person_id,
684: p_effective_date => p_effective_date,
685: p_element => l_ghr_mt_ele_rec);

Line 687: ghr_mto_int.update_element_entries

683: p_person_id => p_person_id,
684: p_effective_date => p_effective_date,
685: p_element => l_ghr_mt_ele_rec);
686: else
687: ghr_mto_int.update_element_entries
688: ( p_transfer_name => p_transfer_name,
689: p_person_id => p_person_id,
690: p_effective_date => p_effective_date,
691: p_element => l_ghr_mt_ele_rec);

Line 723: ghr_mto_int.insert_misc

719: l_ghr_mt_misc_rec.duty_station_desc := p_duty_station_desc;
720: l_ghr_mt_misc_rec.from_agency_code := p_from_agency_code;
721:
722: if p_action = 'INSERT' then
723: ghr_mto_int.insert_misc
724: ( p_transfer_name => p_transfer_name,
725: p_person_id => p_person_id,
726: p_effective_date => p_effective_date,
727: p_misc => l_ghr_mt_misc_rec);

Line 729: ghr_mto_int.update_misc

725: p_person_id => p_person_id,
726: p_effective_date => p_effective_date,
727: p_misc => l_ghr_mt_misc_rec);
728: else
729: ghr_mto_int.update_misc
730: ( p_transfer_name => p_transfer_name,
731: p_person_id => p_person_id,
732: p_effective_date => p_effective_date,
733: p_misc => l_ghr_mt_misc_rec);

Line 764: ghr_mto_int.insert_assignment_ei

760: l_assign_ei1_rec.AEI_INFORMATION8 := p_part_time_hours;
761:
762: if p_action = 'INSERT' then
763: l_assign_ei1_rec.ASSIGNMENT_ID := p_person_id;
764: ghr_mto_int.insert_assignment_ei
765: ( p_transfer_name => p_transfer_name,
766: p_person_id => p_person_id,
767: p_effective_date => p_effective_date,
768: p_a_ei => l_assign_ei1_rec);

Line 770: ghr_mto_int.update_assignment_ei

766: p_person_id => p_person_id,
767: p_effective_date => p_effective_date,
768: p_a_ei => l_assign_ei1_rec);
769: else
770: ghr_mto_int.update_assignment_ei
771: ( p_transfer_name => p_transfer_name,
772: p_person_id => p_person_id,
773: p_effective_date => p_effective_date,
774: p_a_ei => l_assign_ei1_rec);

Line 801: ghr_mto_int.insert_assignment_ei

797: l_assign_ei2_rec.AEI_INFORMATION9 := p_qualif_standards_waiver;
798:
799: if p_action = 'INSERT' then
800: l_assign_ei2_rec.ASSIGNMENT_ID := p_person_id;
801: ghr_mto_int.insert_assignment_ei
802: ( p_transfer_name => p_transfer_name,
803: p_person_id => p_person_id,
804: p_effective_date => p_effective_date,
805: p_a_ei => l_assign_ei2_rec);

Line 807: ghr_mto_int.update_assignment_ei

803: p_person_id => p_person_id,
804: p_effective_date => p_effective_date,
805: p_a_ei => l_assign_ei2_rec);
806: else
807: ghr_mto_int.update_assignment_ei
808: ( p_transfer_name => p_transfer_name,
809: p_person_id => p_person_id,
810: p_effective_date => p_effective_date,
811: p_a_ei => l_assign_ei2_rec);

Line 834: ghr_mto_int.insert_assignment_ei

830: l_assign_ei3_rec.AEI_INFORMATION4 := fnd_date.date_to_canonical(p_assignment_nte);
831:
832: if p_action = 'INSERT' then
833: l_assign_ei3_rec.ASSIGNMENT_ID := p_person_id;
834: ghr_mto_int.insert_assignment_ei
835: ( p_transfer_name => p_transfer_name,
836: p_person_id => p_person_id,
837: p_effective_date => p_effective_date,
838: p_a_ei => l_assign_ei3_rec);

Line 840: ghr_mto_int.update_assignment_ei

836: p_person_id => p_person_id,
837: p_effective_date => p_effective_date,
838: p_a_ei => l_assign_ei3_rec);
839: else
840: ghr_mto_int.update_assignment_ei
841: ( p_transfer_name => p_transfer_name,
842: p_person_id => p_person_id,
843: p_effective_date => p_effective_date,
844: p_a_ei => l_assign_ei3_rec);

Line 867: ghr_mto_int.insert_special_info(

863: l_si.SEGMENT2 := p_academic_discipline;
864: l_si.SEGMENT3 := p_year_degree_attained;
865:
866: if p_action = 'INSERT' then
867: ghr_mto_int.insert_special_info(
868: p_transfer_name => p_transfer_name,
869: p_effective_date => p_effective_date,
870: p_person_id => p_person_id,
871: p_flex_name => l_flex_name,

Line 877: ghr_mto_int.update_special_info(

873: end if;
874: if p_education_level is not null or
875: p_academic_discipline is not null or
876: p_year_degree_attained is not null then
877: ghr_mto_int.update_special_info(
878: p_transfer_name => p_transfer_name,
879: p_effective_date => p_effective_date,
880: p_person_id => p_person_id,
881: p_flex_name => l_flex_name,

Line 899: ghr_mto_int.insert_assignment_f(

895: begin
896: l_assign_f_rec.ASSIGNMENT_ID := p_assignment_id;
897: l_assign_f_rec.PERSON_ID := p_assignment_id;
898:
899: ghr_mto_int.insert_assignment_f(
900: p_transfer_name => p_transfer_name,
901: p_effective_date => p_effective_date,
902: p_a => l_assign_f_rec );
903: end;

Line 916: ghr_mto_int.insert_position(

912:
913: begin
914: l_position_rec.position_id := p_position_id;
915:
916: ghr_mto_int.insert_position(
917: p_transfer_name => p_transfer_name,
918: p_person_id => p_person_id,
919: p_effective_date => p_effective_date,
920: p_pos => l_position_rec);