DBA Data[Home] [Help]

APPS.GHR_UTILITY dependencies on PER_POSITION_DEFINITIONS

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

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,

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

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

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

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

Line 44: l_grade 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;
48:

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

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

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

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

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

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

Line 54: l_grade 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;
58:

Line 55: l_nfc_agency_code 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:
59: -- End NFC Changes