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 1054: select 1 into dummy from sys.dual where exists

1050: end if;
1051:
1052: -- Insure this is a valid notification.
1053: begin
1054: select 1 into dummy from sys.dual where exists
1055: (select null
1056: from WF_NOTIFICATIONS
1057: where NOTIFICATION_ID = nid);
1058: exception

Line 3618: from SYS.DUAL;

3614:
3615: -- Create new nid and insert notification
3616: select WF_NOTIFICATIONS_S.NEXTVAL
3617: into nid
3618: from SYS.DUAL;
3619:
3620: insert into WF_NOTIFICATIONS (
3621: NOTIFICATION_ID,
3622: GROUP_ID,

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

3949: end if;
3950:
3951: -- Check message is valid
3952: begin
3953: select 1 into dummy from sys.dual where exists
3954: (select null
3955: from WF_MESSAGES M
3956: where M.TYPE = msg_type
3957: and M.NAME = msg_name);

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

4067: end if;
4068:
4069: -- Check message is valid
4070: begin
4071: select 1 into dummy from sys.dual where exists
4072: (select null
4073: from WF_MESSAGES M
4074: where M.TYPE = msg_type
4075: and M.NAME = msg_name);

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

4548:
4549: -- If no responses expected, then do not mail cancel notice
4550: -- regardless of role notification_preference setting.
4551: begin
4552: select 1 into dummy from sys.dual where exists
4553: (select NULL
4554: from WF_NOTIFICATIONS WN, WF_MESSAGE_ATTRIBUTES WMA
4555: where WN.NOTIFICATION_ID = nid
4556: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 5267: from sys.dual

5263: begin
5264: --
5265: select 1
5266: into dummy
5267: from sys.dual
5268: where exists ( select null
5269: from wf_notifications
5270: where group_id = Gid
5271: and status = 'OPEN'

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

6060: --Name ReadAttrClob (PUBLIC)
6061: --Desc : Gets full text of a PLSQLCLOB variable
6062: -- and returns the 32K chunks in the doctext out variable.
6063: -- Call this repeatedly until end_of_text is true.
6064: --USE : use this to get the value of idividual PLSQLCLOBs such as attachments.
6065: -- to susbtitute a PLSQLSQL clob into a message body, use GetFullBody
6066:
6067: procedure ReadAttrClob(nid in number,
6068: aname in varchar2,