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_MRE_PKG dependencies on PER_POSITION_EXTRA_INFO

Line 426: l_pos_ei_data per_position_extra_info%rowtype;

422: l_errbuf VARCHAR2(2000);
423:
424: l_retcode NUMBER;
425:
426: l_pos_ei_data per_position_extra_info%rowtype;
427: l_pos_valid_grade_ei_data per_position_extra_info%rowtype;
428: l_pos_grp1_rec per_position_extra_info%rowtype;
429: --l_pos_grp2_rec per_position_extra_info%rowtype;
430:

Line 427: l_pos_valid_grade_ei_data per_position_extra_info%rowtype;

423:
424: l_retcode NUMBER;
425:
426: l_pos_ei_data per_position_extra_info%rowtype;
427: l_pos_valid_grade_ei_data per_position_extra_info%rowtype;
428: l_pos_grp1_rec per_position_extra_info%rowtype;
429: --l_pos_grp2_rec per_position_extra_info%rowtype;
430:
431: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;

Line 428: l_pos_grp1_rec per_position_extra_info%rowtype;

424: l_retcode NUMBER;
425:
426: l_pos_ei_data per_position_extra_info%rowtype;
427: l_pos_valid_grade_ei_data per_position_extra_info%rowtype;
428: l_pos_grp1_rec per_position_extra_info%rowtype;
429: --l_pos_grp2_rec per_position_extra_info%rowtype;
430:
431: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
432: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;

Line 429: --l_pos_grp2_rec per_position_extra_info%rowtype;

425:
426: l_pos_ei_data per_position_extra_info%rowtype;
427: l_pos_valid_grade_ei_data per_position_extra_info%rowtype;
428: l_pos_grp1_rec per_position_extra_info%rowtype;
429: --l_pos_grp2_rec per_position_extra_info%rowtype;
430:
431: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
432: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
433: l_sel_flg VARCHAR2(2);

Line 1652: l_pos_ei_data_rec per_position_extra_info%rowtype;

1648:
1649: l_new_position_id hr_positions_f.position_id%TYPE;
1650: l_position_data_rec ghr_sf52_pos_UPDATE.position_data_rec_type;
1651:
1652: l_pos_ei_data_rec per_position_extra_info%rowtype;
1653: l_new_pos_grp1_rec per_position_extra_info%rowtype;
1654:
1655: l_target_personnel_office_id per_position_extra_info.poei_information1%TYPE;
1656: l_target_agency_code per_position_extra_info.poei_information1%TYPE;

Line 1653: l_new_pos_grp1_rec per_position_extra_info%rowtype;

1649: l_new_position_id hr_positions_f.position_id%TYPE;
1650: l_position_data_rec ghr_sf52_pos_UPDATE.position_data_rec_type;
1651:
1652: l_pos_ei_data_rec per_position_extra_info%rowtype;
1653: l_new_pos_grp1_rec per_position_extra_info%rowtype;
1654:
1655: l_target_personnel_office_id per_position_extra_info.poei_information1%TYPE;
1656: l_target_agency_code per_position_extra_info.poei_information1%TYPE;
1657: l_target_office_symbol per_position_extra_info.poei_information1%TYPE;

Line 1655: l_target_personnel_office_id per_position_extra_info.poei_information1%TYPE;

1651:
1652: l_pos_ei_data_rec per_position_extra_info%rowtype;
1653: l_new_pos_grp1_rec per_position_extra_info%rowtype;
1654:
1655: l_target_personnel_office_id per_position_extra_info.poei_information1%TYPE;
1656: l_target_agency_code per_position_extra_info.poei_information1%TYPE;
1657: l_target_office_symbol per_position_extra_info.poei_information1%TYPE;
1658: l_target_payroll_office_id per_position_extra_info.poei_information1%TYPE;
1659: l_target_org_func_code per_position_extra_info.poei_information1%TYPE;

Line 1656: l_target_agency_code per_position_extra_info.poei_information1%TYPE;

1652: l_pos_ei_data_rec per_position_extra_info%rowtype;
1653: l_new_pos_grp1_rec per_position_extra_info%rowtype;
1654:
1655: l_target_personnel_office_id per_position_extra_info.poei_information1%TYPE;
1656: l_target_agency_code per_position_extra_info.poei_information1%TYPE;
1657: l_target_office_symbol per_position_extra_info.poei_information1%TYPE;
1658: l_target_payroll_office_id per_position_extra_info.poei_information1%TYPE;
1659: l_target_org_func_code per_position_extra_info.poei_information1%TYPE;
1660: l_target_appropriation_code1 per_position_extra_info.poei_information1%TYPE;

Line 1657: l_target_office_symbol per_position_extra_info.poei_information1%TYPE;

1653: l_new_pos_grp1_rec per_position_extra_info%rowtype;
1654:
1655: l_target_personnel_office_id per_position_extra_info.poei_information1%TYPE;
1656: l_target_agency_code per_position_extra_info.poei_information1%TYPE;
1657: l_target_office_symbol per_position_extra_info.poei_information1%TYPE;
1658: l_target_payroll_office_id per_position_extra_info.poei_information1%TYPE;
1659: l_target_org_func_code per_position_extra_info.poei_information1%TYPE;
1660: l_target_appropriation_code1 per_position_extra_info.poei_information1%TYPE;
1661: l_target_appropriation_code2 per_position_extra_info.poei_information1%TYPE;

Line 1658: l_target_payroll_office_id per_position_extra_info.poei_information1%TYPE;

1654:
1655: l_target_personnel_office_id per_position_extra_info.poei_information1%TYPE;
1656: l_target_agency_code per_position_extra_info.poei_information1%TYPE;
1657: l_target_office_symbol per_position_extra_info.poei_information1%TYPE;
1658: l_target_payroll_office_id per_position_extra_info.poei_information1%TYPE;
1659: l_target_org_func_code per_position_extra_info.poei_information1%TYPE;
1660: l_target_appropriation_code1 per_position_extra_info.poei_information1%TYPE;
1661: l_target_appropriation_code2 per_position_extra_info.poei_information1%TYPE;
1662: l_target_position_organization per_position_extra_info.poei_information1%TYPE;

Line 1659: l_target_org_func_code per_position_extra_info.poei_information1%TYPE;

1655: l_target_personnel_office_id per_position_extra_info.poei_information1%TYPE;
1656: l_target_agency_code per_position_extra_info.poei_information1%TYPE;
1657: l_target_office_symbol per_position_extra_info.poei_information1%TYPE;
1658: l_target_payroll_office_id per_position_extra_info.poei_information1%TYPE;
1659: l_target_org_func_code per_position_extra_info.poei_information1%TYPE;
1660: l_target_appropriation_code1 per_position_extra_info.poei_information1%TYPE;
1661: l_target_appropriation_code2 per_position_extra_info.poei_information1%TYPE;
1662: l_target_position_organization per_position_extra_info.poei_information1%TYPE;
1663: -- We don't need Duty Station for vacant positions

Line 1660: l_target_appropriation_code1 per_position_extra_info.poei_information1%TYPE;

1656: l_target_agency_code per_position_extra_info.poei_information1%TYPE;
1657: l_target_office_symbol per_position_extra_info.poei_information1%TYPE;
1658: l_target_payroll_office_id per_position_extra_info.poei_information1%TYPE;
1659: l_target_org_func_code per_position_extra_info.poei_information1%TYPE;
1660: l_target_appropriation_code1 per_position_extra_info.poei_information1%TYPE;
1661: l_target_appropriation_code2 per_position_extra_info.poei_information1%TYPE;
1662: l_target_position_organization per_position_extra_info.poei_information1%TYPE;
1663: -- We don't need Duty Station for vacant positions
1664: l_target_dummy1 per_position_extra_info.poei_information1%TYPE;

Line 1661: l_target_appropriation_code2 per_position_extra_info.poei_information1%TYPE;

1657: l_target_office_symbol per_position_extra_info.poei_information1%TYPE;
1658: l_target_payroll_office_id per_position_extra_info.poei_information1%TYPE;
1659: l_target_org_func_code per_position_extra_info.poei_information1%TYPE;
1660: l_target_appropriation_code1 per_position_extra_info.poei_information1%TYPE;
1661: l_target_appropriation_code2 per_position_extra_info.poei_information1%TYPE;
1662: l_target_position_organization per_position_extra_info.poei_information1%TYPE;
1663: -- We don't need Duty Station for vacant positions
1664: l_target_dummy1 per_position_extra_info.poei_information1%TYPE;
1665: l_target_dummy2 per_position_extra_info.poei_information1%TYPE;

Line 1662: l_target_position_organization per_position_extra_info.poei_information1%TYPE;

1658: l_target_payroll_office_id per_position_extra_info.poei_information1%TYPE;
1659: l_target_org_func_code per_position_extra_info.poei_information1%TYPE;
1660: l_target_appropriation_code1 per_position_extra_info.poei_information1%TYPE;
1661: l_target_appropriation_code2 per_position_extra_info.poei_information1%TYPE;
1662: l_target_position_organization per_position_extra_info.poei_information1%TYPE;
1663: -- We don't need Duty Station for vacant positions
1664: l_target_dummy1 per_position_extra_info.poei_information1%TYPE;
1665: l_target_dummy2 per_position_extra_info.poei_information1%TYPE;
1666: --Begin Bug# 4648802

Line 1664: l_target_dummy1 per_position_extra_info.poei_information1%TYPE;

1660: l_target_appropriation_code1 per_position_extra_info.poei_information1%TYPE;
1661: l_target_appropriation_code2 per_position_extra_info.poei_information1%TYPE;
1662: l_target_position_organization per_position_extra_info.poei_information1%TYPE;
1663: -- We don't need Duty Station for vacant positions
1664: l_target_dummy1 per_position_extra_info.poei_information1%TYPE;
1665: l_target_dummy2 per_position_extra_info.poei_information1%TYPE;
1666: --Begin Bug# 4648802
1667: l_target_dummy3 per_position_extra_info.poei_information1%TYPE;
1668: --End Bug# 4648802

Line 1665: l_target_dummy2 per_position_extra_info.poei_information1%TYPE;

1661: l_target_appropriation_code2 per_position_extra_info.poei_information1%TYPE;
1662: l_target_position_organization per_position_extra_info.poei_information1%TYPE;
1663: -- We don't need Duty Station for vacant positions
1664: l_target_dummy1 per_position_extra_info.poei_information1%TYPE;
1665: l_target_dummy2 per_position_extra_info.poei_information1%TYPE;
1666: --Begin Bug# 4648802
1667: l_target_dummy3 per_position_extra_info.poei_information1%TYPE;
1668: --End Bug# 4648802
1669: l_pos_business_group_id NUMBER;

Line 1667: l_target_dummy3 per_position_extra_info.poei_information1%TYPE;

1663: -- We don't need Duty Station for vacant positions
1664: l_target_dummy1 per_position_extra_info.poei_information1%TYPE;
1665: l_target_dummy2 per_position_extra_info.poei_information1%TYPE;
1666: --Begin Bug# 4648802
1667: l_target_dummy3 per_position_extra_info.poei_information1%TYPE;
1668: --End Bug# 4648802
1669: l_pos_business_group_id NUMBER;
1670: l_target_duty_station_locn_id NUMBER(15); -- Bug 3490826
1671: BEGIN

Line 2232: l_pos_ei_data per_position_extra_info%rowtype;

2228: p_mre_id in NUMBER) is
2229:
2230: l_position_extra_info_id NUMBER;
2231: l_object_version_NUMBER NUMBER;
2232: l_pos_ei_data per_position_extra_info%rowtype;
2233:
2234: CURSOR position_ext_cur (position NUMBER) is
2235: SELECT position_extra_info_id, object_version_NUMBER
2236: FROM PER_POSITION_EXTRA_INFO

Line 2236: FROM PER_POSITION_EXTRA_INFO

2232: l_pos_ei_data per_position_extra_info%rowtype;
2233:
2234: CURSOR position_ext_cur (position NUMBER) is
2235: SELECT position_extra_info_id, object_version_NUMBER
2236: FROM PER_POSITION_EXTRA_INFO
2237: WHERE POSITION_ID = position
2238: and information_type = 'GHR_US_POS_MASS_ACTIONS';
2239:
2240: l_proc VARCHAR2(72) := g_package || '.ins_upd_pos_extra_info';

Line 2388: l_pos_ei_data per_position_extra_info%rowtype;

2384: procedure UPDATE_sel_flg (p_position_id in NUMBER,p_effective_DATE in DATE) is
2385:
2386: l_position_extra_info_id NUMBER;
2387: l_object_version_NUMBER NUMBER;
2388: l_pos_ei_data per_position_extra_info%rowtype;
2389: l_proc VARCHAR2(72) := g_package || '.UPDATE_sel_flg';
2390: l_eff_DATE DATE;
2391: BEGIN
2392: g_proc := 'UPDATE_sel_flg';

Line 2677: per_position_extra_info%rowtype)

2673: p_org_structure_id out NOCOPY VARCHAR2,
2674: p_office_symbol out NOCOPY VARCHAR2,
2675: p_position_organization out NOCOPY VARCHAR2,
2676: p_pos_ei_data OUT NOCOPY
2677: per_position_extra_info%rowtype)
2678: IS
2679:
2680: l_proc VARCHAR2(72)
2681: := g_package || '.get_pos_grp1_ddf';

Line 2682: --l_pos_ei_data per_position_extra_info%type;

2678: IS
2679:
2680: l_proc VARCHAR2(72)
2681: := g_package || '.get_pos_grp1_ddf';
2682: --l_pos_ei_data per_position_extra_info%type;
2683:
2684: BEGIN
2685: g_proc := 'get_pos_grp1_ddf';
2686:

Line 2727: --- p_pos_ei_data OUT per_position_extra_info%rowtype)

2723: p_effective_DATE in DATE,
2724: p_org_func_code out NOCOPY VARCHAR2,
2725: p_appropriation_code1 out NOCOPY VARCHAR2,
2726: p_appropriation_code2 out NOCOPY VARCHAR2)
2727: --- p_pos_ei_data OUT per_position_extra_info%rowtype)
2728: IS
2729:
2730: l_proc VARCHAR2(72)
2731: := g_package || '.get_pos_grp2_ddf';

Line 2732: l_pos_ei_data per_position_extra_info%rowtype;

2728: IS
2729:
2730: l_proc VARCHAR2(72)
2731: := g_package || '.get_pos_grp2_ddf';
2732: l_pos_ei_data per_position_extra_info%rowtype;
2733:
2734: BEGIN
2735: g_proc := 'get_pos_grp2_ddf';
2736: hr_utility.set_location('Entering ' || l_proc,5);

Line 2948: l_pos_ei_data per_position_extra_info%rowtype;

2944:
2945: l_sel_flag VARCHAR2(30);
2946: l_comments VARCHAR2(4000);
2947: l_mre_id NUMBER;
2948: l_pos_ei_data per_position_extra_info%rowtype;
2949: l_proc VARCHAR2(72) := g_package || '.get_extra_info_comments';
2950: l_eff_DATE DATE;
2951: l_char_mre_id VARCHAR2(30);
2952:

Line 3376: from per_position_extra_info

3372: POEI_INFORMATION11,
3373: POEI_INFORMATION12,
3374: POEI_INFORMATION13
3375: POEI_INFORMATION18
3376: from per_position_extra_info
3377: WHERE position_id = (position)
3378: and INFORMATION_TYPE = 'GHR_US_POS_MASS_ACTIONS';
3379: */
3380:

Line 3421: l_pos_ei_data per_position_extra_info%rowtype;

3417: ll_appropriation_code1 VARCHAR2(30);
3418: ll_appropriation_code2 VARCHAR2(30);
3419: ll_position_org VARCHAR2(240);
3420:
3421: l_pos_ei_data per_position_extra_info%rowtype;
3422: l_eff_DATE DATE;
3423:
3424: BEGIN
3425: g_proc := 'get_new_org_dtls';

Line 3719: from per_position_extra_info

3715: procedure upd_ext_info_to_null(p_position_id in NUMBER, p_effective_DATE in DATE) is
3716:
3717: CURSOR POSITION_EXT_CUR (p_position NUMBER) IS
3718: SELECT position_extra_info_id, object_version_NUMBER
3719: from per_position_extra_info
3720: WHERE position_id = (p_position)
3721: and INFORMATION_TYPE = 'GHR_US_POS_MASS_ACTIONS';
3722:
3723: l_Position_EXTRA_INFO_ID NUMBER;

Line 3727: l_pos_ei_data per_position_extra_info%rowtype;

3723: l_Position_EXTRA_INFO_ID NUMBER;
3724: l_OBJECT_VERSION_NUMBER NUMBER;
3725: l_eff_DATE DATE;
3726:
3727: l_pos_ei_data per_position_extra_info%rowtype;
3728: l_proc VARCHAR2(72) := g_package || '.upd_ext_info_api';
3729: BEGIN
3730:
3731: g_proc := 'upd_ext_info_to_null';

Line 3804: from per_position_extra_info

3800: info18 in VARCHAR2,
3801: p_effective_DATE in DATE) IS
3802: CURSOR POSITION_EXT_CUR (p_position NUMBER) IS
3803: SELECT position_extra_info_id, object_version_NUMBER
3804: from per_position_extra_info
3805: WHERE position_id = (p_position)
3806: and INFORMATION_TYPE = 'GHR_US_POS_MASS_ACTIONS';
3807:
3808: l_cnt NUMBER;

Line 3812: l_pos_ei_data per_position_extra_info%rowtype;

3808: l_cnt NUMBER;
3809: l_Position_EXTRA_INFO_ID NUMBER;
3810: l_OBJECT_VERSION_NUMBER NUMBER;
3811:
3812: l_pos_ei_data per_position_extra_info%rowtype;
3813: l_proc VARCHAR2(72) := g_package || '.upd_ext_info_api';
3814: l_eff_DATE DATE;
3815:
3816: BEGIN