APPS.WF_NOTIFICATION dependencies on WF_MESSAGES

Line 2694: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM

2690: begin
2691: -- Get subject
2692: select WM.SUBJECT
2693: into local_subject
2694: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM
2695: where N.NOTIFICATION_ID = nid
2696: and N.MESSAGE_NAME = WM.NAME
2697: and N.MESSAGE_TYPE = WM.TYPE;
2698:

Line 2786: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM

2782: begin
2783: -- Get body
2784: select WM.BODY, WM.HTML_BODY
2785: into local_body, local_html_body
2786: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM
2787: where N.NOTIFICATION_ID = nid
2788: and N.MESSAGE_NAME = WM.NAME
2789: and N.MESSAGE_TYPE = WM.TYPE;
2790:

Line 2936: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM

2932: begin
2933: -- Get body
2934: select WM.BODY
2935: into local_body
2936: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM
2937: where N.NOTIFICATION_ID = nid
2938: and N.MESSAGE_NAME = WM.NAME
2939: and N.MESSAGE_TYPE = WM.TYPE;
2940:

Line 3775: from WF_MESSAGES WM

3771: sendsingle.due_date,
3772: -- sendsingle.send_comment,
3773: sendsingle.callback,
3774: sendsingle.context
3775: from WF_MESSAGES WM
3776: where WM.TYPE = sendsingle.msg_type
3777: and WM.NAME = sendsingle.msg_name;
3778:
3779: -- Open and parse cursor for dynamic sql for getting attr values

Line 4086: from WF_MESSAGES M

4082: -- Check message is valid
4083: begin
4084: select 1 into dummy from sys.dual where exists
4085: (select null
4086: from WF_MESSAGES M
4087: where M.TYPE = msg_type
4088: and M.NAME = msg_name);
4089: exception
4090: when no_data_found then

Line 4208: from WF_MESSAGES M

4204: -- Check message is valid
4205: begin
4206: select 1 into dummy from sys.dual where exists
4207: (select null
4208: from WF_MESSAGES M
4209: where M.TYPE = msg_type
4210: and M.NAME = msg_name);
4211: exception
4212: when no_data_found then

Line 5310: FROM wf_messages_vl

5306:
5307: -- Get the message subject
5308: SELECT SUBJECT
5309: INTO local_text
5310: FROM wf_messages_vl
5311: WHERE type = message_type
5312: AND name = message_name;
5313:
5314: for msg_attr_row in message_attrs_cursor (message_type, message_name) loop

Line 5382: FROM wf_messages_vl

5378:
5379: -- Get the message subject
5380: SELECT SUBJECT
5381: INTO local_text
5382: FROM wf_messages_vl
5383: WHERE type = message_type
5384: AND name = message_name;
5385:
5386: for msg_attr_row in message_attrs_cursor (message_type, message_name) loop

Line 8895: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM

8891: lv_fwk_body := 'N';
8892:
8893: select nvl(WM.BODY, ''), nvl(WM.HTML_BODY, '')
8894: into lv_body, lv_html_body
8895: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM
8896: where N.NOTIFICATION_ID = nid
8897: and N.MESSAGE_NAME = WM.NAME
8898: and N.MESSAGE_TYPE = WM.TYPE;
8899: