[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select RECIPIENT_ROLE, ORIGINAL_RECIPIENT, FROM_ROLE, MORE_INFO_ROLE
into recipient, orig_recipient, from_role, more_info_role
from WF_NOTIFICATIONS WN
where WN.NOTIFICATION_ID = nid;
select 1
into dummy
from sys.dual
where exists ( select null
from wf_item_activity_statuses ias,
wf_item_activity_statuses_h iash,
wf_notifications ntf
where ntf.status = 'OPEN'
and ias.notification_id = ntf.notification_id
and ias.item_type = iash.item_type
and ias.item_key = iash.item_key
and ias.process_activity = iash.process_activity
and iash.notification_id in (select notification_id
from wf_notifications
where status in ('CLOSED','CANCELED','INVALID')
and from_role = username)
and ntf.notification_id = nid
);
select DECODE(MORE_INFO_ROLE, NULL, SUBJECT, FND_MESSAGE.GET_STRING('FND','FND_MORE_INFO_REQUESTED')||' '||SUBJECT) AS subject, to_user, from_user
into p_subject, p_touser, p_fromuser
from wf_notifications
where notification_id = p_nid;
SELECT 1
INTO dummy
FROM dual
WHERE username IN
(
SELECT fg.grantee_key
FROM wf_notifications wn,
wf_user_roles wur,
fnd_grants fg
WHERE ((wn.more_info_role IS NOT NULL AND wur.role_name = wn.more_info_role)
OR wur.role_name = wn.recipient_role)
AND fg.parameter1 = wur.user_name
AND fg.menu_id IN
(SELECT menu_id
FROM fnd_menus
WHERE menu_name = 'FND_WF_WORKLIST')
AND fg.object_id IN
(SELECT object_id
FROM fnd_objects
WHERE obj_name = 'NOTIFICATIONS')
AND fg.instance_set_id IN
(SELECT instance_set_id
FROM fnd_object_instance_sets
WHERE instance_set_name = 'WL_PROXY_ACCESS')
AND fg.instance_type = 'SET'
AND fg.start_date <= sysdate
AND (fg.end_date IS NULL OR fg.end_date > sysdate)
AND (fg.parameter2 IS NULL OR
(fg.parameter2 IS NOT NULL AND
INSTR(','||replace(trim(fg.parameter2), ' ')||',',
','||replace(trim(wn.message_type), ' ')||',') > 0)
)
AND wn.notification_id = nid
);