APPS.HR_HELPDESK_UTIL_SS dependencies on FND_FORM_FUNCTIONS

Line 120: (func_name fnd_form_functions.function_name%type,

116: END get_assign_status;
117:
118:
119: FUNCTION validate_function
120: (func_name fnd_form_functions.function_name%type,
121: bus_grp_id per_all_people_f.business_group_id%type)
122: RETURN varchar2 is
123: l_count number;
124: p_count number;

Line 145: FROM fnd_form_functions

141: )
142: CONNECT BY fme.menu_id = PRIOR fme.sub_menu_id)
143: WHERE function_id IN
144: (SELECT function_id
145: FROM fnd_form_functions
146: WHERE function_name = 'HR_HELPDESK_SS')
147: ;
148:
149:

Line 173: FROM fnd_form_functions

169: )
170: CONNECT BY fme.menu_id = PRIOR fme.sub_menu_id)
171: WHERE function_id IN
172: (SELECT function_id
173: FROM fnd_form_functions
174: WHERE function_name = func_name)
175: ;
176:
177: if p_count > 0 then

Line 202: SELECT type INTO func_type FROM fnd_form_functions WHERE function_name = func_name;

198: func_type varchar2(5);
199:
200: BEGIN
201:
202: SELECT type INTO func_type FROM fnd_form_functions WHERE function_name = func_name;
203: If func_type = 'FORM' then
204: return 'F';
205: Elsif func_type = 'JSP' then
206: return 'J';

Line 218: FUNCTION get_resp_name(func_name fnd_form_functions.function_name%type,

214:
215: END get_function_type;
216:
217:
218: FUNCTION get_resp_name(func_name fnd_form_functions.function_name%type,
219: bus_grp_id per_all_people_f.business_group_id%type)
220: RETURN VARCHAR2 IS
221:
222: l_resp_name fnd_responsibility.RESPONSIBILITY_KEY%type;

Line 233: FROM fnd_form_functions

229: WHERE menu_id IN
230: (SELECT menu_id
231: FROM fnd_menu_entries fme START WITH fme.function_id =
232: (SELECT function_id
233: FROM fnd_form_functions
234: WHERE function_name = func_name)
235: CONNECT BY PRIOR fme.menu_id = fme.sub_menu_id)
236: AND responsibility_id IN
237: (SELECT responsibility_id