APPS.ENG_WORKFLOW_NTF_UTIL dependencies on WF_NOTIFICATION

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 879: IF (display_type = WF_NOTIFICATION.DOC_HTML ) THEN

875: -- Eng_Workflow_Util.Write_Debug('document_type ' || document_type);
876:
877:
878: -- Call GetMessageHTMLBody if display type is text/plain
879: IF (display_type = WF_NOTIFICATION.DOC_HTML ) THEN
880:
881: GetMessageHTMLBody
882: ( document_id => document_id
883: , display_type => display_type

Line 902: -- WF_NOTIFICATION.WriteToClob( document , l_doc);

898:
899: -- Eng_Workflow_Util.Close_Debug_Session;
900:
901: -- We are not supporting text message notification by default
902: -- WF_NOTIFICATION.WriteToClob( document , l_doc);
903:
904: -- Executing Custom Hook: Eng_Workflow_Ext.GetCustomMessageSubject. . .');
905: Eng_Workflow_Ext.GetCustomMessageBody
906: ( document_id => document_id

Line 1079: IF (display_type = WF_NOTIFICATION.DOC_TEXT ) THEN

1075:
1076:
1077: /* Not supporting text
1078: -- Call GetMessageHTMLBody if display type is text/plain
1079: IF (display_type = WF_NOTIFICATION.DOC_TEXT ) THEN
1080:
1081: GetMessageTextBody
1082: ( document_id => document_id
1083: , display_type => display_type

Line 1429: WF_NOTIFICATION.WriteToClob( document , l_doc);

1425:
1426:
1427: -- Eng_Workflow_Util.Close_Debug_Session;
1428:
1429: WF_NOTIFICATION.WriteToClob( document , l_doc);
1430:
1431: -- Executing Custom Hook: Eng_Workflow_Ext.GetCustomMessageSubject
1432: Eng_Workflow_Ext.GetCustomMessageBody
1433: ( document_id => document_id

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