DBA Data[Home] [Help]

APPS.GHR_UTILITY dependencies on PER_POSITION_DEFINITIONS

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

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,

Line 43: l_pos_desc 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,

Line 44: l_seq_no 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,

Line 45: l_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)

Line 46: l_po_id per_position_definitions.segment1%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;

Line 47: l_grade 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;
51:

Line 48: l_nfc_agency_code 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:
52: FUNCTION return_nfc_pos_name(l_pos_title per_position_definitions.segment1%type,

Line 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,

Line 53: l_pos_desc 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,

Line 54: l_seq_no 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,

Line 55: l_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)

Line 56: l_po_id per_position_definitions.segment1%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;

Line 57: l_grade 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;
61:

Line 58: l_nfc_agency_code 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:
62: -- End NFC Changes