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.

[Home] [Help]

APPS.GHR_SF113_A dependencies on GHR_HISTORY_FETCH

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

551: and (l_duty_station_code >= '00' and l_duty_station_code <= '99')
552: THEN
553: l_duty_station := 'O';
554: END IF;
555: GHR_HISTORY_FETCH.fetch_asgei(l_assignment_id,'GHR_US_ASG_SF52',p_rpt_date,
556: l_asgn_hist_data);
557: l_tenure := L_ASGN_HIST_DATA.AEI_INFORMATION4;
558: l_work_schedule := L_ASGN_HIST_DATA.AEI_INFORMATION7;
559:

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

558: l_work_schedule := L_ASGN_HIST_DATA.AEI_INFORMATION7;
559:
560: FOR c_chk_ast_status IN chk_susp_asg_status
561: LOOP
562: GHR_HISTORY_FETCH.fetch_asgei(l_assignment_id,'GHR_US_ASG_NTE_DATES',p_rpt_date, l_asgn_hist_data);
563: l_lwop_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information6);
564: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);
565: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
566: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);

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

571: (nvl(l_furlough_nte_date,p_empl_as_of_date) > p_empl_as_of_date + 30 ) then
572: l_susp_flag := 'Y';
573: END IF;
574: END LOOP;
575: GHR_HISTORY_FETCH.fetch_peopleei(l_person_id,'GHR_US_PER_SF52',
576: p_rpt_date,l_people_hist_data);
577: l_citizenship := l_people_hist_data.pei_information3;
578:
579: GHR_HISTORY_FETCH.fetch_peopleei(l_person_id,'GHR_US_PER_GROUP1',p_rpt_date,

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

575: GHR_HISTORY_FETCH.fetch_peopleei(l_person_id,'GHR_US_PER_SF52',
576: p_rpt_date,l_people_hist_data);
577: l_citizenship := l_people_hist_data.pei_information3;
578:
579: GHR_HISTORY_FETCH.fetch_peopleei(l_person_id,'GHR_US_PER_GROUP1',p_rpt_date,
580: l_people_hist_data);
581: l_emp_type := l_people_hist_data.pei_information4;
582: l_appointment := l_people_hist_data.pei_information3;
583: l_cur_appt1 := l_people_hist_data.pei_information8;

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

583: l_cur_appt1 := l_people_hist_data.pei_information8;
584: l_cur_appt2 := l_people_hist_data.pei_information9;
585:
586: -- Use Assignment Work Schedule Not Position.
587: --GHR_HISTORY_FETCH.fetch_positionei(l_position_id,'GHR_US_POS_GRP1',p_rpt_date,l_pos_hist_data);
588: --l_work_schedule := l_pos_hist_data. poei_information10;
589:
590: GHR_HISTORY_FETCH.fetch_positionei(l_position_id,'GHR_US_POS_GRP2',p_rpt_date,
591: l_pos_hist_data );

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

586: -- Use Assignment Work Schedule Not Position.
587: --GHR_HISTORY_FETCH.fetch_positionei(l_position_id,'GHR_US_POS_GRP1',p_rpt_date,l_pos_hist_data);
588: --l_work_schedule := l_pos_hist_data. poei_information10;
589:
590: GHR_HISTORY_FETCH.fetch_positionei(l_position_id,'GHR_US_POS_GRP2',p_rpt_date,
591: l_pos_hist_data );
592: l_position_code := l_pos_hist_data.poei_information3;
593: hr_utility.set_location('l_susp_flag is ' || l_susp_flag ,2);
594: hr_utility.set_location('l_assignment_id is ' || l_assignment_id ,3);

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

1635:
1636: l_susp_flag := 'N';
1637: FOR c_chk_ast_status IN chk_susp_asg_status
1638: LOOP
1639: GHR_HISTORY_FETCH.fetch_asgei(l_assignment_id,'GHR_US_ASG_NTE_DATES',p_rpt_date, l_asgn_hist_data);
1640: l_lwop_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information6);
1641: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);
1642: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
1643:

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

1680: AND (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1681: l_duty_station := 'O';
1682: END IF;
1683:
1684: GHR_HISTORY_FETCH.fetch_peopleei(l_person_id,'GHR_US_PER_SF52',
1685: p_rpt_date,l_people_hist_data);
1686:
1687: l_citizenship := l_people_hist_data.pei_information3;
1688:

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

1791: and (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1792: l_duty_station := 'O';
1793: END IF;
1794:
1795: GHR_HISTORY_FETCH.fetch_peopleei(l_person_id,'GHR_US_PER_SF52',p_rpt_date,l_people_hist_data);
1796: l_citizenship := l_people_hist_data.pei_information3;
1797:
1798: GHR_HISTORY_FETCH.fetch_positionei(l_position_id,'GHR_US_POS_GRP2',p_rpt_date,
1799: l_pos_hist_data );

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

1794:
1795: GHR_HISTORY_FETCH.fetch_peopleei(l_person_id,'GHR_US_PER_SF52',p_rpt_date,l_people_hist_data);
1796: l_citizenship := l_people_hist_data.pei_information3;
1797:
1798: GHR_HISTORY_FETCH.fetch_positionei(l_position_id,'GHR_US_POS_GRP2',p_rpt_date,
1799: l_pos_hist_data );
1800: l_position_code := l_pos_hist_data.poei_information3;
1801:
1802: hr_utility.set_location('l_person_id is ' || l_person_id ,3);