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

Line 182: l_pos_ei_data per_position_extra_info%rowtype;

178: l_errbuf varchar2(2000);
179:
180: l_retcode number;
181:
182: l_pos_ei_data per_position_extra_info%rowtype;
183: l_pos_grp1_rec per_position_extra_info%rowtype;
184:
185: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
186: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;

Line 183: l_pos_grp1_rec per_position_extra_info%rowtype;

179:
180: l_retcode number;
181:
182: l_pos_ei_data per_position_extra_info%rowtype;
183: l_pos_grp1_rec per_position_extra_info%rowtype;
184:
185: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
186: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
187: l_sel_flg varchar2(2);

Line 1359: l_pos_ei_data per_position_extra_info%rowtype;

1355: l_errbuf varchar2(2000);
1356:
1357: l_retcode number;
1358:
1359: l_pos_ei_data per_position_extra_info%rowtype;
1360: l_pos_grp1_rec per_position_extra_info%rowtype;
1361:
1362: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
1363: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;

Line 1360: l_pos_grp1_rec per_position_extra_info%rowtype;

1356:
1357: l_retcode number;
1358:
1359: l_pos_ei_data per_position_extra_info%rowtype;
1360: l_pos_grp1_rec per_position_extra_info%rowtype;
1361:
1362: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
1363: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
1364: l_sel_flg varchar2(2);

Line 1403: l_pos_valid_grade_ei_data per_position_extra_info%rowtype;

1399: ----FWFA Changes
1400: l_0000_id number;
1401: l_0491_id number;
1402: l_to_pay_table_id number;
1403: l_pos_valid_grade_ei_data per_position_extra_info%rowtype;
1404: l_mtcerrbuf varchar2(2000);
1405: l_avail_status_id number;
1406: l_occ_series varchar2(30);
1407: l_pt_value number;

Line 3845: p_pos_ei_data out nocopy per_position_extra_info%rowtype)

3841: --
3842:
3843: procedure get_pos_grp1_ddf (p_position_id in per_assignments_f.position_id%type,
3844: p_effective_date in date,
3845: p_pos_ei_data out nocopy per_position_extra_info%rowtype)
3846: IS
3847:
3848: l_proc varchar2(72) := g_package || '.get_pos_grp1_ddf';
3849: --l_pos_ei_data per_position_extra_info%type;

Line 3849: --l_pos_ei_data per_position_extra_info%type;

3845: p_pos_ei_data out nocopy per_position_extra_info%rowtype)
3846: IS
3847:
3848: l_proc varchar2(72) := g_package || '.get_pos_grp1_ddf';
3849: --l_pos_ei_data per_position_extra_info%type;
3850:
3851: begin
3852: g_proc := 'get_pos_grp1_ddf';
3853: hr_utility.set_location('Entering ' || l_proc,5);

Line 4973: from per_position_extra_info

4969: procedure upd_ext_info_to_null(p_position_id in NUMBER, p_effective_DATE in DATE) is
4970:
4971: CURSOR POSITION_EXT_CUR (p_position NUMBER) IS
4972: SELECT position_extra_info_id, object_version_NUMBER
4973: from per_position_extra_info
4974: WHERE position_id = (p_position)
4975: and INFORMATION_TYPE = 'GHR_US_POS_MASS_ACTIONS';
4976:
4977: l_Position_EXTRA_INFO_ID NUMBER;

Line 4981: l_pos_ei_data per_position_extra_info%rowtype;

4977: l_Position_EXTRA_INFO_ID NUMBER;
4978: l_OBJECT_VERSION_NUMBER NUMBER;
4979: l_eff_DATE DATE;
4980:
4981: l_pos_ei_data per_position_extra_info%rowtype;
4982: l_proc VARCHAR2(72) := g_package || '.upd_ext_info_api';
4983: BEGIN
4984:
4985: g_proc := 'upd_ext_info_to_null';

Line 5165: l_pos_ei_data per_position_extra_info%rowtype;

5161: p_msl_id in NUMBER) is
5162:
5163: l_position_extra_info_id NUMBER;
5164: l_object_version_NUMBER NUMBER;
5165: l_pos_ei_data per_position_extra_info%rowtype;
5166:
5167: CURSOR position_ext_cur (position NUMBER) is
5168: SELECT position_extra_info_id, object_version_NUMBER
5169: FROM PER_POSITION_EXTRA_INFO

Line 5169: FROM PER_POSITION_EXTRA_INFO

5165: l_pos_ei_data per_position_extra_info%rowtype;
5166:
5167: CURSOR position_ext_cur (position NUMBER) is
5168: SELECT position_extra_info_id, object_version_NUMBER
5169: FROM PER_POSITION_EXTRA_INFO
5170: WHERE POSITION_ID = position
5171: and information_type = 'GHR_US_POS_MASS_ACTIONS';
5172:
5173: l_proc VARCHAR2(72) := g_package || '.ins_upd_pos_extra_info';

Line 5258: l_pos_ei_data per_position_extra_info%rowtype;

5254:
5255: l_sel_flag VARCHAR2(30);
5256: l_comments VARCHAR2(4000);
5257: l_msl_id NUMBER;
5258: l_pos_ei_data per_position_extra_info%rowtype;
5259: l_proc VARCHAR2(72) := g_package || '.get_extra_info_comments';
5260: l_eff_DATE DATE;
5261: l_char_msl_id VARCHAR2(30);
5262:

Line 5392: WHERE pah.table_name = 'PER_POSITION_EXTRA_INFO'

5388: pah.information4 , -- position_id
5389: to_number(pah.information11) user_tab_id,
5390: pah.effective_date
5391: FROM ghr_pa_history pah
5392: WHERE pah.table_name = 'PER_POSITION_EXTRA_INFO'
5393: AND pah.information5 = 'GHR_US_POS_VALID_GRADE'
5394: AND to_number(pah.information4) = l_pos_id
5395: AND to_number(pah.information11) = l_tab_id
5396: AND pah.effective_date >= to_date('2005/05/01','YYYY/MM/DD')