6543: TO_ROLE_NOT_EXISTS exception;
6544: FROM_ROLE_NOT_EXISTS exception;
6545:
6546: err_msg varchar2(2000);
6547: l_to_role wf_local_roles.name%TYPE default null;
6548: l_from_role wf_local_roles.name%TYPE default null;
6549: ln_notification_id number;
6550: begin
6551:
6544: FROM_ROLE_NOT_EXISTS exception;
6545:
6546: err_msg varchar2(2000);
6547: l_to_role wf_local_roles.name%TYPE default null;
6548: l_from_role wf_local_roles.name%TYPE default null;
6549: ln_notification_id number;
6550: begin
6551:
6552: open get_role(p_person_id);
6618: and primary_flag = 'Y';
6619:
6620:
6621: l_super_visor_id per_all_assignments_f.supervisor_id%type;
6622: l_role wf_local_roles.name%TYPE default null;
6623: begin
6624:
6625: open get_supervisor_id(p_person_id);
6626: fetch get_supervisor_id into l_super_visor_id;