98: RETURN VARCHAR2 ;
99: PRAGMA RESTRICT_REFERENCES (check_competence_exists , WNPS , WNDS);
100:
101: FUNCTION Get_Res_competences
102: ( p_person_id IN pa_resources_denorm.person_id%TYPE )
103: RETURN VARCHAR2;
104:
105: FUNCTION Get_Res_Competences_Count
106: ( p_person_id IN pa_resources_denorm.person_id%TYPE)
102: ( p_person_id IN pa_resources_denorm.person_id%TYPE )
103: RETURN VARCHAR2;
104:
105: FUNCTION Get_Res_Competences_Count
106: ( p_person_id IN pa_resources_denorm.person_id%TYPE)
107: RETURN NUMBER;
108:
109: FUNCTION Get_Res_Comp_Last_Updated
110: ( p_person_id IN pa_resources_denorm.person_id%TYPE)
106: ( p_person_id IN pa_resources_denorm.person_id%TYPE)
107: RETURN NUMBER;
108:
109: FUNCTION Get_Res_Comp_Last_Updated
110: ( p_person_id IN pa_resources_denorm.person_id%TYPE)
111: RETURN DATE;
112:
113: FUNCTION Get_Req_Competences
114: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE)