APPS.WF_NOTIFICATION dependencies on WF_MESSAGES

Line 2608: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM

2604: begin
2605: -- Get subject
2606: select WM.SUBJECT
2607: into local_subject
2608: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM
2609: where N.NOTIFICATION_ID = nid
2610: and N.MESSAGE_NAME = WM.NAME
2611: and N.MESSAGE_TYPE = WM.TYPE;
2612:

Line 2700: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM

2696: begin
2697: -- Get body
2698: select WM.BODY, WM.HTML_BODY
2699: into local_body, local_html_body
2700: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM
2701: where N.NOTIFICATION_ID = nid
2702: and N.MESSAGE_NAME = WM.NAME
2703: and N.MESSAGE_TYPE = WM.TYPE;
2704:

Line 2850: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM

2846: begin
2847: -- Get body
2848: select WM.BODY
2849: into local_body
2850: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM
2851: where N.NOTIFICATION_ID = nid
2852: and N.MESSAGE_NAME = WM.NAME
2853: and N.MESSAGE_TYPE = WM.TYPE;
2854:

Line 3658: from WF_MESSAGES WM

3654: sendsingle.due_date,
3655: -- sendsingle.send_comment,
3656: sendsingle.callback,
3657: sendsingle.context
3658: from WF_MESSAGES WM
3659: where WM.TYPE = sendsingle.msg_type
3660: and WM.NAME = sendsingle.msg_name;
3661:
3662: -- Open and parse cursor for dynamic sql for getting attr values

Line 3955: from WF_MESSAGES M

3951: -- Check message is valid
3952: begin
3953: select 1 into dummy from sys.dual where exists
3954: (select null
3955: from WF_MESSAGES M
3956: where M.TYPE = msg_type
3957: and M.NAME = msg_name);
3958: exception
3959: when no_data_found then

Line 4073: from WF_MESSAGES M

4069: -- Check message is valid
4070: begin
4071: select 1 into dummy from sys.dual where exists
4072: (select null
4073: from WF_MESSAGES M
4074: where M.TYPE = msg_type
4075: and M.NAME = msg_name);
4076: exception
4077: when no_data_found then

Line 5473: FROM wf_messages_vl

5469:
5470: -- Get the message subject
5471: SELECT SUBJECT
5472: INTO local_text
5473: FROM wf_messages_vl
5474: WHERE type = message_type
5475: AND name = message_name;
5476:
5477: for msg_attr_row in message_attrs_cursor (message_type, message_name) loop

Line 5545: FROM wf_messages_vl

5541:
5542: -- Get the message subject
5543: SELECT SUBJECT
5544: INTO local_text
5545: FROM wf_messages_vl
5546: WHERE type = message_type
5547: AND name = message_name;
5548:
5549: for msg_attr_row in message_attrs_cursor (message_type, message_name) loop

Line 8645: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM

8641: lv_fwk_body := 'N';
8642:
8643: select nvl(WM.BODY, ''), nvl(WM.HTML_BODY, '')
8644: into lv_body, lv_html_body
8645: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM
8646: where N.NOTIFICATION_ID = nid
8647: and N.MESSAGE_NAME = WM.NAME
8648: and N.MESSAGE_TYPE = WM.TYPE;
8649: