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 499: l_pos_ei_data per_position_extra_info%rowtype;

495: l_errbuf varchar2(2000);
496:
497: l_retcode number;
498:
499: l_pos_ei_data per_position_extra_info%rowtype;
500: l_pos_grp1_rec per_position_extra_info%rowtype;
501: l_pos_grp2_rec per_position_extra_info%rowtype;
502:
503: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;

Line 500: l_pos_grp1_rec per_position_extra_info%rowtype;

496:
497: l_retcode number;
498:
499: l_pos_ei_data per_position_extra_info%rowtype;
500: l_pos_grp1_rec per_position_extra_info%rowtype;
501: l_pos_grp2_rec per_position_extra_info%rowtype;
502:
503: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
504: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;

Line 501: l_pos_grp2_rec per_position_extra_info%rowtype;

497: l_retcode number;
498:
499: l_pos_ei_data per_position_extra_info%rowtype;
500: l_pos_grp1_rec per_position_extra_info%rowtype;
501: l_pos_grp2_rec per_position_extra_info%rowtype;
502:
503: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
504: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
505: l_sel_flg varchar2(2);

Line 525: l_pos_ei_grade_data per_position_extra_info%rowtype;

521: l_ind number := 0;
522: l_break varchar2(1) := 'N';
523:
524: --7533027
525: l_pos_ei_grade_data per_position_extra_info%rowtype;
526: --7533027
527:
528: --7186094
529: l_appl_name varchar2(10);

Line 1872: l_pos_ei_data per_position_extra_info%rowtype;

1868: p_mtfr_id in number) is
1869:
1870: l_position_extra_info_id number;
1871: l_object_version_number number;
1872: l_pos_ei_data per_position_extra_info%rowtype;
1873:
1874: CURSOR position_ext_cur (position number) is
1875: SELECT position_extra_info_id, object_version_number
1876: FROM PER_POSITION_EXTRA_INFO

Line 1876: FROM PER_POSITION_EXTRA_INFO

1872: l_pos_ei_data per_position_extra_info%rowtype;
1873:
1874: CURSOR position_ext_cur (position number) is
1875: SELECT position_extra_info_id, object_version_number
1876: FROM PER_POSITION_EXTRA_INFO
1877: WHERE POSITION_ID = position
1878: and information_type = 'GHR_US_POS_MASS_ACTIONS';
1879:
1880: l_eff_date date;

Line 1968: l_pos_ei_data per_position_extra_info%rowtype;

1964: procedure update_sel_flg (p_position_id in number,p_effective_date in date) is
1965:
1966: l_position_extra_info_id number;
1967: l_object_version_number number;
1968: l_pos_ei_data per_position_extra_info%rowtype;
1969: l_eff_date date;
1970: l_proc varchar2(72)
1971: := g_package || '.update_sel_flg';
1972: begin

Line 2160: p_pos_ei_data OUT NOCOPY per_position_extra_info%rowtype)

2156: p_personnel_office_id out NOCOPY varchar2,
2157: p_org_structure_id out NOCOPY varchar2,
2158: p_office_symbol out NOCOPY varchar2,
2159: p_position_organization out NOCOPY varchar2,
2160: p_pos_ei_data OUT NOCOPY per_position_extra_info%rowtype)
2161: IS
2162:
2163: l_personnel_office_id per_position_Extra_info.poei_information3%type;
2164: l_org_structure_id per_position_Extra_info.poei_information5%type;

Line 2163: l_personnel_office_id per_position_Extra_info.poei_information3%type;

2159: p_position_organization out NOCOPY varchar2,
2160: p_pos_ei_data OUT NOCOPY per_position_extra_info%rowtype)
2161: IS
2162:
2163: l_personnel_office_id per_position_Extra_info.poei_information3%type;
2164: l_org_structure_id per_position_Extra_info.poei_information5%type;
2165: l_office_symbol per_position_Extra_info.poei_information4%type;
2166: l_position_organization per_position_Extra_info.POEI_INFORMATION21%type;
2167:

Line 2164: l_org_structure_id per_position_Extra_info.poei_information5%type;

2160: p_pos_ei_data OUT NOCOPY per_position_extra_info%rowtype)
2161: IS
2162:
2163: l_personnel_office_id per_position_Extra_info.poei_information3%type;
2164: l_org_structure_id per_position_Extra_info.poei_information5%type;
2165: l_office_symbol per_position_Extra_info.poei_information4%type;
2166: l_position_organization per_position_Extra_info.POEI_INFORMATION21%type;
2167:
2168: l_pos_ei_data per_position_extra_info%rowtype;

Line 2165: l_office_symbol per_position_Extra_info.poei_information4%type;

2161: IS
2162:
2163: l_personnel_office_id per_position_Extra_info.poei_information3%type;
2164: l_org_structure_id per_position_Extra_info.poei_information5%type;
2165: l_office_symbol per_position_Extra_info.poei_information4%type;
2166: l_position_organization per_position_Extra_info.POEI_INFORMATION21%type;
2167:
2168: l_pos_ei_data per_position_extra_info%rowtype;
2169:

Line 2166: l_position_organization per_position_Extra_info.POEI_INFORMATION21%type;

2162:
2163: l_personnel_office_id per_position_Extra_info.poei_information3%type;
2164: l_org_structure_id per_position_Extra_info.poei_information5%type;
2165: l_office_symbol per_position_Extra_info.poei_information4%type;
2166: l_position_organization per_position_Extra_info.POEI_INFORMATION21%type;
2167:
2168: l_pos_ei_data per_position_extra_info%rowtype;
2169:
2170: l_proc varchar2(72)

Line 2168: l_pos_ei_data per_position_extra_info%rowtype;

2164: l_org_structure_id per_position_Extra_info.poei_information5%type;
2165: l_office_symbol per_position_Extra_info.poei_information4%type;
2166: l_position_organization per_position_Extra_info.POEI_INFORMATION21%type;
2167:
2168: l_pos_ei_data per_position_extra_info%rowtype;
2169:
2170: l_proc varchar2(72)
2171: := g_package || '.get_pos_grp1_ddf';
2172: --l_pos_ei_data per_position_extra_info%type;

Line 2172: --l_pos_ei_data per_position_extra_info%type;

2168: l_pos_ei_data per_position_extra_info%rowtype;
2169:
2170: l_proc varchar2(72)
2171: := g_package || '.get_pos_grp1_ddf';
2172: --l_pos_ei_data per_position_extra_info%type;
2173:
2174: begin
2175: l_personnel_office_id := p_personnel_office_id;
2176: l_org_structure_id := p_org_structure_id;

Line 2227: p_pos_ei_data OUT NOCOPY per_position_extra_info%rowtype)

2223: p_effective_date in date,
2224: p_org_func_code out NOCOPY varchar2,
2225: p_appropriation_code1 out NOCOPY varchar2,
2226: p_appropriation_code2 out NOCOPY varchar2,
2227: p_pos_ei_data OUT NOCOPY per_position_extra_info%rowtype)
2228: IS
2229:
2230: l_proc varchar2(72)
2231: := g_package || '.get_pos_grp2_ddf';

Line 2233: l_org_func_code per_position_extra_info.POEI_INFORMATION4%type;

2229:
2230: l_proc varchar2(72)
2231: := g_package || '.get_pos_grp2_ddf';
2232:
2233: l_org_func_code per_position_extra_info.POEI_INFORMATION4%type;
2234: l_appropriation_code1 per_position_extra_info.POEI_INFORMATION13%type;
2235: l_appropriation_code2 per_position_extra_info.POEI_INFORMATION13%type;
2236: l_pos_ei_data per_position_extra_info%rowtype;
2237:

Line 2234: l_appropriation_code1 per_position_extra_info.POEI_INFORMATION13%type;

2230: l_proc varchar2(72)
2231: := g_package || '.get_pos_grp2_ddf';
2232:
2233: l_org_func_code per_position_extra_info.POEI_INFORMATION4%type;
2234: l_appropriation_code1 per_position_extra_info.POEI_INFORMATION13%type;
2235: l_appropriation_code2 per_position_extra_info.POEI_INFORMATION13%type;
2236: l_pos_ei_data per_position_extra_info%rowtype;
2237:
2238: begin

Line 2235: l_appropriation_code2 per_position_extra_info.POEI_INFORMATION13%type;

2231: := g_package || '.get_pos_grp2_ddf';
2232:
2233: l_org_func_code per_position_extra_info.POEI_INFORMATION4%type;
2234: l_appropriation_code1 per_position_extra_info.POEI_INFORMATION13%type;
2235: l_appropriation_code2 per_position_extra_info.POEI_INFORMATION13%type;
2236: l_pos_ei_data per_position_extra_info%rowtype;
2237:
2238: begin
2239:

Line 2236: l_pos_ei_data per_position_extra_info%rowtype;

2232:
2233: l_org_func_code per_position_extra_info.POEI_INFORMATION4%type;
2234: l_appropriation_code1 per_position_extra_info.POEI_INFORMATION13%type;
2235: l_appropriation_code2 per_position_extra_info.POEI_INFORMATION13%type;
2236: l_pos_ei_data per_position_extra_info%rowtype;
2237:
2238: begin
2239:
2240: l_org_func_code := p_org_func_code;

Line 2292: l_pos_ei_data per_position_extra_info%rowtype;

2288: p_sel_flag in out NOCOPY varchar2,
2289: p_comments in out NOCOPY varchar2,
2290: p_mtfr_id in out NOCOPY number) IS
2291:
2292: l_pos_ei_data per_position_extra_info%rowtype;
2293: l_proc varchar2(72) := g_package || '.get_extra_info_comments';
2294: l_eff_date date;
2295:
2296: l_sel_flag varchar2(5);

Line 2813: from per_position_extra_info

2809: procedure upd_ext_info_to_null(p_position_id in number) is
2810:
2811: CURSOR POSITION_EXT_CUR (p_position number) IS
2812: select position_extra_info_id, object_version_number
2813: from per_position_extra_info
2814: where position_id = (p_position)
2815: and INFORMATION_TYPE = 'GHR_US_POS_MASS_ACTIONS';
2816:
2817: l_Position_EXTRA_INFO_ID NUMBER;

Line 2820: l_pos_ei_data per_position_extra_info%rowtype;

2816:
2817: l_Position_EXTRA_INFO_ID NUMBER;
2818: l_OBJECT_VERSION_NUMBER NUMBER;
2819:
2820: l_pos_ei_data per_position_extra_info%rowtype;
2821: l_proc varchar2(72) := g_package || '.upd_ext_info_api';
2822: begin
2823:
2824: g_proc := 'upd_ext_info_to_null';