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

Line 54: FROM per_position_extra_info pei

50: SELECT pei.position_id,
51: pei.position_extra_info_id,
52: pei.poei_information3 grade_id,
53: to_number(pei.poei_information5) user_tab_id
54: FROM per_position_extra_info pei
55: WHERE pei.information_type = 'GHR_US_POS_VALID_GRADE'
56: AND to_number(pei.poei_information5) <> l_essl_tab_id
57: AND pei.position_id in
58: (SELECT position_id

Line 74: WHERE pah.table_name = 'PER_POSITION_EXTRA_INFO'

70: pah.information9 , -- grade_id
71: to_number(pah.information11) user_tab_id,
72: pah.effective_date
73: FROM ghr_pa_history pah
74: WHERE pah.table_name = 'PER_POSITION_EXTRA_INFO'
75: AND pah.information5 = 'GHR_US_POS_VALID_GRADE'
76: AND to_number(pah.information11) <> l_essl_tab_id
77: AND to_number(pah.information4) in
78: (SELECT position_id

Line 111: WHERE table_name = 'PER_POSITION_EXTRA_INFO'

107: ---
108: CURSOR cur_his_cut_off_date IS
109: SELECT 1
110: FROM ghr_pa_history pah1
111: WHERE table_name = 'PER_POSITION_EXTRA_INFO'
112: AND information5 = 'GHR_US_POS_VALID_GRADE'
113: and effective_date = l_effective_date
114: AND to_number(information4) = l_position_id
115: AND to_number(information11) = l_essl_tab_id;

Line 121: l_pos_ei_data per_position_extra_info%rowtype;

117: l_proc varchar2(72) := 'ghr_ses_pay_cal_conv';
118:
119: l_his_match BOOLEAN := FALSE;
120: l_pos_valid BOOLEAN := FALSE;
121: l_pos_ei_data per_position_extra_info%rowtype;
122: l_pay_plan per_grade_definitions.segment1%type;
123: l_grade_or_level per_grade_definitions.segment2%type;
124: l_posei_id per_position_extra_info.position_extra_info_id%type;
125: l_grd_id per_position_extra_info.poei_information5%type;

Line 124: l_posei_id per_position_extra_info.position_extra_info_id%type;

120: l_pos_valid BOOLEAN := FALSE;
121: l_pos_ei_data per_position_extra_info%rowtype;
122: l_pay_plan per_grade_definitions.segment1%type;
123: l_grade_or_level per_grade_definitions.segment2%type;
124: l_posei_id per_position_extra_info.position_extra_info_id%type;
125: l_grd_id per_position_extra_info.poei_information5%type;
126: l_hist_id ghr_pa_history.pa_history_id%type;
127: l_his_eff_date ghr_pa_requests.effective_date%type;
128: l_counter NUMBER := 0;

Line 125: l_grd_id per_position_extra_info.poei_information5%type;

121: l_pos_ei_data per_position_extra_info%rowtype;
122: l_pay_plan per_grade_definitions.segment1%type;
123: l_grade_or_level per_grade_definitions.segment2%type;
124: l_posei_id per_position_extra_info.position_extra_info_id%type;
125: l_grd_id per_position_extra_info.poei_information5%type;
126: l_hist_id ghr_pa_history.pa_history_id%type;
127: l_his_eff_date ghr_pa_requests.effective_date%type;
128: l_counter NUMBER := 0;
129: l_counter1 NUMBER := 0;

Line 203: UPDATE PER_POSITION_EXTRA_INFO

199: ---
200:
201: IF l_pay_plan in ('ES','EP','IE','FE') THEN
202:
203: UPDATE PER_POSITION_EXTRA_INFO
204: SET poei_information5 = to_char(l_essl_tab_id)
205: WHERE current of cur_pos_ei;
206:
207: FOR tab_name IN cur_user_pay_tab_name

Line 229: p_message_name => 'ERR-PER_POSITION_EXTRA_INFO',

225: ---
226: l_log_text := substr(l_log_text || ', Message : ' || 'ERROR NOT UPDATED ,',1,2000);
227: ghr_wgi_pkg.create_ghr_errorlog(
228: p_program_name => g_proc_name,
229: p_message_name => 'ERR-PER_POSITION_EXTRA_INFO',
230: p_log_text => substr(l_log_text || 'DB ERROR is : ' || SQLERRM,1,2000),
231: p_log_date => sysdate);
232: ELSE
233: l_counter := l_counter + 1;

Line 241: p_message_name => 'PER_POSITION_EXTRA_INFO',

237: ---
238: l_log_text := substr(l_log_text || ', Message : ' || 'Updated Successful ',1,2000);
239: ghr_wgi_pkg.create_ghr_errorlog(
240: p_program_name => g_proc_name,
241: p_message_name => 'PER_POSITION_EXTRA_INFO',
242: p_log_text => l_log_text,
243: p_log_date => sysdate);
244: END IF;
245:

Line 253: --- No Records in PER_POSITION_EXTRA_INFO - so Enter log.

249: END LOOP;
250:
251: IF l_counter = 0 THEN
252: ---
253: --- No Records in PER_POSITION_EXTRA_INFO - so Enter log.
254: ---
255: ghr_wgi_pkg.create_ghr_errorlog(
256: p_program_name => g_proc_name,
257: p_message_name => 'NO-PER_POSITION_EXTRA_INFO',

Line 257: p_message_name => 'NO-PER_POSITION_EXTRA_INFO',

253: --- No Records in PER_POSITION_EXTRA_INFO - so Enter log.
254: ---
255: ghr_wgi_pkg.create_ghr_errorlog(
256: p_program_name => g_proc_name,
257: p_message_name => 'NO-PER_POSITION_EXTRA_INFO',
258: p_log_text => 'Error : NO Valid Extra Position Info records found for Update' ,
259: p_log_date => sysdate);
260: ELSE
261: ---

Line 262: --- All Records in PER_POSITION_EXTRA_INFO updated - so Enter log.

258: p_log_text => 'Error : NO Valid Extra Position Info records found for Update' ,
259: p_log_date => sysdate);
260: ELSE
261: ---
262: --- All Records in PER_POSITION_EXTRA_INFO updated - so Enter log.
263: ---
264: ghr_wgi_pkg.create_ghr_errorlog(
265: p_program_name => g_proc_name,
266: p_message_name => 'TOT-PER_POSITION_EXTRA_INFO',

Line 266: p_message_name => 'TOT-PER_POSITION_EXTRA_INFO',

262: --- All Records in PER_POSITION_EXTRA_INFO updated - so Enter log.
263: ---
264: ghr_wgi_pkg.create_ghr_errorlog(
265: p_program_name => g_proc_name,
266: p_message_name => 'TOT-PER_POSITION_EXTRA_INFO',
267: p_log_text => 'Total Records updated with SES equivalent plans are ' || to_char(l_counter),
268: p_log_date => sysdate);
269: END IF;
270: