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

Line 432: l_pos_ei_data per_position_extra_info%rowtype;

428: l_errbuf VARCHAR2(2000);
429:
430: l_retcode NUMBER;
431:
432: l_pos_ei_data per_position_extra_info%rowtype;
433: l_pos_valid_grade_ei_data per_position_extra_info%rowtype;
434: l_pos_grp1_rec per_position_extra_info%rowtype;
435: --l_pos_grp2_rec per_position_extra_info%rowtype;
436:

Line 433: l_pos_valid_grade_ei_data per_position_extra_info%rowtype;

429:
430: l_retcode NUMBER;
431:
432: l_pos_ei_data per_position_extra_info%rowtype;
433: l_pos_valid_grade_ei_data per_position_extra_info%rowtype;
434: l_pos_grp1_rec per_position_extra_info%rowtype;
435: --l_pos_grp2_rec per_position_extra_info%rowtype;
436:
437: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;

Line 434: l_pos_grp1_rec per_position_extra_info%rowtype;

430: l_retcode NUMBER;
431:
432: l_pos_ei_data per_position_extra_info%rowtype;
433: l_pos_valid_grade_ei_data per_position_extra_info%rowtype;
434: l_pos_grp1_rec per_position_extra_info%rowtype;
435: --l_pos_grp2_rec per_position_extra_info%rowtype;
436:
437: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
438: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;

Line 435: --l_pos_grp2_rec per_position_extra_info%rowtype;

431:
432: l_pos_ei_data per_position_extra_info%rowtype;
433: l_pos_valid_grade_ei_data per_position_extra_info%rowtype;
434: l_pos_grp1_rec per_position_extra_info%rowtype;
435: --l_pos_grp2_rec per_position_extra_info%rowtype;
436:
437: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
438: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
439: l_sel_flg VARCHAR2(2);

Line 1682: l_pos_ei_data_rec per_position_extra_info%rowtype;

1678:
1679: DECLARE
1680: l_new_position_id hr_positions_f.position_id%TYPE;
1681: l_position_data_rec ghr_sf52_pos_UPDATE.position_data_rec_type;
1682: l_pos_ei_data_rec per_position_extra_info%rowtype;
1683: l_new_pos_grp1_rec per_position_extra_info%rowtype;
1684: l_target_personnel_office_id per_position_extra_info.poei_information1%TYPE;
1685: l_target_agency_code per_position_extra_info.poei_information1%TYPE;
1686: l_target_office_symbol per_position_extra_info.poei_information1%TYPE;

Line 1683: l_new_pos_grp1_rec per_position_extra_info%rowtype;

1679: DECLARE
1680: l_new_position_id hr_positions_f.position_id%TYPE;
1681: l_position_data_rec ghr_sf52_pos_UPDATE.position_data_rec_type;
1682: l_pos_ei_data_rec per_position_extra_info%rowtype;
1683: l_new_pos_grp1_rec per_position_extra_info%rowtype;
1684: l_target_personnel_office_id per_position_extra_info.poei_information1%TYPE;
1685: l_target_agency_code per_position_extra_info.poei_information1%TYPE;
1686: l_target_office_symbol per_position_extra_info.poei_information1%TYPE;
1687: l_target_payroll_office_id per_position_extra_info.poei_information1%TYPE;

Line 1684: l_target_personnel_office_id per_position_extra_info.poei_information1%TYPE;

1680: l_new_position_id hr_positions_f.position_id%TYPE;
1681: l_position_data_rec ghr_sf52_pos_UPDATE.position_data_rec_type;
1682: l_pos_ei_data_rec per_position_extra_info%rowtype;
1683: l_new_pos_grp1_rec per_position_extra_info%rowtype;
1684: l_target_personnel_office_id per_position_extra_info.poei_information1%TYPE;
1685: l_target_agency_code per_position_extra_info.poei_information1%TYPE;
1686: l_target_office_symbol per_position_extra_info.poei_information1%TYPE;
1687: l_target_payroll_office_id per_position_extra_info.poei_information1%TYPE;
1688: l_target_org_func_code per_position_extra_info.poei_information1%TYPE;

Line 1685: l_target_agency_code per_position_extra_info.poei_information1%TYPE;

1681: l_position_data_rec ghr_sf52_pos_UPDATE.position_data_rec_type;
1682: l_pos_ei_data_rec per_position_extra_info%rowtype;
1683: l_new_pos_grp1_rec per_position_extra_info%rowtype;
1684: l_target_personnel_office_id per_position_extra_info.poei_information1%TYPE;
1685: l_target_agency_code per_position_extra_info.poei_information1%TYPE;
1686: l_target_office_symbol per_position_extra_info.poei_information1%TYPE;
1687: l_target_payroll_office_id per_position_extra_info.poei_information1%TYPE;
1688: l_target_org_func_code per_position_extra_info.poei_information1%TYPE;
1689: l_target_appropriation_code1 per_position_extra_info.poei_information1%TYPE;

Line 1686: l_target_office_symbol per_position_extra_info.poei_information1%TYPE;

1682: l_pos_ei_data_rec per_position_extra_info%rowtype;
1683: l_new_pos_grp1_rec per_position_extra_info%rowtype;
1684: l_target_personnel_office_id per_position_extra_info.poei_information1%TYPE;
1685: l_target_agency_code per_position_extra_info.poei_information1%TYPE;
1686: l_target_office_symbol per_position_extra_info.poei_information1%TYPE;
1687: l_target_payroll_office_id per_position_extra_info.poei_information1%TYPE;
1688: l_target_org_func_code per_position_extra_info.poei_information1%TYPE;
1689: l_target_appropriation_code1 per_position_extra_info.poei_information1%TYPE;
1690: l_target_appropriation_code2 per_position_extra_info.poei_information1%TYPE;

Line 1687: l_target_payroll_office_id per_position_extra_info.poei_information1%TYPE;

1683: l_new_pos_grp1_rec per_position_extra_info%rowtype;
1684: l_target_personnel_office_id per_position_extra_info.poei_information1%TYPE;
1685: l_target_agency_code per_position_extra_info.poei_information1%TYPE;
1686: l_target_office_symbol per_position_extra_info.poei_information1%TYPE;
1687: l_target_payroll_office_id per_position_extra_info.poei_information1%TYPE;
1688: l_target_org_func_code per_position_extra_info.poei_information1%TYPE;
1689: l_target_appropriation_code1 per_position_extra_info.poei_information1%TYPE;
1690: l_target_appropriation_code2 per_position_extra_info.poei_information1%TYPE;
1691: l_target_position_organization per_position_extra_info.poei_information1%TYPE;

Line 1688: l_target_org_func_code per_position_extra_info.poei_information1%TYPE;

1684: l_target_personnel_office_id per_position_extra_info.poei_information1%TYPE;
1685: l_target_agency_code per_position_extra_info.poei_information1%TYPE;
1686: l_target_office_symbol per_position_extra_info.poei_information1%TYPE;
1687: l_target_payroll_office_id per_position_extra_info.poei_information1%TYPE;
1688: l_target_org_func_code per_position_extra_info.poei_information1%TYPE;
1689: l_target_appropriation_code1 per_position_extra_info.poei_information1%TYPE;
1690: l_target_appropriation_code2 per_position_extra_info.poei_information1%TYPE;
1691: l_target_position_organization per_position_extra_info.poei_information1%TYPE;
1692: -- We don't need Duty Station for vacant positions

Line 1689: l_target_appropriation_code1 per_position_extra_info.poei_information1%TYPE;

1685: l_target_agency_code per_position_extra_info.poei_information1%TYPE;
1686: l_target_office_symbol per_position_extra_info.poei_information1%TYPE;
1687: l_target_payroll_office_id per_position_extra_info.poei_information1%TYPE;
1688: l_target_org_func_code per_position_extra_info.poei_information1%TYPE;
1689: l_target_appropriation_code1 per_position_extra_info.poei_information1%TYPE;
1690: l_target_appropriation_code2 per_position_extra_info.poei_information1%TYPE;
1691: l_target_position_organization per_position_extra_info.poei_information1%TYPE;
1692: -- We don't need Duty Station for vacant positions
1693: l_target_dummy1 per_position_extra_info.poei_information1%TYPE;

Line 1690: l_target_appropriation_code2 per_position_extra_info.poei_information1%TYPE;

1686: l_target_office_symbol per_position_extra_info.poei_information1%TYPE;
1687: l_target_payroll_office_id per_position_extra_info.poei_information1%TYPE;
1688: l_target_org_func_code per_position_extra_info.poei_information1%TYPE;
1689: l_target_appropriation_code1 per_position_extra_info.poei_information1%TYPE;
1690: l_target_appropriation_code2 per_position_extra_info.poei_information1%TYPE;
1691: l_target_position_organization per_position_extra_info.poei_information1%TYPE;
1692: -- We don't need Duty Station for vacant positions
1693: l_target_dummy1 per_position_extra_info.poei_information1%TYPE;
1694: l_target_dummy2 per_position_extra_info.poei_information1%TYPE;

Line 1691: l_target_position_organization per_position_extra_info.poei_information1%TYPE;

1687: l_target_payroll_office_id per_position_extra_info.poei_information1%TYPE;
1688: l_target_org_func_code per_position_extra_info.poei_information1%TYPE;
1689: l_target_appropriation_code1 per_position_extra_info.poei_information1%TYPE;
1690: l_target_appropriation_code2 per_position_extra_info.poei_information1%TYPE;
1691: l_target_position_organization per_position_extra_info.poei_information1%TYPE;
1692: -- We don't need Duty Station for vacant positions
1693: l_target_dummy1 per_position_extra_info.poei_information1%TYPE;
1694: l_target_dummy2 per_position_extra_info.poei_information1%TYPE;
1695: --Begin Bug# 4648802

Line 1693: l_target_dummy1 per_position_extra_info.poei_information1%TYPE;

1689: l_target_appropriation_code1 per_position_extra_info.poei_information1%TYPE;
1690: l_target_appropriation_code2 per_position_extra_info.poei_information1%TYPE;
1691: l_target_position_organization per_position_extra_info.poei_information1%TYPE;
1692: -- We don't need Duty Station for vacant positions
1693: l_target_dummy1 per_position_extra_info.poei_information1%TYPE;
1694: l_target_dummy2 per_position_extra_info.poei_information1%TYPE;
1695: --Begin Bug# 4648802
1696: l_target_dummy3 per_position_extra_info.poei_information1%TYPE;
1697: --End Bug# 4648802

Line 1694: l_target_dummy2 per_position_extra_info.poei_information1%TYPE;

1690: l_target_appropriation_code2 per_position_extra_info.poei_information1%TYPE;
1691: l_target_position_organization per_position_extra_info.poei_information1%TYPE;
1692: -- We don't need Duty Station for vacant positions
1693: l_target_dummy1 per_position_extra_info.poei_information1%TYPE;
1694: l_target_dummy2 per_position_extra_info.poei_information1%TYPE;
1695: --Begin Bug# 4648802
1696: l_target_dummy3 per_position_extra_info.poei_information1%TYPE;
1697: --End Bug# 4648802
1698: l_pos_business_group_id NUMBER;

Line 1696: l_target_dummy3 per_position_extra_info.poei_information1%TYPE;

1692: -- We don't need Duty Station for vacant positions
1693: l_target_dummy1 per_position_extra_info.poei_information1%TYPE;
1694: l_target_dummy2 per_position_extra_info.poei_information1%TYPE;
1695: --Begin Bug# 4648802
1696: l_target_dummy3 per_position_extra_info.poei_information1%TYPE;
1697: --End Bug# 4648802
1698: l_pos_business_group_id NUMBER;
1699: l_target_duty_station_locn_id NUMBER(15); -- Bug 3490826
1700:

Line 2382: l_pos_ei_data per_position_extra_info%rowtype;

2378: p_mre_id in NUMBER) is
2379:
2380: l_position_extra_info_id NUMBER;
2381: l_object_version_NUMBER NUMBER;
2382: l_pos_ei_data per_position_extra_info%rowtype;
2383:
2384: CURSOR position_ext_cur (position NUMBER) is
2385: SELECT position_extra_info_id, object_version_NUMBER
2386: FROM PER_POSITION_EXTRA_INFO

Line 2386: FROM PER_POSITION_EXTRA_INFO

2382: l_pos_ei_data per_position_extra_info%rowtype;
2383:
2384: CURSOR position_ext_cur (position NUMBER) is
2385: SELECT position_extra_info_id, object_version_NUMBER
2386: FROM PER_POSITION_EXTRA_INFO
2387: WHERE POSITION_ID = position
2388: and information_type = 'GHR_US_POS_MASS_ACTIONS';
2389:
2390: l_proc VARCHAR2(72) := g_package || '.ins_upd_pos_extra_info';

Line 2538: l_pos_ei_data per_position_extra_info%rowtype;

2534: procedure UPDATE_sel_flg (p_position_id in NUMBER,p_effective_DATE in DATE) is
2535:
2536: l_position_extra_info_id NUMBER;
2537: l_object_version_NUMBER NUMBER;
2538: l_pos_ei_data per_position_extra_info%rowtype;
2539: l_proc VARCHAR2(72) := g_package || '.UPDATE_sel_flg';
2540: l_eff_DATE DATE;
2541: BEGIN
2542: g_proc := 'UPDATE_sel_flg';

Line 2838: per_position_extra_info%rowtype)

2834: p_org_structure_id out NOCOPY VARCHAR2,
2835: p_office_symbol out NOCOPY VARCHAR2,
2836: p_position_organization out NOCOPY VARCHAR2,
2837: p_pos_ei_data OUT NOCOPY
2838: per_position_extra_info%rowtype)
2839: IS
2840:
2841: l_proc VARCHAR2(72)
2842: := g_package || '.get_pos_grp1_ddf';

Line 2843: --l_pos_ei_data per_position_extra_info%type;

2839: IS
2840:
2841: l_proc VARCHAR2(72)
2842: := g_package || '.get_pos_grp1_ddf';
2843: --l_pos_ei_data per_position_extra_info%type;
2844:
2845: BEGIN
2846: g_proc := 'get_pos_grp1_ddf';
2847:

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

2884: p_effective_DATE in DATE,
2885: p_org_func_code out NOCOPY VARCHAR2,
2886: p_appropriation_code1 out NOCOPY VARCHAR2,
2887: p_appropriation_code2 out NOCOPY VARCHAR2)
2888: --- p_pos_ei_data OUT per_position_extra_info%rowtype)
2889: IS
2890:
2891: l_proc VARCHAR2(72)
2892: := g_package || '.get_pos_grp2_ddf';

Line 2893: l_pos_ei_data per_position_extra_info%rowtype;

2889: IS
2890:
2891: l_proc VARCHAR2(72)
2892: := g_package || '.get_pos_grp2_ddf';
2893: l_pos_ei_data per_position_extra_info%rowtype;
2894:
2895: BEGIN
2896: g_proc := 'get_pos_grp2_ddf';
2897: hr_utility.set_location('Entering ' || l_proc,5);

Line 3109: l_pos_ei_data per_position_extra_info%rowtype;

3105:
3106: l_sel_flag VARCHAR2(30);
3107: l_comments VARCHAR2(4000);
3108: l_mre_id NUMBER;
3109: l_pos_ei_data per_position_extra_info%rowtype;
3110: l_proc VARCHAR2(72) := g_package || '.get_extra_info_comments';
3111: l_eff_DATE DATE;
3112: l_char_mre_id VARCHAR2(30);
3113:

Line 3543: from per_position_extra_info

3539: POEI_INFORMATION11,
3540: POEI_INFORMATION12,
3541: POEI_INFORMATION13
3542: POEI_INFORMATION18
3543: from per_position_extra_info
3544: WHERE position_id = (position)
3545: and INFORMATION_TYPE = 'GHR_US_POS_MASS_ACTIONS';
3546: */
3547:

Line 3588: l_pos_ei_data per_position_extra_info%rowtype;

3584: ll_appropriation_code1 VARCHAR2(30);
3585: ll_appropriation_code2 VARCHAR2(30);
3586: ll_position_org VARCHAR2(240);
3587:
3588: l_pos_ei_data per_position_extra_info%rowtype;
3589: l_eff_DATE DATE;
3590:
3591: BEGIN
3592: g_proc := 'get_new_org_dtls';

Line 3886: from per_position_extra_info

3882: procedure upd_ext_info_to_null(p_position_id in NUMBER, p_effective_DATE in DATE) is
3883:
3884: CURSOR POSITION_EXT_CUR (p_position NUMBER) IS
3885: SELECT position_extra_info_id, object_version_NUMBER
3886: from per_position_extra_info
3887: WHERE position_id = (p_position)
3888: and INFORMATION_TYPE = 'GHR_US_POS_MASS_ACTIONS';
3889:
3890: l_Position_EXTRA_INFO_ID NUMBER;

Line 3894: l_pos_ei_data per_position_extra_info%rowtype;

3890: l_Position_EXTRA_INFO_ID NUMBER;
3891: l_OBJECT_VERSION_NUMBER NUMBER;
3892: l_eff_DATE DATE;
3893:
3894: l_pos_ei_data per_position_extra_info%rowtype;
3895: l_proc VARCHAR2(72) := g_package || '.upd_ext_info_api';
3896: BEGIN
3897:
3898: g_proc := 'upd_ext_info_to_null';

Line 3971: from per_position_extra_info

3967: info18 in VARCHAR2,
3968: p_effective_DATE in DATE) IS
3969: CURSOR POSITION_EXT_CUR (p_position NUMBER) IS
3970: SELECT position_extra_info_id, object_version_NUMBER
3971: from per_position_extra_info
3972: WHERE position_id = (p_position)
3973: and INFORMATION_TYPE = 'GHR_US_POS_MASS_ACTIONS';
3974:
3975: l_cnt NUMBER;

Line 3979: l_pos_ei_data per_position_extra_info%rowtype;

3975: l_cnt NUMBER;
3976: l_Position_EXTRA_INFO_ID NUMBER;
3977: l_OBJECT_VERSION_NUMBER NUMBER;
3978:
3979: l_pos_ei_data per_position_extra_info%rowtype;
3980: l_proc VARCHAR2(72) := g_package || '.upd_ext_info_api';
3981: l_eff_DATE DATE;
3982:
3983: BEGIN