APPS.GHR_UTILITY dependencies on FND_ID_FLEX_STRUCTURES_TL

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

54:
55:
56: --############### Function to get Flex Number #############################################
57:
58: FUNCTION get_flex_num(p_flex_code fnd_id_flex_structures_tl.id_flex_code%TYPE,
59: p_struct_name fnd_id_flex_structures_tl.id_flex_structure_name%TYPE) RETURN NUMBER IS
60:
61: CURSOR c_flex_num(c_flex_code fnd_id_flex_structures_tl.id_flex_code%TYPE,
62: c_struct_name fnd_id_flex_structures_tl.id_flex_structure_name%TYPE) IS

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

55:
56: --############### Function to get Flex Number #############################################
57:
58: FUNCTION get_flex_num(p_flex_code fnd_id_flex_structures_tl.id_flex_code%TYPE,
59: p_struct_name fnd_id_flex_structures_tl.id_flex_structure_name%TYPE) RETURN NUMBER IS
60:
61: CURSOR c_flex_num(c_flex_code fnd_id_flex_structures_tl.id_flex_code%TYPE,
62: c_struct_name fnd_id_flex_structures_tl.id_flex_structure_name%TYPE) IS
63: select flx.id_flex_num

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

57:
58: FUNCTION get_flex_num(p_flex_code fnd_id_flex_structures_tl.id_flex_code%TYPE,
59: p_struct_name fnd_id_flex_structures_tl.id_flex_structure_name%TYPE) RETURN NUMBER IS
60:
61: CURSOR c_flex_num(c_flex_code fnd_id_flex_structures_tl.id_flex_code%TYPE,
62: c_struct_name fnd_id_flex_structures_tl.id_flex_structure_name%TYPE) IS
63: select flx.id_flex_num
64: from fnd_id_flex_structures_tl flx
65: where flx.id_flex_code = c_flex_code -- 'POS'

Line 62: c_struct_name fnd_id_flex_structures_tl.id_flex_structure_name%TYPE) IS

58: FUNCTION get_flex_num(p_flex_code fnd_id_flex_structures_tl.id_flex_code%TYPE,
59: p_struct_name fnd_id_flex_structures_tl.id_flex_structure_name%TYPE) RETURN NUMBER IS
60:
61: CURSOR c_flex_num(c_flex_code fnd_id_flex_structures_tl.id_flex_code%TYPE,
62: c_struct_name fnd_id_flex_structures_tl.id_flex_structure_name%TYPE) IS
63: select flx.id_flex_num
64: from fnd_id_flex_structures_tl flx
65: where flx.id_flex_code = c_flex_code -- 'POS'
66: and flx.application_id = 800 --

Line 64: from fnd_id_flex_structures_tl flx

60:
61: CURSOR c_flex_num(c_flex_code fnd_id_flex_structures_tl.id_flex_code%TYPE,
62: c_struct_name fnd_id_flex_structures_tl.id_flex_structure_name%TYPE) IS
63: select flx.id_flex_num
64: from fnd_id_flex_structures_tl flx
65: where flx.id_flex_code = c_flex_code -- 'POS'
66: and flx.application_id = 800 --
67: and flx.id_flex_structure_name = c_struct_name -- 'US Federal Position'
68: and flx.language = 'US';

Line 69: l_flex_num fnd_id_flex_structures_tl.id_flex_num%type;

65: where flx.id_flex_code = c_flex_code -- 'POS'
66: and flx.application_id = 800 --
67: and flx.id_flex_structure_name = c_struct_name -- 'US Federal Position'
68: and flx.language = 'US';
69: l_flex_num fnd_id_flex_structures_tl.id_flex_num%type;
70:
71: BEGIN
72: -- Get Flex ID Number
73: FOR l_cur_flex_num IN c_flex_num(p_flex_code,p_struct_name) LOOP

Line 89: l_flex_num fnd_id_flex_structures_tl.id_flex_num%type;

85: from hr_organization_information oi
86: where org_information_context = 'Business Group Information'
87: and organization_id = c_bus_org_id;
88:
89: l_flex_num fnd_id_flex_structures_tl.id_flex_num%type;
90:
91: BEGIN
92: -- Get Flex ID Number
93: FOR l_cur_flex_num IN c_pos_flex_num(p_bus_org_id) LOOP

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

96: RETURN l_flex_num;
97: END get_pos_flex_num;
98:
99: --############### Function to get Flex field segment values #############################################
100: FUNCTION get_segments(p_flex_num fnd_id_flex_structures_tl.id_flex_num%type,
101: p_flex_code fnd_id_flex_segments_vl.id_flex_code%type)
102: RETURN t_flex_recs IS
103:
104: CURSOR c_get_segment_rec(c_flex_num fnd_id_flex_structures_tl.id_flex_num%type,

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

100: FUNCTION get_segments(p_flex_num fnd_id_flex_structures_tl.id_flex_num%type,
101: p_flex_code fnd_id_flex_segments_vl.id_flex_code%type)
102: RETURN t_flex_recs IS
103:
104: CURSOR c_get_segment_rec(c_flex_num fnd_id_flex_structures_tl.id_flex_num%type,
105: c_flex_code fnd_id_flex_segments_vl.id_flex_code%type) IS
106: SELECT
107: SEGMENT_NAME,
108: DESCRIPTION,