DBA Data[Home] [Help]

APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on WF_LOCAL_ROLES

Line 9394: l_to_role wf_local_roles.NAME%TYPE DEFAULT NULL;

9390: --bug14046867
9391: to_role_not_exists EXCEPTION;
9392: from_role_not_exists EXCEPTION;
9393: err_msg VARCHAR2 (2000);
9394: l_to_role wf_local_roles.NAME%TYPE DEFAULT NULL;
9395: l_from_role wf_local_roles.NAME%TYPE DEFAULT NULL;
9396: ln_notification_id NUMBER;
9397: BEGIN
9398: OPEN get_role (p_person_id);

Line 9395: l_from_role wf_local_roles.NAME%TYPE DEFAULT NULL;

9391: to_role_not_exists EXCEPTION;
9392: from_role_not_exists EXCEPTION;
9393: err_msg VARCHAR2 (2000);
9394: l_to_role wf_local_roles.NAME%TYPE DEFAULT NULL;
9395: l_from_role wf_local_roles.NAME%TYPE DEFAULT NULL;
9396: ln_notification_id NUMBER;
9397: BEGIN
9398: OPEN get_role (p_person_id);
9399:

Line 9520: l_role wf_local_roles.NAME%TYPE DEFAULT NULL;

9516: AND TRUNC (SYSDATE) BETWEEN effective_start_date AND effective_end_date
9517: AND assignment_id = p_assignment_id;
9518:
9519: l_super_visor_id per_all_assignments_f.supervisor_id%TYPE;
9520: l_role wf_local_roles.NAME%TYPE DEFAULT NULL;
9521: BEGIN
9522: OPEN get_supervisor_id (p_person_id);
9523:
9524: FETCH get_supervisor_id