eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_CPDF_STATRPT dependencies on GHR_HISTORY_FETCH

Line 175: GHR_HISTORY_FETCH.fetch_asgei(

171: l_ASGNEI_DATA := l_ASGNEI_DATA_INIT;
172: -- Begin Bug# 4168162
173: g_message_name := 'Assignment EIT: Assigment RPA';
174: -- End Bug# 4168162
175: GHR_HISTORY_FETCH.fetch_asgei(
176: p_assignment_id => p_sr_assignment_id,
177: p_information_type => 'GHR_US_ASG_SF52',
178: p_date_effective => p_sr_report_date,
179: p_asg_ei_data => l_ASGNEI_DATA

Line 313: GHR_HISTORY_FETCH.fetch_peopleei(

309: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
310: -- Begin Bug# 4168162
311: g_message_name := 'Person EIT: Uniformed Serivces';
312: -- End Bug# 4168162
313: GHR_HISTORY_FETCH.fetch_peopleei(
314: p_person_id => p_sr_person_id,
315: p_information_type => 'GHR_US_PER_UNIFORMED_SERVICES',
316: p_date_effective => p_sr_report_date,
317: p_per_ei_data => l_PEOPEI_DATA

Line 325: GHR_HISTORY_FETCH.fetch_peopleei(

321: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
322: -- Begin Bug# 4168162
323: g_message_name := 'Person EIT: Separation, Retire';
324: -- End Bug# 4168162
325: GHR_HISTORY_FETCH.fetch_peopleei(
326: p_person_id => p_sr_person_id,
327: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
328: p_date_effective => p_sr_report_date,
329: p_per_ei_data => l_PEOPEI_DATA

Line 339: GHR_HISTORY_FETCH.fetch_peopleei(

335: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
336: -- Begin Bug# 4168162
337: g_message_name := 'Person EIT: Person RPA';
338: -- End Bug# 4168162
339: GHR_HISTORY_FETCH.fetch_peopleei(
340: p_person_id => p_sr_person_id,
341: p_information_type => 'GHR_US_PER_SF52',
342: p_date_effective => p_sr_report_date,
343: p_per_ei_data => l_PEOPEI_DATA

Line 355: GHR_HISTORY_FETCH.fetch_peopleei(

351: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
352: -- Begin Bug# 4168162
353: g_message_name := 'Person EIT: Person Group1';
354: -- End Bug# 4168162
355: GHR_HISTORY_FETCH.fetch_peopleei(
356: p_person_id => p_sr_person_id,
357: p_information_type => 'GHR_US_PER_GROUP1',
358: p_date_effective => p_sr_report_date,
359: p_per_ei_data => l_PEOPEI_DATA

Line 368: -- GHR_HISTORY_FETCH.fetch_peopleei

364: p_sr_ghr_cpdf_temp.handicap_code := l_PEOPEI_DATA.PEI_INFORMATION11;
365: l_type_of_employment := l_PEOPEI_DATA.PEI_INFORMATION4;
366:
367: -- bug 749190 Use FUNCTION ghr_pc_basic_pay.get_retained_grade_details instead of
368: -- GHR_HISTORY_FETCH.fetch_peopleei
369: -- do not woory if it didn't return anything!
370: IF p_sr_ghr_cpdf_temp.to_pay_rate_determinant IN ('A','B','E','F','U','V') THEN
371: BEGIN
372: -- Begin Bug# 4168162

Line 398: GHR_HISTORY_FETCH.fetch_peopleei(

394: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
395: -- Begin Bug# 4168162
396: g_message_name := 'Person EIT: Person SCD Info';
397: -- End Bug# 4168162
398: GHR_HISTORY_FETCH.fetch_peopleei(
399: p_person_id => p_sr_person_id,
400: p_information_type => 'GHR_US_PER_SCD_INFORMATION',
401: p_date_effective => p_sr_report_date,
402: p_per_ei_data => l_PEOPEI_DATA

Line 489: ghr_history_fetch.fetch_peopleei

485: l_PEOPEI_DATA :=NULL;
486: -- Begin Bug# 4168162
487: g_message_name := 'Person EIT: Ethnicity, Race';
488: -- End Bug# 4168162
489: ghr_history_fetch.fetch_peopleei
490: (p_person_id => p_sr_person_id,
491: p_information_type => 'GHR_US_PER_ETHNICITY_RACE',
492: p_date_effective => p_sr_report_date,
493: p_per_ei_data => l_PEOPEI_DATA

Line 527: GHR_HISTORY_FETCH.fetch_positionei(

523: l_POSIEI_DATA := l_POSIEI_DATA_INIT;
524: -- Begin Bug# 4168162
525: g_message_name := 'Position EIT: Position Group1';
526: -- End Bug# 4168162
527: GHR_HISTORY_FETCH.fetch_positionei(
528: p_position_id => p_sr_position_id,
529: p_information_type => 'GHR_US_POS_GRP1',
530: p_date_effective => p_sr_report_date,
531: p_pos_ei_data => l_POSIEI_DATA

Line 545: GHR_HISTORY_FETCH.fetch_positionei(

541: l_POSIEI_DATA := l_POSIEI_DATA_INIT;
542: -- Begin Bug# 4168162
543: g_message_name := 'Position EIT: Valid Grade';
544: -- End Bug# 4168162
545: GHR_HISTORY_FETCH.fetch_positionei(
546: p_position_id => p_sr_position_id,
547: p_information_type => 'GHR_US_POS_VALID_GRADE',
548: p_date_effective => p_sr_report_date,
549: p_pos_ei_data => l_POSIEI_DATA

Line 564: GHR_HISTORY_FETCH.fetch_positionei(

560: l_POSIEI_DATA := l_POSIEI_DATA_INIT;
561: -- Begin Bug# 4168162
562: g_message_name := 'Position EIT: Position Group2';
563: -- End Bug# 4168162
564: GHR_HISTORY_FETCH.fetch_positionei(
565: p_position_id => p_sr_position_id,
566: p_information_type => 'GHR_US_POS_GRP2',
567: p_date_effective => p_sr_report_date,
568: p_pos_ei_data => l_POSIEI_DATA

Line 711: GHR_HISTORY_FETCH.fetch_element_entry_value(

707: l_scrn_ent_val := l_scrn_ent_val_init;
708: -- Begin Bug# 4168162
709: g_message_name := 'Fetch Element: Retirement Plan';
710: -- End Bug# 4168162
711: GHR_HISTORY_FETCH.fetch_element_entry_value(
712: p_element_name => 'Retirement Plan',
713: p_input_value_name => 'Plan',
714: p_assignment_id => p_sr_assignment_id,
715: p_date_effective => p_sr_report_date,

Line 724: GHR_HISTORY_FETCH.fetch_element_entry_value(

720: l_scrn_ent_val := l_scrn_ent_val_init;
721: -- Begin Bug# 4168162
722: g_message_name := 'Fetch Element: FEGLI';
723: -- End Bug# 4168162
724: GHR_HISTORY_FETCH.fetch_element_entry_value(
725: p_element_name => 'FEGLI',
726: p_input_value_name => 'FEGLI',
727: p_assignment_id => p_sr_assignment_id,
728: p_date_effective => p_sr_report_date,

Line 739: GHR_HISTORY_FETCH.fetch_element_entry_value(

735: l_scrn_ent_val := l_scrn_ent_val_init;
736: -- Begin Bug# 4168162
737: g_message_name := 'Fetch Element: HB Pre Tax plan';
738: -- End Bug# 4168162
739: GHR_HISTORY_FETCH.fetch_element_entry_value(
740: p_element_name => 'Health Benefits Pre tax',
741: p_input_value_name => 'Health Plan',
742: p_assignment_id => p_sr_assignment_id,
743: p_date_effective => p_sr_report_date,

Line 750: GHR_HISTORY_FETCH.fetch_element_entry_value(

746: l_scrn_ent_val := l_scrn_ent_val_init;
747: -- Begin Bug# 4168162
748: g_message_name := 'Fetch Element: HB Pre tax Enrl';
749: -- End Bug# 4168162
750: GHR_HISTORY_FETCH.fetch_element_entry_value(
751: p_element_name => 'Health Benefits Pre tax',
752: p_input_value_name => 'Enrollment',
753: p_assignment_id => p_sr_assignment_id,
754: p_date_effective => p_sr_report_date,

Line 762: GHR_HISTORY_FETCH.fetch_element_entry_value(

758: l_scrn_ent_val := l_scrn_ent_val_init;
759: -- Begin Bug# 4168162
760: g_message_name := ' Fetch Element: HB plan';
761: -- End Bug# 4168162
762: GHR_HISTORY_FETCH.fetch_element_entry_value(
763: p_element_name => 'Health Benefits',
764: p_input_value_name => 'Health Plan',
765: p_assignment_id => p_sr_assignment_id,
766: p_date_effective => p_sr_report_date,

Line 773: GHR_HISTORY_FETCH.fetch_element_entry_value(

769: l_scrn_ent_val := l_scrn_ent_val_init;
770: -- Begin Bug# 4168162
771: g_message_name := ' Fetch Element: HB Enrollment';
772: -- End Bug# 4168162
773: GHR_HISTORY_FETCH.fetch_element_entry_value(
774: p_element_name => 'Health Benefits',
775: p_input_value_name => 'Enrollment',
776: p_assignment_id => p_sr_assignment_id,
777: p_date_effective => p_sr_report_date,

Line 794: GHR_HISTORY_FETCH.fetch_element_entry_value(

790: l_scrn_ent_val := l_scrn_ent_val_init;
791: -- Begin Bug# 4168162
792: g_message_name := 'Fetch Element: Basic Salary';
793: -- End Bug# 4168162
794: GHR_HISTORY_FETCH.fetch_element_entry_value(
795: p_element_name => 'Basic Salary Rate',
796: p_input_value_name => 'Rate',
797: p_assignment_id => p_sr_assignment_id,
798: p_date_effective => p_sr_report_date,

Line 814: GHR_HISTORY_FETCH.fetch_element_entry_value(

810: --
811: -- Begin Bug# 4168162
812: g_message_name := 'Fetch Element: Locality Pay';
813: -- End Bug# 4168162
814: GHR_HISTORY_FETCH.fetch_element_entry_value(
815: -- FWFA Changes Bug#4444609
816: p_element_name => 'Locality Pay or SR Supplement',
817: -- FWFA Changes Modify 'Locality Pay' to 'Locality Pay or SR Supplement'
818: p_input_value_name => 'Rate',

Line 829: GHR_HISTORY_FETCH.fetch_element_entry_value(

825: l_scrn_ent_val := l_scrn_ent_val_init;
826: -- Begin Bug# 4168162
827: g_message_name := 'Fetch Element: Staffing Diff';
828: -- End Bug# 4168162
829: GHR_HISTORY_FETCH.fetch_element_entry_value(
830: p_element_name => 'Staffing Differential',
831: p_input_value_name => 'Amount',
832: p_assignment_id => p_sr_assignment_id,
833: p_date_effective => p_sr_report_date,

Line 842: GHR_HISTORY_FETCH.fetch_element_entry_value(

838: l_scrn_ent_val := l_scrn_ent_val_init;
839: -- Begin Bug# 4168162
840: g_message_name := 'Fetch Element:Supervisory Diff';
841: -- End Bug# 4168162
842: GHR_HISTORY_FETCH.fetch_element_entry_value(
843: p_element_name => 'Supervisory Differential',
844: p_input_value_name => 'Amount',
845: p_assignment_id => p_sr_assignment_id,
846: p_date_effective => p_sr_report_date,

Line 855: GHR_HISTORY_FETCH.fetch_element_entry_value(

851: l_scrn_ent_val := l_scrn_ent_val_init;
852: -- Begin Bug# 4168162
853: g_message_name := 'Fetch Element:Retention Allow';
854: -- End Bug# 4168162
855: GHR_HISTORY_FETCH.fetch_element_entry_value(
856: p_element_name => 'Retention Allowance',
857: p_input_value_name => 'Amount',
858: p_assignment_id => p_sr_assignment_id,
859: p_date_effective => p_sr_report_date,

Line 1353: /* ghr_history_fetch.fetch_peopleei

1349: p_business_group_id => l_business_group_id,
1350: p_effective_date => g_report_date);
1351:
1352:
1353: /* ghr_history_fetch.fetch_peopleei
1354: (p_person_id => g_person_id,
1355: p_information_type => 'GHR_US_PER_SCD_INFORMATION',
1356: p_date_effective => nvl(g_report_date,trunc(sysdate)),
1357: p_per_ei_data => ll_per_ei_data