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

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

Line 185: l_pos_grp1_rec per_position_extra_info%rowtype;

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

Line 1385: l_pos_ei_data per_position_extra_info%rowtype;

1381: l_errbuf varchar2(2000);
1382:
1383: l_retcode number;
1384:
1385: l_pos_ei_data per_position_extra_info%rowtype;
1386: l_pos_grp1_rec per_position_extra_info%rowtype;
1387:
1388: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
1389: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;

Line 1386: l_pos_grp1_rec per_position_extra_info%rowtype;

1382:
1383: l_retcode number;
1384:
1385: l_pos_ei_data per_position_extra_info%rowtype;
1386: l_pos_grp1_rec per_position_extra_info%rowtype;
1387:
1388: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;
1389: l_pay_calc_out_data ghr_pay_calc.pay_calc_out_rec_type;
1390: l_sel_flg varchar2(2);

Line 1429: l_pos_valid_grade_ei_data per_position_extra_info%rowtype;

1425: ----FWFA Changes
1426: l_0000_id number;
1427: l_0491_id number;
1428: l_to_pay_table_id number;
1429: l_pos_valid_grade_ei_data per_position_extra_info%rowtype;
1430: l_mtcerrbuf varchar2(2000);
1431: l_avail_status_id number;
1432: l_occ_series varchar2(30);
1433: l_pt_value number;

Line 3891: p_pos_ei_data out nocopy per_position_extra_info%rowtype)

3887: --
3888:
3889: procedure get_pos_grp1_ddf (p_position_id in per_assignments_f.position_id%type,
3890: p_effective_date in date,
3891: p_pos_ei_data out nocopy per_position_extra_info%rowtype)
3892: IS
3893:
3894: l_proc varchar2(72) := g_package || '.get_pos_grp1_ddf';
3895: --l_pos_ei_data per_position_extra_info%type;

Line 3895: --l_pos_ei_data per_position_extra_info%type;

3891: p_pos_ei_data out nocopy per_position_extra_info%rowtype)
3892: IS
3893:
3894: l_proc varchar2(72) := g_package || '.get_pos_grp1_ddf';
3895: --l_pos_ei_data per_position_extra_info%type;
3896:
3897: begin
3898: g_proc := 'get_pos_grp1_ddf';
3899: hr_utility.set_location('Entering ' || l_proc,5);

Line 5031: from per_position_extra_info

5027: procedure upd_ext_info_to_null(p_position_id in NUMBER, p_effective_DATE in DATE) is
5028:
5029: CURSOR POSITION_EXT_CUR (p_position NUMBER) IS
5030: SELECT position_extra_info_id, object_version_NUMBER
5031: from per_position_extra_info
5032: WHERE position_id = (p_position)
5033: and INFORMATION_TYPE = 'GHR_US_POS_MASS_ACTIONS';
5034:
5035: l_Position_EXTRA_INFO_ID NUMBER;

Line 5039: l_pos_ei_data per_position_extra_info%rowtype;

5035: l_Position_EXTRA_INFO_ID NUMBER;
5036: l_OBJECT_VERSION_NUMBER NUMBER;
5037: l_eff_DATE DATE;
5038:
5039: l_pos_ei_data per_position_extra_info%rowtype;
5040: l_proc VARCHAR2(72) := g_package || '.upd_ext_info_api';
5041: BEGIN
5042:
5043: g_proc := 'upd_ext_info_to_null';

Line 5223: l_pos_ei_data per_position_extra_info%rowtype;

5219: p_msl_id in NUMBER) is
5220:
5221: l_position_extra_info_id NUMBER;
5222: l_object_version_NUMBER NUMBER;
5223: l_pos_ei_data per_position_extra_info%rowtype;
5224:
5225: CURSOR position_ext_cur (position NUMBER) is
5226: SELECT position_extra_info_id, object_version_NUMBER
5227: FROM PER_POSITION_EXTRA_INFO

Line 5227: FROM PER_POSITION_EXTRA_INFO

5223: l_pos_ei_data per_position_extra_info%rowtype;
5224:
5225: CURSOR position_ext_cur (position NUMBER) is
5226: SELECT position_extra_info_id, object_version_NUMBER
5227: FROM PER_POSITION_EXTRA_INFO
5228: WHERE POSITION_ID = position
5229: and information_type = 'GHR_US_POS_MASS_ACTIONS';
5230:
5231: l_proc VARCHAR2(72) := g_package || '.ins_upd_pos_extra_info';

Line 5316: l_pos_ei_data per_position_extra_info%rowtype;

5312:
5313: l_sel_flag VARCHAR2(30);
5314: l_comments VARCHAR2(4000);
5315: l_msl_id NUMBER;
5316: l_pos_ei_data per_position_extra_info%rowtype;
5317: l_proc VARCHAR2(72) := g_package || '.get_extra_info_comments';
5318: l_eff_DATE DATE;
5319: l_char_msl_id VARCHAR2(30);
5320:

Line 5450: WHERE pah.table_name = 'PER_POSITION_EXTRA_INFO'

5446: pah.information4 , -- position_id
5447: to_number(pah.information11) user_tab_id,
5448: pah.effective_date
5449: FROM ghr_pa_history pah
5450: WHERE pah.table_name = 'PER_POSITION_EXTRA_INFO'
5451: AND pah.information5 = 'GHR_US_POS_VALID_GRADE'
5452: AND to_number(pah.information4) = l_pos_id
5453: AND to_number(pah.information11) = l_tab_id
5454: AND pah.effective_date >= to_date('2005/05/01','YYYY/MM/DD')