DBA Data[Home] [Help]

APPS.WF_XML dependencies on DUAL

Line 1554: from dual

1550: -- the response attributes.
1551: l_response := 0;
1552: begin
1553: select 1 into l_response
1554: from dual
1555: where exists (select NULL
1556: from WF_MESSAGE_ATTRIBUTES MA,
1557: WF_NOTIFICATIONS N
1558: where N.NOTIFICATION_ID = p_nid

Line 1842: -- Determine the total list of individual recipients

1838: when others then
1839: raise;
1840: end;
1841: if l_recipient_role is not null then
1842: -- Determine the total list of individual recipients
1843: -- ordered by Protocol and then Language.
1844: l_recipient_list.DELETE;
1845: GetRecipients(l_recipient_role, l_recipient_list);
1846:

Line 2575: from sys.dual;

2571:
2572: begin
2573: select userenv('LANGUAGE')
2574: into nls_base
2575: from sys.dual;
2576:
2577: underscore_pos := instr(nls_base, '_');
2578: dot_pos := instr(nls_base, '.');
2579:

Line 4134: -- send or not should come from the individual memebers and not the

4130:
4131:
4132: -- 4104735 Removing the test for "p_notification_pref not in
4133: -- ('QUERY','SUMMARY','SUMHTML', 'DISABLED')". The rule to
4134: -- send or not should come from the individual memebers and not the
4135: -- parent role. If there are simply no members then the NULL document
4136: -- should be sent. The testing of the notification preference for
4137: -- the members will be performed again in genreateDoc.
4138: if members_t.count = 0 then