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 171: FUNCTION return_pos_name(l_pos_title per_position_definitions.segment1%type,

167: END get_flex_delimiter;
168:
169:
170: --############### Function to get concatenated Position name #############################################
171: FUNCTION return_pos_name(l_pos_title per_position_definitions.segment1%type,
172: l_pos_desc per_position_definitions.segment1%type,
173: l_seq_no per_position_definitions.segment1%type,
174: l_agency_code per_position_definitions.segment1%type,
175: l_po_id per_position_definitions.segment1%type,

Line 172: l_pos_desc per_position_definitions.segment1%type,

168:
169:
170: --############### Function to get concatenated Position name #############################################
171: FUNCTION return_pos_name(l_pos_title per_position_definitions.segment1%type,
172: l_pos_desc per_position_definitions.segment1%type,
173: l_seq_no per_position_definitions.segment1%type,
174: l_agency_code per_position_definitions.segment1%type,
175: l_po_id per_position_definitions.segment1%type,
176: l_grade per_position_definitions.segment1%type,

Line 173: l_seq_no per_position_definitions.segment1%type,

169:
170: --############### Function to get concatenated Position name #############################################
171: FUNCTION return_pos_name(l_pos_title per_position_definitions.segment1%type,
172: l_pos_desc per_position_definitions.segment1%type,
173: l_seq_no per_position_definitions.segment1%type,
174: l_agency_code per_position_definitions.segment1%type,
175: l_po_id per_position_definitions.segment1%type,
176: l_grade per_position_definitions.segment1%type,
177: l_nfc_agency_code per_position_definitions.segment1%type,

Line 174: l_agency_code per_position_definitions.segment1%type,

170: --############### Function to get concatenated Position name #############################################
171: FUNCTION return_pos_name(l_pos_title per_position_definitions.segment1%type,
172: l_pos_desc per_position_definitions.segment1%type,
173: l_seq_no per_position_definitions.segment1%type,
174: l_agency_code per_position_definitions.segment1%type,
175: l_po_id per_position_definitions.segment1%type,
176: l_grade per_position_definitions.segment1%type,
177: l_nfc_agency_code per_position_definitions.segment1%type,
178: l_full_title hr_positions_f.name%type)

Line 175: l_po_id per_position_definitions.segment1%type,

171: FUNCTION return_pos_name(l_pos_title per_position_definitions.segment1%type,
172: l_pos_desc per_position_definitions.segment1%type,
173: l_seq_no per_position_definitions.segment1%type,
174: l_agency_code per_position_definitions.segment1%type,
175: l_po_id per_position_definitions.segment1%type,
176: l_grade per_position_definitions.segment1%type,
177: l_nfc_agency_code per_position_definitions.segment1%type,
178: l_full_title hr_positions_f.name%type)
179: RETURN VARCHAR2 IS

Line 176: l_grade per_position_definitions.segment1%type,

172: l_pos_desc per_position_definitions.segment1%type,
173: l_seq_no per_position_definitions.segment1%type,
174: l_agency_code per_position_definitions.segment1%type,
175: l_po_id per_position_definitions.segment1%type,
176: l_grade per_position_definitions.segment1%type,
177: l_nfc_agency_code per_position_definitions.segment1%type,
178: l_full_title hr_positions_f.name%type)
179: RETURN VARCHAR2 IS
180: l_flex_num NUMBER;

Line 177: l_nfc_agency_code per_position_definitions.segment1%type,

173: l_seq_no per_position_definitions.segment1%type,
174: l_agency_code per_position_definitions.segment1%type,
175: l_po_id per_position_definitions.segment1%type,
176: l_grade per_position_definitions.segment1%type,
177: l_nfc_agency_code per_position_definitions.segment1%type,
178: l_full_title hr_positions_f.name%type)
179: RETURN VARCHAR2 IS
180: l_flex_num NUMBER;
181: l_flex_recs t_flex_recs;

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

285:
286: END return_pos_name;
287:
288: --############### Function to get concatenated Position name #############################################
289: FUNCTION return_nfc_pos_name(l_pos_title per_position_definitions.segment1%type,
290: l_pos_desc per_position_definitions.segment1%type,
291: l_seq_no per_position_definitions.segment1%type,
292: l_agency_code per_position_definitions.segment1%type,
293: l_po_id per_position_definitions.segment1%type,

Line 290: l_pos_desc per_position_definitions.segment1%type,

286: END return_pos_name;
287:
288: --############### Function to get concatenated Position name #############################################
289: FUNCTION return_nfc_pos_name(l_pos_title per_position_definitions.segment1%type,
290: l_pos_desc per_position_definitions.segment1%type,
291: l_seq_no per_position_definitions.segment1%type,
292: l_agency_code per_position_definitions.segment1%type,
293: l_po_id per_position_definitions.segment1%type,
294: l_grade per_position_definitions.segment1%type,

Line 291: l_seq_no per_position_definitions.segment1%type,

287:
288: --############### Function to get concatenated Position name #############################################
289: FUNCTION return_nfc_pos_name(l_pos_title per_position_definitions.segment1%type,
290: l_pos_desc per_position_definitions.segment1%type,
291: l_seq_no per_position_definitions.segment1%type,
292: l_agency_code per_position_definitions.segment1%type,
293: l_po_id per_position_definitions.segment1%type,
294: l_grade per_position_definitions.segment1%type,
295: l_nfc_agency_code per_position_definitions.segment1%type,

Line 292: l_agency_code per_position_definitions.segment1%type,

288: --############### Function to get concatenated Position name #############################################
289: FUNCTION return_nfc_pos_name(l_pos_title per_position_definitions.segment1%type,
290: l_pos_desc per_position_definitions.segment1%type,
291: l_seq_no per_position_definitions.segment1%type,
292: l_agency_code per_position_definitions.segment1%type,
293: l_po_id per_position_definitions.segment1%type,
294: l_grade per_position_definitions.segment1%type,
295: l_nfc_agency_code per_position_definitions.segment1%type,
296: l_full_title hr_positions_f.name%type)

Line 293: l_po_id per_position_definitions.segment1%type,

289: FUNCTION return_nfc_pos_name(l_pos_title per_position_definitions.segment1%type,
290: l_pos_desc per_position_definitions.segment1%type,
291: l_seq_no per_position_definitions.segment1%type,
292: l_agency_code per_position_definitions.segment1%type,
293: l_po_id per_position_definitions.segment1%type,
294: l_grade per_position_definitions.segment1%type,
295: l_nfc_agency_code per_position_definitions.segment1%type,
296: l_full_title hr_positions_f.name%type)
297: RETURN VARCHAR2 IS

Line 294: l_grade per_position_definitions.segment1%type,

290: l_pos_desc per_position_definitions.segment1%type,
291: l_seq_no per_position_definitions.segment1%type,
292: l_agency_code per_position_definitions.segment1%type,
293: l_po_id per_position_definitions.segment1%type,
294: l_grade per_position_definitions.segment1%type,
295: l_nfc_agency_code per_position_definitions.segment1%type,
296: l_full_title hr_positions_f.name%type)
297: RETURN VARCHAR2 IS
298: l_final VARCHAR2(2000);

Line 295: l_nfc_agency_code per_position_definitions.segment1%type,

291: l_seq_no per_position_definitions.segment1%type,
292: l_agency_code per_position_definitions.segment1%type,
293: l_po_id per_position_definitions.segment1%type,
294: l_grade per_position_definitions.segment1%type,
295: l_nfc_agency_code per_position_definitions.segment1%type,
296: l_full_title hr_positions_f.name%type)
297: RETURN VARCHAR2 IS
298: l_final VARCHAR2(2000);
299: l_delimiter VARCHAR2(10);

Line 305: l_pos_new_title per_position_definitions.segment1%type;

301: l_rem varchar2(2000);
302: TYPE t_pos_name_arr IS TABLE OF VARCHAR2(250) INDEX BY BINARY_INTEGER;
303: l_pos_name_arr t_pos_name_arr;
304: l_delimiter_index NUMBER;
305: l_pos_new_title per_position_definitions.segment1%type;
306: l_pos_new_desc per_position_definitions.segment1%type;
307: l_ctr NUMBER;
308: l_flex_num NUMBER;
309: l_bus_group_id per_business_groups.business_group_id%TYPE;

Line 306: l_pos_new_desc per_position_definitions.segment1%type;

302: TYPE t_pos_name_arr IS TABLE OF VARCHAR2(250) INDEX BY BINARY_INTEGER;
303: l_pos_name_arr t_pos_name_arr;
304: l_delimiter_index NUMBER;
305: l_pos_new_title per_position_definitions.segment1%type;
306: l_pos_new_desc per_position_definitions.segment1%type;
307: l_ctr NUMBER;
308: l_flex_num NUMBER;
309: l_bus_group_id per_business_groups.business_group_id%TYPE;
310:

Line 398: from per_position_definitions pdf, hr_all_positions_f pos

394: cursor c_old_pos_segments(c_position_id hr_all_positions_f.position_id%type,
395: c_effective_date date) is
396: select information6,segment1,segment2,segment3,segment4,
397: segment5,segment6,segment7
398: from per_position_definitions pdf, hr_all_positions_f pos
399: where pos.position_definition_id = pdf.position_definition_id
400: and pos.position_id = c_position_id
401: and c_effective_date between pos.effective_start_date and
402: pos.effective_end_date;

Line 548: from per_position_definitions pdf, hr_all_positions_f pos

544: cursor c_old_pos_segments(c_position_id hr_all_positions_f.position_id%type,
545: c_effective_date date) is
546: select information6,segment1,segment2,segment3,segment4,
547: segment5,segment6,segment7
548: from per_position_definitions pdf, hr_all_positions_f pos
549: where pos.position_definition_id = pdf.position_definition_id
550: and pos.position_id = c_position_id
551: and c_effective_date between pos.effective_start_date and
552: pos.effective_end_date;