290:
291:
292: cursor fnd_resp(l_a_id number,l_r_id number) is
293: select responsibility_id
294: from fnd_responsibility
295: where responsibility_id =l_r_id
296: and application_id=l_a_id;
297:
298:
348: end if;
349: close fnd_app;
350:
351: --if level is responsibility
352: --check validity of id against fnd_responsibility table
353: elsIF p_option_level=l_resp_value THEN
354:
355: -- check if the value forms a numerical value
356: --set to temp string for validation