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 179: GHR_HISTORY_FETCH.fetch_asgei(

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

Line 317: GHR_HISTORY_FETCH.fetch_peopleei(

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

Line 329: GHR_HISTORY_FETCH.fetch_peopleei(

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

Line 343: GHR_HISTORY_FETCH.fetch_peopleei(

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

Line 359: GHR_HISTORY_FETCH.fetch_peopleei(

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

Line 372: -- GHR_HISTORY_FETCH.fetch_peopleei

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

Line 404: GHR_HISTORY_FETCH.fetch_peopleei(

400: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
401: -- Begin Bug# 4168162
402: g_message_name := 'Person EIT: Person SCD Info';
403: -- End Bug# 4168162
404: GHR_HISTORY_FETCH.fetch_peopleei(
405: p_person_id => p_sr_person_id,
406: p_information_type => 'GHR_US_PER_SCD_INFORMATION',
407: p_date_effective => p_sr_report_date,
408: p_per_ei_data => l_PEOPEI_DATA

Line 519: ghr_history_fetch.fetch_peopleei

515: l_PEOPEI_DATA :=NULL;
516: -- Begin Bug# 4168162
517: g_message_name := 'Person EIT: Ethnicity, Race';
518: -- End Bug# 4168162
519: ghr_history_fetch.fetch_peopleei
520: (p_person_id => p_sr_person_id,
521: p_information_type => 'GHR_US_PER_ETHNICITY_RACE',
522: p_date_effective => p_sr_report_date,
523: p_per_ei_data => l_PEOPEI_DATA

Line 557: GHR_HISTORY_FETCH.fetch_positionei(

553: l_POSIEI_DATA := l_POSIEI_DATA_INIT;
554: -- Begin Bug# 4168162
555: g_message_name := 'Position EIT: Position Group1';
556: -- End Bug# 4168162
557: GHR_HISTORY_FETCH.fetch_positionei(
558: p_position_id => p_sr_position_id,
559: p_information_type => 'GHR_US_POS_GRP1',
560: p_date_effective => p_sr_report_date,
561: p_pos_ei_data => l_POSIEI_DATA

Line 575: GHR_HISTORY_FETCH.fetch_positionei(

571: l_POSIEI_DATA := l_POSIEI_DATA_INIT;
572: -- Begin Bug# 4168162
573: g_message_name := 'Position EIT: Valid Grade';
574: -- End Bug# 4168162
575: GHR_HISTORY_FETCH.fetch_positionei(
576: p_position_id => p_sr_position_id,
577: p_information_type => 'GHR_US_POS_VALID_GRADE',
578: p_date_effective => p_sr_report_date,
579: p_pos_ei_data => l_POSIEI_DATA

Line 594: GHR_HISTORY_FETCH.fetch_positionei(

590: l_POSIEI_DATA := l_POSIEI_DATA_INIT;
591: -- Begin Bug# 4168162
592: g_message_name := 'Position EIT: Position Group2';
593: -- End Bug# 4168162
594: GHR_HISTORY_FETCH.fetch_positionei(
595: p_position_id => p_sr_position_id,
596: p_information_type => 'GHR_US_POS_GRP2',
597: p_date_effective => p_sr_report_date,
598: p_pos_ei_data => l_POSIEI_DATA

Line 741: GHR_HISTORY_FETCH.fetch_element_entry_value(

737: l_scrn_ent_val := l_scrn_ent_val_init;
738: -- Begin Bug# 4168162
739: g_message_name := 'Fetch Element: Retirement Plan';
740: -- End Bug# 4168162
741: GHR_HISTORY_FETCH.fetch_element_entry_value(
742: p_element_name => 'Retirement Plan',
743: p_input_value_name => 'Plan',
744: p_assignment_id => p_sr_assignment_id,
745: p_date_effective => p_sr_report_date,

Line 754: GHR_HISTORY_FETCH.fetch_element_entry_value(

750: l_scrn_ent_val := l_scrn_ent_val_init;
751: -- Begin Bug# 4168162
752: g_message_name := 'Fetch Element: FEGLI';
753: -- End Bug# 4168162
754: GHR_HISTORY_FETCH.fetch_element_entry_value(
755: p_element_name => 'FEGLI',
756: p_input_value_name => 'FEGLI',
757: p_assignment_id => p_sr_assignment_id,
758: p_date_effective => p_sr_report_date,

Line 769: GHR_HISTORY_FETCH.fetch_element_entry_value(

765: l_scrn_ent_val := l_scrn_ent_val_init;
766: -- Begin Bug# 4168162
767: g_message_name := 'Fetch Element: HB Pre Tax plan';
768: -- End Bug# 4168162
769: GHR_HISTORY_FETCH.fetch_element_entry_value(
770: p_element_name => 'Health Benefits Pre tax',
771: p_input_value_name => 'Health Plan',
772: p_assignment_id => p_sr_assignment_id,
773: p_date_effective => p_sr_report_date,

Line 780: GHR_HISTORY_FETCH.fetch_element_entry_value(

776: l_scrn_ent_val := l_scrn_ent_val_init;
777: -- Begin Bug# 4168162
778: g_message_name := 'Fetch Element: HB Pre tax Enrl';
779: -- End Bug# 4168162
780: GHR_HISTORY_FETCH.fetch_element_entry_value(
781: p_element_name => 'Health Benefits Pre tax',
782: p_input_value_name => 'Enrollment',
783: p_assignment_id => p_sr_assignment_id,
784: p_date_effective => p_sr_report_date,

Line 792: GHR_HISTORY_FETCH.fetch_element_entry_value(

788: l_scrn_ent_val := l_scrn_ent_val_init;
789: -- Begin Bug# 4168162
790: g_message_name := ' Fetch Element: HB plan';
791: -- End Bug# 4168162
792: GHR_HISTORY_FETCH.fetch_element_entry_value(
793: p_element_name => 'Health Benefits',
794: p_input_value_name => 'Health Plan',
795: p_assignment_id => p_sr_assignment_id,
796: p_date_effective => p_sr_report_date,

Line 803: GHR_HISTORY_FETCH.fetch_element_entry_value(

799: l_scrn_ent_val := l_scrn_ent_val_init;
800: -- Begin Bug# 4168162
801: g_message_name := ' Fetch Element: HB Enrollment';
802: -- End Bug# 4168162
803: GHR_HISTORY_FETCH.fetch_element_entry_value(
804: p_element_name => 'Health Benefits',
805: p_input_value_name => 'Enrollment',
806: p_assignment_id => p_sr_assignment_id,
807: p_date_effective => p_sr_report_date,

Line 824: GHR_HISTORY_FETCH.fetch_element_entry_value(

820: l_scrn_ent_val := l_scrn_ent_val_init;
821: -- Begin Bug# 4168162
822: g_message_name := 'Fetch Element: Basic Salary';
823: -- End Bug# 4168162
824: GHR_HISTORY_FETCH.fetch_element_entry_value(
825: p_element_name => 'Basic Salary Rate',
826: p_input_value_name => 'Rate',
827: p_assignment_id => p_sr_assignment_id,
828: p_date_effective => p_sr_report_date,

Line 844: GHR_HISTORY_FETCH.fetch_element_entry_value(

840: --
841: -- Begin Bug# 4168162
842: g_message_name := 'Fetch Element: Locality Pay';
843: -- End Bug# 4168162
844: GHR_HISTORY_FETCH.fetch_element_entry_value(
845: -- FWFA Changes Bug#4444609
846: p_element_name => 'Locality Pay or SR Supplement',
847: -- FWFA Changes Modify 'Locality Pay' to 'Locality Pay or SR Supplement'
848: p_input_value_name => 'Rate',

Line 859: GHR_HISTORY_FETCH.fetch_element_entry_value(

855: l_scrn_ent_val := l_scrn_ent_val_init;
856: -- Begin Bug# 4168162
857: g_message_name := 'Fetch Element: Staffing Diff';
858: -- End Bug# 4168162
859: GHR_HISTORY_FETCH.fetch_element_entry_value(
860: p_element_name => 'Staffing Differential',
861: p_input_value_name => 'Amount',
862: p_assignment_id => p_sr_assignment_id,
863: p_date_effective => p_sr_report_date,

Line 872: GHR_HISTORY_FETCH.fetch_element_entry_value(

868: l_scrn_ent_val := l_scrn_ent_val_init;
869: -- Begin Bug# 4168162
870: g_message_name := 'Fetch Element:Supervisory Diff';
871: -- End Bug# 4168162
872: GHR_HISTORY_FETCH.fetch_element_entry_value(
873: p_element_name => 'Supervisory Differential',
874: p_input_value_name => 'Amount',
875: p_assignment_id => p_sr_assignment_id,
876: p_date_effective => p_sr_report_date,

Line 885: GHR_HISTORY_FETCH.fetch_element_entry_value(

881: l_scrn_ent_val := l_scrn_ent_val_init;
882: -- Begin Bug# 4168162
883: g_message_name := 'Fetch Element:Retention Allow';
884: -- End Bug# 4168162
885: GHR_HISTORY_FETCH.fetch_element_entry_value(
886: p_element_name => 'Retention Allowance',
887: p_input_value_name => 'Amount',
888: p_assignment_id => p_sr_assignment_id,
889: p_date_effective => p_sr_report_date,

Line 1399: /* ghr_history_fetch.fetch_peopleei

1395: p_business_group_id => l_business_group_id,
1396: p_effective_date => g_report_date);
1397:
1398:
1399: /* ghr_history_fetch.fetch_peopleei
1400: (p_person_id => g_person_id,
1401: p_information_type => 'GHR_US_PER_SCD_INFORMATION',
1402: p_date_effective => nvl(g_report_date,trunc(sysdate)),
1403: p_per_ei_data => ll_per_ei_data