DBA Data[Home] [Help]

APPS.WF_DIAGNOSTICS dependencies on WF_MESSAGES_VL

Line 1551: from wf_messages_vl

1547: if (l_ttype is not null and l_tname is not null) then
1548: begin
1549: select subject, body, html_body
1550: into l_subj, l_txt_body, l_htm_body
1551: from wf_messages_vl
1552: where name = l_tname
1553: and type = l_ttype;
1554: exception
1555: when no_data_found then

Line 1613: from wf_messages_vl

1609:
1610: begin
1611: select subject, body, html_body
1612: into l_subj, l_txt_body, l_htm_body
1613: from wf_messages_vl
1614: where name = l_msg_name
1615: and type = l_msg_type;
1616: exception
1617: when no_data_found then

Line 1797: from wf_messages_vl

1793: SetNLS(l_user_lang, l_user_terr);
1794:
1795: select subject, body, html_body
1796: into l_subj, l_txt_body, l_htm_body
1797: from wf_messages_vl
1798: where name = l_tname
1799: and type = l_ttype;
1800:
1801: l_result := NULL;

Line 1862: from wf_messages_vl

1858: SetNLS(l_ses_lang, l_ses_terr);
1859:
1860: select subject, body, html_body
1861: into l_subj, l_txt_body, l_htm_body
1862: from wf_messages_vl
1863: where name = l_tname
1864: and type = l_ttype;
1865:
1866: l_result := NULL;