452: RAISE;
453: END check_competence_exists;
454:
455: FUNCTION Get_Res_Competences
456: (p_person_id IN pa_resources_denorm.person_id%TYPE)
457: RETURN VARCHAR2 IS
458:
459: TYPE number_tbl IS TABLE OF NUMBER(15);
460: TYPE varchar240_tbl IS TABLE OF VARCHAR(240);
510:
511: END Get_Res_Competences;
512:
513: FUNCTION Get_Res_Competences_Count
514: (p_person_id IN pa_resources_denorm.person_id%TYPE)
515: RETURN NUMBER IS
516: l_count NUMBER;
517: BEGIN
518: SELECT count(*)
528: RAISE;
529: END Get_Res_Competences_Count;
530:
531: FUNCTION Get_Res_Comp_Last_Updated
532: (p_person_id IN pa_resources_denorm.person_id%TYPE)
533: RETURN DATE IS
534: l_date DATE;
535: BEGIN
536: SELECT MAX(last_update_date)