DBA Data[Home] [Help]

APPS.HR_WPM_NTF_UTIL dependencies on WF_LOCAL_ROLES

Line 84: from_role wf_local_roles.NAME%TYPE DEFAULT NULL;

80: AND ptu.person_type_id = ppt.person_type_id
81: AND ppt.system_person_type IN ('EMP', 'CWK', 'EMP_APL', 'CWK_APL'));
82:
83: ln_notification_id NUMBER;
84: from_role wf_local_roles.NAME%TYPE DEFAULT NULL;
85: to_role wf_local_roles.NAME%TYPE DEFAULT NULL;
86: from_name per_all_people_f.GLOBAL_NAME%TYPE;
87: to_name per_all_people_f.GLOBAL_NAME%TYPE;
88: from_role_not_exists EXCEPTION;

Line 85: to_role wf_local_roles.NAME%TYPE DEFAULT NULL;

81: AND ppt.system_person_type IN ('EMP', 'CWK', 'EMP_APL', 'CWK_APL'));
82:
83: ln_notification_id NUMBER;
84: from_role wf_local_roles.NAME%TYPE DEFAULT NULL;
85: to_role wf_local_roles.NAME%TYPE DEFAULT NULL;
86: from_name per_all_people_f.GLOBAL_NAME%TYPE;
87: to_name per_all_people_f.GLOBAL_NAME%TYPE;
88: from_role_not_exists EXCEPTION;
89: to_role_not_exists EXCEPTION;