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_SF113_A dependencies on GHR_HISTORY_FETCH

Line 533: ghr_history_fetch.fetch_positionei(

529:
530: EXIT WHEN SF113_SECTION1%NOTFOUND;
531: l_susp_flag := 'N';
532: --Begin Bug# 8928564
533: ghr_history_fetch.fetch_positionei(
534: p_position_id => l_position_id
535: ,p_information_type => 'GHR_US_POS_VALID_GRADE'
536: ,p_date_effective => p_rpt_date
537: ,p_pos_ei_data => l_pos_hist_data);

Line 564: GHR_HISTORY_FETCH.fetch_asgei(l_assignment_id,'GHR_US_ASG_SF52',p_rpt_date,

560: and (l_duty_station_code >= '00' and l_duty_station_code <= '99')
561: THEN
562: l_duty_station := 'O';
563: END IF;
564: GHR_HISTORY_FETCH.fetch_asgei(l_assignment_id,'GHR_US_ASG_SF52',p_rpt_date,
565: l_asgn_hist_data);
566: l_tenure := L_ASGN_HIST_DATA.AEI_INFORMATION4;
567: l_work_schedule := L_ASGN_HIST_DATA.AEI_INFORMATION7;
568:

Line 571: GHR_HISTORY_FETCH.fetch_asgei(l_assignment_id,'GHR_US_ASG_NTE_DATES',p_rpt_date, l_asgn_hist_data);

567: l_work_schedule := L_ASGN_HIST_DATA.AEI_INFORMATION7;
568:
569: FOR c_chk_ast_status IN chk_susp_asg_status
570: LOOP
571: GHR_HISTORY_FETCH.fetch_asgei(l_assignment_id,'GHR_US_ASG_NTE_DATES',p_rpt_date, l_asgn_hist_data);
572: l_lwop_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information6);
573: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);
574: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
575: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);

Line 584: GHR_HISTORY_FETCH.fetch_peopleei(l_person_id,'GHR_US_PER_SF52',

580: (nvl(l_furlough_nte_date,p_empl_as_of_date) > p_empl_as_of_date + 30 ) then
581: l_susp_flag := 'Y';
582: END IF;
583: END LOOP;
584: GHR_HISTORY_FETCH.fetch_peopleei(l_person_id,'GHR_US_PER_SF52',
585: p_rpt_date,l_people_hist_data);
586: l_citizenship := l_people_hist_data.pei_information3;
587:
588: GHR_HISTORY_FETCH.fetch_peopleei(l_person_id,'GHR_US_PER_GROUP1',p_rpt_date,

Line 588: GHR_HISTORY_FETCH.fetch_peopleei(l_person_id,'GHR_US_PER_GROUP1',p_rpt_date,

584: GHR_HISTORY_FETCH.fetch_peopleei(l_person_id,'GHR_US_PER_SF52',
585: p_rpt_date,l_people_hist_data);
586: l_citizenship := l_people_hist_data.pei_information3;
587:
588: GHR_HISTORY_FETCH.fetch_peopleei(l_person_id,'GHR_US_PER_GROUP1',p_rpt_date,
589: l_people_hist_data);
590: l_emp_type := l_people_hist_data.pei_information4;
591: l_appointment := l_people_hist_data.pei_information3;
592: l_cur_appt1 := l_people_hist_data.pei_information8;

Line 596: --GHR_HISTORY_FETCH.fetch_positionei(l_position_id,'GHR_US_POS_GRP1',p_rpt_date,l_pos_hist_data);

592: l_cur_appt1 := l_people_hist_data.pei_information8;
593: l_cur_appt2 := l_people_hist_data.pei_information9;
594:
595: -- Use Assignment Work Schedule Not Position.
596: --GHR_HISTORY_FETCH.fetch_positionei(l_position_id,'GHR_US_POS_GRP1',p_rpt_date,l_pos_hist_data);
597: --l_work_schedule := l_pos_hist_data. poei_information10;
598:
599: GHR_HISTORY_FETCH.fetch_positionei(l_position_id,'GHR_US_POS_GRP2',p_rpt_date,
600: l_pos_hist_data );

Line 599: GHR_HISTORY_FETCH.fetch_positionei(l_position_id,'GHR_US_POS_GRP2',p_rpt_date,

595: -- Use Assignment Work Schedule Not Position.
596: --GHR_HISTORY_FETCH.fetch_positionei(l_position_id,'GHR_US_POS_GRP1',p_rpt_date,l_pos_hist_data);
597: --l_work_schedule := l_pos_hist_data. poei_information10;
598:
599: GHR_HISTORY_FETCH.fetch_positionei(l_position_id,'GHR_US_POS_GRP2',p_rpt_date,
600: l_pos_hist_data );
601: l_position_code := l_pos_hist_data.poei_information3;
602: hr_utility.set_location('l_susp_flag is ' || l_susp_flag ,2);
603: hr_utility.set_location('l_assignment_id is ' || l_assignment_id ,3);

Line 1639: ghr_history_fetch.fetch_positionei(

1635:
1636:
1637: -- Exclude NAF positions (Non-Appropriate Fund positions)
1638: --Begin Bug# 8928564
1639: ghr_history_fetch.fetch_positionei(
1640: p_position_id => l_position_id
1641: ,p_information_type => 'GHR_US_POS_VALID_GRADE'
1642: ,p_date_effective => p_rpt_date
1643: ,p_pos_ei_data => l_pos_hist_data);

Line 1659: GHR_HISTORY_FETCH.fetch_asgei(l_assignment_id,'GHR_US_ASG_NTE_DATES',p_rpt_date, l_asgn_hist_data);

1655:
1656: l_susp_flag := 'N';
1657: FOR c_chk_ast_status IN chk_susp_asg_status
1658: LOOP
1659: GHR_HISTORY_FETCH.fetch_asgei(l_assignment_id,'GHR_US_ASG_NTE_DATES',p_rpt_date, l_asgn_hist_data);
1660: l_lwop_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information6);
1661: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);
1662: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
1663:

Line 1704: GHR_HISTORY_FETCH.fetch_peopleei(l_person_id,'GHR_US_PER_SF52',

1700: AND (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1701: l_duty_station := 'O';
1702: END IF;
1703:
1704: GHR_HISTORY_FETCH.fetch_peopleei(l_person_id,'GHR_US_PER_SF52',
1705: p_rpt_date,l_people_hist_data);
1706:
1707: l_citizenship := l_people_hist_data.pei_information3;
1708:

Line 1794: ghr_history_fetch.fetch_positionei(

1790:
1791: EXIT WHEN sf113_section3%NOTFOUND;
1792:
1793: --Begin Bug# 8928564
1794: ghr_history_fetch.fetch_positionei(
1795: p_position_id => l_position_id
1796: ,p_information_type => 'GHR_US_POS_VALID_GRADE'
1797: ,p_date_effective => p_rpt_date
1798: ,p_pos_ei_data => l_pos_hist_data);

Line 1826: GHR_HISTORY_FETCH.fetch_peopleei(l_person_id,'GHR_US_PER_SF52',p_rpt_date,l_people_hist_data);

1822: and (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1823: l_duty_station := 'O';
1824: END IF;
1825:
1826: GHR_HISTORY_FETCH.fetch_peopleei(l_person_id,'GHR_US_PER_SF52',p_rpt_date,l_people_hist_data);
1827: l_citizenship := l_people_hist_data.pei_information3;
1828:
1829: GHR_HISTORY_FETCH.fetch_positionei(l_position_id,'GHR_US_POS_GRP2',p_rpt_date,
1830: l_pos_hist_data );

Line 1829: GHR_HISTORY_FETCH.fetch_positionei(l_position_id,'GHR_US_POS_GRP2',p_rpt_date,

1825:
1826: GHR_HISTORY_FETCH.fetch_peopleei(l_person_id,'GHR_US_PER_SF52',p_rpt_date,l_people_hist_data);
1827: l_citizenship := l_people_hist_data.pei_information3;
1828:
1829: GHR_HISTORY_FETCH.fetch_positionei(l_position_id,'GHR_US_POS_GRP2',p_rpt_date,
1830: l_pos_hist_data );
1831: l_position_code := l_pos_hist_data.poei_information3;
1832:
1833: hr_utility.set_location('l_person_id is ' || l_person_id ,3);