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

Line 473: l_pos_ei_data per_position_extra_info%rowtype;

469: l_errbuf varchar2(2000);
470:
471: l_retcode number;
472:
473: l_pos_ei_data per_position_extra_info%rowtype;
474: l_pos_grp1_rec per_position_extra_info%rowtype;
475: l_pos_grp2_rec per_position_extra_info%rowtype;
476:
477: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;

Line 474: l_pos_grp1_rec per_position_extra_info%rowtype;

470:
471: l_retcode number;
472:
473: l_pos_ei_data per_position_extra_info%rowtype;
474: l_pos_grp1_rec per_position_extra_info%rowtype;
475: l_pos_grp2_rec per_position_extra_info%rowtype;
476:
477: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
478: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;

Line 475: l_pos_grp2_rec per_position_extra_info%rowtype;

471: l_retcode number;
472:
473: l_pos_ei_data per_position_extra_info%rowtype;
474: l_pos_grp1_rec per_position_extra_info%rowtype;
475: l_pos_grp2_rec per_position_extra_info%rowtype;
476:
477: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
478: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
479: l_sel_flg varchar2(2);

Line 1765: l_pos_ei_data per_position_extra_info%rowtype;

1761: p_mtfr_id in number) is
1762:
1763: l_position_extra_info_id number;
1764: l_object_version_number number;
1765: l_pos_ei_data per_position_extra_info%rowtype;
1766:
1767: CURSOR position_ext_cur (position number) is
1768: SELECT position_extra_info_id, object_version_number
1769: FROM PER_POSITION_EXTRA_INFO

Line 1769: FROM PER_POSITION_EXTRA_INFO

1765: l_pos_ei_data per_position_extra_info%rowtype;
1766:
1767: CURSOR position_ext_cur (position number) is
1768: SELECT position_extra_info_id, object_version_number
1769: FROM PER_POSITION_EXTRA_INFO
1770: WHERE POSITION_ID = position
1771: and information_type = 'GHR_US_POS_MASS_ACTIONS';
1772:
1773: l_eff_date date;

Line 1861: l_pos_ei_data per_position_extra_info%rowtype;

1857: procedure update_sel_flg (p_position_id in number,p_effective_date in date) is
1858:
1859: l_position_extra_info_id number;
1860: l_object_version_number number;
1861: l_pos_ei_data per_position_extra_info%rowtype;
1862: l_eff_date date;
1863: l_proc varchar2(72)
1864: := g_package || '.update_sel_flg';
1865: begin

Line 2053: p_pos_ei_data OUT NOCOPY per_position_extra_info%rowtype)

2049: p_personnel_office_id out NOCOPY varchar2,
2050: p_org_structure_id out NOCOPY varchar2,
2051: p_office_symbol out NOCOPY varchar2,
2052: p_position_organization out NOCOPY varchar2,
2053: p_pos_ei_data OUT NOCOPY per_position_extra_info%rowtype)
2054: IS
2055:
2056: l_personnel_office_id per_position_Extra_info.poei_information3%type;
2057: l_org_structure_id per_position_Extra_info.poei_information5%type;

Line 2056: l_personnel_office_id per_position_Extra_info.poei_information3%type;

2052: p_position_organization out NOCOPY varchar2,
2053: p_pos_ei_data OUT NOCOPY per_position_extra_info%rowtype)
2054: IS
2055:
2056: l_personnel_office_id per_position_Extra_info.poei_information3%type;
2057: l_org_structure_id per_position_Extra_info.poei_information5%type;
2058: l_office_symbol per_position_Extra_info.poei_information4%type;
2059: l_position_organization per_position_Extra_info.POEI_INFORMATION21%type;
2060:

Line 2057: l_org_structure_id per_position_Extra_info.poei_information5%type;

2053: p_pos_ei_data OUT NOCOPY per_position_extra_info%rowtype)
2054: IS
2055:
2056: l_personnel_office_id per_position_Extra_info.poei_information3%type;
2057: l_org_structure_id per_position_Extra_info.poei_information5%type;
2058: l_office_symbol per_position_Extra_info.poei_information4%type;
2059: l_position_organization per_position_Extra_info.POEI_INFORMATION21%type;
2060:
2061: l_pos_ei_data per_position_extra_info%rowtype;

Line 2058: l_office_symbol per_position_Extra_info.poei_information4%type;

2054: IS
2055:
2056: l_personnel_office_id per_position_Extra_info.poei_information3%type;
2057: l_org_structure_id per_position_Extra_info.poei_information5%type;
2058: l_office_symbol per_position_Extra_info.poei_information4%type;
2059: l_position_organization per_position_Extra_info.POEI_INFORMATION21%type;
2060:
2061: l_pos_ei_data per_position_extra_info%rowtype;
2062:

Line 2059: l_position_organization per_position_Extra_info.POEI_INFORMATION21%type;

2055:
2056: l_personnel_office_id per_position_Extra_info.poei_information3%type;
2057: l_org_structure_id per_position_Extra_info.poei_information5%type;
2058: l_office_symbol per_position_Extra_info.poei_information4%type;
2059: l_position_organization per_position_Extra_info.POEI_INFORMATION21%type;
2060:
2061: l_pos_ei_data per_position_extra_info%rowtype;
2062:
2063: l_proc varchar2(72)

Line 2061: l_pos_ei_data per_position_extra_info%rowtype;

2057: l_org_structure_id per_position_Extra_info.poei_information5%type;
2058: l_office_symbol per_position_Extra_info.poei_information4%type;
2059: l_position_organization per_position_Extra_info.POEI_INFORMATION21%type;
2060:
2061: l_pos_ei_data per_position_extra_info%rowtype;
2062:
2063: l_proc varchar2(72)
2064: := g_package || '.get_pos_grp1_ddf';
2065: --l_pos_ei_data per_position_extra_info%type;

Line 2065: --l_pos_ei_data per_position_extra_info%type;

2061: l_pos_ei_data per_position_extra_info%rowtype;
2062:
2063: l_proc varchar2(72)
2064: := g_package || '.get_pos_grp1_ddf';
2065: --l_pos_ei_data per_position_extra_info%type;
2066:
2067: begin
2068: l_personnel_office_id := p_personnel_office_id;
2069: l_org_structure_id := p_org_structure_id;

Line 2120: p_pos_ei_data OUT NOCOPY per_position_extra_info%rowtype)

2116: p_effective_date in date,
2117: p_org_func_code out NOCOPY varchar2,
2118: p_appropriation_code1 out NOCOPY varchar2,
2119: p_appropriation_code2 out NOCOPY varchar2,
2120: p_pos_ei_data OUT NOCOPY per_position_extra_info%rowtype)
2121: IS
2122:
2123: l_proc varchar2(72)
2124: := g_package || '.get_pos_grp2_ddf';

Line 2126: l_org_func_code per_position_extra_info.POEI_INFORMATION4%type;

2122:
2123: l_proc varchar2(72)
2124: := g_package || '.get_pos_grp2_ddf';
2125:
2126: l_org_func_code per_position_extra_info.POEI_INFORMATION4%type;
2127: l_appropriation_code1 per_position_extra_info.POEI_INFORMATION13%type;
2128: l_appropriation_code2 per_position_extra_info.POEI_INFORMATION13%type;
2129: l_pos_ei_data per_position_extra_info%rowtype;
2130:

Line 2127: l_appropriation_code1 per_position_extra_info.POEI_INFORMATION13%type;

2123: l_proc varchar2(72)
2124: := g_package || '.get_pos_grp2_ddf';
2125:
2126: l_org_func_code per_position_extra_info.POEI_INFORMATION4%type;
2127: l_appropriation_code1 per_position_extra_info.POEI_INFORMATION13%type;
2128: l_appropriation_code2 per_position_extra_info.POEI_INFORMATION13%type;
2129: l_pos_ei_data per_position_extra_info%rowtype;
2130:
2131: begin

Line 2128: l_appropriation_code2 per_position_extra_info.POEI_INFORMATION13%type;

2124: := g_package || '.get_pos_grp2_ddf';
2125:
2126: l_org_func_code per_position_extra_info.POEI_INFORMATION4%type;
2127: l_appropriation_code1 per_position_extra_info.POEI_INFORMATION13%type;
2128: l_appropriation_code2 per_position_extra_info.POEI_INFORMATION13%type;
2129: l_pos_ei_data per_position_extra_info%rowtype;
2130:
2131: begin
2132:

Line 2129: l_pos_ei_data per_position_extra_info%rowtype;

2125:
2126: l_org_func_code per_position_extra_info.POEI_INFORMATION4%type;
2127: l_appropriation_code1 per_position_extra_info.POEI_INFORMATION13%type;
2128: l_appropriation_code2 per_position_extra_info.POEI_INFORMATION13%type;
2129: l_pos_ei_data per_position_extra_info%rowtype;
2130:
2131: begin
2132:
2133: l_org_func_code := p_org_func_code;

Line 2185: l_pos_ei_data per_position_extra_info%rowtype;

2181: p_sel_flag in out NOCOPY varchar2,
2182: p_comments in out NOCOPY varchar2,
2183: p_mtfr_id in out NOCOPY number) IS
2184:
2185: l_pos_ei_data per_position_extra_info%rowtype;
2186: l_proc varchar2(72) := g_package || '.get_extra_info_comments';
2187: l_eff_date date;
2188:
2189: l_sel_flag varchar2(5);

Line 2700: from per_position_extra_info

2696: procedure upd_ext_info_to_null(p_position_id in number) is
2697:
2698: CURSOR POSITION_EXT_CUR (p_position number) IS
2699: select position_extra_info_id, object_version_number
2700: from per_position_extra_info
2701: where position_id = (p_position)
2702: and INFORMATION_TYPE = 'GHR_US_POS_MASS_ACTIONS';
2703:
2704: l_Position_EXTRA_INFO_ID NUMBER;

Line 2707: l_pos_ei_data per_position_extra_info%rowtype;

2703:
2704: l_Position_EXTRA_INFO_ID NUMBER;
2705: l_OBJECT_VERSION_NUMBER NUMBER;
2706:
2707: l_pos_ei_data per_position_extra_info%rowtype;
2708: l_proc varchar2(72) := g_package || '.upd_ext_info_api';
2709: begin
2710:
2711: g_proc := 'upd_ext_info_to_null';