APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on WF_LOCAL_ROLES

Line 425: DELETE FROM WF_LOCAL_ROLES B WHERE NAME LIKE 'CSM%ROLE'

421:
422: COMMIT;
423:
424: /*12.1.2 PURGE INACTIVE CSM WF ROLES*/
425: DELETE FROM WF_LOCAL_ROLES B WHERE NAME LIKE 'CSM%ROLE'
426: AND NOT EXISTS( SELECT 1 FROM FND_USER U
427: WHERE USER_NAME=substr(B.NAME,5,length(B.NAME)-9)
428: AND sysdate between nvl(start_date,sysdate-1) and nvl(end_date,sysdate+1));
429:

Line 841: FROM WF_LOCAL_ROLES wf, ASG_USER au

837: l_upd BOOLEAN:=false;
838: BEGIN
839: BEGIN
840: SELECT wf.name,wf.email_address,wf.notification_preference INTO role_name,l_wf_email ,l_pref
841: FROM WF_LOCAL_ROLES wf, ASG_USER au
842: WHERE wf.name ='CSM_'||b_user_name||'_ROLE'
843: AND au.user_name=b_user_name
844: AND au.enabled='Y';
845:

Line 856: l_stmt:= 'UPDATE WF_LOCAL_ROLES SET DESCRIPTION=DESCRIPTION ';

852: 'CSM_NOTIFICATION_EVENT_PKG.createMobileWFUser',FND_LOG.LEVEL_PROCEDURE);
853: RETURN FALSE;
854: END IF;
855:
856: l_stmt:= 'UPDATE WF_LOCAL_ROLES SET DESCRIPTION=DESCRIPTION ';
857:
858:
859: IF l_pref<> 'MAILTEXT' THEN
860: l_stmt := l_stmt||' , notification_preference=''MAILTEXT''';

Line 878: FROM FND_USER fu, Asg_user au ,wf_local_roles wf

874: EXCEPTION
875: WHEN no_data_found THEN
876: SELECT 'CSM_'||fu.user_name||'_ROLE',wf.display_name,fu.email_address
877: INTO role_name,role_display_name,l_fnd_email
878: FROM FND_USER fu, Asg_user au ,wf_local_roles wf
879: WHERE fu.user_name=b_user_name
880: AND sysdate between nvl(fu.start_date,sysdate-1) and nvl(fu.end_date,sysdate+1)
881: AND wf.name=fu.USER_NAME AND au.USER_NAME=fu.USER_NAME AND au.ENABLED='Y' ;
882: