DBA Data[Home] [Help]

APPS.WF_ENGINE_UTIL dependencies on DUAL

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

2684: -- response, return a response of '' so that the activity will
2685: -- complete immediately instead of waiting for the notification
2686: -- to be responded to.
2687: begin
2688: select 1 into dummy from sys.dual where exists
2689: (select null
2690: from WF_MESSAGE_ATTRIBUTES
2691: where MESSAGE_TYPE = msgtype
2692: and MESSAGE_NAME = msg

Line 2760: from SYS.DUAL;

2756:
2757: -- create a new notification
2758: select WF_NOTIFICATIONS_S.NEXTVAL
2759: into nid
2760: from SYS.DUAL;
2761:
2762: -- Use nid of the first notification as group id for the rest
2763: -- but only if notification is expand_roles
2764: if (gid =0) then

Line 3017: from SYS.DUAL;

3013:
3014: -- Get key for errorprocess: concatenate WF to ensure unique
3015: select 'WF'||to_char(WF_ERROR_PROCESSES_S.NEXTVAL)
3016: into errkey
3017: from SYS.DUAL;
3018:
3019: -- Create process and set item parent columns with ids of
3020: -- activity initiating error.
3021: Wf_Engine.CreateProcess(errortype, errkey, errorprocess);