APPS.WF_MAIL dependencies on WF_MESSAGES_VL

Line 2398: from WF_MESSAGES_VL

2394: -- Get template 'WARNING'
2395: begin
2396: select SUBJECT, BODY, HTML_BODY
2397: into t_subject, t_text_body, t_html_body
2398: from WF_MESSAGES_VL
2399: where NAME = messageName
2400: and TYPE = itemType;
2401: exception
2402: when no_data_found then

Line 2549: from WF_MESSAGES_VL

2545: -- message attribute if used contains a typo
2546: begin
2547: select 1
2548: into validTemplate
2549: from WF_MESSAGES_VL
2550: where NAME = t_name
2551: and TYPE = t_type;
2552: exception
2553: when NO_DATA_FOUND then

Line 3119: from WF_MESSAGES_VL

3115: -- Get template
3116: begin
3117: select SUBJECT, BODY, HTML_BODY
3118: into t_subject, t_text_body, t_html_body
3119: from WF_MESSAGES_VL
3120: where NAME = t_name and TYPE = t_type;
3121: exception
3122: when no_data_found then
3123: wf_core.token('NAME', t_name);

Line 3256: from WF_MESSAGES_VL

3252: -- Check to see if the response is included in the template
3253: begin
3254: select 'Y'
3255: into n_response_exists
3256: from WF_MESSAGES_VL
3257: where NAME = t_name and TYPE = 'WFMAIL'
3258: and instr(body,'&'||'RESPONSE')<>0;
3259: exception
3260: when no_data_found then

Line 4931: FROM wf_notifications n, wf_messages_vl wm

4927: l_get_text := false;
4928:
4929: SELECT wm.body, wm.html_body
4930: INTO l_text_body, l_html_body
4931: FROM wf_notifications n, wf_messages_vl wm
4932: WHERE n.notification_id = p_nid
4933: AND n.message_name = wm.name
4934: AND n.message_type = wm.type;
4935:

Line 5229: from WF_MESSAGES_VL

5225: -- Get template
5226: begin
5227: select SUBJECT, BODY, HTML_BODY
5228: into t_subject, t_text_body, t_html_body
5229: from WF_MESSAGES_VL
5230: where NAME = t_name and TYPE = t_type;
5231: exception
5232: when no_data_found then
5233: wf_core.token('NAME', t_name);

Line 5987: from WF_MESSAGES_VL

5983: -- Get template 'SUMMARY'
5984: begin
5985: select SUBJECT, BODY, HTML_BODY
5986: into t_subject, t_body, t_html_body
5987: from WF_MESSAGES_VL
5988: where NAME = templateName
5989: and TYPE = templateType;
5990: exception
5991: when no_data_found then

Line 7250: from WF_MESSAGES_VL

7246: -- Get the template.
7247: begin
7248: select SUBJECT, HTML_BODY
7249: into l_subject, l_html_body
7250: from WF_MESSAGES_VL
7251: where NAME = 'ATTACHED_URLS' and TYPE = 'WFMAIL';
7252: exception
7253: when no_data_found then
7254: -- If the template has not been installed, then construct a

Line 8379: FROM wf_messages_vl

8375:
8376: -- Get template 'WARNING'
8377: SELECT subject, BODY, HTML_BODY
8378: INTO l_subject,l_text_body,l_html_body
8379: FROM wf_messages_vl
8380: WHERE name = 'MORE_INFO_ANSWERED'
8381: AND type = 'WFMAIL';
8382:
8383: -- Get Error message