DBA Data[Home] [Help]

APPS.GHR_CPDF_EHRIS dependencies on GHR_HISTORY_FETCH

Line 288: GHR_HISTORY_FETCH.fetch_asgei(

284: l_ASGNEI_DATA := l_ASGNEI_DATA_INIT;
285: -- Begin Bug# 4753092
286: g_message_name := 'Assignment EIT: Assigment RPA';
287: -- End Bug# 4753092
288: GHR_HISTORY_FETCH.fetch_asgei(
289: p_assignment_id => p_sr_assignment_id,
290: p_information_type => 'GHR_US_ASG_SF52',
291: p_date_effective => p_sr_report_date,
292: p_asg_ei_data => l_ASGNEI_DATA

Line 798: GHR_HISTORY_FETCH.fetch_peopleei(

794: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
795: -- Begin Bug# 4753092
796: g_message_name := 'Person EIT: Uniformed Serivces';
797: -- End Bug# 4753092
798: GHR_HISTORY_FETCH.fetch_peopleei(
799: p_person_id => p_sr_person_id,
800: p_information_type => 'GHR_US_PER_UNIFORMED_SERVICES',
801: p_date_effective => p_sr_report_date,
802: p_per_ei_data => l_PEOPEI_DATA

Line 824: GHR_HISTORY_FETCH.fetch_peopleei(

820: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
821: -- Begin Bug# 4753092
822: g_message_name := 'Person EIT: Separation, Retire';
823: -- End Bug# 4753092
824: GHR_HISTORY_FETCH.fetch_peopleei(
825: p_person_id => p_sr_person_id,
826: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
827: p_date_effective => p_sr_report_date,
828: p_per_ei_data => l_PEOPEI_DATA

Line 840: GHR_HISTORY_FETCH.fetch_peopleei(

836: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
837: -- Begin Bug# 4753092
838: g_message_name := 'Person EIT: Person RPA';
839: -- End Bug# 4753092
840: GHR_HISTORY_FETCH.fetch_peopleei(
841: p_person_id => p_sr_person_id,
842: p_information_type => 'GHR_US_PER_SF52',
843: p_date_effective => p_sr_report_date,
844: p_per_ei_data => l_PEOPEI_DATA

Line 867: GHR_HISTORY_FETCH.fetch_peopleei(

863: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
864: -- Begin Bug# 4753092
865: g_message_name := 'Person EIT: Person Group1';
866: -- End Bug# 4753092
867: GHR_HISTORY_FETCH.fetch_peopleei(
868: p_person_id => p_sr_person_id,
869: p_information_type => 'GHR_US_PER_GROUP1',
870: p_date_effective => p_sr_report_date,
871: p_per_ei_data => l_PEOPEI_DATA

Line 886: -- GHR_HISTORY_FETCH.fetch_peopleei

882: p_sr_ghr_cpdf_temp.slct_serv_regi_indicator := l_PEOPEI_DATA.PEI_INFORMATION19;
883: p_sr_ghr_cpdf_temp.career_tenure_code := l_PEOPEI_DATA.PEI_INFORMATION20;
884:
885: -- bug 749190 Use FUNCTION ghr_pc_basic_pay.get_retained_grade_details instead of
886: -- GHR_HISTORY_FETCH.fetch_peopleei
887: -- do not worry if it didn't return anything!
888: -- Begin Bug# 4753092
889: g_message_name := 'Person EIT: RG Details';
890: -- End Bug# 4753092

Line 922: GHR_HISTORY_FETCH.fetch_peopleei(

918: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
919: -- Begin Bug# 4753092
920: g_message_name := 'Person EIT: Person SCD Info';
921: -- End Bug# 4753092
922: GHR_HISTORY_FETCH.fetch_peopleei(
923: p_person_id => p_sr_person_id,
924: p_information_type => 'GHR_US_PER_SCD_INFORMATION',
925: p_date_effective => p_sr_report_date,
926: p_per_ei_data => l_PEOPEI_DATA

Line 954: ghr_history_fetch.fetch_peopleei ( p_person_extra_info_id => l_extra_info_id,

950: l_extra_info_id := extra_info.person_extra_info_id;
951: If l_extra_info_id is not null then
952: hr_utility.set_location(l_proc,10);
953: ghr_history_api.get_g_session_var(l_session);
954: ghr_history_fetch.fetch_peopleei ( p_person_extra_info_id => l_extra_info_id,
955: p_date_effective => p_sr_report_date,
956: p_altered_pa_request_id => l_session.altered_pa_request_id,
957: p_noa_id_corrected => l_session.noa_id_correct,
958: p_pa_history_id => l_session.pa_history_id,

Line 1072: ghr_history_fetch.fetch_peopleei

1068: -- Begin Bug# 4753092
1069: g_message_name := 'Person EIT: Ethnicity, Race';
1070:
1071: -- End Bug# 4753092
1072: ghr_history_fetch.fetch_peopleei
1073: (p_person_id => p_sr_person_id,
1074: p_information_type => 'GHR_US_PER_ETHNICITY_RACE',
1075: p_date_effective => p_sr_report_date,
1076: p_per_ei_data => l_PEOPEI_DATA

Line 1098: GHR_HISTORY_FETCH.fetch_peopleei(p_person_id => p_sr_person_id,

1094:
1095: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
1096: g_message_name := 'Person EIT : US Benefit Cont';
1097:
1098: GHR_HISTORY_FETCH.fetch_peopleei(p_person_id => p_sr_person_id,
1099: p_information_type => 'GHR_US_PER_BENEFITS_CONT',
1100: p_date_effective => p_sr_report_date,
1101: p_per_ei_data => l_PEOPEI_DATA
1102: );

Line 1140: GHR_HISTORY_FETCH.fetch_positionei(

1136: l_POSIEI_DATA := l_POSIEI_DATA_INIT;
1137: -- Begin Bug# 4753092
1138: g_message_name := 'Position EIT: Position Group1';
1139: -- End Bug# 4753092
1140: GHR_HISTORY_FETCH.fetch_positionei(
1141: p_position_id => p_sr_position_id,
1142: p_information_type => 'GHR_US_POS_GRP1',
1143: p_date_effective => p_sr_report_date,
1144: p_pos_ei_data => l_POSIEI_DATA

Line 1160: GHR_HISTORY_FETCH.fetch_positionei(

1156: l_POSIEI_DATA := l_POSIEI_DATA_INIT;
1157: -- Begin Bug# 4753092
1158: g_message_name := 'Position EIT: Valid Grade';
1159: -- End Bug# 4753092
1160: GHR_HISTORY_FETCH.fetch_positionei(
1161: p_position_id => p_sr_position_id,
1162: p_information_type => 'GHR_US_POS_VALID_GRADE',
1163: p_date_effective => p_sr_report_date,
1164: p_pos_ei_data => l_POSIEI_DATA

Line 1200: GHR_HISTORY_FETCH.fetch_positionei(

1196: l_POSIEI_DATA := l_POSIEI_DATA_INIT;
1197: -- Begin Bug# 4753092
1198: g_message_name := 'Position EIT: Position Group2';
1199: -- End Bug# 4753092
1200: GHR_HISTORY_FETCH.fetch_positionei(
1201: p_position_id => p_sr_position_id,
1202: p_information_type => 'GHR_US_POS_GRP2',
1203: p_date_effective => p_sr_report_date,
1204: p_pos_ei_data => l_POSIEI_DATA