3182: l_no_of_errors NUMBER DEFAULT 0;
3183: l_no_of_processed NUMBER DEFAULT 0;
3184: ecode NUMBER;
3185: emesg VARCHAR2 (4000);
3186: l_to_wkr_role wf_local_roles.NAME%TYPE DEFAULT NULL;
3187: l_to_wkr_name per_all_people_f.full_name%TYPE;
3188: l_to_mgr_role wf_local_roles.NAME%TYPE DEFAULT NULL;
3189: l_to_mgr_name per_all_people_f.full_name%TYPE;
3190: l_to_nma_role wf_local_roles.NAME%TYPE DEFAULT NULL;
3184: ecode NUMBER;
3185: emesg VARCHAR2 (4000);
3186: l_to_wkr_role wf_local_roles.NAME%TYPE DEFAULT NULL;
3187: l_to_wkr_name per_all_people_f.full_name%TYPE;
3188: l_to_mgr_role wf_local_roles.NAME%TYPE DEFAULT NULL;
3189: l_to_mgr_name per_all_people_f.full_name%TYPE;
3190: l_to_nma_role wf_local_roles.NAME%TYPE DEFAULT NULL;
3191: l_to_nma_name per_all_people_f.full_name%TYPE;
3192: l_from_role wf_local_roles.NAME%TYPE DEFAULT NULL;
3186: l_to_wkr_role wf_local_roles.NAME%TYPE DEFAULT NULL;
3187: l_to_wkr_name per_all_people_f.full_name%TYPE;
3188: l_to_mgr_role wf_local_roles.NAME%TYPE DEFAULT NULL;
3189: l_to_mgr_name per_all_people_f.full_name%TYPE;
3190: l_to_nma_role wf_local_roles.NAME%TYPE DEFAULT NULL;
3191: l_to_nma_name per_all_people_f.full_name%TYPE;
3192: l_from_role wf_local_roles.NAME%TYPE DEFAULT NULL;
3193: ln_notification_id NUMBER;
3194: l_dummy VARCHAR2 (1) DEFAULT 'N';
3188: l_to_mgr_role wf_local_roles.NAME%TYPE DEFAULT NULL;
3189: l_to_mgr_name per_all_people_f.full_name%TYPE;
3190: l_to_nma_role wf_local_roles.NAME%TYPE DEFAULT NULL;
3191: l_to_nma_name per_all_people_f.full_name%TYPE;
3192: l_from_role wf_local_roles.NAME%TYPE DEFAULT NULL;
3193: ln_notification_id NUMBER;
3194: l_dummy VARCHAR2 (1) DEFAULT 'N';
3195: l_plan_id per_personal_scorecards.plan_id%TYPE;
3196: BEGIN