29: FUNCTION check_profile_exists
30: (p_profile_name IN varchar2) RETURN boolean IS
31: l_profile_value varchar2(30);
32: BEGIN 33: fnd_profile.get (p_profile_name 34: ,l_profile_value);
35:
36: IF l_profile_value = 'PARTIAL'
37: OR l_profile_value = 'ALL' THEN