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