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_UTILITY dependencies on PER_POSITION_DEFINITIONS

Line 181: FUNCTION return_pos_name(l_pos_title per_position_definitions.segment1%type,

177: END get_flex_delimiter;
178:
179:
180: --############### Function to get concatenated Position name #############################################
181: FUNCTION return_pos_name(l_pos_title per_position_definitions.segment1%type,
182: l_pos_desc per_position_definitions.segment1%type,
183: l_seq_no per_position_definitions.segment1%type,
184: l_agency_code per_position_definitions.segment1%type,
185: l_po_id per_position_definitions.segment1%type,

Line 182: l_pos_desc per_position_definitions.segment1%type,

178:
179:
180: --############### Function to get concatenated Position name #############################################
181: FUNCTION return_pos_name(l_pos_title per_position_definitions.segment1%type,
182: l_pos_desc per_position_definitions.segment1%type,
183: l_seq_no per_position_definitions.segment1%type,
184: l_agency_code per_position_definitions.segment1%type,
185: l_po_id per_position_definitions.segment1%type,
186: l_grade per_position_definitions.segment1%type,

Line 183: l_seq_no per_position_definitions.segment1%type,

179:
180: --############### Function to get concatenated Position name #############################################
181: FUNCTION return_pos_name(l_pos_title per_position_definitions.segment1%type,
182: l_pos_desc per_position_definitions.segment1%type,
183: l_seq_no per_position_definitions.segment1%type,
184: l_agency_code per_position_definitions.segment1%type,
185: l_po_id per_position_definitions.segment1%type,
186: l_grade per_position_definitions.segment1%type,
187: l_nfc_agency_code per_position_definitions.segment1%type,

Line 184: l_agency_code per_position_definitions.segment1%type,

180: --############### Function to get concatenated Position name #############################################
181: FUNCTION return_pos_name(l_pos_title per_position_definitions.segment1%type,
182: l_pos_desc per_position_definitions.segment1%type,
183: l_seq_no per_position_definitions.segment1%type,
184: l_agency_code per_position_definitions.segment1%type,
185: l_po_id per_position_definitions.segment1%type,
186: l_grade per_position_definitions.segment1%type,
187: l_nfc_agency_code per_position_definitions.segment1%type,
188: l_full_title hr_positions_f.name%type)

Line 185: l_po_id per_position_definitions.segment1%type,

181: FUNCTION return_pos_name(l_pos_title per_position_definitions.segment1%type,
182: l_pos_desc per_position_definitions.segment1%type,
183: l_seq_no per_position_definitions.segment1%type,
184: l_agency_code per_position_definitions.segment1%type,
185: l_po_id per_position_definitions.segment1%type,
186: l_grade per_position_definitions.segment1%type,
187: l_nfc_agency_code per_position_definitions.segment1%type,
188: l_full_title hr_positions_f.name%type)
189: RETURN VARCHAR2 IS

Line 186: l_grade per_position_definitions.segment1%type,

182: l_pos_desc per_position_definitions.segment1%type,
183: l_seq_no per_position_definitions.segment1%type,
184: l_agency_code per_position_definitions.segment1%type,
185: l_po_id per_position_definitions.segment1%type,
186: l_grade per_position_definitions.segment1%type,
187: l_nfc_agency_code per_position_definitions.segment1%type,
188: l_full_title hr_positions_f.name%type)
189: RETURN VARCHAR2 IS
190: l_flex_num NUMBER;

Line 187: l_nfc_agency_code per_position_definitions.segment1%type,

183: l_seq_no per_position_definitions.segment1%type,
184: l_agency_code per_position_definitions.segment1%type,
185: l_po_id per_position_definitions.segment1%type,
186: l_grade per_position_definitions.segment1%type,
187: l_nfc_agency_code per_position_definitions.segment1%type,
188: l_full_title hr_positions_f.name%type)
189: RETURN VARCHAR2 IS
190: l_flex_num NUMBER;
191: l_flex_recs t_flex_recs;

Line 299: FUNCTION return_nfc_pos_name(l_pos_title per_position_definitions.segment1%type,

295:
296: END return_pos_name;
297:
298: --############### Function to get concatenated Position name #############################################
299: FUNCTION return_nfc_pos_name(l_pos_title per_position_definitions.segment1%type,
300: l_pos_desc per_position_definitions.segment1%type,
301: l_seq_no per_position_definitions.segment1%type,
302: l_agency_code per_position_definitions.segment1%type,
303: l_po_id per_position_definitions.segment1%type,

Line 300: l_pos_desc per_position_definitions.segment1%type,

296: END return_pos_name;
297:
298: --############### Function to get concatenated Position name #############################################
299: FUNCTION return_nfc_pos_name(l_pos_title per_position_definitions.segment1%type,
300: l_pos_desc per_position_definitions.segment1%type,
301: l_seq_no per_position_definitions.segment1%type,
302: l_agency_code per_position_definitions.segment1%type,
303: l_po_id per_position_definitions.segment1%type,
304: l_grade per_position_definitions.segment1%type,

Line 301: l_seq_no per_position_definitions.segment1%type,

297:
298: --############### Function to get concatenated Position name #############################################
299: FUNCTION return_nfc_pos_name(l_pos_title per_position_definitions.segment1%type,
300: l_pos_desc per_position_definitions.segment1%type,
301: l_seq_no per_position_definitions.segment1%type,
302: l_agency_code per_position_definitions.segment1%type,
303: l_po_id per_position_definitions.segment1%type,
304: l_grade per_position_definitions.segment1%type,
305: l_nfc_agency_code per_position_definitions.segment1%type,

Line 302: l_agency_code per_position_definitions.segment1%type,

298: --############### Function to get concatenated Position name #############################################
299: FUNCTION return_nfc_pos_name(l_pos_title per_position_definitions.segment1%type,
300: l_pos_desc per_position_definitions.segment1%type,
301: l_seq_no per_position_definitions.segment1%type,
302: l_agency_code per_position_definitions.segment1%type,
303: l_po_id per_position_definitions.segment1%type,
304: l_grade per_position_definitions.segment1%type,
305: l_nfc_agency_code per_position_definitions.segment1%type,
306: l_full_title hr_positions_f.name%type)

Line 303: l_po_id per_position_definitions.segment1%type,

299: FUNCTION return_nfc_pos_name(l_pos_title per_position_definitions.segment1%type,
300: l_pos_desc per_position_definitions.segment1%type,
301: l_seq_no per_position_definitions.segment1%type,
302: l_agency_code per_position_definitions.segment1%type,
303: l_po_id per_position_definitions.segment1%type,
304: l_grade per_position_definitions.segment1%type,
305: l_nfc_agency_code per_position_definitions.segment1%type,
306: l_full_title hr_positions_f.name%type)
307: RETURN VARCHAR2 IS

Line 304: l_grade per_position_definitions.segment1%type,

300: l_pos_desc per_position_definitions.segment1%type,
301: l_seq_no per_position_definitions.segment1%type,
302: l_agency_code per_position_definitions.segment1%type,
303: l_po_id per_position_definitions.segment1%type,
304: l_grade per_position_definitions.segment1%type,
305: l_nfc_agency_code per_position_definitions.segment1%type,
306: l_full_title hr_positions_f.name%type)
307: RETURN VARCHAR2 IS
308: l_final VARCHAR2(2000);

Line 305: l_nfc_agency_code per_position_definitions.segment1%type,

301: l_seq_no per_position_definitions.segment1%type,
302: l_agency_code per_position_definitions.segment1%type,
303: l_po_id per_position_definitions.segment1%type,
304: l_grade per_position_definitions.segment1%type,
305: l_nfc_agency_code per_position_definitions.segment1%type,
306: l_full_title hr_positions_f.name%type)
307: RETURN VARCHAR2 IS
308: l_final VARCHAR2(2000);
309: l_delimiter VARCHAR2(10);

Line 315: l_pos_new_title per_position_definitions.segment1%type;

311: l_rem varchar2(2000);
312: TYPE t_pos_name_arr IS TABLE OF VARCHAR2(250) INDEX BY BINARY_INTEGER;
313: l_pos_name_arr t_pos_name_arr;
314: l_delimiter_index NUMBER;
315: l_pos_new_title per_position_definitions.segment1%type;
316: l_pos_new_desc per_position_definitions.segment1%type;
317: l_ctr NUMBER;
318: l_flex_num NUMBER;
319: l_bus_group_id per_business_groups.business_group_id%TYPE;

Line 316: l_pos_new_desc per_position_definitions.segment1%type;

312: TYPE t_pos_name_arr IS TABLE OF VARCHAR2(250) INDEX BY BINARY_INTEGER;
313: l_pos_name_arr t_pos_name_arr;
314: l_delimiter_index NUMBER;
315: l_pos_new_title per_position_definitions.segment1%type;
316: l_pos_new_desc per_position_definitions.segment1%type;
317: l_ctr NUMBER;
318: l_flex_num NUMBER;
319: l_bus_group_id per_business_groups.business_group_id%TYPE;
320:

Line 408: from per_position_definitions pdf, hr_all_positions_f pos

404: cursor c_old_pos_segments(c_position_id hr_all_positions_f.position_id%type,
405: c_effective_date date) is
406: select information6,segment1,segment2,segment3,segment4,
407: segment5,segment6,segment7
408: from per_position_definitions pdf, hr_all_positions_f pos
409: where pos.position_definition_id = pdf.position_definition_id
410: and pos.position_id = c_position_id
411: and c_effective_date between pos.effective_start_date and
412: pos.effective_end_date;

Line 558: from per_position_definitions pdf, hr_all_positions_f pos

554: cursor c_old_pos_segments(c_position_id hr_all_positions_f.position_id%type,
555: c_effective_date date) is
556: select information6,segment1,segment2,segment3,segment4,
557: segment5,segment6,segment7
558: from per_position_definitions pdf, hr_all_positions_f pos
559: where pos.position_definition_id = pdf.position_definition_id
560: and pos.position_id = c_position_id
561: and c_effective_date between pos.effective_start_date and
562: pos.effective_end_date;