eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_PROCESS_ACTIVITY dependencies on WF_CACHE

Line 114: WF_CACHE.GetProcessActivity(actid, status);

110: is
111: status PLS_INTEGER;
112:
113: begin
114: WF_CACHE.GetProcessActivity(actid, status);
115:
116: if (status <> WF_CACHE.task_SUCCESS) then
117:
118: select WPA.PROCESS_ITEM_TYPE, WPA.PROCESS_NAME, WPA.PROCESS_VERSION,

Line 116: if (status <> WF_CACHE.task_SUCCESS) then

112:
113: begin
114: WF_CACHE.GetProcessActivity(actid, status);
115:
116: if (status <> WF_CACHE.task_SUCCESS) then
117:
118: select WPA.PROCESS_ITEM_TYPE, WPA.PROCESS_NAME, WPA.PROCESS_VERSION,
119: WPA.ACTIVITY_ITEM_TYPE, WPA.ACTIVITY_NAME, WPA.INSTANCE_ID,
120: WPA.INSTANCE_LABEL, WPA.PERFORM_ROLE, WPA.PERFORM_ROLE_TYPE,

Line 122: into WF_CACHE.ProcessActivities(actid)

118: select WPA.PROCESS_ITEM_TYPE, WPA.PROCESS_NAME, WPA.PROCESS_VERSION,
119: WPA.ACTIVITY_ITEM_TYPE, WPA.ACTIVITY_NAME, WPA.INSTANCE_ID,
120: WPA.INSTANCE_LABEL, WPA.PERFORM_ROLE, WPA.PERFORM_ROLE_TYPE,
121: WPA.START_END, WPA.DEFAULT_RESULT
122: into WF_CACHE.ProcessActivities(actid)
123: from WF_PROCESS_ACTIVITIES WPA
124: where WPA.INSTANCE_ID = actid;
125:
126: end if;

Line 128: act_itemtype := WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE;

124: where WPA.INSTANCE_ID = actid;
125:
126: end if;
127:
128: act_itemtype := WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE;
129: act_name := WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME;
130:
131: exception
132: when no_data_found then

Line 129: act_name := WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME;

125:
126: end if;
127:
128: act_itemtype := WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE;
129: act_name := WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME;
130:
131: exception
132: when no_data_found then
133: Wf_Core.Token('ACTID', to_char(actid));

Line 346: WF_CACHE.GetProcessActivityInfo(rootid, actdate, status, waIND);

342: status PLS_INTEGER;
343: waIND NUMBER;
344:
345: begin
346: WF_CACHE.GetProcessActivityInfo(rootid, actdate, status, waIND);
347:
348: if (status <> WF_CACHE.task_SUCCESS) then
349: waIND := 0;
350:

Line 348: if (status <> WF_CACHE.task_SUCCESS) then

344:
345: begin
346: WF_CACHE.GetProcessActivityInfo(rootid, actdate, status, waIND);
347:
348: if (status <> WF_CACHE.task_SUCCESS) then
349: waIND := 0;
350:
351: select WA.ITEM_TYPE, WA.NAME, WA.VERSION, WA.TYPE, WA.RERUN,
352: WA.EXPAND_ROLE, WA.COST, WA.ERROR_ITEM_TYPE, WA.ERROR_PROCESS,

Line 360: into WF_CACHE.Activities(waIND).ITEM_TYPE,

356: WPA.ACTIVITY_NAME, WPA.INSTANCE_ID, WPA.INSTANCE_LABEL,
357: WPA.PERFORM_ROLE, WPA.PERFORM_ROLE_TYPE, WPA.START_END,
358: WPA.DEFAULT_RESULT
359:
360: into WF_CACHE.Activities(waIND).ITEM_TYPE,
361: WF_CACHE.Activities(waIND).NAME,
362: WF_CACHE.Activities(waIND).VERSION,
363: WF_CACHE.Activities(waIND).TYPE,
364: WF_CACHE.Activities(waIND).RERUN,

Line 361: WF_CACHE.Activities(waIND).NAME,

357: WPA.PERFORM_ROLE, WPA.PERFORM_ROLE_TYPE, WPA.START_END,
358: WPA.DEFAULT_RESULT
359:
360: into WF_CACHE.Activities(waIND).ITEM_TYPE,
361: WF_CACHE.Activities(waIND).NAME,
362: WF_CACHE.Activities(waIND).VERSION,
363: WF_CACHE.Activities(waIND).TYPE,
364: WF_CACHE.Activities(waIND).RERUN,
365: WF_CACHE.Activities(waIND).EXPAND_ROLE,

Line 362: WF_CACHE.Activities(waIND).VERSION,

358: WPA.DEFAULT_RESULT
359:
360: into WF_CACHE.Activities(waIND).ITEM_TYPE,
361: WF_CACHE.Activities(waIND).NAME,
362: WF_CACHE.Activities(waIND).VERSION,
363: WF_CACHE.Activities(waIND).TYPE,
364: WF_CACHE.Activities(waIND).RERUN,
365: WF_CACHE.Activities(waIND).EXPAND_ROLE,
366: WF_CACHE.Activities(waIND).COST,

Line 363: WF_CACHE.Activities(waIND).TYPE,

359:
360: into WF_CACHE.Activities(waIND).ITEM_TYPE,
361: WF_CACHE.Activities(waIND).NAME,
362: WF_CACHE.Activities(waIND).VERSION,
363: WF_CACHE.Activities(waIND).TYPE,
364: WF_CACHE.Activities(waIND).RERUN,
365: WF_CACHE.Activities(waIND).EXPAND_ROLE,
366: WF_CACHE.Activities(waIND).COST,
367: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,

Line 364: WF_CACHE.Activities(waIND).RERUN,

360: into WF_CACHE.Activities(waIND).ITEM_TYPE,
361: WF_CACHE.Activities(waIND).NAME,
362: WF_CACHE.Activities(waIND).VERSION,
363: WF_CACHE.Activities(waIND).TYPE,
364: WF_CACHE.Activities(waIND).RERUN,
365: WF_CACHE.Activities(waIND).EXPAND_ROLE,
366: WF_CACHE.Activities(waIND).COST,
367: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
368: WF_CACHE.Activities(waIND).ERROR_PROCESS,

Line 365: WF_CACHE.Activities(waIND).EXPAND_ROLE,

361: WF_CACHE.Activities(waIND).NAME,
362: WF_CACHE.Activities(waIND).VERSION,
363: WF_CACHE.Activities(waIND).TYPE,
364: WF_CACHE.Activities(waIND).RERUN,
365: WF_CACHE.Activities(waIND).EXPAND_ROLE,
366: WF_CACHE.Activities(waIND).COST,
367: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
368: WF_CACHE.Activities(waIND).ERROR_PROCESS,
369: WF_CACHE.Activities(waIND).FUNCTION,

Line 366: WF_CACHE.Activities(waIND).COST,

362: WF_CACHE.Activities(waIND).VERSION,
363: WF_CACHE.Activities(waIND).TYPE,
364: WF_CACHE.Activities(waIND).RERUN,
365: WF_CACHE.Activities(waIND).EXPAND_ROLE,
366: WF_CACHE.Activities(waIND).COST,
367: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
368: WF_CACHE.Activities(waIND).ERROR_PROCESS,
369: WF_CACHE.Activities(waIND).FUNCTION,
370: WF_CACHE.Activities(waIND).FUNCTION_TYPE,

Line 367: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,

363: WF_CACHE.Activities(waIND).TYPE,
364: WF_CACHE.Activities(waIND).RERUN,
365: WF_CACHE.Activities(waIND).EXPAND_ROLE,
366: WF_CACHE.Activities(waIND).COST,
367: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
368: WF_CACHE.Activities(waIND).ERROR_PROCESS,
369: WF_CACHE.Activities(waIND).FUNCTION,
370: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
371: WF_CACHE.Activities(waIND).MESSAGE,

Line 368: WF_CACHE.Activities(waIND).ERROR_PROCESS,

364: WF_CACHE.Activities(waIND).RERUN,
365: WF_CACHE.Activities(waIND).EXPAND_ROLE,
366: WF_CACHE.Activities(waIND).COST,
367: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
368: WF_CACHE.Activities(waIND).ERROR_PROCESS,
369: WF_CACHE.Activities(waIND).FUNCTION,
370: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
371: WF_CACHE.Activities(waIND).MESSAGE,
372: WF_CACHE.Activities(waIND).BEGIN_DATE,

Line 369: WF_CACHE.Activities(waIND).FUNCTION,

365: WF_CACHE.Activities(waIND).EXPAND_ROLE,
366: WF_CACHE.Activities(waIND).COST,
367: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
368: WF_CACHE.Activities(waIND).ERROR_PROCESS,
369: WF_CACHE.Activities(waIND).FUNCTION,
370: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
371: WF_CACHE.Activities(waIND).MESSAGE,
372: WF_CACHE.Activities(waIND).BEGIN_DATE,
373: WF_CACHE.Activities(waIND).END_DATE,

Line 370: WF_CACHE.Activities(waIND).FUNCTION_TYPE,

366: WF_CACHE.Activities(waIND).COST,
367: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
368: WF_CACHE.Activities(waIND).ERROR_PROCESS,
369: WF_CACHE.Activities(waIND).FUNCTION,
370: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
371: WF_CACHE.Activities(waIND).MESSAGE,
372: WF_CACHE.Activities(waIND).BEGIN_DATE,
373: WF_CACHE.Activities(waIND).END_DATE,
374: WF_CACHE.Activities(waIND).DIRECTION,

Line 371: WF_CACHE.Activities(waIND).MESSAGE,

367: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
368: WF_CACHE.Activities(waIND).ERROR_PROCESS,
369: WF_CACHE.Activities(waIND).FUNCTION,
370: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
371: WF_CACHE.Activities(waIND).MESSAGE,
372: WF_CACHE.Activities(waIND).BEGIN_DATE,
373: WF_CACHE.Activities(waIND).END_DATE,
374: WF_CACHE.Activities(waIND).DIRECTION,
375: WF_CACHE.ProcessActivities(rootid).PROCESS_ITEM_TYPE,

Line 372: WF_CACHE.Activities(waIND).BEGIN_DATE,

368: WF_CACHE.Activities(waIND).ERROR_PROCESS,
369: WF_CACHE.Activities(waIND).FUNCTION,
370: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
371: WF_CACHE.Activities(waIND).MESSAGE,
372: WF_CACHE.Activities(waIND).BEGIN_DATE,
373: WF_CACHE.Activities(waIND).END_DATE,
374: WF_CACHE.Activities(waIND).DIRECTION,
375: WF_CACHE.ProcessActivities(rootid).PROCESS_ITEM_TYPE,
376: WF_CACHE.ProcessActivities(rootid).PROCESS_NAME,

Line 373: WF_CACHE.Activities(waIND).END_DATE,

369: WF_CACHE.Activities(waIND).FUNCTION,
370: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
371: WF_CACHE.Activities(waIND).MESSAGE,
372: WF_CACHE.Activities(waIND).BEGIN_DATE,
373: WF_CACHE.Activities(waIND).END_DATE,
374: WF_CACHE.Activities(waIND).DIRECTION,
375: WF_CACHE.ProcessActivities(rootid).PROCESS_ITEM_TYPE,
376: WF_CACHE.ProcessActivities(rootid).PROCESS_NAME,
377: WF_CACHE.ProcessActivities(rootid).PROCESS_VERSION,

Line 374: WF_CACHE.Activities(waIND).DIRECTION,

370: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
371: WF_CACHE.Activities(waIND).MESSAGE,
372: WF_CACHE.Activities(waIND).BEGIN_DATE,
373: WF_CACHE.Activities(waIND).END_DATE,
374: WF_CACHE.Activities(waIND).DIRECTION,
375: WF_CACHE.ProcessActivities(rootid).PROCESS_ITEM_TYPE,
376: WF_CACHE.ProcessActivities(rootid).PROCESS_NAME,
377: WF_CACHE.ProcessActivities(rootid).PROCESS_VERSION,
378: WF_CACHE.ProcessActivities(rootid).ACTIVITY_ITEM_TYPE,

Line 375: WF_CACHE.ProcessActivities(rootid).PROCESS_ITEM_TYPE,

371: WF_CACHE.Activities(waIND).MESSAGE,
372: WF_CACHE.Activities(waIND).BEGIN_DATE,
373: WF_CACHE.Activities(waIND).END_DATE,
374: WF_CACHE.Activities(waIND).DIRECTION,
375: WF_CACHE.ProcessActivities(rootid).PROCESS_ITEM_TYPE,
376: WF_CACHE.ProcessActivities(rootid).PROCESS_NAME,
377: WF_CACHE.ProcessActivities(rootid).PROCESS_VERSION,
378: WF_CACHE.ProcessActivities(rootid).ACTIVITY_ITEM_TYPE,
379: WF_CACHE.ProcessActivities(rootid).ACTIVITY_NAME,

Line 376: WF_CACHE.ProcessActivities(rootid).PROCESS_NAME,

372: WF_CACHE.Activities(waIND).BEGIN_DATE,
373: WF_CACHE.Activities(waIND).END_DATE,
374: WF_CACHE.Activities(waIND).DIRECTION,
375: WF_CACHE.ProcessActivities(rootid).PROCESS_ITEM_TYPE,
376: WF_CACHE.ProcessActivities(rootid).PROCESS_NAME,
377: WF_CACHE.ProcessActivities(rootid).PROCESS_VERSION,
378: WF_CACHE.ProcessActivities(rootid).ACTIVITY_ITEM_TYPE,
379: WF_CACHE.ProcessActivities(rootid).ACTIVITY_NAME,
380: WF_CACHE.ProcessActivities(rootid).INSTANCE_ID,

Line 377: WF_CACHE.ProcessActivities(rootid).PROCESS_VERSION,

373: WF_CACHE.Activities(waIND).END_DATE,
374: WF_CACHE.Activities(waIND).DIRECTION,
375: WF_CACHE.ProcessActivities(rootid).PROCESS_ITEM_TYPE,
376: WF_CACHE.ProcessActivities(rootid).PROCESS_NAME,
377: WF_CACHE.ProcessActivities(rootid).PROCESS_VERSION,
378: WF_CACHE.ProcessActivities(rootid).ACTIVITY_ITEM_TYPE,
379: WF_CACHE.ProcessActivities(rootid).ACTIVITY_NAME,
380: WF_CACHE.ProcessActivities(rootid).INSTANCE_ID,
381: WF_CACHE.ProcessActivities(rootid).INSTANCE_LABEL,

Line 378: WF_CACHE.ProcessActivities(rootid).ACTIVITY_ITEM_TYPE,

374: WF_CACHE.Activities(waIND).DIRECTION,
375: WF_CACHE.ProcessActivities(rootid).PROCESS_ITEM_TYPE,
376: WF_CACHE.ProcessActivities(rootid).PROCESS_NAME,
377: WF_CACHE.ProcessActivities(rootid).PROCESS_VERSION,
378: WF_CACHE.ProcessActivities(rootid).ACTIVITY_ITEM_TYPE,
379: WF_CACHE.ProcessActivities(rootid).ACTIVITY_NAME,
380: WF_CACHE.ProcessActivities(rootid).INSTANCE_ID,
381: WF_CACHE.ProcessActivities(rootid).INSTANCE_LABEL,
382: WF_CACHE.ProcessActivities(rootid).PERFORM_ROLE,

Line 379: WF_CACHE.ProcessActivities(rootid).ACTIVITY_NAME,

375: WF_CACHE.ProcessActivities(rootid).PROCESS_ITEM_TYPE,
376: WF_CACHE.ProcessActivities(rootid).PROCESS_NAME,
377: WF_CACHE.ProcessActivities(rootid).PROCESS_VERSION,
378: WF_CACHE.ProcessActivities(rootid).ACTIVITY_ITEM_TYPE,
379: WF_CACHE.ProcessActivities(rootid).ACTIVITY_NAME,
380: WF_CACHE.ProcessActivities(rootid).INSTANCE_ID,
381: WF_CACHE.ProcessActivities(rootid).INSTANCE_LABEL,
382: WF_CACHE.ProcessActivities(rootid).PERFORM_ROLE,
383: WF_CACHE.ProcessActivities(rootid).PERFORM_ROLE_TYPE,

Line 380: WF_CACHE.ProcessActivities(rootid).INSTANCE_ID,

376: WF_CACHE.ProcessActivities(rootid).PROCESS_NAME,
377: WF_CACHE.ProcessActivities(rootid).PROCESS_VERSION,
378: WF_CACHE.ProcessActivities(rootid).ACTIVITY_ITEM_TYPE,
379: WF_CACHE.ProcessActivities(rootid).ACTIVITY_NAME,
380: WF_CACHE.ProcessActivities(rootid).INSTANCE_ID,
381: WF_CACHE.ProcessActivities(rootid).INSTANCE_LABEL,
382: WF_CACHE.ProcessActivities(rootid).PERFORM_ROLE,
383: WF_CACHE.ProcessActivities(rootid).PERFORM_ROLE_TYPE,
384: WF_CACHE.ProcessActivities(rootid).START_END,

Line 381: WF_CACHE.ProcessActivities(rootid).INSTANCE_LABEL,

377: WF_CACHE.ProcessActivities(rootid).PROCESS_VERSION,
378: WF_CACHE.ProcessActivities(rootid).ACTIVITY_ITEM_TYPE,
379: WF_CACHE.ProcessActivities(rootid).ACTIVITY_NAME,
380: WF_CACHE.ProcessActivities(rootid).INSTANCE_ID,
381: WF_CACHE.ProcessActivities(rootid).INSTANCE_LABEL,
382: WF_CACHE.ProcessActivities(rootid).PERFORM_ROLE,
383: WF_CACHE.ProcessActivities(rootid).PERFORM_ROLE_TYPE,
384: WF_CACHE.ProcessActivities(rootid).START_END,
385: WF_CACHE.ProcessActivities(rootid).DEFAULT_RESULT

Line 382: WF_CACHE.ProcessActivities(rootid).PERFORM_ROLE,

378: WF_CACHE.ProcessActivities(rootid).ACTIVITY_ITEM_TYPE,
379: WF_CACHE.ProcessActivities(rootid).ACTIVITY_NAME,
380: WF_CACHE.ProcessActivities(rootid).INSTANCE_ID,
381: WF_CACHE.ProcessActivities(rootid).INSTANCE_LABEL,
382: WF_CACHE.ProcessActivities(rootid).PERFORM_ROLE,
383: WF_CACHE.ProcessActivities(rootid).PERFORM_ROLE_TYPE,
384: WF_CACHE.ProcessActivities(rootid).START_END,
385: WF_CACHE.ProcessActivities(rootid).DEFAULT_RESULT
386:

Line 383: WF_CACHE.ProcessActivities(rootid).PERFORM_ROLE_TYPE,

379: WF_CACHE.ProcessActivities(rootid).ACTIVITY_NAME,
380: WF_CACHE.ProcessActivities(rootid).INSTANCE_ID,
381: WF_CACHE.ProcessActivities(rootid).INSTANCE_LABEL,
382: WF_CACHE.ProcessActivities(rootid).PERFORM_ROLE,
383: WF_CACHE.ProcessActivities(rootid).PERFORM_ROLE_TYPE,
384: WF_CACHE.ProcessActivities(rootid).START_END,
385: WF_CACHE.ProcessActivities(rootid).DEFAULT_RESULT
386:
387: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA

Line 384: WF_CACHE.ProcessActivities(rootid).START_END,

380: WF_CACHE.ProcessActivities(rootid).INSTANCE_ID,
381: WF_CACHE.ProcessActivities(rootid).INSTANCE_LABEL,
382: WF_CACHE.ProcessActivities(rootid).PERFORM_ROLE,
383: WF_CACHE.ProcessActivities(rootid).PERFORM_ROLE_TYPE,
384: WF_CACHE.ProcessActivities(rootid).START_END,
385: WF_CACHE.ProcessActivities(rootid).DEFAULT_RESULT
386:
387: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA
388:

Line 385: WF_CACHE.ProcessActivities(rootid).DEFAULT_RESULT

381: WF_CACHE.ProcessActivities(rootid).INSTANCE_LABEL,
382: WF_CACHE.ProcessActivities(rootid).PERFORM_ROLE,
383: WF_CACHE.ProcessActivities(rootid).PERFORM_ROLE_TYPE,
384: WF_CACHE.ProcessActivities(rootid).START_END,
385: WF_CACHE.ProcessActivities(rootid).DEFAULT_RESULT
386:
387: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA
388:
389: where WPA.INSTANCE_ID = rootid

Line 395: waIND := WF_CACHE.HashKey(

391: and WA.NAME = WPA.ACTIVITY_NAME
392: and actdate >= WA.BEGIN_DATE
393: and actdate < NVL(WA.END_DATE, actdate+1);
394:
395: waIND := WF_CACHE.HashKey(
396: WF_CACHE.ProcessActivities(rootid).ACTIVITY_ITEM_TYPE ||
397: WF_CACHE.ProcessActivities(rootid).ACTIVITY_NAME);
398:
399: WF_CACHE.Activities(waIND) := WF_CACHE.Activities(0);

Line 396: WF_CACHE.ProcessActivities(rootid).ACTIVITY_ITEM_TYPE ||

392: and actdate >= WA.BEGIN_DATE
393: and actdate < NVL(WA.END_DATE, actdate+1);
394:
395: waIND := WF_CACHE.HashKey(
396: WF_CACHE.ProcessActivities(rootid).ACTIVITY_ITEM_TYPE ||
397: WF_CACHE.ProcessActivities(rootid).ACTIVITY_NAME);
398:
399: WF_CACHE.Activities(waIND) := WF_CACHE.Activities(0);
400:

Line 397: WF_CACHE.ProcessActivities(rootid).ACTIVITY_NAME);

393: and actdate < NVL(WA.END_DATE, actdate+1);
394:
395: waIND := WF_CACHE.HashKey(
396: WF_CACHE.ProcessActivities(rootid).ACTIVITY_ITEM_TYPE ||
397: WF_CACHE.ProcessActivities(rootid).ACTIVITY_NAME);
398:
399: WF_CACHE.Activities(waIND) := WF_CACHE.Activities(0);
400:
401: end if;

Line 399: WF_CACHE.Activities(waIND) := WF_CACHE.Activities(0);

395: waIND := WF_CACHE.HashKey(
396: WF_CACHE.ProcessActivities(rootid).ACTIVITY_ITEM_TYPE ||
397: WF_CACHE.ProcessActivities(rootid).ACTIVITY_NAME);
398:
399: WF_CACHE.Activities(waIND) := WF_CACHE.Activities(0);
400:
401: end if;
402:
403:

Line 405: if (((WF_CACHE.ProcessActivities(rootid).PROCESS_ITEM_TYPE = acttype) and

401: end if;
402:
403:
404: -- Quick check to see if root is already right
405: if (((WF_CACHE.ProcessActivities(rootid).PROCESS_ITEM_TYPE = acttype) and
406: (WF_CACHE.ProcessActivities(rootid).PROCESS_NAME = actname)) or
407: ((WF_CACHE.Activities(waIND).ITEM_TYPE = acttype) and
408: (WF_CACHE.Activities(waIND).NAME = actname))) then
409: return(TRUE);

Line 406: (WF_CACHE.ProcessActivities(rootid).PROCESS_NAME = actname)) or

402:
403:
404: -- Quick check to see if root is already right
405: if (((WF_CACHE.ProcessActivities(rootid).PROCESS_ITEM_TYPE = acttype) and
406: (WF_CACHE.ProcessActivities(rootid).PROCESS_NAME = actname)) or
407: ((WF_CACHE.Activities(waIND).ITEM_TYPE = acttype) and
408: (WF_CACHE.Activities(waIND).NAME = actname))) then
409: return(TRUE);
410: end if;

Line 407: ((WF_CACHE.Activities(waIND).ITEM_TYPE = acttype) and

403:
404: -- Quick check to see if root is already right
405: if (((WF_CACHE.ProcessActivities(rootid).PROCESS_ITEM_TYPE = acttype) and
406: (WF_CACHE.ProcessActivities(rootid).PROCESS_NAME = actname)) or
407: ((WF_CACHE.Activities(waIND).ITEM_TYPE = acttype) and
408: (WF_CACHE.Activities(waIND).NAME = actname))) then
409: return(TRUE);
410: end if;
411:

Line 408: (WF_CACHE.Activities(waIND).NAME = actname))) then

404: -- Quick check to see if root is already right
405: if (((WF_CACHE.ProcessActivities(rootid).PROCESS_ITEM_TYPE = acttype) and
406: (WF_CACHE.ProcessActivities(rootid).PROCESS_NAME = actname)) or
407: ((WF_CACHE.Activities(waIND).ITEM_TYPE = acttype) and
408: (WF_CACHE.Activities(waIND).NAME = actname))) then
409: return(TRUE);
410: end if;
411:
412: -- If activity at rootid has an error process, check it recursively

Line 414: if (WF_CACHE.Activities(waIND).ERROR_PROCESS is not null) then

410: end if;
411:
412: -- If activity at rootid has an error process, check it recursively
413: -- for a reference to the activity.
414: if (WF_CACHE.Activities(waIND).ERROR_PROCESS is not null) then
415: -- Get root id for the error process
416: begin
417: select WPA.INSTANCE_ID
418: into errid

Line 420: where WPA.PROCESS_ITEM_TYPE = WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE

416: begin
417: select WPA.INSTANCE_ID
418: into errid
419: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA
420: where WPA.PROCESS_ITEM_TYPE = WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE
421: and WPA.PROCESS_NAME = 'ROOT'
422: and WPA.PROCESS_VERSION = WA.VERSION
423: and WA.ITEM_TYPE = WPA.PROCESS_ITEM_TYPE
424: and WA.NAME = WPA.PROCESS_NAME

Line 427: and WPA.INSTANCE_LABEL = WF_CACHE.Activities(waIND).ERROR_PROCESS;

423: and WA.ITEM_TYPE = WPA.PROCESS_ITEM_TYPE
424: and WA.NAME = WPA.PROCESS_NAME
425: and actdate >= WA.BEGIN_DATE
426: and actdate < NVL(WA.END_DATE, actdate+1)
427: and WPA.INSTANCE_LABEL = WF_CACHE.Activities(waIND).ERROR_PROCESS;
428: exception
429: when no_data_found then
430: -- Error process is invalid, so ignore it
431: errid := '';

Line 544: WF_CACHE.GetProcessActivity(parentid, status);

540: process := '';
541: label := activity;
542: end if;
543:
544: WF_CACHE.GetProcessActivity(parentid, status);
545:
546: if (status <> WF_CACHE.task_SUCCESS) then
547:
548: select WPA.PROCESS_ITEM_TYPE, WPA.PROCESS_NAME, WPA.PROCESS_VERSION,

Line 546: if (status <> WF_CACHE.task_SUCCESS) then

542: end if;
543:
544: WF_CACHE.GetProcessActivity(parentid, status);
545:
546: if (status <> WF_CACHE.task_SUCCESS) then
547:
548: select WPA.PROCESS_ITEM_TYPE, WPA.PROCESS_NAME, WPA.PROCESS_VERSION,
549: WPA.ACTIVITY_ITEM_TYPE, WPA.ACTIVITY_NAME, WPA.INSTANCE_ID,
550: WPA.INSTANCE_LABEL, WPA.PERFORM_ROLE, WPA.PERFORM_ROLE_TYPE,

Line 552: into WF_CACHE.ProcessActivities(parentid)

548: select WPA.PROCESS_ITEM_TYPE, WPA.PROCESS_NAME, WPA.PROCESS_VERSION,
549: WPA.ACTIVITY_ITEM_TYPE, WPA.ACTIVITY_NAME, WPA.INSTANCE_ID,
550: WPA.INSTANCE_LABEL, WPA.PERFORM_ROLE, WPA.PERFORM_ROLE_TYPE,
551: WPA.START_END, WPA.DEFAULT_RESULT
552: into WF_CACHE.ProcessActivities(parentid)
553: from WF_PROCESS_ACTIVITIES WPA
554: where WPA.INSTANCE_ID = parentid;
555:
556: end if;

Line 558: if ((WF_CACHE.ProcessActivities(parentid).PROCESS_NAME =

554: where WPA.INSTANCE_ID = parentid;
555:
556: end if;
557:
558: if ((WF_CACHE.ProcessActivities(parentid).PROCESS_NAME =
559: nvl(process, WF_CACHE.ProcessActivities(parentid).PROCESS_NAME)) and
560: (WF_CACHE.ProcessActivities(parentid).INSTANCE_LABEL = label)) then
561: return(parentid);
562: end if;

Line 559: nvl(process, WF_CACHE.ProcessActivities(parentid).PROCESS_NAME)) and

555:
556: end if;
557:
558: if ((WF_CACHE.ProcessActivities(parentid).PROCESS_NAME =
559: nvl(process, WF_CACHE.ProcessActivities(parentid).PROCESS_NAME)) and
560: (WF_CACHE.ProcessActivities(parentid).INSTANCE_LABEL = label)) then
561: return(parentid);
562: end if;
563:

Line 560: (WF_CACHE.ProcessActivities(parentid).INSTANCE_LABEL = label)) then

556: end if;
557:
558: if ((WF_CACHE.ProcessActivities(parentid).PROCESS_NAME =
559: nvl(process, WF_CACHE.ProcessActivities(parentid).PROCESS_NAME)) and
560: (WF_CACHE.ProcessActivities(parentid).INSTANCE_LABEL = label)) then
561: return(parentid);
562: end if;
563:
564: for child in curs(parentid, actdate) loop