APPS.WF_NOTIFICATION dependencies on DUAL

Line 282: -- o Parsing the comma delimited list and making individual select is more

278: -- list. The cost of non-reusable sql may be high.
279: -- o Considered using bind variables with dynamic sql. Then we must impose
280: -- a hard limit on the number of bind variables. If a limit exceed we
281: -- need some fall back handling.
282: -- o Parsing the comma delimited list and making individual select is more
283: -- costly. But the sql will be reusable, it may end up cheaper.
284: --
285: function wf_msg_attr(nid in number,
286: attrs in varchar2,

Line 1093: select 1 into dummy from sys.dual where exists

1089: end if;
1090:
1091: -- Insure this is a valid notification.
1092: begin
1093: select 1 into dummy from sys.dual where exists
1094: (select null
1095: from WF_NOTIFICATIONS
1096: where NOTIFICATION_ID = nid);
1097: exception

Line 3733: from SYS.DUAL;

3729:
3730: -- Create new nid and insert notification
3731: select WF_NOTIFICATIONS_S.NEXTVAL
3732: into nid
3733: from SYS.DUAL;
3734:
3735: insert into WF_NOTIFICATIONS (
3736: NOTIFICATION_ID,
3737: GROUP_ID,

Line 4084: select 1 into dummy from sys.dual where exists

4080: end if;
4081:
4082: -- Check message is valid
4083: begin
4084: select 1 into dummy from sys.dual where exists
4085: (select null
4086: from WF_MESSAGES M
4087: where M.TYPE = msg_type
4088: and M.NAME = msg_name);

Line 4206: select 1 into dummy from sys.dual where exists

4202: end if;
4203:
4204: -- Check message is valid
4205: begin
4206: select 1 into dummy from sys.dual where exists
4207: (select null
4208: from WF_MESSAGES M
4209: where M.TYPE = msg_type
4210: and M.NAME = msg_name);

Line 4717: select 1 into dummy from sys.dual where exists

4713:
4714: -- If no responses expected, then do not mail cancel notice
4715: -- regardless of role notification_preference setting.
4716: begin
4717: select 1 into dummy from sys.dual where exists
4718: (select NULL
4719: from WF_NOTIFICATIONS WN, WF_MESSAGE_ATTRIBUTES WMA
4720: where WN.NOTIFICATION_ID = nid
4721: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 5108: from sys.dual

5104: begin
5105: --
5106: select 1
5107: into dummy
5108: from sys.dual
5109: where exists ( select null
5110: from wf_notifications
5111: where group_id = Gid
5112: and status = 'OPEN'

Line 5894: --USE : use this to get the value of idividual PLSQLCLOBs such as attachments.

5890: --Name ReadAttrClob (PUBLIC)
5891: --Desc : Gets full text of a PLSQLCLOB variable
5892: -- and returns the 32K chunks in the doctext out variable.
5893: -- Call this repeatedly until end_of_text is true.
5894: --USE : use this to get the value of idividual PLSQLCLOBs such as attachments.
5895: -- to susbtitute a PLSQLSQL clob into a message body, use GetFullBody
5896:
5897: procedure ReadAttrClob(nid in number,
5898: aname in varchar2,