DBA Data[Home] [Help]

APPS.WF_RULE dependencies on DUAL

Line 226: from dual;

222: if (wf_event_functions_pkg.subscriptionparameters(p_string=>subparams
223: ,p_key=>'CORRELATION_ID') = 'UNIQUE') then
224: select wf_error_processes_s.nextval
225: into lcorrid
226: from dual;
227:
228: lcorrid := p_event.event_key||'-'||lcorrid;
229: p_event.SetCorrelationId(lcorrid);
230: end if;

Line 248: select to_char(WF_ERROR_PROCESSES_S.nextval) into ikey from dual;

244: p_event.Parameter_List := lparamlist;
245: --p_event.addParameterToList('SUB_GUID', p_subscription_guid);
246:
247: if (wftype = 'WFERROR') then
248: select to_char(WF_ERROR_PROCESSES_S.nextval) into ikey from dual;
249: else
250: ikey := nvl(p_event.Correlation_ID, p_event.Event_Key);
251: end if;
252:

Line 376: select to_char(WF_ERROR_PROCESSES_S.nextval) into ikey from dual;

372: p_event.addParameterToList('SNDACK', nvl(sndack,'N'));
373: p_event.addParameterToList('SUB_GUID', p_subscription_guid);
374:
375: if (wftype = 'WFERROR') then
376: select to_char(WF_ERROR_PROCESSES_S.nextval) into ikey from dual;
377: else
378: ikey := nvl(p_event.getCorrelationID(), p_event.getEventKey());
379: end if;
380:

Line 432: select to_char(WF_ERROR_PROCESSES_S.nextval) into ikey from dual;

428:
429: p_event.addParameterToList('SUB_GUID', p_subscription_guid);
430:
431: if (wftype = 'WFERROR') then
432: select to_char(WF_ERROR_PROCESSES_S.nextval) into ikey from dual;
433: else
434: ikey := nvl(p_event.getCorrelationID(), p_event.getEventKey());
435: end if;
436:

Line 837: from sys.dual;

833: begin
834:
835: select to_char(sysdate, timeMask)
836: into generateTime
837: from sys.dual;
838:
839: dbms_lob.createTemporary(doc, true, DBMS_LOB.CALL);
840:
841: l_str := ''||wf_core.newLine;