DBA Data[Home] [Help]

APPS.HR_WPM_MASS_APR_PUSH dependencies on WF_LOCAL_ROLES

Line 3186: l_to_wkr_role wf_local_roles.NAME%TYPE DEFAULT NULL;

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;

Line 3188: l_to_mgr_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;

Line 3190: l_to_nma_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';

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

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