35: FUNCTION get_segments(p_flex_num fnd_id_flex_structures_tl.id_flex_num%type,
36: p_flex_code fnd_id_flex_segments_vl.id_flex_code%type) RETURN t_flex_recs;
37:
38:
39: FUNCTION return_pos_name(l_pos_title per_position_definitions.segment1%type,
40: l_pos_desc per_position_definitions.segment1%type,
41: l_seq_no per_position_definitions.segment1%type,
42: l_agency_code per_position_definitions.segment1%type,
43: l_po_id per_position_definitions.segment1%type,
36: p_flex_code fnd_id_flex_segments_vl.id_flex_code%type) RETURN t_flex_recs;
37:
38:
39: FUNCTION return_pos_name(l_pos_title per_position_definitions.segment1%type,
40: l_pos_desc per_position_definitions.segment1%type,
41: l_seq_no per_position_definitions.segment1%type,
42: l_agency_code per_position_definitions.segment1%type,
43: l_po_id per_position_definitions.segment1%type,
44: l_grade per_position_definitions.segment1%type,
37:
38:
39: FUNCTION return_pos_name(l_pos_title per_position_definitions.segment1%type,
40: l_pos_desc per_position_definitions.segment1%type,
41: l_seq_no per_position_definitions.segment1%type,
42: l_agency_code per_position_definitions.segment1%type,
43: l_po_id per_position_definitions.segment1%type,
44: l_grade per_position_definitions.segment1%type,
45: l_nfc_agency_code per_position_definitions.segment1%type,
38:
39: FUNCTION return_pos_name(l_pos_title per_position_definitions.segment1%type,
40: l_pos_desc per_position_definitions.segment1%type,
41: l_seq_no per_position_definitions.segment1%type,
42: l_agency_code per_position_definitions.segment1%type,
43: l_po_id per_position_definitions.segment1%type,
44: l_grade per_position_definitions.segment1%type,
45: l_nfc_agency_code per_position_definitions.segment1%type,
46: l_full_title hr_positions_f.name%type)
39: FUNCTION return_pos_name(l_pos_title per_position_definitions.segment1%type,
40: l_pos_desc per_position_definitions.segment1%type,
41: l_seq_no per_position_definitions.segment1%type,
42: l_agency_code per_position_definitions.segment1%type,
43: l_po_id per_position_definitions.segment1%type,
44: l_grade per_position_definitions.segment1%type,
45: l_nfc_agency_code per_position_definitions.segment1%type,
46: l_full_title hr_positions_f.name%type)
47: RETURN VARCHAR2;
40: l_pos_desc per_position_definitions.segment1%type,
41: l_seq_no per_position_definitions.segment1%type,
42: l_agency_code per_position_definitions.segment1%type,
43: l_po_id per_position_definitions.segment1%type,
44: l_grade per_position_definitions.segment1%type,
45: l_nfc_agency_code per_position_definitions.segment1%type,
46: l_full_title hr_positions_f.name%type)
47: RETURN VARCHAR2;
48:
41: l_seq_no per_position_definitions.segment1%type,
42: l_agency_code per_position_definitions.segment1%type,
43: l_po_id per_position_definitions.segment1%type,
44: l_grade per_position_definitions.segment1%type,
45: l_nfc_agency_code per_position_definitions.segment1%type,
46: l_full_title hr_positions_f.name%type)
47: RETURN VARCHAR2;
48:
49: FUNCTION return_nfc_pos_name(l_pos_title per_position_definitions.segment1%type,
45: l_nfc_agency_code per_position_definitions.segment1%type,
46: l_full_title hr_positions_f.name%type)
47: RETURN VARCHAR2;
48:
49: FUNCTION return_nfc_pos_name(l_pos_title per_position_definitions.segment1%type,
50: l_pos_desc per_position_definitions.segment1%type,
51: l_seq_no per_position_definitions.segment1%type,
52: l_agency_code per_position_definitions.segment1%type,
53: l_po_id per_position_definitions.segment1%type,
46: l_full_title hr_positions_f.name%type)
47: RETURN VARCHAR2;
48:
49: FUNCTION return_nfc_pos_name(l_pos_title per_position_definitions.segment1%type,
50: l_pos_desc per_position_definitions.segment1%type,
51: l_seq_no per_position_definitions.segment1%type,
52: l_agency_code per_position_definitions.segment1%type,
53: l_po_id per_position_definitions.segment1%type,
54: l_grade per_position_definitions.segment1%type,
47: RETURN VARCHAR2;
48:
49: FUNCTION return_nfc_pos_name(l_pos_title per_position_definitions.segment1%type,
50: l_pos_desc per_position_definitions.segment1%type,
51: l_seq_no per_position_definitions.segment1%type,
52: l_agency_code per_position_definitions.segment1%type,
53: l_po_id per_position_definitions.segment1%type,
54: l_grade per_position_definitions.segment1%type,
55: l_nfc_agency_code per_position_definitions.segment1%type,
48:
49: FUNCTION return_nfc_pos_name(l_pos_title per_position_definitions.segment1%type,
50: l_pos_desc per_position_definitions.segment1%type,
51: l_seq_no per_position_definitions.segment1%type,
52: l_agency_code per_position_definitions.segment1%type,
53: l_po_id per_position_definitions.segment1%type,
54: l_grade per_position_definitions.segment1%type,
55: l_nfc_agency_code per_position_definitions.segment1%type,
56: l_full_title hr_positions_f.name%type)
49: FUNCTION return_nfc_pos_name(l_pos_title per_position_definitions.segment1%type,
50: l_pos_desc per_position_definitions.segment1%type,
51: l_seq_no per_position_definitions.segment1%type,
52: l_agency_code per_position_definitions.segment1%type,
53: l_po_id per_position_definitions.segment1%type,
54: l_grade per_position_definitions.segment1%type,
55: l_nfc_agency_code per_position_definitions.segment1%type,
56: l_full_title hr_positions_f.name%type)
57: RETURN VARCHAR2;
50: l_pos_desc per_position_definitions.segment1%type,
51: l_seq_no per_position_definitions.segment1%type,
52: l_agency_code per_position_definitions.segment1%type,
53: l_po_id per_position_definitions.segment1%type,
54: l_grade per_position_definitions.segment1%type,
55: l_nfc_agency_code per_position_definitions.segment1%type,
56: l_full_title hr_positions_f.name%type)
57: RETURN VARCHAR2;
58:
51: l_seq_no per_position_definitions.segment1%type,
52: l_agency_code per_position_definitions.segment1%type,
53: l_po_id per_position_definitions.segment1%type,
54: l_grade per_position_definitions.segment1%type,
55: l_nfc_agency_code per_position_definitions.segment1%type,
56: l_full_title hr_positions_f.name%type)
57: RETURN VARCHAR2;
58:
59: -- End NFC Changes