114: IS
115: CURSOR get_appraisal_status (l_appraisal_system_status VARCHAR2)
116: IS
117: SELECT meaning
118: FROM hr_lookups
119: WHERE lookup_type = 'APPRAISAL_SYSTEM_STATUS' AND lookup_code = l_appraisal_system_status;
120:
121: l_rec get_appraisal_info_rec;
122: l_appraisal_system_status VARCHAR2 (80);
266:
267: FUNCTION enable_share_for_topsupervisor (
268: p_planid IN per_perf_mgmt_plans.plan_id%TYPE,
269: p_personid IN per_personal_scorecards.person_id%TYPE,
270: p_lookupcode IN hr_lookups.lookup_code%TYPE
271: )
272: RETURN VARCHAR2
273: IS
274: RESULT VARCHAR2 (1) := 'N';