95: WHEN OTHERS THEN
96: return '';
97: END Get_Privacy_Lvl_Format_Str;
98:
99: FUNCTION get_person_encumb(p_person_id igs_pe_person.person_id%TYPE) RETURN VARCHAR2 IS
100: ------------------------------------------------------------------
101: --Created by : rboddu , Oracle India
102: --Date created: 16-JUL-2002
103: --
175:
176: -- Cursor to find the full name of the user logged in
177: CURSOR person_name_cur(cp_person_id hz_parties.party_id%TYPE) IS
178: SELECT person_number,full_name
179: FROM igs_pe_person_base_v
180: WHERE person_id = cp_person_id;
181:
182: l_staff VARCHAR2(1);
183: BEGIN