DBA Data[Home] [Help]

APPS.WF_DIAGNOSTICS dependencies on WF_MESSAGES_VL

Line 1373: from wf_messages_vl

1369: if (l_ttype is not null and l_tname is not null) then
1370: begin
1371: select subject, body, html_body
1372: into l_subj, l_txt_body, l_htm_body
1373: from wf_messages_vl
1374: where name = l_tname
1375: and type = l_ttype;
1376: exception
1377: when no_data_found then

Line 1429: from wf_messages_vl

1425:
1426: begin
1427: select subject, body, html_body
1428: into l_subj, l_txt_body, l_htm_body
1429: from wf_messages_vl
1430: where name = l_msg_name
1431: and type = l_msg_type;
1432: exception
1433: when no_data_found then

Line 1610: from wf_messages_vl

1606: SetNLS(l_user_lang, l_user_terr);
1607:
1608: select subject, body, html_body
1609: into l_subj, l_txt_body, l_htm_body
1610: from wf_messages_vl
1611: where name = l_tname
1612: and type = l_ttype;
1613:
1614: l_result := NULL;

Line 1675: from wf_messages_vl

1671: SetNLS(l_ses_lang, l_ses_terr);
1672:
1673: select subject, body, html_body
1674: into l_subj, l_txt_body, l_htm_body
1675: from wf_messages_vl
1676: where name = l_tname
1677: and type = l_ttype;
1678:
1679: l_result := NULL;