APPS.WF_MAIL dependencies on WF_MESSAGES_VL

Line 2244: from WF_MESSAGES_VL

2240: -- Get template 'WARNING'
2241: begin
2242: select SUBJECT, BODY, HTML_BODY
2243: into t_subject, t_text_body, t_html_body
2244: from WF_MESSAGES_VL
2245: where NAME = messageName
2246: and TYPE = itemType;
2247: exception
2248: when no_data_found then

Line 2395: from WF_MESSAGES_VL

2391: -- message attribute if used contains a typo
2392: begin
2393: select 1
2394: into validTemplate
2395: from WF_MESSAGES_VL
2396: where NAME = t_name
2397: and TYPE = t_type;
2398: exception
2399: when NO_DATA_FOUND then

Line 2965: from WF_MESSAGES_VL

2961: -- Get template
2962: begin
2963: select SUBJECT, BODY, HTML_BODY
2964: into t_subject, t_text_body, t_html_body
2965: from WF_MESSAGES_VL
2966: where NAME = t_name and TYPE = t_type;
2967: exception
2968: when no_data_found then
2969: wf_core.token('NAME', t_name);

Line 3102: from WF_MESSAGES_VL

3098: -- Check to see if the response is included in the template
3099: begin
3100: select 'Y'
3101: into n_response_exists
3102: from WF_MESSAGES_VL
3103: where NAME = t_name and TYPE = 'WFMAIL'
3104: and instr(body,'&'||'RESPONSE')<>0;
3105: exception
3106: when no_data_found then

Line 4754: FROM wf_notifications n, wf_messages_vl wm

4750: l_get_text := false;
4751:
4752: SELECT wm.body, wm.html_body
4753: INTO l_text_body, l_html_body
4754: FROM wf_notifications n, wf_messages_vl wm
4755: WHERE n.notification_id = p_nid
4756: AND n.message_name = wm.name
4757: AND n.message_type = wm.type;
4758:

Line 5052: from WF_MESSAGES_VL

5048: -- Get template
5049: begin
5050: select SUBJECT, BODY, HTML_BODY
5051: into t_subject, t_text_body, t_html_body
5052: from WF_MESSAGES_VL
5053: where NAME = t_name and TYPE = t_type;
5054: exception
5055: when no_data_found then
5056: wf_core.token('NAME', t_name);

Line 5723: from WF_MESSAGES_VL

5719: -- Get template 'SUMMARY'
5720: begin
5721: select SUBJECT, BODY, HTML_BODY
5722: into t_subject, t_body, t_html_body
5723: from WF_MESSAGES_VL
5724: where NAME = templateName
5725: and TYPE = templateType;
5726: exception
5727: when no_data_found then

Line 6996: from WF_MESSAGES_VL

6992: -- Get the template.
6993: begin
6994: select SUBJECT, HTML_BODY
6995: into l_subject, l_html_body
6996: from WF_MESSAGES_VL
6997: where NAME = 'ATTACHED_URLS' and TYPE = 'WFMAIL';
6998: exception
6999: when no_data_found then
7000: -- If the template has not been installed, then construct a

Line 8060: FROM wf_messages_vl

8056:
8057: -- Get template 'WARNING'
8058: SELECT subject, BODY, HTML_BODY
8059: INTO l_subject,l_text_body,l_html_body
8060: FROM wf_messages_vl
8061: WHERE name = 'MORE_INFO_ANSWERED'
8062: AND type = 'WFMAIL';
8063:
8064: -- Get Error message