DBA Data[Home] [Help]

APPS.GHR_CPDF_EHRIS dependencies on GHR_HISTORY_FETCH

Line 292: GHR_HISTORY_FETCH.fetch_asgei(

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

Line 310: ghr_history_fetch.fetch_asgei

306: p_sr_ghr_cpdf_temp.to_pay_table_id := l_ASGNEI_DATA.AEI_INFORMATION9;
307: --FWFA Changes
308:
309: --BUG # 13532887 fetched PAY USER RA STATUS from NON SF52
310: ghr_history_fetch.fetch_asgei
311: (p_assignment_id => p_sr_assignment_id,
312: p_information_type => 'GHR_US_ASG_NON_SF52',
313: p_date_effective => p_sr_report_date,
314: p_asg_ei_data => l_non_asg_ei_data );

Line 811: GHR_HISTORY_FETCH.fetch_peopleei(

807: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
808: -- Begin Bug# 4753092
809: g_message_name := 'Person EIT: Uniformed Serivces';
810: -- End Bug# 4753092
811: GHR_HISTORY_FETCH.fetch_peopleei(
812: p_person_id => p_sr_person_id,
813: p_information_type => 'GHR_US_PER_UNIFORMED_SERVICES',
814: p_date_effective => p_sr_report_date,
815: p_per_ei_data => l_PEOPEI_DATA

Line 839: GHR_HISTORY_FETCH.fetch_peopleei(

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

Line 855: GHR_HISTORY_FETCH.fetch_peopleei(

851: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
852: -- Begin Bug# 4753092
853: g_message_name := 'Person EIT: Person RPA';
854: -- End Bug# 4753092
855: GHR_HISTORY_FETCH.fetch_peopleei(
856: p_person_id => p_sr_person_id,
857: p_information_type => 'GHR_US_PER_SF52',
858: p_date_effective => p_sr_report_date,
859: p_per_ei_data => l_PEOPEI_DATA

Line 882: GHR_HISTORY_FETCH.fetch_peopleei(

878: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
879: -- Begin Bug# 4753092
880: g_message_name := 'Person EIT: Person Group1';
881: -- End Bug# 4753092
882: GHR_HISTORY_FETCH.fetch_peopleei(
883: p_person_id => p_sr_person_id,
884: p_information_type => 'GHR_US_PER_GROUP1',
885: p_date_effective => p_sr_report_date,
886: p_per_ei_data => l_PEOPEI_DATA

Line 905: -- GHR_HISTORY_FETCH.fetch_peopleei

901: --p_sr_ghr_cpdf_temp.slct_serv_regi_indicator := l_PEOPEI_DATA.PEI_INFORMATION19;
902: p_sr_ghr_cpdf_temp.career_tenure_code := l_PEOPEI_DATA.PEI_INFORMATION20;
903:
904: -- bug 749190 Use FUNCTION ghr_pc_basic_pay.get_retained_grade_details instead of
905: -- GHR_HISTORY_FETCH.fetch_peopleei
906: -- do not worry if it didn't return anything!
907: -- Begin Bug# 4753092
908: g_message_name := 'Person EIT: RG Details';
909: -- End Bug# 4753092

Line 941: GHR_HISTORY_FETCH.fetch_peopleei(

937: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
938: -- Begin Bug# 4753092
939: g_message_name := 'Person EIT: Person SCD Info';
940: -- End Bug# 4753092
941: GHR_HISTORY_FETCH.fetch_peopleei(
942: p_person_id => p_sr_person_id,
943: p_information_type => 'GHR_US_PER_SCD_INFORMATION',
944: p_date_effective => p_sr_report_date,
945: p_per_ei_data => l_PEOPEI_DATA

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

972: l_extra_info_id := extra_info.person_extra_info_id;
973: If l_extra_info_id is not null then
974: hr_utility.set_location(l_proc,10);
975: ghr_history_api.get_g_session_var(l_session);
976: ghr_history_fetch.fetch_peopleei ( p_person_extra_info_id => l_extra_info_id,
977: p_date_effective => p_sr_report_date,
978: p_altered_pa_request_id => l_session.altered_pa_request_id,
979: p_noa_id_corrected => l_session.noa_id_correct,
980: p_pa_history_id => l_session.pa_history_id,

Line 1107: ghr_history_fetch.fetch_peopleei

1103: -- Begin Bug# 4753092
1104: g_message_name := 'Person EIT: Ethnicity, Race';
1105:
1106: -- End Bug# 4753092
1107: ghr_history_fetch.fetch_peopleei
1108: (p_person_id => p_sr_person_id,
1109: p_information_type => 'GHR_US_PER_ETHNICITY_RACE',
1110: p_date_effective => p_sr_report_date,
1111: p_per_ei_data => l_PEOPEI_DATA

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

1129:
1130: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
1131: g_message_name := 'Person EIT : US Benefit Cont';
1132:
1133: GHR_HISTORY_FETCH.fetch_peopleei(p_person_id => p_sr_person_id,
1134: p_information_type => 'GHR_US_PER_BENEFITS_CONT',
1135: p_date_effective => p_sr_report_date,
1136: p_per_ei_data => l_PEOPEI_DATA
1137: );

Line 1175: GHR_HISTORY_FETCH.fetch_positionei(

1171: l_POSIEI_DATA := l_POSIEI_DATA_INIT;
1172: -- Begin Bug# 4753092
1173: g_message_name := 'Position EIT: Position Group1';
1174: -- End Bug# 4753092
1175: GHR_HISTORY_FETCH.fetch_positionei(
1176: p_position_id => p_sr_position_id,
1177: p_information_type => 'GHR_US_POS_GRP1',
1178: p_date_effective => p_sr_report_date,
1179: p_pos_ei_data => l_POSIEI_DATA

Line 1195: GHR_HISTORY_FETCH.fetch_positionei(

1191: l_POSIEI_DATA := l_POSIEI_DATA_INIT;
1192: -- Begin Bug# 4753092
1193: g_message_name := 'Position EIT: Valid Grade';
1194: -- End Bug# 4753092
1195: GHR_HISTORY_FETCH.fetch_positionei(
1196: p_position_id => p_sr_position_id,
1197: p_information_type => 'GHR_US_POS_VALID_GRADE',
1198: p_date_effective => p_sr_report_date,
1199: p_pos_ei_data => l_POSIEI_DATA

Line 1235: GHR_HISTORY_FETCH.fetch_positionei(

1231: l_POSIEI_DATA := l_POSIEI_DATA_INIT;
1232: -- Begin Bug# 4753092
1233: g_message_name := 'Position EIT: Position Group2';
1234: -- End Bug# 4753092
1235: GHR_HISTORY_FETCH.fetch_positionei(
1236: p_position_id => p_sr_position_id,
1237: p_information_type => 'GHR_US_POS_GRP2',
1238: p_date_effective => p_sr_report_date,
1239: p_pos_ei_data => l_POSIEI_DATA

Line 1253: GHR_HISTORY_FETCH.fetch_positionei(

1249: END IF;
1250: --Begin bug# 14245991
1251: l_POSIEI_DATA := l_POSIEI_DATA_INIT;
1252: g_message_name := 'Position EIT: Telework Info';
1253: GHR_HISTORY_FETCH.fetch_positionei(
1254: p_position_id => p_sr_position_id,
1255: p_information_type => 'GHR_US_POS_TELEWORK_INFO',
1256: p_date_effective => p_sr_report_date,
1257: p_pos_ei_data => l_POSIEI_DATA