APPS.GHR_UTILITY dependencies on FND_ID_FLEX_STRUCTURES_TL

Line 68: FUNCTION get_flex_num(p_flex_code fnd_id_flex_structures_tl.id_flex_code%TYPE,

64:
65:
66: --############### Function to get Flex Number #############################################
67:
68: FUNCTION get_flex_num(p_flex_code fnd_id_flex_structures_tl.id_flex_code%TYPE,
69: p_struct_name fnd_id_flex_structures_tl.id_flex_structure_name%TYPE) RETURN NUMBER IS
70:
71: CURSOR c_flex_num(c_flex_code fnd_id_flex_structures_tl.id_flex_code%TYPE,
72: c_struct_name fnd_id_flex_structures_tl.id_flex_structure_name%TYPE) IS

Line 69: p_struct_name fnd_id_flex_structures_tl.id_flex_structure_name%TYPE) RETURN NUMBER IS

65:
66: --############### Function to get Flex Number #############################################
67:
68: FUNCTION get_flex_num(p_flex_code fnd_id_flex_structures_tl.id_flex_code%TYPE,
69: p_struct_name fnd_id_flex_structures_tl.id_flex_structure_name%TYPE) RETURN NUMBER IS
70:
71: CURSOR c_flex_num(c_flex_code fnd_id_flex_structures_tl.id_flex_code%TYPE,
72: c_struct_name fnd_id_flex_structures_tl.id_flex_structure_name%TYPE) IS
73: select flx.id_flex_num

Line 71: CURSOR c_flex_num(c_flex_code fnd_id_flex_structures_tl.id_flex_code%TYPE,

67:
68: FUNCTION get_flex_num(p_flex_code fnd_id_flex_structures_tl.id_flex_code%TYPE,
69: p_struct_name fnd_id_flex_structures_tl.id_flex_structure_name%TYPE) RETURN NUMBER IS
70:
71: CURSOR c_flex_num(c_flex_code fnd_id_flex_structures_tl.id_flex_code%TYPE,
72: c_struct_name fnd_id_flex_structures_tl.id_flex_structure_name%TYPE) IS
73: select flx.id_flex_num
74: from fnd_id_flex_structures_tl flx
75: where flx.id_flex_code = c_flex_code -- 'POS'

Line 72: c_struct_name fnd_id_flex_structures_tl.id_flex_structure_name%TYPE) IS

68: FUNCTION get_flex_num(p_flex_code fnd_id_flex_structures_tl.id_flex_code%TYPE,
69: p_struct_name fnd_id_flex_structures_tl.id_flex_structure_name%TYPE) RETURN NUMBER IS
70:
71: CURSOR c_flex_num(c_flex_code fnd_id_flex_structures_tl.id_flex_code%TYPE,
72: c_struct_name fnd_id_flex_structures_tl.id_flex_structure_name%TYPE) IS
73: select flx.id_flex_num
74: from fnd_id_flex_structures_tl flx
75: where flx.id_flex_code = c_flex_code -- 'POS'
76: and flx.application_id = 800 --

Line 74: from fnd_id_flex_structures_tl flx

70:
71: CURSOR c_flex_num(c_flex_code fnd_id_flex_structures_tl.id_flex_code%TYPE,
72: c_struct_name fnd_id_flex_structures_tl.id_flex_structure_name%TYPE) IS
73: select flx.id_flex_num
74: from fnd_id_flex_structures_tl flx
75: where flx.id_flex_code = c_flex_code -- 'POS'
76: and flx.application_id = 800 --
77: and flx.id_flex_structure_name = c_struct_name -- 'US Federal Position'
78: and flx.language = 'US';

Line 79: l_flex_num fnd_id_flex_structures_tl.id_flex_num%type;

75: where flx.id_flex_code = c_flex_code -- 'POS'
76: and flx.application_id = 800 --
77: and flx.id_flex_structure_name = c_struct_name -- 'US Federal Position'
78: and flx.language = 'US';
79: l_flex_num fnd_id_flex_structures_tl.id_flex_num%type;
80:
81: BEGIN
82: -- Get Flex ID Number
83: FOR l_cur_flex_num IN c_flex_num(p_flex_code,p_struct_name) LOOP

Line 99: l_flex_num fnd_id_flex_structures_tl.id_flex_num%type;

95: from hr_organization_information oi
96: where org_information_context = 'Business Group Information'
97: and organization_id = c_bus_org_id;
98:
99: l_flex_num fnd_id_flex_structures_tl.id_flex_num%type;
100:
101: BEGIN
102: -- Get Flex ID Number
103: FOR l_cur_flex_num IN c_pos_flex_num(p_bus_org_id) LOOP

Line 110: FUNCTION get_segments(p_flex_num fnd_id_flex_structures_tl.id_flex_num%type,

106: RETURN l_flex_num;
107: END get_pos_flex_num;
108:
109: --############### Function to get Flex field segment values #############################################
110: FUNCTION get_segments(p_flex_num fnd_id_flex_structures_tl.id_flex_num%type,
111: p_flex_code fnd_id_flex_segments_vl.id_flex_code%type)
112: RETURN t_flex_recs IS
113:
114: CURSOR c_get_segment_rec(c_flex_num fnd_id_flex_structures_tl.id_flex_num%type,

Line 114: CURSOR c_get_segment_rec(c_flex_num fnd_id_flex_structures_tl.id_flex_num%type,

110: FUNCTION get_segments(p_flex_num fnd_id_flex_structures_tl.id_flex_num%type,
111: p_flex_code fnd_id_flex_segments_vl.id_flex_code%type)
112: RETURN t_flex_recs IS
113:
114: CURSOR c_get_segment_rec(c_flex_num fnd_id_flex_structures_tl.id_flex_num%type,
115: c_flex_code fnd_id_flex_segments_vl.id_flex_code%type) IS
116: SELECT
117: SEGMENT_NAME,
118: DESCRIPTION,