DBA Data[Home] [Help]

APPS.ENG_WORKFLOW_NTF_UTIL dependencies on WF_NOTIFICATIONS

Line 31: FROM WF_NOTIFICATIONS

27: CURSOR c_msg (p_nid NUMBER)
28: IS
29:
30: SELECT message_name
31: FROM WF_NOTIFICATIONS
32: WHERE notification_id = p_nid ;
33:
34: l_msg_name VARCHAR2(30) ;
35:

Line 119: FROM WF_NOTIFICATIONS wfn

115: CURSOR c_ntf (p_nid NUMBER)
116: IS
117:
118: SELECT 'This is To Do Ntf'
119: FROM WF_NOTIFICATIONS wfn
120: WHERE EXISTS (SELECT null
121: FROM WF_MESSAGE_ATTRIBUTES wfma
122: WHERE wfma.subtype = 'RESPOND'
123: AND wfma.message_name = wfn.message_name

Line 1538: , WF_NOTIFICATIONS wn

1534: , u.USER_ID
1535: , u.PARTY_ID
1536: , u.PARTY_NAME
1537: FROM EGO_USER_V u
1538: , WF_NOTIFICATIONS wn
1539: WHERE u.USER_NAME = wn.RECIPIENT_ROLE
1540: AND wn.NOTIFICATION_ID = c_ntf_id ;
1541:
1542: BEGIN