3267: RAISE;
3268: END; -- get_events
3269:
3270: --
3271: -- Get the per system status from per_assignment_status_types
3272: --
3273: FUNCTION get_status_type
3274: (p_status_type_id IN NUMBER
3275: ) RETURN VARCHAR2
3279: g_proc_name||'get_status_type';
3280:
3281: CURSOR csr_status_type IS
3282: SELECT per_system_status
3283: FROM per_assignment_status_types
3284: WHERE assignment_status_type_id = p_status_type_id;
3285:
3286: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
3287:
3282: SELECT per_system_status
3283: FROM per_assignment_status_types
3284: WHERE assignment_status_type_id = p_status_type_id;
3285:
3286: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
3287:
3288: BEGIN -- get_status_type
3289:
3290: debug_enter(l_proc_name);