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_ENGINE dependencies on WF_CACHE

Line 101: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname, iStatus, wiavIND);

97:
98: if (itemkey = wf_engine.eng_synch) then
99: --ItemAttrValues are indexed on the hash value of the name.
100: --ItemKey is not used here because we are in #SYNCH mode.
101: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname, iStatus, wiavIND);
102:
103: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemtype;
104: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
105: WF_CACHE.ItemAttrValues(wiavIND).NAME := aname;

Line 103: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemtype;

99: --ItemAttrValues are indexed on the hash value of the name.
100: --ItemKey is not used here because we are in #SYNCH mode.
101: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname, iStatus, wiavIND);
102:
103: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemtype;
104: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
105: WF_CACHE.ItemAttrValues(wiavIND).NAME := aname;
106: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := text_value;
107: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := number_value;

Line 104: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;

100: --ItemKey is not used here because we are in #SYNCH mode.
101: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname, iStatus, wiavIND);
102:
103: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemtype;
104: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
105: WF_CACHE.ItemAttrValues(wiavIND).NAME := aname;
106: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := text_value;
107: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := number_value;
108: WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE := date_value;

Line 105: WF_CACHE.ItemAttrValues(wiavIND).NAME := aname;

101: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname, iStatus, wiavIND);
102:
103: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemtype;
104: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
105: WF_CACHE.ItemAttrValues(wiavIND).NAME := aname;
106: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := text_value;
107: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := number_value;
108: WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE := date_value;
109:

Line 106: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := text_value;

102:
103: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemtype;
104: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
105: WF_CACHE.ItemAttrValues(wiavIND).NAME := aname;
106: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := text_value;
107: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := number_value;
108: WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE := date_value;
109:
110: else

Line 107: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := number_value;

103: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemtype;
104: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
105: WF_CACHE.ItemAttrValues(wiavIND).NAME := aname;
106: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := text_value;
107: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := number_value;
108: WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE := date_value;
109:
110: else
111: insert into WF_ITEM_ATTRIBUTE_VALUES (

Line 108: WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE := date_value;

104: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
105: WF_CACHE.ItemAttrValues(wiavIND).NAME := aname;
106: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := text_value;
107: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := number_value;
108: WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE := date_value;
109:
110: else
111: insert into WF_ITEM_ATTRIBUTE_VALUES (
112: ITEM_TYPE,

Line 191: -- Check to see if we are in synch mode and use WF_CACHE.

187: Wf_Core.Raise('WFENG_ITEM_ATTR_ARRAY_MISMATCH');
188:
189: end if;
190:
191: -- Check to see if we are in synch mode and use WF_CACHE.
192:
193: success_cnt := 0;
194: if (itemkey = wf_engine.eng_synch) then
195: -- Use WF_CACHE.ItemAttrValues for #SYNCH mode.

Line 195: -- Use WF_CACHE.ItemAttrValues for #SYNCH mode.

191: -- Check to see if we are in synch mode and use WF_CACHE.
192:
193: success_cnt := 0;
194: if (itemkey = wf_engine.eng_synch) then
195: -- Use WF_CACHE.ItemAttrValues for #SYNCH mode.
196: for arrayIndex in aname.FIRST..aname.LAST loop
197: -- first check duplicate attribute name
198: WF_CACHE.GetItemAttrValue( itemType, itemKey, aname(arrayIndex), iStatus,
199: wiavIND);

Line 198: WF_CACHE.GetItemAttrValue( itemType, itemKey, aname(arrayIndex), iStatus,

194: if (itemkey = wf_engine.eng_synch) then
195: -- Use WF_CACHE.ItemAttrValues for #SYNCH mode.
196: for arrayIndex in aname.FIRST..aname.LAST loop
197: -- first check duplicate attribute name
198: WF_CACHE.GetItemAttrValue( itemType, itemKey, aname(arrayIndex), iStatus,
199: wiavIND);
200:
201: if (iStatus = WF_CACHE.task_SUCCESS) then
202: null; --There is already an attribute in cache, so we will try to

Line 201: if (iStatus = WF_CACHE.task_SUCCESS) then

197: -- first check duplicate attribute name
198: WF_CACHE.GetItemAttrValue( itemType, itemKey, aname(arrayIndex), iStatus,
199: wiavIND);
200:
201: if (iStatus = WF_CACHE.task_SUCCESS) then
202: null; --There is already an attribute in cache, so we will try to
203: --load the rest, then raise a dup_val_on_index after we
204: --complete.
205: else

Line 206: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemtype;

202: null; --There is already an attribute in cache, so we will try to
203: --load the rest, then raise a dup_val_on_index after we
204: --complete.
205: else
206: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemtype;
207: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
208: WF_CACHE.ItemAttrValues(wiavIND).NAME := aname(arrayIndex);
209: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := avalue(arrayIndex);
210:

Line 207: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;

203: --load the rest, then raise a dup_val_on_index after we
204: --complete.
205: else
206: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemtype;
207: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
208: WF_CACHE.ItemAttrValues(wiavIND).NAME := aname(arrayIndex);
209: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := avalue(arrayIndex);
210:
211: success_cnt := success_cnt + 1;

Line 208: WF_CACHE.ItemAttrValues(wiavIND).NAME := aname(arrayIndex);

204: --complete.
205: else
206: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemtype;
207: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
208: WF_CACHE.ItemAttrValues(wiavIND).NAME := aname(arrayIndex);
209: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := avalue(arrayIndex);
210:
211: success_cnt := success_cnt + 1;
212:

Line 209: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := avalue(arrayIndex);

205: else
206: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemtype;
207: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
208: WF_CACHE.ItemAttrValues(wiavIND).NAME := aname(arrayIndex);
209: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := avalue(arrayIndex);
210:
211: success_cnt := success_cnt + 1;
212:
213: end if;

Line 298: --If we are in #SYNCH mode, we will go ahead and use WF_CACHE to

294:
295: end if;
296:
297: success_cnt := 0;
298: --If we are in #SYNCH mode, we will go ahead and use WF_CACHE to
299: --Store the attributes.
300: if (itemkey = wf_engine.eng_synch) then
301: for arrayIndex in aname.FIRST..aname.LAST loop
302: -- first check duplicate attribute name

Line 303: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname(arrayIndex), iStatus,

299: --Store the attributes.
300: if (itemkey = wf_engine.eng_synch) then
301: for arrayIndex in aname.FIRST..aname.LAST loop
302: -- first check duplicate attribute name
303: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname(arrayIndex), iStatus,
304: wiavIND);
305:
306: if (iStatus = WF_CACHE.task_SUCCESS) then
307: null; --Proceed and attempt to add the rest before raising

Line 306: if (iStatus = WF_CACHE.task_SUCCESS) then

302: -- first check duplicate attribute name
303: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname(arrayIndex), iStatus,
304: wiavIND);
305:
306: if (iStatus = WF_CACHE.task_SUCCESS) then
307: null; --Proceed and attempt to add the rest before raising
308: --dup_val_on_index.
309: else
310: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemtype;

Line 310: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemtype;

306: if (iStatus = WF_CACHE.task_SUCCESS) then
307: null; --Proceed and attempt to add the rest before raising
308: --dup_val_on_index.
309: else
310: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemtype;
311: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
312: WF_CACHE.ItemAttrValues(wiavIND).NAME := aname(arrayIndex);
313: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := avalue(arrayIndex);
314: success_cnt := success_cnt + 1;

Line 311: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;

307: null; --Proceed and attempt to add the rest before raising
308: --dup_val_on_index.
309: else
310: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemtype;
311: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
312: WF_CACHE.ItemAttrValues(wiavIND).NAME := aname(arrayIndex);
313: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := avalue(arrayIndex);
314: success_cnt := success_cnt + 1;
315: end if;

Line 312: WF_CACHE.ItemAttrValues(wiavIND).NAME := aname(arrayIndex);

308: --dup_val_on_index.
309: else
310: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemtype;
311: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
312: WF_CACHE.ItemAttrValues(wiavIND).NAME := aname(arrayIndex);
313: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := avalue(arrayIndex);
314: success_cnt := success_cnt + 1;
315: end if;
316: end loop;

Line 313: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := avalue(arrayIndex);

309: else
310: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemtype;
311: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
312: WF_CACHE.ItemAttrValues(wiavIND).NAME := aname(arrayIndex);
313: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := avalue(arrayIndex);
314: success_cnt := success_cnt + 1;
315: end if;
316: end loop;
317: else

Line 400: -- If in #SYNCH mode, we will use WF_CACHE to store the attributes.

396: Wf_Core.Raise('WFENG_ITEM_ATTR_ARRAY_MISMATCH');
397: end if;
398:
399: success_cnt := 0;
400: -- If in #SYNCH mode, we will use WF_CACHE to store the attributes.
401: if (itemkey = wf_engine.eng_synch) then
402: for arrayIndex in aname.FIRST..aname.LAST loop
403: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname(arrayIndex), iStatus,
404: wiavIND);

Line 403: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname(arrayIndex), iStatus,

399: success_cnt := 0;
400: -- If in #SYNCH mode, we will use WF_CACHE to store the attributes.
401: if (itemkey = wf_engine.eng_synch) then
402: for arrayIndex in aname.FIRST..aname.LAST loop
403: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname(arrayIndex), iStatus,
404: wiavIND);
405:
406: if (iStatus = WF_CACHE.task_SUCCESS) then
407: null; --Attempt to add the rest before raising the dup_val_on_index

Line 406: if (iStatus = WF_CACHE.task_SUCCESS) then

402: for arrayIndex in aname.FIRST..aname.LAST loop
403: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname(arrayIndex), iStatus,
404: wiavIND);
405:
406: if (iStatus = WF_CACHE.task_SUCCESS) then
407: null; --Attempt to add the rest before raising the dup_val_on_index
408: else
409: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemtype;
410: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;

Line 409: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemtype;

405:
406: if (iStatus = WF_CACHE.task_SUCCESS) then
407: null; --Attempt to add the rest before raising the dup_val_on_index
408: else
409: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemtype;
410: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
411: WF_CACHE.ItemAttrValues(wiavIND).NAME := aname(arrayIndex);
412: WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE := avalue(arrayIndex);
413: success_cnt := success_cnt + 1;

Line 410: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;

406: if (iStatus = WF_CACHE.task_SUCCESS) then
407: null; --Attempt to add the rest before raising the dup_val_on_index
408: else
409: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemtype;
410: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
411: WF_CACHE.ItemAttrValues(wiavIND).NAME := aname(arrayIndex);
412: WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE := avalue(arrayIndex);
413: success_cnt := success_cnt + 1;
414: end if;

Line 411: WF_CACHE.ItemAttrValues(wiavIND).NAME := aname(arrayIndex);

407: null; --Attempt to add the rest before raising the dup_val_on_index
408: else
409: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemtype;
410: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
411: WF_CACHE.ItemAttrValues(wiavIND).NAME := aname(arrayIndex);
412: WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE := avalue(arrayIndex);
413: success_cnt := success_cnt + 1;
414: end if;
415: end loop;

Line 412: WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE := avalue(arrayIndex);

408: else
409: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemtype;
410: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
411: WF_CACHE.ItemAttrValues(wiavIND).NAME := aname(arrayIndex);
412: WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE := avalue(arrayIndex);
413: success_cnt := success_cnt + 1;
414: end if;
415: end loop;
416: else

Line 492: WF_CACHE.GetItemAttribute(itemtype, aname, status, wiaIND);

488:
489: -- Get type and format of attr.
490: -- This is used for translating number/date strings.
491:
492: WF_CACHE.GetItemAttribute(itemtype, aname, status, wiaIND);
493:
494: if (status <> WF_CACHE.task_SUCCESS) then
495: begin
496: select WIA.ITEM_TYPE, WIA.NAME, WIA.TYPE, WIA.SUBTYPE, WIA.FORMAT,

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

490: -- This is used for translating number/date strings.
491:
492: WF_CACHE.GetItemAttribute(itemtype, aname, status, wiaIND);
493:
494: if (status <> WF_CACHE.task_SUCCESS) then
495: begin
496: select WIA.ITEM_TYPE, WIA.NAME, WIA.TYPE, WIA.SUBTYPE, WIA.FORMAT,
497: WIA.TEXT_DEFAULT, WIA.NUMBER_DEFAULT, WIA.DATE_DEFAULT
498: into WF_CACHE.ItemAttributes(wiaIND)

Line 498: into WF_CACHE.ItemAttributes(wiaIND)

494: if (status <> WF_CACHE.task_SUCCESS) then
495: begin
496: select WIA.ITEM_TYPE, WIA.NAME, WIA.TYPE, WIA.SUBTYPE, WIA.FORMAT,
497: WIA.TEXT_DEFAULT, WIA.NUMBER_DEFAULT, WIA.DATE_DEFAULT
498: into WF_CACHE.ItemAttributes(wiaIND)
499: from WF_ITEM_ATTRIBUTES WIA
500: where WIA.ITEM_TYPE = itemtype
501: and WIA.NAME = aname;
502:

Line 507: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemtype;

503: exception
504: when no_data_found then
505: -- This is an unvalidated runtime attr.
506: -- Treat it as a varchar2.
507: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemtype;
508: WF_CACHE.ItemAttributes(wiaIND).NAME := aname;
509: WF_CACHE.ItemAttributes(wiaIND).TYPE := 'VARCHAR2';
510: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := '';
511: WF_CACHE.ItemAttributes(wiaIND).FORMAT := '';

Line 508: WF_CACHE.ItemAttributes(wiaIND).NAME := aname;

504: when no_data_found then
505: -- This is an unvalidated runtime attr.
506: -- Treat it as a varchar2.
507: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemtype;
508: WF_CACHE.ItemAttributes(wiaIND).NAME := aname;
509: WF_CACHE.ItemAttributes(wiaIND).TYPE := 'VARCHAR2';
510: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := '';
511: WF_CACHE.ItemAttributes(wiaIND).FORMAT := '';
512:

Line 509: WF_CACHE.ItemAttributes(wiaIND).TYPE := 'VARCHAR2';

505: -- This is an unvalidated runtime attr.
506: -- Treat it as a varchar2.
507: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemtype;
508: WF_CACHE.ItemAttributes(wiaIND).NAME := aname;
509: WF_CACHE.ItemAttributes(wiaIND).TYPE := 'VARCHAR2';
510: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := '';
511: WF_CACHE.ItemAttributes(wiaIND).FORMAT := '';
512:
513: end;

Line 510: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := '';

506: -- Treat it as a varchar2.
507: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemtype;
508: WF_CACHE.ItemAttributes(wiaIND).NAME := aname;
509: WF_CACHE.ItemAttributes(wiaIND).TYPE := 'VARCHAR2';
510: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := '';
511: WF_CACHE.ItemAttributes(wiaIND).FORMAT := '';
512:
513: end;
514: end if;

Line 511: WF_CACHE.ItemAttributes(wiaIND).FORMAT := '';

507: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemtype;
508: WF_CACHE.ItemAttributes(wiaIND).NAME := aname;
509: WF_CACHE.ItemAttributes(wiaIND).TYPE := 'VARCHAR2';
510: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := '';
511: WF_CACHE.ItemAttributes(wiaIND).FORMAT := '';
512:
513: end;
514: end if;
515:

Line 517: if (WF_CACHE.ItemAttributes(wiaIND).TYPE = 'NUMBER') then

513: end;
514: end if;
515:
516: -- Update attribute value in appropriate type column.
517: if (WF_CACHE.ItemAttributes(wiaIND).TYPE = 'NUMBER') then
518:
519: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then
520: nvalue := to_number(avalue);
521: else

Line 519: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then

515:
516: -- Update attribute value in appropriate type column.
517: if (WF_CACHE.ItemAttributes(wiaIND).TYPE = 'NUMBER') then
518:
519: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then
520: nvalue := to_number(avalue);
521: else
522: nvalue := to_number(avalue, WF_CACHE.ItemAttributes(wiaIND).FORMAT);
523: end if;

Line 522: nvalue := to_number(avalue, WF_CACHE.ItemAttributes(wiaIND).FORMAT);

518:
519: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then
520: nvalue := to_number(avalue);
521: else
522: nvalue := to_number(avalue, WF_CACHE.ItemAttributes(wiaIND).FORMAT);
523: end if;
524: Wf_Engine.SetItemAttrNumber(itemtype, itemkey, aname, nvalue);
525:
526: elsif (WF_CACHE.ItemAttributes(wiaIND).TYPE = 'DATE') then

Line 526: elsif (WF_CACHE.ItemAttributes(wiaIND).TYPE = 'DATE') then

522: nvalue := to_number(avalue, WF_CACHE.ItemAttributes(wiaIND).FORMAT);
523: end if;
524: Wf_Engine.SetItemAttrNumber(itemtype, itemkey, aname, nvalue);
525:
526: elsif (WF_CACHE.ItemAttributes(wiaIND).TYPE = 'DATE') then
527:
528: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then
529: dvalue := to_date(avalue,SYS_CONTEXT('USERENV','NLS_DATE_FORMAT'));
530: else

Line 528: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then

524: Wf_Engine.SetItemAttrNumber(itemtype, itemkey, aname, nvalue);
525:
526: elsif (WF_CACHE.ItemAttributes(wiaIND).TYPE = 'DATE') then
527:
528: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then
529: dvalue := to_date(avalue,SYS_CONTEXT('USERENV','NLS_DATE_FORMAT'));
530: else
531: dvalue := to_date(avalue, WF_CACHE.ItemAttributes(wiaIND).FORMAT);
532: end if;

Line 531: dvalue := to_date(avalue, WF_CACHE.ItemAttributes(wiaIND).FORMAT);

527:
528: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then
529: dvalue := to_date(avalue,SYS_CONTEXT('USERENV','NLS_DATE_FORMAT'));
530: else
531: dvalue := to_date(avalue, WF_CACHE.ItemAttributes(wiaIND).FORMAT);
532: end if;
533: Wf_Engine.SetItemAttrDate(itemtype, itemkey, aname, dvalue);
534:
535: else -- One of the text values

Line 537: if (WF_CACHE.ItemAttributes(wiaIND).TYPE = 'VARCHAR2') then

533: Wf_Engine.SetItemAttrDate(itemtype, itemkey, aname, dvalue);
534:
535: else -- One of the text values
536:
537: if (WF_CACHE.ItemAttributes(wiaIND).TYPE = 'VARCHAR2') then
538: -- VARCHAR2 type. Truncate value as necessary
539: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then
540: tvalue := avalue;
541: else

Line 539: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then

535: else -- One of the text values
536:
537: if (WF_CACHE.ItemAttributes(wiaIND).TYPE = 'VARCHAR2') then
538: -- VARCHAR2 type. Truncate value as necessary
539: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then
540: tvalue := avalue;
541: else
542: tvalue := substr(avalue, 1,
543: to_number(WF_CACHE.ItemAttributes(wiaIND).FORMAT));

Line 543: to_number(WF_CACHE.ItemAttributes(wiaIND).FORMAT));

539: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then
540: tvalue := avalue;
541: else
542: tvalue := substr(avalue, 1,
543: to_number(WF_CACHE.ItemAttributes(wiaIND).FORMAT));
544: end if;
545: elsif (WF_CACHE.ItemAttributes(wiaIND).TYPE = 'ROLE') then
546: -- ROLE type. Decode to internal name.
547: if (avalue is null) then

Line 545: elsif (WF_CACHE.ItemAttributes(wiaIND).TYPE = 'ROLE') then

541: else
542: tvalue := substr(avalue, 1,
543: to_number(WF_CACHE.ItemAttributes(wiaIND).FORMAT));
544: end if;
545: elsif (WF_CACHE.ItemAttributes(wiaIND).TYPE = 'ROLE') then
546: -- ROLE type. Decode to internal name.
547: if (avalue is null) then
548: -- Null role values are ok
549: tvalue := '';

Line 579: -- Use WF_CACHE in synch mode

575: end if;
576:
577: -- Set the text value.
578: if (itemkey = wf_engine.eng_synch) then
579: -- Use WF_CACHE in synch mode
580: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname, status, wiavIND);
581:
582: if (status <> WF_CACHE.task_SUCCESS) then
583: raise no_data_found;

Line 580: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname, status, wiavIND);

576:
577: -- Set the text value.
578: if (itemkey = wf_engine.eng_synch) then
579: -- Use WF_CACHE in synch mode
580: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname, status, wiavIND);
581:
582: if (status <> WF_CACHE.task_SUCCESS) then
583: raise no_data_found;
584:

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

578: if (itemkey = wf_engine.eng_synch) then
579: -- Use WF_CACHE in synch mode
580: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname, status, wiavIND);
581:
582: if (status <> WF_CACHE.task_SUCCESS) then
583: raise no_data_found;
584:
585: else
586: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := tvalue;

Line 586: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := tvalue;

582: if (status <> WF_CACHE.task_SUCCESS) then
583: raise no_data_found;
584:
585: else
586: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := tvalue;
587:
588: end if;
589:
590: else

Line 635: Wf_Core.Token('TYPE', WF_CACHE.ItemAttributes(wiaIND).TYPE);

631: when bad_format then --
632: Wf_Core.Context('Wf_Engine', 'SetItemAttrText', itemtype, itemkey,
633: aname, avalue);
634: Wf_Core.Token('VALUE', avalue);
635: Wf_Core.Token('TYPE', WF_CACHE.ItemAttributes(wiaIND).TYPE);
636:
637: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is not null) then
638: WF_CORE.Token('FORMAT', '('||WF_CACHE.ItemAttributes(wiaIND).FORMAT||')');
639:

Line 637: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is not null) then

633: aname, avalue);
634: Wf_Core.Token('VALUE', avalue);
635: Wf_Core.Token('TYPE', WF_CACHE.ItemAttributes(wiaIND).TYPE);
636:
637: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is not null) then
638: WF_CORE.Token('FORMAT', '('||WF_CACHE.ItemAttributes(wiaIND).FORMAT||')');
639:
640: else
641: WF_CORE.Token('FORMAT', '');

Line 638: WF_CORE.Token('FORMAT', '('||WF_CACHE.ItemAttributes(wiaIND).FORMAT||')');

634: Wf_Core.Token('VALUE', avalue);
635: Wf_Core.Token('TYPE', WF_CACHE.ItemAttributes(wiaIND).TYPE);
636:
637: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is not null) then
638: WF_CORE.Token('FORMAT', '('||WF_CACHE.ItemAttributes(wiaIND).FORMAT||')');
639:
640: else
641: WF_CORE.Token('FORMAT', '');
642:

Line 687: -- Use WF_CACHE in synch mode

683: end if;
684:
685: -- Set the text value.
686: if (p_itemkey = wf_engine.eng_synch) then
687: -- Use WF_CACHE in synch mode
688: WF_CACHE.GetItemAttrValue(p_itemtype, p_itemkey, p_aname, status, wiavIND);
689:
690: if (status <> WF_CACHE.task_SUCCESS) then
691: return FALSE;

Line 688: WF_CACHE.GetItemAttrValue(p_itemtype, p_itemkey, p_aname, status, wiavIND);

684:
685: -- Set the text value.
686: if (p_itemkey = wf_engine.eng_synch) then
687: -- Use WF_CACHE in synch mode
688: WF_CACHE.GetItemAttrValue(p_itemtype, p_itemkey, p_aname, status, wiavIND);
689:
690: if (status <> WF_CACHE.task_SUCCESS) then
691: return FALSE;
692:

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

686: if (p_itemkey = wf_engine.eng_synch) then
687: -- Use WF_CACHE in synch mode
688: WF_CACHE.GetItemAttrValue(p_itemtype, p_itemkey, p_aname, status, wiavIND);
689:
690: if (status <> WF_CACHE.task_SUCCESS) then
691: return FALSE;
692:
693: else
694: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := p_avalue;

Line 694: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := p_avalue;

690: if (status <> WF_CACHE.task_SUCCESS) then
691: return FALSE;
692:
693: else
694: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := p_avalue;
695: return TRUE;
696: end if;
697:
698: else

Line 771: WF_CACHE.GetItemAttribute(itemtype, aname, status, wiaIND);

767:
768: begin
769: -- Get type and format of attr.
770: -- This is used for translating number/date strings.
771: WF_CACHE.GetItemAttribute(itemtype, aname, status, wiaIND);
772:
773: if (status <> WF_CACHE.task_SUCCESS) then
774: begin
775: select WIA.ITEM_TYPE, WIA.NAME, WIA.TYPE, WIA.SUBTYPE, WIA.FORMAT,

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

769: -- Get type and format of attr.
770: -- This is used for translating number/date strings.
771: WF_CACHE.GetItemAttribute(itemtype, aname, status, wiaIND);
772:
773: if (status <> WF_CACHE.task_SUCCESS) then
774: begin
775: select WIA.ITEM_TYPE, WIA.NAME, WIA.TYPE, WIA.SUBTYPE, WIA.FORMAT,
776: WIA.TEXT_DEFAULT, WIA.NUMBER_DEFAULT, WIA.DATE_DEFAULT
777: into WF_CACHE.ItemAttributes(wiaIND)

Line 777: into WF_CACHE.ItemAttributes(wiaIND)

773: if (status <> WF_CACHE.task_SUCCESS) then
774: begin
775: select WIA.ITEM_TYPE, WIA.NAME, WIA.TYPE, WIA.SUBTYPE, WIA.FORMAT,
776: WIA.TEXT_DEFAULT, WIA.NUMBER_DEFAULT, WIA.DATE_DEFAULT
777: into WF_CACHE.ItemAttributes(wiaIND)
778: from WF_ITEM_ATTRIBUTES WIA
779: where WIA.ITEM_TYPE = itemtype
780: and WIA.NAME = aname;
781:

Line 786: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemtype;

782: exception
783: when no_data_found then
784: -- This is an unvalidated runtime attr.
785: -- Treat it as a varchar2.
786: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemtype;
787: WF_CACHE.ItemAttributes(wiaIND).NAME := aname;
788: WF_CACHE.ItemAttributes(wiaIND).TYPE := 'VARCHAR2';
789: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := '';
790: WF_CACHE.ItemAttributes(wiaIND).FORMAT := '';

Line 787: WF_CACHE.ItemAttributes(wiaIND).NAME := aname;

783: when no_data_found then
784: -- This is an unvalidated runtime attr.
785: -- Treat it as a varchar2.
786: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemtype;
787: WF_CACHE.ItemAttributes(wiaIND).NAME := aname;
788: WF_CACHE.ItemAttributes(wiaIND).TYPE := 'VARCHAR2';
789: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := '';
790: WF_CACHE.ItemAttributes(wiaIND).FORMAT := '';
791:

Line 788: WF_CACHE.ItemAttributes(wiaIND).TYPE := 'VARCHAR2';

784: -- This is an unvalidated runtime attr.
785: -- Treat it as a varchar2.
786: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemtype;
787: WF_CACHE.ItemAttributes(wiaIND).NAME := aname;
788: WF_CACHE.ItemAttributes(wiaIND).TYPE := 'VARCHAR2';
789: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := '';
790: WF_CACHE.ItemAttributes(wiaIND).FORMAT := '';
791:
792: end;

Line 789: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := '';

785: -- Treat it as a varchar2.
786: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemtype;
787: WF_CACHE.ItemAttributes(wiaIND).NAME := aname;
788: WF_CACHE.ItemAttributes(wiaIND).TYPE := 'VARCHAR2';
789: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := '';
790: WF_CACHE.ItemAttributes(wiaIND).FORMAT := '';
791:
792: end;
793: end if;

Line 790: WF_CACHE.ItemAttributes(wiaIND).FORMAT := '';

786: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemtype;
787: WF_CACHE.ItemAttributes(wiaIND).NAME := aname;
788: WF_CACHE.ItemAttributes(wiaIND).TYPE := 'VARCHAR2';
789: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := '';
790: WF_CACHE.ItemAttributes(wiaIND).FORMAT := '';
791:
792: end;
793: end if;
794:

Line 796: if (WF_CACHE.ItemAttributes(wiaIND).TYPE = 'NUMBER') then

792: end;
793: end if;
794:
795: -- Update attribute value in appropriate type column.
796: if (WF_CACHE.ItemAttributes(wiaIND).TYPE = 'NUMBER') then
797:
798: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then
799: nvalue := to_number(avalue, wf_core.canonical_number_mask);
800: else

Line 798: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then

794:
795: -- Update attribute value in appropriate type column.
796: if (WF_CACHE.ItemAttributes(wiaIND).TYPE = 'NUMBER') then
797:
798: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then
799: nvalue := to_number(avalue, wf_core.canonical_number_mask);
800: else
801: nvalue := to_number(avalue, WF_CACHE.ItemAttributes(wiaIND).FORMAT);
802: end if;

Line 801: nvalue := to_number(avalue, WF_CACHE.ItemAttributes(wiaIND).FORMAT);

797:
798: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then
799: nvalue := to_number(avalue, wf_core.canonical_number_mask);
800: else
801: nvalue := to_number(avalue, WF_CACHE.ItemAttributes(wiaIND).FORMAT);
802: end if;
803: Wf_Engine.SetItemAttrNumber(itemtype, itemkey, aname, nvalue);
804:
805: elsif (WF_CACHE.ItemAttributes(wiaIND).TYPE = 'DATE') then

Line 805: elsif (WF_CACHE.ItemAttributes(wiaIND).TYPE = 'DATE') then

801: nvalue := to_number(avalue, WF_CACHE.ItemAttributes(wiaIND).FORMAT);
802: end if;
803: Wf_Engine.SetItemAttrNumber(itemtype, itemkey, aname, nvalue);
804:
805: elsif (WF_CACHE.ItemAttributes(wiaIND).TYPE = 'DATE') then
806:
807: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then
808: dvalue := to_date(avalue, wf_core.canonical_date_mask);
809: else

Line 807: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then

803: Wf_Engine.SetItemAttrNumber(itemtype, itemkey, aname, nvalue);
804:
805: elsif (WF_CACHE.ItemAttributes(wiaIND).TYPE = 'DATE') then
806:
807: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then
808: dvalue := to_date(avalue, wf_core.canonical_date_mask);
809: else
810: dvalue := to_date(avalue, WF_CACHE.ItemAttributes(wiaIND).FORMAT);
811: end if;

Line 810: dvalue := to_date(avalue, WF_CACHE.ItemAttributes(wiaIND).FORMAT);

806:
807: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then
808: dvalue := to_date(avalue, wf_core.canonical_date_mask);
809: else
810: dvalue := to_date(avalue, WF_CACHE.ItemAttributes(wiaIND).FORMAT);
811: end if;
812: Wf_Engine.SetItemAttrDate(itemtype, itemkey, aname, dvalue);
813:
814: else -- One of the text values

Line 865: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname, iStatus, wiavIND);

861: Wf_Core.Raise('WFSQL_ARGS');
862: end if;
863:
864: if (itemkey = wf_engine.eng_synch) then
865: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname, iStatus, wiavIND);
866:
867: if (iStatus <> WF_CACHE.task_SUCCESS) then
868: raise no_data_found;
869:

Line 867: if (iStatus <> WF_CACHE.task_SUCCESS) then

863:
864: if (itemkey = wf_engine.eng_synch) then
865: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname, iStatus, wiavIND);
866:
867: if (iStatus <> WF_CACHE.task_SUCCESS) then
868: raise no_data_found;
869:
870: else
871: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := avalue;

Line 871: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := avalue;

867: if (iStatus <> WF_CACHE.task_SUCCESS) then
868: raise no_data_found;
869:
870: else
871: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := avalue;
872:
873: end if;
874:
875: else

Line 952: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname, iStatus, wiavIND);

948: Wf_Core.Raise('WFSQL_ARGS');
949: end if;
950:
951: if (itemkey = wf_engine.eng_synch) then
952: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname, iStatus, wiavIND);
953:
954: if (iStatus <> WF_CACHE.task_SUCCESS) then
955: raise no_data_found;
956:

Line 954: if (iStatus <> WF_CACHE.task_SUCCESS) then

950:
951: if (itemkey = wf_engine.eng_synch) then
952: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname, iStatus, wiavIND);
953:
954: if (iStatus <> WF_CACHE.task_SUCCESS) then
955: raise no_data_found;
956:
957: else
958: WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE := avalue;

Line 958: WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE := avalue;

954: if (iStatus <> WF_CACHE.task_SUCCESS) then
955: raise no_data_found;
956:
957: else
958: WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE := avalue;
959:
960: end if;
961:
962: else

Line 1168: -- Use WF_CACHE in synch mode

1164: end if;
1165:
1166: -- Set the text value.
1167: if (itemkey = wf_engine.eng_synch) then
1168: -- Use WF_CACHE in synch mode
1169: success_cnt := 0;
1170:
1171: for arrayIndex in aname.FIRST..aname.LAST loop
1172: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname(arrayIndex), status,

Line 1172: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname(arrayIndex), status,

1168: -- Use WF_CACHE in synch mode
1169: success_cnt := 0;
1170:
1171: for arrayIndex in aname.FIRST..aname.LAST loop
1172: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname(arrayIndex), status,
1173: wiavIND);
1174:
1175: if (status <> WF_CACHE.task_SUCCESS) then
1176: null; --The attribute is not in cache to be set. We will proceed to

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

1171: for arrayIndex in aname.FIRST..aname.LAST loop
1172: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname(arrayIndex), status,
1173: wiavIND);
1174:
1175: if (status <> WF_CACHE.task_SUCCESS) then
1176: null; --The attribute is not in cache to be set. We will proceed to
1177: --try to set the remainder and then raise a no_data_found after
1178: --we complete
1179:

Line 1181: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := avalue(arrayIndex);

1177: --try to set the remainder and then raise a no_data_found after
1178: --we complete
1179:
1180: else
1181: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := avalue(arrayIndex);
1182: success_cnt := success_cnt + 1;
1183:
1184: end if;
1185: end loop;

Line 1280: -- Use WF_CACHE in synch mode

1276: end if;
1277:
1278: -- Set the number value.
1279: if (itemkey = wf_engine.eng_synch) then
1280: -- Use WF_CACHE in synch mode
1281: success_cnt := 0;
1282:
1283: for arrayIndex in aname.FIRST..aname.LAST loop
1284: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname(arrayIndex), status,

Line 1284: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname(arrayIndex), status,

1280: -- Use WF_CACHE in synch mode
1281: success_cnt := 0;
1282:
1283: for arrayIndex in aname.FIRST..aname.LAST loop
1284: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname(arrayIndex), status,
1285: wiavIND);
1286:
1287: if (status <> WF_CACHE.task_SUCCESS) then
1288: null; --The attribute is not in cache to be set. We will proceed to

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

1283: for arrayIndex in aname.FIRST..aname.LAST loop
1284: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname(arrayIndex), status,
1285: wiavIND);
1286:
1287: if (status <> WF_CACHE.task_SUCCESS) then
1288: null; --The attribute is not in cache to be set. We will proceed to
1289: --try to set the remainder and then raise a no_data_found after
1290: --we complete.
1291:

Line 1293: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := avalue(arrayIndex);

1289: --try to set the remainder and then raise a no_data_found after
1290: --we complete.
1291:
1292: else
1293: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := avalue(arrayIndex);
1294: success_cnt := success_cnt + 1;
1295:
1296: end if;
1297:

Line 1393: -- Use WF_CACHE in synch mode

1389:
1390: success_cnt := 0;
1391: -- Set the date value.
1392: if (itemkey = wf_engine.eng_synch) then
1393: -- Use WF_CACHE in synch mode
1394: for arrayIndex in aname.FIRST..aname.LAST loop
1395: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname(arrayIndex), status,
1396: wiavIND);
1397:

Line 1395: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname(arrayIndex), status,

1391: -- Set the date value.
1392: if (itemkey = wf_engine.eng_synch) then
1393: -- Use WF_CACHE in synch mode
1394: for arrayIndex in aname.FIRST..aname.LAST loop
1395: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname(arrayIndex), status,
1396: wiavIND);
1397:
1398: if (status <> WF_CACHE.task_SUCCESS) then
1399: null; --The attribute is not in cache to be set. We will proceed to

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

1394: for arrayIndex in aname.FIRST..aname.LAST loop
1395: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname(arrayIndex), status,
1396: wiavIND);
1397:
1398: if (status <> WF_CACHE.task_SUCCESS) then
1399: null; --The attribute is not in cache to be set. We will proceed to
1400: --try to set the remainder and then raise a no_data_found after
1401: --we complete.
1402:

Line 1404: WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE := avalue(arrayIndex);

1400: --try to set the remainder and then raise a no_data_found after
1401: --we complete.
1402:
1403: else
1404: WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE := avalue(arrayIndex);
1405: success_cnt := success_cnt + 1;
1406:
1407: end if;
1408:

Line 1491: WF_CACHE.GetItemAttribute(itemtype, aname, status, wiaIND);

1487: Wf_Core.Token('ANAME', nvl(aname, 'NULL'));
1488: Wf_Core.Raise('WFSQL_ARGS');
1489: end if;
1490:
1491: WF_CACHE.GetItemAttribute(itemtype, aname, status, wiaIND);
1492:
1493: if (status <> WF_CACHE.task_SUCCESS) then
1494: select WIA.ITEM_TYPE, WIA.NAME, WIA.TYPE, WIA.SUBTYPE, WIA.FORMAT,
1495: WIA.TEXT_DEFAULT, WIA.NUMBER_DEFAULT, WIA.DATE_DEFAULT

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

1489: end if;
1490:
1491: WF_CACHE.GetItemAttribute(itemtype, aname, status, wiaIND);
1492:
1493: if (status <> WF_CACHE.task_SUCCESS) then
1494: select WIA.ITEM_TYPE, WIA.NAME, WIA.TYPE, WIA.SUBTYPE, WIA.FORMAT,
1495: WIA.TEXT_DEFAULT, WIA.NUMBER_DEFAULT, WIA.DATE_DEFAULT
1496: into WF_CACHE.ItemAttributes(wiaIND)
1497: from WF_ITEM_ATTRIBUTES WIA

Line 1496: into WF_CACHE.ItemAttributes(wiaIND)

1492:
1493: if (status <> WF_CACHE.task_SUCCESS) then
1494: select WIA.ITEM_TYPE, WIA.NAME, WIA.TYPE, WIA.SUBTYPE, WIA.FORMAT,
1495: WIA.TEXT_DEFAULT, WIA.NUMBER_DEFAULT, WIA.DATE_DEFAULT
1496: into WF_CACHE.ItemAttributes(wiaIND)
1497: from WF_ITEM_ATTRIBUTES WIA
1498: where WIA.ITEM_TYPE = itemtype
1499: and WIA.NAME = aname;
1500:

Line 1503: atype := WF_CACHE.ItemAttributes(wiaIND).TYPE;

1499: and WIA.NAME = aname;
1500:
1501: end if;
1502:
1503: atype := WF_CACHE.ItemAttributes(wiaIND).TYPE;
1504: subtype := WF_CACHE.ItemAttributes(wiaIND).SUBTYPE;
1505: format := WF_CACHE.ItemAttributes(wiaIND).FORMAT;
1506:
1507: exception

Line 1504: subtype := WF_CACHE.ItemAttributes(wiaIND).SUBTYPE;

1500:
1501: end if;
1502:
1503: atype := WF_CACHE.ItemAttributes(wiaIND).TYPE;
1504: subtype := WF_CACHE.ItemAttributes(wiaIND).SUBTYPE;
1505: format := WF_CACHE.ItemAttributes(wiaIND).FORMAT;
1506:
1507: exception
1508: when no_data_found then

Line 1505: format := WF_CACHE.ItemAttributes(wiaIND).FORMAT;

1501: end if;
1502:
1503: atype := WF_CACHE.ItemAttributes(wiaIND).TYPE;
1504: subtype := WF_CACHE.ItemAttributes(wiaIND).SUBTYPE;
1505: format := WF_CACHE.ItemAttributes(wiaIND).FORMAT;
1506:
1507: exception
1508: when no_data_found then
1509: Wf_Core.Context('Wf_Engine', 'GetItemAttrInfo', itemtype, aname);

Line 1560: WF_CACHE.GetItemAttribute(itemtype, aname, status, wiaIND);

1556: end if;
1557:
1558: -- Get type and format of attr.
1559: -- This is used for translating number/date strings.
1560: WF_CACHE.GetItemAttribute(itemtype, aname, status, wiaIND);
1561:
1562: if (status <> WF_CACHE.task_SUCCESS) then
1563: begin
1564: select WIA.ITEM_TYPE, WIA.NAME, WIA.TYPE, WIA.SUBTYPE, WIA.FORMAT,

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

1558: -- Get type and format of attr.
1559: -- This is used for translating number/date strings.
1560: WF_CACHE.GetItemAttribute(itemtype, aname, status, wiaIND);
1561:
1562: if (status <> WF_CACHE.task_SUCCESS) then
1563: begin
1564: select WIA.ITEM_TYPE, WIA.NAME, WIA.TYPE, WIA.SUBTYPE, WIA.FORMAT,
1565: WIA.TEXT_DEFAULT, WIA.NUMBER_DEFAULT, WIA.DATE_DEFAULT
1566: into WF_CACHE.ItemAttributes(wiaIND)

Line 1566: into WF_CACHE.ItemAttributes(wiaIND)

1562: if (status <> WF_CACHE.task_SUCCESS) then
1563: begin
1564: select WIA.ITEM_TYPE, WIA.NAME, WIA.TYPE, WIA.SUBTYPE, WIA.FORMAT,
1565: WIA.TEXT_DEFAULT, WIA.NUMBER_DEFAULT, WIA.DATE_DEFAULT
1566: into WF_CACHE.ItemAttributes(wiaIND)
1567: from WF_ITEM_ATTRIBUTES WIA
1568: where WIA.ITEM_TYPE = itemtype
1569: and WIA.NAME = aname;
1570:

Line 1575: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemtype;

1571: exception
1572: when no_data_found then
1573: -- This is an unvalidated runtime attr.
1574: -- Treat it as a varchar2.
1575: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemtype;
1576: WF_CACHE.ItemAttributes(wiaIND).NAME := aname;
1577: WF_CACHE.ItemAttributes(wiaIND).TYPE := 'VARCHAR2';
1578: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := '';
1579: WF_CACHE.ItemAttributes(wiaIND).FORMAT := '';

Line 1576: WF_CACHE.ItemAttributes(wiaIND).NAME := aname;

1572: when no_data_found then
1573: -- This is an unvalidated runtime attr.
1574: -- Treat it as a varchar2.
1575: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemtype;
1576: WF_CACHE.ItemAttributes(wiaIND).NAME := aname;
1577: WF_CACHE.ItemAttributes(wiaIND).TYPE := 'VARCHAR2';
1578: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := '';
1579: WF_CACHE.ItemAttributes(wiaIND).FORMAT := '';
1580:

Line 1577: WF_CACHE.ItemAttributes(wiaIND).TYPE := 'VARCHAR2';

1573: -- This is an unvalidated runtime attr.
1574: -- Treat it as a varchar2.
1575: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemtype;
1576: WF_CACHE.ItemAttributes(wiaIND).NAME := aname;
1577: WF_CACHE.ItemAttributes(wiaIND).TYPE := 'VARCHAR2';
1578: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := '';
1579: WF_CACHE.ItemAttributes(wiaIND).FORMAT := '';
1580:
1581: end;

Line 1578: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := '';

1574: -- Treat it as a varchar2.
1575: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemtype;
1576: WF_CACHE.ItemAttributes(wiaIND).NAME := aname;
1577: WF_CACHE.ItemAttributes(wiaIND).TYPE := 'VARCHAR2';
1578: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := '';
1579: WF_CACHE.ItemAttributes(wiaIND).FORMAT := '';
1580:
1581: end;
1582: end if;

Line 1579: WF_CACHE.ItemAttributes(wiaIND).FORMAT := '';

1575: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemtype;
1576: WF_CACHE.ItemAttributes(wiaIND).NAME := aname;
1577: WF_CACHE.ItemAttributes(wiaIND).TYPE := 'VARCHAR2';
1578: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := '';
1579: WF_CACHE.ItemAttributes(wiaIND).FORMAT := '';
1580:
1581: end;
1582: end if;
1583:

Line 1585: if (WF_CACHE.ItemAttributes(wiaIND).TYPE = 'NUMBER') then

1581: end;
1582: end if;
1583:
1584: -- Select value from appropriate type column.
1585: if (WF_CACHE.ItemAttributes(wiaIND).TYPE = 'NUMBER') then
1586: nvalue := Wf_Engine.GetItemAttrNumber(itemtype, itemkey, aname);
1587: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then
1588: lvalue := to_char(nvalue);
1589: else

Line 1587: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then

1583:
1584: -- Select value from appropriate type column.
1585: if (WF_CACHE.ItemAttributes(wiaIND).TYPE = 'NUMBER') then
1586: nvalue := Wf_Engine.GetItemAttrNumber(itemtype, itemkey, aname);
1587: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then
1588: lvalue := to_char(nvalue);
1589: else
1590: lvalue := to_char(nvalue, WF_CACHE.ItemAttributes(wiaIND).FORMAT);
1591: end if;

Line 1590: lvalue := to_char(nvalue, WF_CACHE.ItemAttributes(wiaIND).FORMAT);

1586: nvalue := Wf_Engine.GetItemAttrNumber(itemtype, itemkey, aname);
1587: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then
1588: lvalue := to_char(nvalue);
1589: else
1590: lvalue := to_char(nvalue, WF_CACHE.ItemAttributes(wiaIND).FORMAT);
1591: end if;
1592: elsif (WF_CACHE.ItemAttributes(wiaIND).TYPE = 'DATE') then
1593: dvalue := Wf_Engine.GetItemAttrDate(itemtype, itemkey, aname);
1594: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then

Line 1592: elsif (WF_CACHE.ItemAttributes(wiaIND).TYPE = 'DATE') then

1588: lvalue := to_char(nvalue);
1589: else
1590: lvalue := to_char(nvalue, WF_CACHE.ItemAttributes(wiaIND).FORMAT);
1591: end if;
1592: elsif (WF_CACHE.ItemAttributes(wiaIND).TYPE = 'DATE') then
1593: dvalue := Wf_Engine.GetItemAttrDate(itemtype, itemkey, aname);
1594: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then
1595: lvalue := to_char(dvalue);
1596: else

Line 1594: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then

1590: lvalue := to_char(nvalue, WF_CACHE.ItemAttributes(wiaIND).FORMAT);
1591: end if;
1592: elsif (WF_CACHE.ItemAttributes(wiaIND).TYPE = 'DATE') then
1593: dvalue := Wf_Engine.GetItemAttrDate(itemtype, itemkey, aname);
1594: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then
1595: lvalue := to_char(dvalue);
1596: else
1597: lvalue := to_char(dvalue, WF_CACHE.ItemAttributes(wiaIND).FORMAT);
1598: end if;

Line 1597: lvalue := to_char(dvalue, WF_CACHE.ItemAttributes(wiaIND).FORMAT);

1593: dvalue := Wf_Engine.GetItemAttrDate(itemtype, itemkey, aname);
1594: if (WF_CACHE.ItemAttributes(wiaIND).FORMAT is null) then
1595: lvalue := to_char(dvalue);
1596: else
1597: lvalue := to_char(dvalue, WF_CACHE.ItemAttributes(wiaIND).FORMAT);
1598: end if;
1599: else
1600: -- VARCHAR2, LOOKUP, FORM, URL, DOCUMENT.
1601: -- Get the text value directly with no translation.

Line 1603: -- Use WF_CACHE in synch mode

1599: else
1600: -- VARCHAR2, LOOKUP, FORM, URL, DOCUMENT.
1601: -- Get the text value directly with no translation.
1602: if (itemkey = wf_engine.eng_synch) then
1603: -- Use WF_CACHE in synch mode
1604: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname, status, wiavIND);
1605:
1606: if (status <> WF_CACHE.task_SUCCESS) then
1607: raise no_data_found;

Line 1604: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname, status, wiavIND);

1600: -- VARCHAR2, LOOKUP, FORM, URL, DOCUMENT.
1601: -- Get the text value directly with no translation.
1602: if (itemkey = wf_engine.eng_synch) then
1603: -- Use WF_CACHE in synch mode
1604: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname, status, wiavIND);
1605:
1606: if (status <> WF_CACHE.task_SUCCESS) then
1607: raise no_data_found;
1608:

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

1602: if (itemkey = wf_engine.eng_synch) then
1603: -- Use WF_CACHE in synch mode
1604: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname, status, wiavIND);
1605:
1606: if (status <> WF_CACHE.task_SUCCESS) then
1607: raise no_data_found;
1608:
1609: else
1610: return(WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE);

Line 1610: return(WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE);

1606: if (status <> WF_CACHE.task_SUCCESS) then
1607: raise no_data_found;
1608:
1609: else
1610: return(WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE);
1611:
1612: end if;
1613:
1614: else

Line 1700: -- Use WF_CACHE in synch mode

1696: Wf_Core.Raise('WFSQL_ARGS');
1697: end if;
1698:
1699: if (itemkey = wf_engine.eng_synch) then
1700: -- Use WF_CACHE in synch mode
1701: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname, status, wiavIND);
1702:
1703: if (status <> WF_CACHE.task_SUCCESS) then
1704: raise no_data_found;

Line 1701: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname, status, wiavIND);

1697: end if;
1698:
1699: if (itemkey = wf_engine.eng_synch) then
1700: -- Use WF_CACHE in synch mode
1701: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname, status, wiavIND);
1702:
1703: if (status <> WF_CACHE.task_SUCCESS) then
1704: raise no_data_found;
1705:

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

1699: if (itemkey = wf_engine.eng_synch) then
1700: -- Use WF_CACHE in synch mode
1701: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname, status, wiavIND);
1702:
1703: if (status <> WF_CACHE.task_SUCCESS) then
1704: raise no_data_found;
1705:
1706: else
1707: return(WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE);

Line 1707: return(WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE);

1703: if (status <> WF_CACHE.task_SUCCESS) then
1704: raise no_data_found;
1705:
1706: else
1707: return(WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE);
1708:
1709: end if;
1710:
1711: else

Line 1791: -- Use WF_CACHE in synch mode

1787: Wf_Core.Raise('WFSQL_ARGS');
1788: end if;
1789:
1790: if (itemkey = wf_engine.eng_synch) then
1791: -- Use WF_CACHE in synch mode
1792: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname, status, wiavIND);
1793:
1794: if (status <> WF_CACHE.task_SUCCESS) then
1795: raise no_data_found;

Line 1792: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname, status, wiavIND);

1788: end if;
1789:
1790: if (itemkey = wf_engine.eng_synch) then
1791: -- Use WF_CACHE in synch mode
1792: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname, status, wiavIND);
1793:
1794: if (status <> WF_CACHE.task_SUCCESS) then
1795: raise no_data_found;
1796:

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

1790: if (itemkey = wf_engine.eng_synch) then
1791: -- Use WF_CACHE in synch mode
1792: WF_CACHE.GetItemAttrValue(itemtype, itemKey, aname, status, wiavIND);
1793:
1794: if (status <> WF_CACHE.task_SUCCESS) then
1795: raise no_data_found;
1796:
1797: else
1798: return(WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE);

Line 1798: return(WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE);

1794: if (status <> WF_CACHE.task_SUCCESS) then
1795: raise no_data_found;
1796:
1797: else
1798: return(WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE);
1799:
1800: end if;
1801:
1802: else

Line 1929: WF_CACHE.GetItemAttribute(itemtype, aname, status, wiaIND);

1925:
1926: -- ### Needs to be integrated with document support in wf_notifications!
1927:
1928: -- Get attribute type info
1929: WF_CACHE.GetItemAttribute(itemtype, aname, status, wiaIND);
1930:
1931: if (status <> WF_CACHE.task_SUCCESS) then
1932: begin
1933: select WIA.ITEM_TYPE, WIA.NAME, WIA.TYPE, WIA.SUBTYPE, WIA.FORMAT,

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

1927:
1928: -- Get attribute type info
1929: WF_CACHE.GetItemAttribute(itemtype, aname, status, wiaIND);
1930:
1931: if (status <> WF_CACHE.task_SUCCESS) then
1932: begin
1933: select WIA.ITEM_TYPE, WIA.NAME, WIA.TYPE, WIA.SUBTYPE, WIA.FORMAT,
1934: WIA.TEXT_DEFAULT, WIA.NUMBER_DEFAULT, WIA.DATE_DEFAULT
1935: into WF_CACHE.ItemAttributes(wiaIND)

Line 1935: into WF_CACHE.ItemAttributes(wiaIND)

1931: if (status <> WF_CACHE.task_SUCCESS) then
1932: begin
1933: select WIA.ITEM_TYPE, WIA.NAME, WIA.TYPE, WIA.SUBTYPE, WIA.FORMAT,
1934: WIA.TEXT_DEFAULT, WIA.NUMBER_DEFAULT, WIA.DATE_DEFAULT
1935: into WF_CACHE.ItemAttributes(wiaIND)
1936: from WF_ITEM_ATTRIBUTES WIA
1937: where WIA.ITEM_TYPE = GetItemAttrClob.itemtype
1938: and WIA.NAME = GetItemAttrClob.aname;
1939:

Line 1944: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemtype;

1940: exception
1941: when no_data_found then
1942: -- This is an unvalidated runtime attr.
1943: -- Treat it as a varchar2.
1944: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemtype;
1945: WF_CACHE.ItemAttributes(wiaIND).NAME := aname;
1946: WF_CACHE.ItemAttributes(wiaIND).TYPE := 'VARCHAR2';
1947: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := '';
1948: WF_CACHE.ItemAttributes(wiaIND).FORMAT := '';

Line 1945: WF_CACHE.ItemAttributes(wiaIND).NAME := aname;

1941: when no_data_found then
1942: -- This is an unvalidated runtime attr.
1943: -- Treat it as a varchar2.
1944: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemtype;
1945: WF_CACHE.ItemAttributes(wiaIND).NAME := aname;
1946: WF_CACHE.ItemAttributes(wiaIND).TYPE := 'VARCHAR2';
1947: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := '';
1948: WF_CACHE.ItemAttributes(wiaIND).FORMAT := '';
1949:

Line 1946: WF_CACHE.ItemAttributes(wiaIND).TYPE := 'VARCHAR2';

1942: -- This is an unvalidated runtime attr.
1943: -- Treat it as a varchar2.
1944: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemtype;
1945: WF_CACHE.ItemAttributes(wiaIND).NAME := aname;
1946: WF_CACHE.ItemAttributes(wiaIND).TYPE := 'VARCHAR2';
1947: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := '';
1948: WF_CACHE.ItemAttributes(wiaIND).FORMAT := '';
1949:
1950: end;

Line 1947: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := '';

1943: -- Treat it as a varchar2.
1944: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemtype;
1945: WF_CACHE.ItemAttributes(wiaIND).NAME := aname;
1946: WF_CACHE.ItemAttributes(wiaIND).TYPE := 'VARCHAR2';
1947: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := '';
1948: WF_CACHE.ItemAttributes(wiaIND).FORMAT := '';
1949:
1950: end;
1951: end if;

Line 1948: WF_CACHE.ItemAttributes(wiaIND).FORMAT := '';

1944: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemtype;
1945: WF_CACHE.ItemAttributes(wiaIND).NAME := aname;
1946: WF_CACHE.ItemAttributes(wiaIND).TYPE := 'VARCHAR2';
1947: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := '';
1948: WF_CACHE.ItemAttributes(wiaIND).FORMAT := '';
1949:
1950: end;
1951: end if;
1952:

Line 1954: if (WF_CACHE.ItemAttributes(wiaIND).TYPE = '###NOTDONE') then

1950: end;
1951: end if;
1952:
1953: -- Build clob with contents based on attr type
1954: if (WF_CACHE.ItemAttributes(wiaIND).TYPE = '###NOTDONE') then
1955: -- Parse out document subtypes
1956: null;
1957: else
1958: -- All others just use text value

Line 2108: WF_CACHE.GetActivityAttr( itemtype, aname, actid, actdate, status, waIND,

2104: end if;
2105:
2106: actdate := Wf_Item.Active_Date(itemtype, itemkey);
2107:
2108: WF_CACHE.GetActivityAttr( itemtype, aname, actid, actdate, status, waIND,
2109: waaIND );
2110:
2111: if (status <> WF_CACHE.task_SUCCESS) then
2112:

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

2107:
2108: WF_CACHE.GetActivityAttr( itemtype, aname, actid, actdate, status, waIND,
2109: waaIND );
2110:
2111: if (status <> WF_CACHE.task_SUCCESS) then
2112:
2113: waIND := 0; --If the Get failed, we presume we did not get proper
2114: waaIND := 0; --hash values for the indexes. So we default to 0.
2115:

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

2123: WPA.PROCESS_VERSION, WPA.ACTIVITY_ITEM_TYPE, WPA.ACTIVITY_NAME,
2124: WPA.INSTANCE_ID, WPA.INSTANCE_LABEL, WPA.PERFORM_ROLE,
2125: WPA.PERFORM_ROLE_TYPE, WPA.START_END, WPA.DEFAULT_RESULT
2126:
2127: into WF_CACHE.Activities(waIND).ITEM_TYPE,
2128: WF_CACHE.Activities(waIND).NAME,
2129: WF_CACHE.Activities(waIND).VERSION,
2130: WF_CACHE.Activities(waIND).TYPE,
2131: WF_CACHE.Activities(waIND).RERUN,

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

2124: WPA.INSTANCE_ID, WPA.INSTANCE_LABEL, WPA.PERFORM_ROLE,
2125: WPA.PERFORM_ROLE_TYPE, WPA.START_END, WPA.DEFAULT_RESULT
2126:
2127: into WF_CACHE.Activities(waIND).ITEM_TYPE,
2128: WF_CACHE.Activities(waIND).NAME,
2129: WF_CACHE.Activities(waIND).VERSION,
2130: WF_CACHE.Activities(waIND).TYPE,
2131: WF_CACHE.Activities(waIND).RERUN,
2132: WF_CACHE.Activities(waIND).EXPAND_ROLE,

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

2125: WPA.PERFORM_ROLE_TYPE, WPA.START_END, WPA.DEFAULT_RESULT
2126:
2127: into WF_CACHE.Activities(waIND).ITEM_TYPE,
2128: WF_CACHE.Activities(waIND).NAME,
2129: WF_CACHE.Activities(waIND).VERSION,
2130: WF_CACHE.Activities(waIND).TYPE,
2131: WF_CACHE.Activities(waIND).RERUN,
2132: WF_CACHE.Activities(waIND).EXPAND_ROLE,
2133: WF_CACHE.Activities(waIND).COST,

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

2126:
2127: into WF_CACHE.Activities(waIND).ITEM_TYPE,
2128: WF_CACHE.Activities(waIND).NAME,
2129: WF_CACHE.Activities(waIND).VERSION,
2130: WF_CACHE.Activities(waIND).TYPE,
2131: WF_CACHE.Activities(waIND).RERUN,
2132: WF_CACHE.Activities(waIND).EXPAND_ROLE,
2133: WF_CACHE.Activities(waIND).COST,
2134: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,

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

2127: into WF_CACHE.Activities(waIND).ITEM_TYPE,
2128: WF_CACHE.Activities(waIND).NAME,
2129: WF_CACHE.Activities(waIND).VERSION,
2130: WF_CACHE.Activities(waIND).TYPE,
2131: WF_CACHE.Activities(waIND).RERUN,
2132: WF_CACHE.Activities(waIND).EXPAND_ROLE,
2133: WF_CACHE.Activities(waIND).COST,
2134: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
2135: WF_CACHE.Activities(waIND).ERROR_PROCESS,

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

2128: WF_CACHE.Activities(waIND).NAME,
2129: WF_CACHE.Activities(waIND).VERSION,
2130: WF_CACHE.Activities(waIND).TYPE,
2131: WF_CACHE.Activities(waIND).RERUN,
2132: WF_CACHE.Activities(waIND).EXPAND_ROLE,
2133: WF_CACHE.Activities(waIND).COST,
2134: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
2135: WF_CACHE.Activities(waIND).ERROR_PROCESS,
2136: WF_CACHE.Activities(waIND).FUNCTION,

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

2129: WF_CACHE.Activities(waIND).VERSION,
2130: WF_CACHE.Activities(waIND).TYPE,
2131: WF_CACHE.Activities(waIND).RERUN,
2132: WF_CACHE.Activities(waIND).EXPAND_ROLE,
2133: WF_CACHE.Activities(waIND).COST,
2134: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
2135: WF_CACHE.Activities(waIND).ERROR_PROCESS,
2136: WF_CACHE.Activities(waIND).FUNCTION,
2137: WF_CACHE.Activities(waIND).FUNCTION_TYPE,

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

2130: WF_CACHE.Activities(waIND).TYPE,
2131: WF_CACHE.Activities(waIND).RERUN,
2132: WF_CACHE.Activities(waIND).EXPAND_ROLE,
2133: WF_CACHE.Activities(waIND).COST,
2134: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
2135: WF_CACHE.Activities(waIND).ERROR_PROCESS,
2136: WF_CACHE.Activities(waIND).FUNCTION,
2137: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
2138: WF_CACHE.Activities(waIND).EVENT_NAME,

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

2131: WF_CACHE.Activities(waIND).RERUN,
2132: WF_CACHE.Activities(waIND).EXPAND_ROLE,
2133: WF_CACHE.Activities(waIND).COST,
2134: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
2135: WF_CACHE.Activities(waIND).ERROR_PROCESS,
2136: WF_CACHE.Activities(waIND).FUNCTION,
2137: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
2138: WF_CACHE.Activities(waIND).EVENT_NAME,
2139: WF_CACHE.Activities(waIND).MESSAGE,

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

2132: WF_CACHE.Activities(waIND).EXPAND_ROLE,
2133: WF_CACHE.Activities(waIND).COST,
2134: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
2135: WF_CACHE.Activities(waIND).ERROR_PROCESS,
2136: WF_CACHE.Activities(waIND).FUNCTION,
2137: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
2138: WF_CACHE.Activities(waIND).EVENT_NAME,
2139: WF_CACHE.Activities(waIND).MESSAGE,
2140: WF_CACHE.Activities(waIND).BEGIN_DATE,

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

2133: WF_CACHE.Activities(waIND).COST,
2134: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
2135: WF_CACHE.Activities(waIND).ERROR_PROCESS,
2136: WF_CACHE.Activities(waIND).FUNCTION,
2137: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
2138: WF_CACHE.Activities(waIND).EVENT_NAME,
2139: WF_CACHE.Activities(waIND).MESSAGE,
2140: WF_CACHE.Activities(waIND).BEGIN_DATE,
2141: WF_CACHE.Activities(waIND).END_DATE,

Line 2138: WF_CACHE.Activities(waIND).EVENT_NAME,

2134: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
2135: WF_CACHE.Activities(waIND).ERROR_PROCESS,
2136: WF_CACHE.Activities(waIND).FUNCTION,
2137: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
2138: WF_CACHE.Activities(waIND).EVENT_NAME,
2139: WF_CACHE.Activities(waIND).MESSAGE,
2140: WF_CACHE.Activities(waIND).BEGIN_DATE,
2141: WF_CACHE.Activities(waIND).END_DATE,
2142: WF_CACHE.Activities(waIND).DIRECTION,

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

2135: WF_CACHE.Activities(waIND).ERROR_PROCESS,
2136: WF_CACHE.Activities(waIND).FUNCTION,
2137: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
2138: WF_CACHE.Activities(waIND).EVENT_NAME,
2139: WF_CACHE.Activities(waIND).MESSAGE,
2140: WF_CACHE.Activities(waIND).BEGIN_DATE,
2141: WF_CACHE.Activities(waIND).END_DATE,
2142: WF_CACHE.Activities(waIND).DIRECTION,
2143: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE,

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

2136: WF_CACHE.Activities(waIND).FUNCTION,
2137: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
2138: WF_CACHE.Activities(waIND).EVENT_NAME,
2139: WF_CACHE.Activities(waIND).MESSAGE,
2140: WF_CACHE.Activities(waIND).BEGIN_DATE,
2141: WF_CACHE.Activities(waIND).END_DATE,
2142: WF_CACHE.Activities(waIND).DIRECTION,
2143: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE,
2144: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME,

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

2137: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
2138: WF_CACHE.Activities(waIND).EVENT_NAME,
2139: WF_CACHE.Activities(waIND).MESSAGE,
2140: WF_CACHE.Activities(waIND).BEGIN_DATE,
2141: WF_CACHE.Activities(waIND).END_DATE,
2142: WF_CACHE.Activities(waIND).DIRECTION,
2143: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE,
2144: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME,
2145: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION,

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

2138: WF_CACHE.Activities(waIND).EVENT_NAME,
2139: WF_CACHE.Activities(waIND).MESSAGE,
2140: WF_CACHE.Activities(waIND).BEGIN_DATE,
2141: WF_CACHE.Activities(waIND).END_DATE,
2142: WF_CACHE.Activities(waIND).DIRECTION,
2143: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE,
2144: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME,
2145: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION,
2146: WF_CACHE.ActivityAttributes(waaIND).NAME,

Line 2143: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE,

2139: WF_CACHE.Activities(waIND).MESSAGE,
2140: WF_CACHE.Activities(waIND).BEGIN_DATE,
2141: WF_CACHE.Activities(waIND).END_DATE,
2142: WF_CACHE.Activities(waIND).DIRECTION,
2143: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE,
2144: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME,
2145: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION,
2146: WF_CACHE.ActivityAttributes(waaIND).NAME,
2147: WF_CACHE.ActivityAttributes(waaIND).TYPE,

Line 2144: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME,

2140: WF_CACHE.Activities(waIND).BEGIN_DATE,
2141: WF_CACHE.Activities(waIND).END_DATE,
2142: WF_CACHE.Activities(waIND).DIRECTION,
2143: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE,
2144: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME,
2145: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION,
2146: WF_CACHE.ActivityAttributes(waaIND).NAME,
2147: WF_CACHE.ActivityAttributes(waaIND).TYPE,
2148: WF_CACHE.ActivityAttributes(waaIND).SUBTYPE,

Line 2145: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION,

2141: WF_CACHE.Activities(waIND).END_DATE,
2142: WF_CACHE.Activities(waIND).DIRECTION,
2143: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE,
2144: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME,
2145: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION,
2146: WF_CACHE.ActivityAttributes(waaIND).NAME,
2147: WF_CACHE.ActivityAttributes(waaIND).TYPE,
2148: WF_CACHE.ActivityAttributes(waaIND).SUBTYPE,
2149: WF_CACHE.ActivityAttributes(waaIND).FORMAT,

Line 2146: WF_CACHE.ActivityAttributes(waaIND).NAME,

2142: WF_CACHE.Activities(waIND).DIRECTION,
2143: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE,
2144: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME,
2145: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION,
2146: WF_CACHE.ActivityAttributes(waaIND).NAME,
2147: WF_CACHE.ActivityAttributes(waaIND).TYPE,
2148: WF_CACHE.ActivityAttributes(waaIND).SUBTYPE,
2149: WF_CACHE.ActivityAttributes(waaIND).FORMAT,
2150: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,

Line 2147: WF_CACHE.ActivityAttributes(waaIND).TYPE,

2143: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE,
2144: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME,
2145: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION,
2146: WF_CACHE.ActivityAttributes(waaIND).NAME,
2147: WF_CACHE.ActivityAttributes(waaIND).TYPE,
2148: WF_CACHE.ActivityAttributes(waaIND).SUBTYPE,
2149: WF_CACHE.ActivityAttributes(waaIND).FORMAT,
2150: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
2151: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,

Line 2148: WF_CACHE.ActivityAttributes(waaIND).SUBTYPE,

2144: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME,
2145: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION,
2146: WF_CACHE.ActivityAttributes(waaIND).NAME,
2147: WF_CACHE.ActivityAttributes(waaIND).TYPE,
2148: WF_CACHE.ActivityAttributes(waaIND).SUBTYPE,
2149: WF_CACHE.ActivityAttributes(waaIND).FORMAT,
2150: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
2151: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
2152: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,

Line 2149: WF_CACHE.ActivityAttributes(waaIND).FORMAT,

2145: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION,
2146: WF_CACHE.ActivityAttributes(waaIND).NAME,
2147: WF_CACHE.ActivityAttributes(waaIND).TYPE,
2148: WF_CACHE.ActivityAttributes(waaIND).SUBTYPE,
2149: WF_CACHE.ActivityAttributes(waaIND).FORMAT,
2150: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
2151: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
2152: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
2153: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,

Line 2150: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,

2146: WF_CACHE.ActivityAttributes(waaIND).NAME,
2147: WF_CACHE.ActivityAttributes(waaIND).TYPE,
2148: WF_CACHE.ActivityAttributes(waaIND).SUBTYPE,
2149: WF_CACHE.ActivityAttributes(waaIND).FORMAT,
2150: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
2151: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
2152: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
2153: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
2154: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,

Line 2151: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,

2147: WF_CACHE.ActivityAttributes(waaIND).TYPE,
2148: WF_CACHE.ActivityAttributes(waaIND).SUBTYPE,
2149: WF_CACHE.ActivityAttributes(waaIND).FORMAT,
2150: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
2151: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
2152: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
2153: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
2154: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
2155: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,

Line 2152: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,

2148: WF_CACHE.ActivityAttributes(waaIND).SUBTYPE,
2149: WF_CACHE.ActivityAttributes(waaIND).FORMAT,
2150: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
2151: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
2152: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
2153: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
2154: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
2155: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
2156: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,

Line 2153: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,

2149: WF_CACHE.ActivityAttributes(waaIND).FORMAT,
2150: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
2151: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
2152: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
2153: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
2154: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
2155: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
2156: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
2157: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,

Line 2154: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,

2150: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
2151: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
2152: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
2153: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
2154: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
2155: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
2156: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
2157: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
2158: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,

Line 2155: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,

2151: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
2152: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
2153: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
2154: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
2155: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
2156: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
2157: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
2158: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
2159: WF_CACHE.ProcessActivities(actid).START_END,

Line 2156: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,

2152: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
2153: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
2154: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
2155: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
2156: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
2157: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
2158: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
2159: WF_CACHE.ProcessActivities(actid).START_END,
2160: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT

Line 2157: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,

2153: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
2154: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
2155: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
2156: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
2157: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
2158: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
2159: WF_CACHE.ProcessActivities(actid).START_END,
2160: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT
2161:

Line 2158: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,

2154: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
2155: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
2156: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
2157: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
2158: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
2159: WF_CACHE.ProcessActivities(actid).START_END,
2160: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT
2161:
2162: from WF_ACTIVITY_ATTRIBUTES WAA, WF_PROCESS_ACTIVITIES WPA,

Line 2159: WF_CACHE.ProcessActivities(actid).START_END,

2155: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
2156: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
2157: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
2158: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
2159: WF_CACHE.ProcessActivities(actid).START_END,
2160: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT
2161:
2162: from WF_ACTIVITY_ATTRIBUTES WAA, WF_PROCESS_ACTIVITIES WPA,
2163: WF_ACTIVITIES WA

Line 2160: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT

2156: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
2157: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
2158: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
2159: WF_CACHE.ProcessActivities(actid).START_END,
2160: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT
2161:
2162: from WF_ACTIVITY_ATTRIBUTES WAA, WF_PROCESS_ACTIVITIES WPA,
2163: WF_ACTIVITIES WA
2164:

Line 2177: waIND := WF_CACHE.HashKey(itemType ||

2173: and WAA.NAME = aname;
2174:
2175: --Get the proper hash key and copy the temporary records into the
2176: --proper locations.
2177: waIND := WF_CACHE.HashKey(itemType ||
2178: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
2179:
2180: WF_CACHE.Activities(waIND) := WF_CACHE.Activities(0);
2181:

Line 2178: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);

2174:
2175: --Get the proper hash key and copy the temporary records into the
2176: --proper locations.
2177: waIND := WF_CACHE.HashKey(itemType ||
2178: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
2179:
2180: WF_CACHE.Activities(waIND) := WF_CACHE.Activities(0);
2181:
2182: waaIND := WF_CACHE.HashKey(itemType || aname ||

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

2176: --proper locations.
2177: waIND := WF_CACHE.HashKey(itemType ||
2178: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
2179:
2180: WF_CACHE.Activities(waIND) := WF_CACHE.Activities(0);
2181:
2182: waaIND := WF_CACHE.HashKey(itemType || aname ||
2183: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
2184:

Line 2182: waaIND := WF_CACHE.HashKey(itemType || aname ||

2178: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
2179:
2180: WF_CACHE.Activities(waIND) := WF_CACHE.Activities(0);
2181:
2182: waaIND := WF_CACHE.HashKey(itemType || aname ||
2183: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
2184:
2185: WF_CACHE.ActivityAttributes(waaIND) :=
2186: WF_CACHE.ActivityAttributes(0);

Line 2183: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);

2179:
2180: WF_CACHE.Activities(waIND) := WF_CACHE.Activities(0);
2181:
2182: waaIND := WF_CACHE.HashKey(itemType || aname ||
2183: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
2184:
2185: WF_CACHE.ActivityAttributes(waaIND) :=
2186: WF_CACHE.ActivityAttributes(0);
2187:

Line 2185: WF_CACHE.ActivityAttributes(waaIND) :=

2181:
2182: waaIND := WF_CACHE.HashKey(itemType || aname ||
2183: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
2184:
2185: WF_CACHE.ActivityAttributes(waaIND) :=
2186: WF_CACHE.ActivityAttributes(0);
2187:
2188: end if;
2189:

Line 2186: WF_CACHE.ActivityAttributes(0);

2182: waaIND := WF_CACHE.HashKey(itemType || aname ||
2183: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
2184:
2185: WF_CACHE.ActivityAttributes(waaIND) :=
2186: WF_CACHE.ActivityAttributes(0);
2187:
2188: end if;
2189:
2190: atype := WF_CACHE.ActivityAttributes(waaIND).TYPE;

Line 2190: atype := WF_CACHE.ActivityAttributes(waaIND).TYPE;

2186: WF_CACHE.ActivityAttributes(0);
2187:
2188: end if;
2189:
2190: atype := WF_CACHE.ActivityAttributes(waaIND).TYPE;
2191: subtype := WF_CACHE.ActivityAttributes(waaIND).SUBTYPE;
2192: format := WF_CACHE.ActivityAttributes(waaIND).FORMAT;
2193:
2194: exception

Line 2191: subtype := WF_CACHE.ActivityAttributes(waaIND).SUBTYPE;

2187:
2188: end if;
2189:
2190: atype := WF_CACHE.ActivityAttributes(waaIND).TYPE;
2191: subtype := WF_CACHE.ActivityAttributes(waaIND).SUBTYPE;
2192: format := WF_CACHE.ActivityAttributes(waaIND).FORMAT;
2193:
2194: exception
2195: when no_data_found then

Line 2192: format := WF_CACHE.ActivityAttributes(waaIND).FORMAT;

2188: end if;
2189:
2190: atype := WF_CACHE.ActivityAttributes(waaIND).TYPE;
2191: subtype := WF_CACHE.ActivityAttributes(waaIND).SUBTYPE;
2192: format := WF_CACHE.ActivityAttributes(waaIND).FORMAT;
2193:
2194: exception
2195: when no_data_found then
2196: Wf_Core.Context('Wf_Engine', 'GetActivityAttrInfo', itemtype, itemkey,

Line 2253: WF_CACHE.GetActivityAttrValue(actid, aname, status, waavIND);

2249: end if;
2250:
2251: -- First check value_type flag for possible item_attribute ref.
2252: -- Checking to see if the Attribute Value is in cache.
2253: WF_CACHE.GetActivityAttrValue(actid, aname, status, waavIND);
2254:
2255: if (status <> WF_CACHE.task_SUCCESS) then
2256: open curs_activityattr (actid, aname);
2257: fetch curs_activityattr into WF_CACHE.ActivityAttrValues(waavIND);

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

2251: -- First check value_type flag for possible item_attribute ref.
2252: -- Checking to see if the Attribute Value is in cache.
2253: WF_CACHE.GetActivityAttrValue(actid, aname, status, waavIND);
2254:
2255: if (status <> WF_CACHE.task_SUCCESS) then
2256: open curs_activityattr (actid, aname);
2257: fetch curs_activityattr into WF_CACHE.ActivityAttrValues(waavIND);
2258: close curs_activityattr;
2259: end if;

Line 2257: fetch curs_activityattr into WF_CACHE.ActivityAttrValues(waavIND);

2253: WF_CACHE.GetActivityAttrValue(actid, aname, status, waavIND);
2254:
2255: if (status <> WF_CACHE.task_SUCCESS) then
2256: open curs_activityattr (actid, aname);
2257: fetch curs_activityattr into WF_CACHE.ActivityAttrValues(waavIND);
2258: close curs_activityattr;
2259: end if;
2260:
2261: -- If it is a reference, return value of item_attr instead of

Line 2263: if (WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE = 'ITEMATTR') then

2259: end if;
2260:
2261: -- If it is a reference, return value of item_attr instead of
2262: -- contents of WAAV.
2263: if (WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE = 'ITEMATTR') then
2264: if (WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE is null) then
2265: return(null); -- Null itemattr means null value, not an error
2266: end if;
2267:

Line 2264: if (WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE is null) then

2260:
2261: -- If it is a reference, return value of item_attr instead of
2262: -- contents of WAAV.
2263: if (WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE = 'ITEMATTR') then
2264: if (WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE is null) then
2265: return(null); -- Null itemattr means null value, not an error
2266: end if;
2267:
2268: return(GetItemAttrText(itemtype, itemkey,

Line 2269: substrb(WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE, 1, 30)));

2265: return(null); -- Null itemattr means null value, not an error
2266: end if;
2267:
2268: return(GetItemAttrText(itemtype, itemkey,
2269: substrb(WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE, 1, 30)));
2270:
2271: end if;
2272:
2273: -- This is NOT an itemattr reference, get value directly from WAAV.

Line 2278: WF_CACHE.GetActivityAttr( itemtype, aname, actid, actdate, status, waIND,

2274: -- Get type and format of attr for translating number/date strings.
2275: begin
2276: actdate := Wf_Item.Active_Date(itemtype, itemkey);
2277:
2278: WF_CACHE.GetActivityAttr( itemtype, aname, actid, actdate, status, waIND,
2279: waaIND );
2280:
2281: if (status <> WF_CACHE.task_SUCCESS) then
2282: waIND := 0;

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

2277:
2278: WF_CACHE.GetActivityAttr( itemtype, aname, actid, actdate, status, waIND,
2279: waaIND );
2280:
2281: if (status <> WF_CACHE.task_SUCCESS) then
2282: waIND := 0;
2283: waaIND := 0;
2284:
2285: select WA.ITEM_TYPE, WA.NAME, WA.VERSION, WA.TYPE, WA.RERUN,

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

2292: WPA.PROCESS_VERSION, WPA.ACTIVITY_ITEM_TYPE, WPA.ACTIVITY_NAME,
2293: WPA.INSTANCE_ID, WPA.INSTANCE_LABEL, WPA.PERFORM_ROLE,
2294: WPA.PERFORM_ROLE_TYPE, WPA.START_END, WPA.DEFAULT_RESULT
2295:
2296: into WF_CACHE.Activities(waIND).ITEM_TYPE,
2297: WF_CACHE.Activities(waIND).NAME,
2298: WF_CACHE.Activities(waIND).VERSION,
2299: WF_CACHE.Activities(waIND).TYPE,
2300: WF_CACHE.Activities(waIND).RERUN,

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

2293: WPA.INSTANCE_ID, WPA.INSTANCE_LABEL, WPA.PERFORM_ROLE,
2294: WPA.PERFORM_ROLE_TYPE, WPA.START_END, WPA.DEFAULT_RESULT
2295:
2296: into WF_CACHE.Activities(waIND).ITEM_TYPE,
2297: WF_CACHE.Activities(waIND).NAME,
2298: WF_CACHE.Activities(waIND).VERSION,
2299: WF_CACHE.Activities(waIND).TYPE,
2300: WF_CACHE.Activities(waIND).RERUN,
2301: WF_CACHE.Activities(waIND).EXPAND_ROLE,

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

2294: WPA.PERFORM_ROLE_TYPE, WPA.START_END, WPA.DEFAULT_RESULT
2295:
2296: into WF_CACHE.Activities(waIND).ITEM_TYPE,
2297: WF_CACHE.Activities(waIND).NAME,
2298: WF_CACHE.Activities(waIND).VERSION,
2299: WF_CACHE.Activities(waIND).TYPE,
2300: WF_CACHE.Activities(waIND).RERUN,
2301: WF_CACHE.Activities(waIND).EXPAND_ROLE,
2302: WF_CACHE.Activities(waIND).COST,

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

2295:
2296: into WF_CACHE.Activities(waIND).ITEM_TYPE,
2297: WF_CACHE.Activities(waIND).NAME,
2298: WF_CACHE.Activities(waIND).VERSION,
2299: WF_CACHE.Activities(waIND).TYPE,
2300: WF_CACHE.Activities(waIND).RERUN,
2301: WF_CACHE.Activities(waIND).EXPAND_ROLE,
2302: WF_CACHE.Activities(waIND).COST,
2303: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,

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

2296: into WF_CACHE.Activities(waIND).ITEM_TYPE,
2297: WF_CACHE.Activities(waIND).NAME,
2298: WF_CACHE.Activities(waIND).VERSION,
2299: WF_CACHE.Activities(waIND).TYPE,
2300: WF_CACHE.Activities(waIND).RERUN,
2301: WF_CACHE.Activities(waIND).EXPAND_ROLE,
2302: WF_CACHE.Activities(waIND).COST,
2303: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
2304: WF_CACHE.Activities(waIND).ERROR_PROCESS,

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

2297: WF_CACHE.Activities(waIND).NAME,
2298: WF_CACHE.Activities(waIND).VERSION,
2299: WF_CACHE.Activities(waIND).TYPE,
2300: WF_CACHE.Activities(waIND).RERUN,
2301: WF_CACHE.Activities(waIND).EXPAND_ROLE,
2302: WF_CACHE.Activities(waIND).COST,
2303: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
2304: WF_CACHE.Activities(waIND).ERROR_PROCESS,
2305: WF_CACHE.Activities(waIND).FUNCTION,

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

2298: WF_CACHE.Activities(waIND).VERSION,
2299: WF_CACHE.Activities(waIND).TYPE,
2300: WF_CACHE.Activities(waIND).RERUN,
2301: WF_CACHE.Activities(waIND).EXPAND_ROLE,
2302: WF_CACHE.Activities(waIND).COST,
2303: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
2304: WF_CACHE.Activities(waIND).ERROR_PROCESS,
2305: WF_CACHE.Activities(waIND).FUNCTION,
2306: WF_CACHE.Activities(waIND).FUNCTION_TYPE,

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

2299: WF_CACHE.Activities(waIND).TYPE,
2300: WF_CACHE.Activities(waIND).RERUN,
2301: WF_CACHE.Activities(waIND).EXPAND_ROLE,
2302: WF_CACHE.Activities(waIND).COST,
2303: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
2304: WF_CACHE.Activities(waIND).ERROR_PROCESS,
2305: WF_CACHE.Activities(waIND).FUNCTION,
2306: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
2307: WF_CACHE.Activities(waIND).EVENT_NAME,

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

2300: WF_CACHE.Activities(waIND).RERUN,
2301: WF_CACHE.Activities(waIND).EXPAND_ROLE,
2302: WF_CACHE.Activities(waIND).COST,
2303: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
2304: WF_CACHE.Activities(waIND).ERROR_PROCESS,
2305: WF_CACHE.Activities(waIND).FUNCTION,
2306: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
2307: WF_CACHE.Activities(waIND).EVENT_NAME,
2308: WF_CACHE.Activities(waIND).MESSAGE,

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

2301: WF_CACHE.Activities(waIND).EXPAND_ROLE,
2302: WF_CACHE.Activities(waIND).COST,
2303: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
2304: WF_CACHE.Activities(waIND).ERROR_PROCESS,
2305: WF_CACHE.Activities(waIND).FUNCTION,
2306: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
2307: WF_CACHE.Activities(waIND).EVENT_NAME,
2308: WF_CACHE.Activities(waIND).MESSAGE,
2309: WF_CACHE.Activities(waIND).BEGIN_DATE,

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

2302: WF_CACHE.Activities(waIND).COST,
2303: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
2304: WF_CACHE.Activities(waIND).ERROR_PROCESS,
2305: WF_CACHE.Activities(waIND).FUNCTION,
2306: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
2307: WF_CACHE.Activities(waIND).EVENT_NAME,
2308: WF_CACHE.Activities(waIND).MESSAGE,
2309: WF_CACHE.Activities(waIND).BEGIN_DATE,
2310: WF_CACHE.Activities(waIND).END_DATE,

Line 2307: WF_CACHE.Activities(waIND).EVENT_NAME,

2303: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
2304: WF_CACHE.Activities(waIND).ERROR_PROCESS,
2305: WF_CACHE.Activities(waIND).FUNCTION,
2306: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
2307: WF_CACHE.Activities(waIND).EVENT_NAME,
2308: WF_CACHE.Activities(waIND).MESSAGE,
2309: WF_CACHE.Activities(waIND).BEGIN_DATE,
2310: WF_CACHE.Activities(waIND).END_DATE,
2311: WF_CACHE.Activities(waIND).DIRECTION,

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

2304: WF_CACHE.Activities(waIND).ERROR_PROCESS,
2305: WF_CACHE.Activities(waIND).FUNCTION,
2306: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
2307: WF_CACHE.Activities(waIND).EVENT_NAME,
2308: WF_CACHE.Activities(waIND).MESSAGE,
2309: WF_CACHE.Activities(waIND).BEGIN_DATE,
2310: WF_CACHE.Activities(waIND).END_DATE,
2311: WF_CACHE.Activities(waIND).DIRECTION,
2312: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE,

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

2305: WF_CACHE.Activities(waIND).FUNCTION,
2306: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
2307: WF_CACHE.Activities(waIND).EVENT_NAME,
2308: WF_CACHE.Activities(waIND).MESSAGE,
2309: WF_CACHE.Activities(waIND).BEGIN_DATE,
2310: WF_CACHE.Activities(waIND).END_DATE,
2311: WF_CACHE.Activities(waIND).DIRECTION,
2312: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE,
2313: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME,

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

2306: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
2307: WF_CACHE.Activities(waIND).EVENT_NAME,
2308: WF_CACHE.Activities(waIND).MESSAGE,
2309: WF_CACHE.Activities(waIND).BEGIN_DATE,
2310: WF_CACHE.Activities(waIND).END_DATE,
2311: WF_CACHE.Activities(waIND).DIRECTION,
2312: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE,
2313: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME,
2314: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION,

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

2307: WF_CACHE.Activities(waIND).EVENT_NAME,
2308: WF_CACHE.Activities(waIND).MESSAGE,
2309: WF_CACHE.Activities(waIND).BEGIN_DATE,
2310: WF_CACHE.Activities(waIND).END_DATE,
2311: WF_CACHE.Activities(waIND).DIRECTION,
2312: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE,
2313: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME,
2314: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION,
2315: WF_CACHE.ActivityAttributes(waaIND).NAME,

Line 2312: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE,

2308: WF_CACHE.Activities(waIND).MESSAGE,
2309: WF_CACHE.Activities(waIND).BEGIN_DATE,
2310: WF_CACHE.Activities(waIND).END_DATE,
2311: WF_CACHE.Activities(waIND).DIRECTION,
2312: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE,
2313: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME,
2314: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION,
2315: WF_CACHE.ActivityAttributes(waaIND).NAME,
2316: WF_CACHE.ActivityAttributes(waaIND).TYPE,

Line 2313: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME,

2309: WF_CACHE.Activities(waIND).BEGIN_DATE,
2310: WF_CACHE.Activities(waIND).END_DATE,
2311: WF_CACHE.Activities(waIND).DIRECTION,
2312: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE,
2313: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME,
2314: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION,
2315: WF_CACHE.ActivityAttributes(waaIND).NAME,
2316: WF_CACHE.ActivityAttributes(waaIND).TYPE,
2317: WF_CACHE.ActivityAttributes(waaIND).SUBTYPE,

Line 2314: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION,

2310: WF_CACHE.Activities(waIND).END_DATE,
2311: WF_CACHE.Activities(waIND).DIRECTION,
2312: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE,
2313: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME,
2314: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION,
2315: WF_CACHE.ActivityAttributes(waaIND).NAME,
2316: WF_CACHE.ActivityAttributes(waaIND).TYPE,
2317: WF_CACHE.ActivityAttributes(waaIND).SUBTYPE,
2318: WF_CACHE.ActivityAttributes(waaIND).FORMAT,

Line 2315: WF_CACHE.ActivityAttributes(waaIND).NAME,

2311: WF_CACHE.Activities(waIND).DIRECTION,
2312: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE,
2313: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME,
2314: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION,
2315: WF_CACHE.ActivityAttributes(waaIND).NAME,
2316: WF_CACHE.ActivityAttributes(waaIND).TYPE,
2317: WF_CACHE.ActivityAttributes(waaIND).SUBTYPE,
2318: WF_CACHE.ActivityAttributes(waaIND).FORMAT,
2319: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,

Line 2316: WF_CACHE.ActivityAttributes(waaIND).TYPE,

2312: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE,
2313: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME,
2314: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION,
2315: WF_CACHE.ActivityAttributes(waaIND).NAME,
2316: WF_CACHE.ActivityAttributes(waaIND).TYPE,
2317: WF_CACHE.ActivityAttributes(waaIND).SUBTYPE,
2318: WF_CACHE.ActivityAttributes(waaIND).FORMAT,
2319: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
2320: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,

Line 2317: WF_CACHE.ActivityAttributes(waaIND).SUBTYPE,

2313: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME,
2314: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION,
2315: WF_CACHE.ActivityAttributes(waaIND).NAME,
2316: WF_CACHE.ActivityAttributes(waaIND).TYPE,
2317: WF_CACHE.ActivityAttributes(waaIND).SUBTYPE,
2318: WF_CACHE.ActivityAttributes(waaIND).FORMAT,
2319: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
2320: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
2321: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,

Line 2318: WF_CACHE.ActivityAttributes(waaIND).FORMAT,

2314: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION,
2315: WF_CACHE.ActivityAttributes(waaIND).NAME,
2316: WF_CACHE.ActivityAttributes(waaIND).TYPE,
2317: WF_CACHE.ActivityAttributes(waaIND).SUBTYPE,
2318: WF_CACHE.ActivityAttributes(waaIND).FORMAT,
2319: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
2320: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
2321: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
2322: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,

Line 2319: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,

2315: WF_CACHE.ActivityAttributes(waaIND).NAME,
2316: WF_CACHE.ActivityAttributes(waaIND).TYPE,
2317: WF_CACHE.ActivityAttributes(waaIND).SUBTYPE,
2318: WF_CACHE.ActivityAttributes(waaIND).FORMAT,
2319: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
2320: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
2321: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
2322: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
2323: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,

Line 2320: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,

2316: WF_CACHE.ActivityAttributes(waaIND).TYPE,
2317: WF_CACHE.ActivityAttributes(waaIND).SUBTYPE,
2318: WF_CACHE.ActivityAttributes(waaIND).FORMAT,
2319: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
2320: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
2321: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
2322: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
2323: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
2324: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,

Line 2321: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,

2317: WF_CACHE.ActivityAttributes(waaIND).SUBTYPE,
2318: WF_CACHE.ActivityAttributes(waaIND).FORMAT,
2319: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
2320: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
2321: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
2322: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
2323: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
2324: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
2325: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,

Line 2322: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,

2318: WF_CACHE.ActivityAttributes(waaIND).FORMAT,
2319: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
2320: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
2321: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
2322: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
2323: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
2324: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
2325: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
2326: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,

Line 2323: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,

2319: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
2320: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
2321: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
2322: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
2323: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
2324: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
2325: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
2326: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
2327: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,

Line 2324: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,

2320: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
2321: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
2322: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
2323: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
2324: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
2325: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
2326: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
2327: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
2328: WF_CACHE.ProcessActivities(actid).START_END,

Line 2325: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,

2321: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
2322: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
2323: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
2324: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
2325: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
2326: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
2327: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
2328: WF_CACHE.ProcessActivities(actid).START_END,
2329: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT

Line 2326: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,

2322: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
2323: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
2324: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
2325: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
2326: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
2327: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
2328: WF_CACHE.ProcessActivities(actid).START_END,
2329: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT
2330:

Line 2327: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,

2323: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
2324: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
2325: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
2326: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
2327: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
2328: WF_CACHE.ProcessActivities(actid).START_END,
2329: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT
2330:
2331: from WF_ACTIVITY_ATTRIBUTES WAA, WF_PROCESS_ACTIVITIES WPA,

Line 2328: WF_CACHE.ProcessActivities(actid).START_END,

2324: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
2325: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
2326: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
2327: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
2328: WF_CACHE.ProcessActivities(actid).START_END,
2329: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT
2330:
2331: from WF_ACTIVITY_ATTRIBUTES WAA, WF_PROCESS_ACTIVITIES WPA,
2332: WF_ACTIVITIES WA

Line 2329: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT

2325: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
2326: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
2327: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
2328: WF_CACHE.ProcessActivities(actid).START_END,
2329: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT
2330:
2331: from WF_ACTIVITY_ATTRIBUTES WAA, WF_PROCESS_ACTIVITIES WPA,
2332: WF_ACTIVITIES WA
2333:

Line 2346: waIND := WF_CACHE.HashKey(itemType ||

2342: and WAA.NAME = aname;
2343:
2344: --Get the proper hash key and copy the temporary records into the
2345: --proper locations.
2346: waIND := WF_CACHE.HashKey(itemType ||
2347: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
2348:
2349: WF_CACHE.Activities(waIND) := WF_CACHE.Activities(0);
2350:

Line 2347: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);

2343:
2344: --Get the proper hash key and copy the temporary records into the
2345: --proper locations.
2346: waIND := WF_CACHE.HashKey(itemType ||
2347: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
2348:
2349: WF_CACHE.Activities(waIND) := WF_CACHE.Activities(0);
2350:
2351: waaIND := WF_CACHE.HashKey(itemType || aname ||

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

2345: --proper locations.
2346: waIND := WF_CACHE.HashKey(itemType ||
2347: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
2348:
2349: WF_CACHE.Activities(waIND) := WF_CACHE.Activities(0);
2350:
2351: waaIND := WF_CACHE.HashKey(itemType || aname ||
2352: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
2353:

Line 2351: waaIND := WF_CACHE.HashKey(itemType || aname ||

2347: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
2348:
2349: WF_CACHE.Activities(waIND) := WF_CACHE.Activities(0);
2350:
2351: waaIND := WF_CACHE.HashKey(itemType || aname ||
2352: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
2353:
2354: WF_CACHE.ActivityAttributes(waaIND) :=
2355: WF_CACHE.ActivityAttributes(0);

Line 2352: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);

2348:
2349: WF_CACHE.Activities(waIND) := WF_CACHE.Activities(0);
2350:
2351: waaIND := WF_CACHE.HashKey(itemType || aname ||
2352: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
2353:
2354: WF_CACHE.ActivityAttributes(waaIND) :=
2355: WF_CACHE.ActivityAttributes(0);
2356:

Line 2354: WF_CACHE.ActivityAttributes(waaIND) :=

2350:
2351: waaIND := WF_CACHE.HashKey(itemType || aname ||
2352: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
2353:
2354: WF_CACHE.ActivityAttributes(waaIND) :=
2355: WF_CACHE.ActivityAttributes(0);
2356:
2357: end if;
2358:

Line 2355: WF_CACHE.ActivityAttributes(0);

2351: waaIND := WF_CACHE.HashKey(itemType || aname ||
2352: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
2353:
2354: WF_CACHE.ActivityAttributes(waaIND) :=
2355: WF_CACHE.ActivityAttributes(0);
2356:
2357: end if;
2358:
2359: exception

Line 2367: WF_CACHE.GetProcessActivityInfo(actid, actdate, status, waIND);

2363: -- We know that the activity and process activity should be retrievable.
2364: -- We will build a unvalidated runtime attr in cache. First we need to
2365: -- validate that we have the correct activity and process activity cached
2366:
2367: WF_CACHE.GetProcessActivityInfo(actid, actdate, status, waIND);
2368:
2369: if (status <> WF_CACHE.task_SUCCESS) then
2370: waIND := 0;
2371:

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

2365: -- validate that we have the correct activity and process activity cached
2366:
2367: WF_CACHE.GetProcessActivityInfo(actid, actdate, status, waIND);
2368:
2369: if (status <> WF_CACHE.task_SUCCESS) then
2370: waIND := 0;
2371:
2372: select WA.ITEM_TYPE, WA.NAME, WA.VERSION, WA.TYPE, WA.RERUN,
2373: WA.EXPAND_ROLE, WA.COST, WA.ERROR_ITEM_TYPE, WA.ERROR_PROCESS,

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

2377: WPA.ACTIVITY_NAME, WPA.INSTANCE_ID, WPA.INSTANCE_LABEL,
2378: WPA.PERFORM_ROLE, WPA.PERFORM_ROLE_TYPE, WPA.START_END,
2379: WPA.DEFAULT_RESULT
2380:
2381: into WF_CACHE.Activities(waIND).ITEM_TYPE,
2382: WF_CACHE.Activities(waIND).NAME,
2383: WF_CACHE.Activities(waIND).VERSION,
2384: WF_CACHE.Activities(waIND).TYPE,
2385: WF_CACHE.Activities(waIND).RERUN,

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

2378: WPA.PERFORM_ROLE, WPA.PERFORM_ROLE_TYPE, WPA.START_END,
2379: WPA.DEFAULT_RESULT
2380:
2381: into WF_CACHE.Activities(waIND).ITEM_TYPE,
2382: WF_CACHE.Activities(waIND).NAME,
2383: WF_CACHE.Activities(waIND).VERSION,
2384: WF_CACHE.Activities(waIND).TYPE,
2385: WF_CACHE.Activities(waIND).RERUN,
2386: WF_CACHE.Activities(waIND).EXPAND_ROLE,

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

2379: WPA.DEFAULT_RESULT
2380:
2381: into WF_CACHE.Activities(waIND).ITEM_TYPE,
2382: WF_CACHE.Activities(waIND).NAME,
2383: WF_CACHE.Activities(waIND).VERSION,
2384: WF_CACHE.Activities(waIND).TYPE,
2385: WF_CACHE.Activities(waIND).RERUN,
2386: WF_CACHE.Activities(waIND).EXPAND_ROLE,
2387: WF_CACHE.Activities(waIND).COST,

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

2380:
2381: into WF_CACHE.Activities(waIND).ITEM_TYPE,
2382: WF_CACHE.Activities(waIND).NAME,
2383: WF_CACHE.Activities(waIND).VERSION,
2384: WF_CACHE.Activities(waIND).TYPE,
2385: WF_CACHE.Activities(waIND).RERUN,
2386: WF_CACHE.Activities(waIND).EXPAND_ROLE,
2387: WF_CACHE.Activities(waIND).COST,
2388: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,

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

2381: into WF_CACHE.Activities(waIND).ITEM_TYPE,
2382: WF_CACHE.Activities(waIND).NAME,
2383: WF_CACHE.Activities(waIND).VERSION,
2384: WF_CACHE.Activities(waIND).TYPE,
2385: WF_CACHE.Activities(waIND).RERUN,
2386: WF_CACHE.Activities(waIND).EXPAND_ROLE,
2387: WF_CACHE.Activities(waIND).COST,
2388: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
2389: WF_CACHE.Activities(waIND).ERROR_PROCESS,

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

2382: WF_CACHE.Activities(waIND).NAME,
2383: WF_CACHE.Activities(waIND).VERSION,
2384: WF_CACHE.Activities(waIND).TYPE,
2385: WF_CACHE.Activities(waIND).RERUN,
2386: WF_CACHE.Activities(waIND).EXPAND_ROLE,
2387: WF_CACHE.Activities(waIND).COST,
2388: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
2389: WF_CACHE.Activities(waIND).ERROR_PROCESS,
2390: WF_CACHE.Activities(waIND).FUNCTION,

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

2383: WF_CACHE.Activities(waIND).VERSION,
2384: WF_CACHE.Activities(waIND).TYPE,
2385: WF_CACHE.Activities(waIND).RERUN,
2386: WF_CACHE.Activities(waIND).EXPAND_ROLE,
2387: WF_CACHE.Activities(waIND).COST,
2388: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
2389: WF_CACHE.Activities(waIND).ERROR_PROCESS,
2390: WF_CACHE.Activities(waIND).FUNCTION,
2391: WF_CACHE.Activities(waIND).FUNCTION_TYPE,

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

2384: WF_CACHE.Activities(waIND).TYPE,
2385: WF_CACHE.Activities(waIND).RERUN,
2386: WF_CACHE.Activities(waIND).EXPAND_ROLE,
2387: WF_CACHE.Activities(waIND).COST,
2388: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
2389: WF_CACHE.Activities(waIND).ERROR_PROCESS,
2390: WF_CACHE.Activities(waIND).FUNCTION,
2391: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
2392: WF_CACHE.Activities(waIND).MESSAGE,

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

2385: WF_CACHE.Activities(waIND).RERUN,
2386: WF_CACHE.Activities(waIND).EXPAND_ROLE,
2387: WF_CACHE.Activities(waIND).COST,
2388: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
2389: WF_CACHE.Activities(waIND).ERROR_PROCESS,
2390: WF_CACHE.Activities(waIND).FUNCTION,
2391: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
2392: WF_CACHE.Activities(waIND).MESSAGE,
2393: WF_CACHE.Activities(waIND).BEGIN_DATE,

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

2386: WF_CACHE.Activities(waIND).EXPAND_ROLE,
2387: WF_CACHE.Activities(waIND).COST,
2388: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
2389: WF_CACHE.Activities(waIND).ERROR_PROCESS,
2390: WF_CACHE.Activities(waIND).FUNCTION,
2391: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
2392: WF_CACHE.Activities(waIND).MESSAGE,
2393: WF_CACHE.Activities(waIND).BEGIN_DATE,
2394: WF_CACHE.Activities(waIND).END_DATE,

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

2387: WF_CACHE.Activities(waIND).COST,
2388: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
2389: WF_CACHE.Activities(waIND).ERROR_PROCESS,
2390: WF_CACHE.Activities(waIND).FUNCTION,
2391: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
2392: WF_CACHE.Activities(waIND).MESSAGE,
2393: WF_CACHE.Activities(waIND).BEGIN_DATE,
2394: WF_CACHE.Activities(waIND).END_DATE,
2395: WF_CACHE.Activities(waIND).DIRECTION,

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

2388: WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
2389: WF_CACHE.Activities(waIND).ERROR_PROCESS,
2390: WF_CACHE.Activities(waIND).FUNCTION,
2391: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
2392: WF_CACHE.Activities(waIND).MESSAGE,
2393: WF_CACHE.Activities(waIND).BEGIN_DATE,
2394: WF_CACHE.Activities(waIND).END_DATE,
2395: WF_CACHE.Activities(waIND).DIRECTION,
2396: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,

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

2389: WF_CACHE.Activities(waIND).ERROR_PROCESS,
2390: WF_CACHE.Activities(waIND).FUNCTION,
2391: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
2392: WF_CACHE.Activities(waIND).MESSAGE,
2393: WF_CACHE.Activities(waIND).BEGIN_DATE,
2394: WF_CACHE.Activities(waIND).END_DATE,
2395: WF_CACHE.Activities(waIND).DIRECTION,
2396: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
2397: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,

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

2390: WF_CACHE.Activities(waIND).FUNCTION,
2391: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
2392: WF_CACHE.Activities(waIND).MESSAGE,
2393: WF_CACHE.Activities(waIND).BEGIN_DATE,
2394: WF_CACHE.Activities(waIND).END_DATE,
2395: WF_CACHE.Activities(waIND).DIRECTION,
2396: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
2397: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
2398: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,

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

2391: WF_CACHE.Activities(waIND).FUNCTION_TYPE,
2392: WF_CACHE.Activities(waIND).MESSAGE,
2393: WF_CACHE.Activities(waIND).BEGIN_DATE,
2394: WF_CACHE.Activities(waIND).END_DATE,
2395: WF_CACHE.Activities(waIND).DIRECTION,
2396: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
2397: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
2398: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
2399: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,

Line 2396: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,

2392: WF_CACHE.Activities(waIND).MESSAGE,
2393: WF_CACHE.Activities(waIND).BEGIN_DATE,
2394: WF_CACHE.Activities(waIND).END_DATE,
2395: WF_CACHE.Activities(waIND).DIRECTION,
2396: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
2397: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
2398: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
2399: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
2400: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,

Line 2397: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,

2393: WF_CACHE.Activities(waIND).BEGIN_DATE,
2394: WF_CACHE.Activities(waIND).END_DATE,
2395: WF_CACHE.Activities(waIND).DIRECTION,
2396: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
2397: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
2398: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
2399: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
2400: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
2401: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,

Line 2398: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,

2394: WF_CACHE.Activities(waIND).END_DATE,
2395: WF_CACHE.Activities(waIND).DIRECTION,
2396: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
2397: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
2398: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
2399: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
2400: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
2401: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
2402: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,

Line 2399: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,

2395: WF_CACHE.Activities(waIND).DIRECTION,
2396: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
2397: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
2398: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
2399: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
2400: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
2401: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
2402: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
2403: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,

Line 2400: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,

2396: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE,
2397: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
2398: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
2399: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
2400: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
2401: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
2402: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
2403: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
2404: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,

Line 2401: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,

2397: WF_CACHE.ProcessActivities(actid).PROCESS_NAME,
2398: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
2399: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
2400: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
2401: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
2402: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
2403: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
2404: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
2405: WF_CACHE.ProcessActivities(actid).START_END,

Line 2402: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,

2398: WF_CACHE.ProcessActivities(actid).PROCESS_VERSION,
2399: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
2400: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
2401: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
2402: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
2403: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
2404: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
2405: WF_CACHE.ProcessActivities(actid).START_END,
2406: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT

Line 2403: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,

2399: WF_CACHE.ProcessActivities(actid).ACTIVITY_ITEM_TYPE,
2400: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
2401: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
2402: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
2403: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
2404: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
2405: WF_CACHE.ProcessActivities(actid).START_END,
2406: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT
2407:

Line 2404: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,

2400: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME,
2401: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
2402: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
2403: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
2404: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
2405: WF_CACHE.ProcessActivities(actid).START_END,
2406: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT
2407:
2408: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA

Line 2405: WF_CACHE.ProcessActivities(actid).START_END,

2401: WF_CACHE.ProcessActivities(actid).INSTANCE_ID,
2402: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
2403: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
2404: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
2405: WF_CACHE.ProcessActivities(actid).START_END,
2406: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT
2407:
2408: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA
2409:

Line 2406: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT

2402: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL,
2403: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE,
2404: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
2405: WF_CACHE.ProcessActivities(actid).START_END,
2406: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT
2407:
2408: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA
2409:
2410: where WPA.INSTANCE_ID = actid

Line 2418: waIND := WF_CACHE.HashKey(itemType ||

2414: and actdate < NVL(WA.END_DATE, actdate+1);
2415:
2416: end if;
2417:
2418: waIND := WF_CACHE.HashKey(itemType ||
2419: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
2420:
2421: waaIND := WF_CACHE.HashKey(itemType || aname ||
2422: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);

Line 2419: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);

2415:
2416: end if;
2417:
2418: waIND := WF_CACHE.HashKey(itemType ||
2419: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
2420:
2421: waaIND := WF_CACHE.HashKey(itemType || aname ||
2422: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
2423:

Line 2421: waaIND := WF_CACHE.HashKey(itemType || aname ||

2417:
2418: waIND := WF_CACHE.HashKey(itemType ||
2419: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
2420:
2421: waaIND := WF_CACHE.HashKey(itemType || aname ||
2422: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
2423:
2424: WF_CACHE.Activities(waIND) := WF_CACHE.Activities(0);
2425:

Line 2422: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);

2418: waIND := WF_CACHE.HashKey(itemType ||
2419: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
2420:
2421: waaIND := WF_CACHE.HashKey(itemType || aname ||
2422: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
2423:
2424: WF_CACHE.Activities(waIND) := WF_CACHE.Activities(0);
2425:
2426: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE :=

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

2420:
2421: waaIND := WF_CACHE.HashKey(itemType || aname ||
2422: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
2423:
2424: WF_CACHE.Activities(waIND) := WF_CACHE.Activities(0);
2425:
2426: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE :=
2427: WF_CACHE.Activities(waIND).ITEM_TYPE;
2428: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME :=

Line 2426: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE :=

2422: WF_CACHE.ProcessActivities(actid).ACTIVITY_NAME);
2423:
2424: WF_CACHE.Activities(waIND) := WF_CACHE.Activities(0);
2425:
2426: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE :=
2427: WF_CACHE.Activities(waIND).ITEM_TYPE;
2428: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME :=
2429: WF_CACHE.Activities(waIND).NAME;
2430: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION :=

Line 2427: WF_CACHE.Activities(waIND).ITEM_TYPE;

2423:
2424: WF_CACHE.Activities(waIND) := WF_CACHE.Activities(0);
2425:
2426: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE :=
2427: WF_CACHE.Activities(waIND).ITEM_TYPE;
2428: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME :=
2429: WF_CACHE.Activities(waIND).NAME;
2430: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION :=
2431: WF_CACHE.Activities(waIND).VERSION;

Line 2428: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME :=

2424: WF_CACHE.Activities(waIND) := WF_CACHE.Activities(0);
2425:
2426: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE :=
2427: WF_CACHE.Activities(waIND).ITEM_TYPE;
2428: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME :=
2429: WF_CACHE.Activities(waIND).NAME;
2430: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION :=
2431: WF_CACHE.Activities(waIND).VERSION;
2432: WF_CACHE.ActivityAttributes(waaIND).NAME := aname;

Line 2429: WF_CACHE.Activities(waIND).NAME;

2425:
2426: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE :=
2427: WF_CACHE.Activities(waIND).ITEM_TYPE;
2428: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME :=
2429: WF_CACHE.Activities(waIND).NAME;
2430: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION :=
2431: WF_CACHE.Activities(waIND).VERSION;
2432: WF_CACHE.ActivityAttributes(waaIND).NAME := aname;
2433: WF_CACHE.ActivityAttributes(waaIND).TYPE := 'VARCHAR2';

Line 2430: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION :=

2426: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_ITEM_TYPE :=
2427: WF_CACHE.Activities(waIND).ITEM_TYPE;
2428: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME :=
2429: WF_CACHE.Activities(waIND).NAME;
2430: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION :=
2431: WF_CACHE.Activities(waIND).VERSION;
2432: WF_CACHE.ActivityAttributes(waaIND).NAME := aname;
2433: WF_CACHE.ActivityAttributes(waaIND).TYPE := 'VARCHAR2';
2434: WF_CACHE.ActivityAttributes(waaIND).SUBTYPE := '';

Line 2431: WF_CACHE.Activities(waIND).VERSION;

2427: WF_CACHE.Activities(waIND).ITEM_TYPE;
2428: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME :=
2429: WF_CACHE.Activities(waIND).NAME;
2430: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION :=
2431: WF_CACHE.Activities(waIND).VERSION;
2432: WF_CACHE.ActivityAttributes(waaIND).NAME := aname;
2433: WF_CACHE.ActivityAttributes(waaIND).TYPE := 'VARCHAR2';
2434: WF_CACHE.ActivityAttributes(waaIND).SUBTYPE := '';
2435: WF_CACHE.ActivityAttributes(waaIND).FORMAT := '';

Line 2432: WF_CACHE.ActivityAttributes(waaIND).NAME := aname;

2428: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_NAME :=
2429: WF_CACHE.Activities(waIND).NAME;
2430: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION :=
2431: WF_CACHE.Activities(waIND).VERSION;
2432: WF_CACHE.ActivityAttributes(waaIND).NAME := aname;
2433: WF_CACHE.ActivityAttributes(waaIND).TYPE := 'VARCHAR2';
2434: WF_CACHE.ActivityAttributes(waaIND).SUBTYPE := '';
2435: WF_CACHE.ActivityAttributes(waaIND).FORMAT := '';
2436:

Line 2433: WF_CACHE.ActivityAttributes(waaIND).TYPE := 'VARCHAR2';

2429: WF_CACHE.Activities(waIND).NAME;
2430: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION :=
2431: WF_CACHE.Activities(waIND).VERSION;
2432: WF_CACHE.ActivityAttributes(waaIND).NAME := aname;
2433: WF_CACHE.ActivityAttributes(waaIND).TYPE := 'VARCHAR2';
2434: WF_CACHE.ActivityAttributes(waaIND).SUBTYPE := '';
2435: WF_CACHE.ActivityAttributes(waaIND).FORMAT := '';
2436:
2437: end;

Line 2434: WF_CACHE.ActivityAttributes(waaIND).SUBTYPE := '';

2430: WF_CACHE.ActivityAttributes(waaIND).ACTIVITY_VERSION :=
2431: WF_CACHE.Activities(waIND).VERSION;
2432: WF_CACHE.ActivityAttributes(waaIND).NAME := aname;
2433: WF_CACHE.ActivityAttributes(waaIND).TYPE := 'VARCHAR2';
2434: WF_CACHE.ActivityAttributes(waaIND).SUBTYPE := '';
2435: WF_CACHE.ActivityAttributes(waaIND).FORMAT := '';
2436:
2437: end;
2438:

Line 2435: WF_CACHE.ActivityAttributes(waaIND).FORMAT := '';

2431: WF_CACHE.Activities(waIND).VERSION;
2432: WF_CACHE.ActivityAttributes(waaIND).NAME := aname;
2433: WF_CACHE.ActivityAttributes(waaIND).TYPE := 'VARCHAR2';
2434: WF_CACHE.ActivityAttributes(waaIND).SUBTYPE := '';
2435: WF_CACHE.ActivityAttributes(waaIND).FORMAT := '';
2436:
2437: end;
2438:
2439: -- Format return value as needed for text/number/date type.

Line 2440: if (WF_CACHE.ActivityAttributes(waaIND).TYPE = 'NUMBER') then

2436:
2437: end;
2438:
2439: -- Format return value as needed for text/number/date type.
2440: if (WF_CACHE.ActivityAttributes(waaIND).TYPE = 'NUMBER') then
2441: if (WF_CACHE.ActivityAttributes(waaIND).FORMAT <> '') then
2442: return(to_char(WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE,
2443: WF_CACHE.ActivityAttributes(waaIND).FORMAT));
2444:

Line 2441: if (WF_CACHE.ActivityAttributes(waaIND).FORMAT <> '') then

2437: end;
2438:
2439: -- Format return value as needed for text/number/date type.
2440: if (WF_CACHE.ActivityAttributes(waaIND).TYPE = 'NUMBER') then
2441: if (WF_CACHE.ActivityAttributes(waaIND).FORMAT <> '') then
2442: return(to_char(WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE,
2443: WF_CACHE.ActivityAttributes(waaIND).FORMAT));
2444:
2445: else

Line 2442: return(to_char(WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE,

2438:
2439: -- Format return value as needed for text/number/date type.
2440: if (WF_CACHE.ActivityAttributes(waaIND).TYPE = 'NUMBER') then
2441: if (WF_CACHE.ActivityAttributes(waaIND).FORMAT <> '') then
2442: return(to_char(WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE,
2443: WF_CACHE.ActivityAttributes(waaIND).FORMAT));
2444:
2445: else
2446: return(to_char(WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE));

Line 2443: WF_CACHE.ActivityAttributes(waaIND).FORMAT));

2439: -- Format return value as needed for text/number/date type.
2440: if (WF_CACHE.ActivityAttributes(waaIND).TYPE = 'NUMBER') then
2441: if (WF_CACHE.ActivityAttributes(waaIND).FORMAT <> '') then
2442: return(to_char(WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE,
2443: WF_CACHE.ActivityAttributes(waaIND).FORMAT));
2444:
2445: else
2446: return(to_char(WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE));
2447:

Line 2446: return(to_char(WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE));

2442: return(to_char(WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE,
2443: WF_CACHE.ActivityAttributes(waaIND).FORMAT));
2444:
2445: else
2446: return(to_char(WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE));
2447:
2448: end if;
2449:
2450: elsif (WF_CACHE.ActivityAttributes(waaIND).TYPE = 'DATE') then

Line 2450: elsif (WF_CACHE.ActivityAttributes(waaIND).TYPE = 'DATE') then

2446: return(to_char(WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE));
2447:
2448: end if;
2449:
2450: elsif (WF_CACHE.ActivityAttributes(waaIND).TYPE = 'DATE') then
2451: if (WF_CACHE.ActivityAttributes(waaIND).FORMAT <> '') then
2452: return(to_char(WF_CACHE.ActivityAttrValues(waavIND).DATE_VALUE,
2453: WF_CACHE.ActivityAttributes(waaIND).FORMAT));
2454:

Line 2451: if (WF_CACHE.ActivityAttributes(waaIND).FORMAT <> '') then

2447:
2448: end if;
2449:
2450: elsif (WF_CACHE.ActivityAttributes(waaIND).TYPE = 'DATE') then
2451: if (WF_CACHE.ActivityAttributes(waaIND).FORMAT <> '') then
2452: return(to_char(WF_CACHE.ActivityAttrValues(waavIND).DATE_VALUE,
2453: WF_CACHE.ActivityAttributes(waaIND).FORMAT));
2454:
2455: else

Line 2452: return(to_char(WF_CACHE.ActivityAttrValues(waavIND).DATE_VALUE,

2448: end if;
2449:
2450: elsif (WF_CACHE.ActivityAttributes(waaIND).TYPE = 'DATE') then
2451: if (WF_CACHE.ActivityAttributes(waaIND).FORMAT <> '') then
2452: return(to_char(WF_CACHE.ActivityAttrValues(waavIND).DATE_VALUE,
2453: WF_CACHE.ActivityAttributes(waaIND).FORMAT));
2454:
2455: else
2456: return(to_char(WF_CACHE.ActivityAttrValues(waavIND).DATE_VALUE));

Line 2453: WF_CACHE.ActivityAttributes(waaIND).FORMAT));

2449:
2450: elsif (WF_CACHE.ActivityAttributes(waaIND).TYPE = 'DATE') then
2451: if (WF_CACHE.ActivityAttributes(waaIND).FORMAT <> '') then
2452: return(to_char(WF_CACHE.ActivityAttrValues(waavIND).DATE_VALUE,
2453: WF_CACHE.ActivityAttributes(waaIND).FORMAT));
2454:
2455: else
2456: return(to_char(WF_CACHE.ActivityAttrValues(waavIND).DATE_VALUE));
2457:

Line 2456: return(to_char(WF_CACHE.ActivityAttrValues(waavIND).DATE_VALUE));

2452: return(to_char(WF_CACHE.ActivityAttrValues(waavIND).DATE_VALUE,
2453: WF_CACHE.ActivityAttributes(waaIND).FORMAT));
2454:
2455: else
2456: return(to_char(WF_CACHE.ActivityAttrValues(waavIND).DATE_VALUE));
2457:
2458: end if;
2459:
2460: else

Line 2463: return(WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE);

2459:
2460: else
2461: -- VARCHAR2, LOOKUP, FORM, URL, DOCUMENT.
2462: -- Set the text value directly with no translation.
2463: return(WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE);
2464:
2465: end if;
2466:
2467: exception

Line 2537: WF_CACHE.GetActivityAttrValue(actid, aname, status, waavIND);

2533: Wf_Core.Token('ANAME', nvl(aname, 'NULL'));
2534: Wf_Core.Raise('WFSQL_ARGS');
2535: end if;
2536:
2537: WF_CACHE.GetActivityAttrValue(actid, aname, status, waavIND);
2538:
2539: if (status <> WF_CACHE.task_SUCCESS) then
2540: open curs_activityattr (actid, aname);
2541: fetch curs_activityattr into WF_CACHE.ActivityAttrValues(waavIND);

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

2535: end if;
2536:
2537: WF_CACHE.GetActivityAttrValue(actid, aname, status, waavIND);
2538:
2539: if (status <> WF_CACHE.task_SUCCESS) then
2540: open curs_activityattr (actid, aname);
2541: fetch curs_activityattr into WF_CACHE.ActivityAttrValues(waavIND);
2542: close curs_activityattr;
2543: end if;

Line 2541: fetch curs_activityattr into WF_CACHE.ActivityAttrValues(waavIND);

2537: WF_CACHE.GetActivityAttrValue(actid, aname, status, waavIND);
2538:
2539: if (status <> WF_CACHE.task_SUCCESS) then
2540: open curs_activityattr (actid, aname);
2541: fetch curs_activityattr into WF_CACHE.ActivityAttrValues(waavIND);
2542: close curs_activityattr;
2543: end if;
2544:
2545: -- If it is a reference, replace lvalue with value of itemattr.

Line 2546: if (WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE = 'ITEMATTR') then

2542: close curs_activityattr;
2543: end if;
2544:
2545: -- If it is a reference, replace lvalue with value of itemattr.
2546: if (WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE = 'ITEMATTR') then
2547: return(GetItemAttrNumber(itemtype, itemkey,
2548: substrb(WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE, 1, 30)));
2549:
2550: else

Line 2548: substrb(WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE, 1, 30)));

2544:
2545: -- If it is a reference, replace lvalue with value of itemattr.
2546: if (WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE = 'ITEMATTR') then
2547: return(GetItemAttrNumber(itemtype, itemkey,
2548: substrb(WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE, 1, 30)));
2549:
2550: else
2551: return(WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE);
2552:

Line 2551: return(WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE);

2547: return(GetItemAttrNumber(itemtype, itemkey,
2548: substrb(WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE, 1, 30)));
2549:
2550: else
2551: return(WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE);
2552:
2553: end if;
2554:
2555: exception

Line 2563: WF_CACHE.ActivityAttrValues(waavIND).PROCESS_ACTIVITY_ID := actid;

2559: CLOSE curs_activityattr;
2560: end if;
2561:
2562: if (ignore_notfound) then
2563: WF_CACHE.ActivityAttrValues(waavIND).PROCESS_ACTIVITY_ID := actid;
2564: WF_CACHE.ActivityAttrValues(waavIND).NAME := aname;
2565: WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE := 'CONSTANT';
2566: WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE := '';
2567: WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE := '';

Line 2564: WF_CACHE.ActivityAttrValues(waavIND).NAME := aname;

2560: end if;
2561:
2562: if (ignore_notfound) then
2563: WF_CACHE.ActivityAttrValues(waavIND).PROCESS_ACTIVITY_ID := actid;
2564: WF_CACHE.ActivityAttrValues(waavIND).NAME := aname;
2565: WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE := 'CONSTANT';
2566: WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE := '';
2567: WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE := '';
2568: WF_CACHE.ActivityAttrValues(waavIND).DATE_VALUE := to_date(NULL);

Line 2565: WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE := 'CONSTANT';

2561:
2562: if (ignore_notfound) then
2563: WF_CACHE.ActivityAttrValues(waavIND).PROCESS_ACTIVITY_ID := actid;
2564: WF_CACHE.ActivityAttrValues(waavIND).NAME := aname;
2565: WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE := 'CONSTANT';
2566: WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE := '';
2567: WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE := '';
2568: WF_CACHE.ActivityAttrValues(waavIND).DATE_VALUE := to_date(NULL);
2569:

Line 2566: WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE := '';

2562: if (ignore_notfound) then
2563: WF_CACHE.ActivityAttrValues(waavIND).PROCESS_ACTIVITY_ID := actid;
2564: WF_CACHE.ActivityAttrValues(waavIND).NAME := aname;
2565: WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE := 'CONSTANT';
2566: WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE := '';
2567: WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE := '';
2568: WF_CACHE.ActivityAttrValues(waavIND).DATE_VALUE := to_date(NULL);
2569:
2570: return null;

Line 2567: WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE := '';

2563: WF_CACHE.ActivityAttrValues(waavIND).PROCESS_ACTIVITY_ID := actid;
2564: WF_CACHE.ActivityAttrValues(waavIND).NAME := aname;
2565: WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE := 'CONSTANT';
2566: WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE := '';
2567: WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE := '';
2568: WF_CACHE.ActivityAttrValues(waavIND).DATE_VALUE := to_date(NULL);
2569:
2570: return null;
2571:

Line 2568: WF_CACHE.ActivityAttrValues(waavIND).DATE_VALUE := to_date(NULL);

2564: WF_CACHE.ActivityAttrValues(waavIND).NAME := aname;
2565: WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE := 'CONSTANT';
2566: WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE := '';
2567: WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE := '';
2568: WF_CACHE.ActivityAttrValues(waavIND).DATE_VALUE := to_date(NULL);
2569:
2570: return null;
2571:
2572: else

Line 2631: WF_CACHE.GetActivityAttrValue(actid, aname, status, waavIND);

2627: Wf_Core.Raise('WFSQL_ARGS');
2628: end if;
2629:
2630: -- First check value_type flag for possible item_attribute ref.
2631: WF_CACHE.GetActivityAttrValue(actid, aname, status, waavIND);
2632:
2633: if (status <> WF_CACHE.task_SUCCESS) then
2634: open curs_activityattr (actid, aname);
2635: fetch curs_activityattr into WF_CACHE.ActivityAttrValues(waavIND);

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

2629:
2630: -- First check value_type flag for possible item_attribute ref.
2631: WF_CACHE.GetActivityAttrValue(actid, aname, status, waavIND);
2632:
2633: if (status <> WF_CACHE.task_SUCCESS) then
2634: open curs_activityattr (actid, aname);
2635: fetch curs_activityattr into WF_CACHE.ActivityAttrValues(waavIND);
2636: close curs_activityattr;
2637: end if;

Line 2635: fetch curs_activityattr into WF_CACHE.ActivityAttrValues(waavIND);

2631: WF_CACHE.GetActivityAttrValue(actid, aname, status, waavIND);
2632:
2633: if (status <> WF_CACHE.task_SUCCESS) then
2634: open curs_activityattr (actid, aname);
2635: fetch curs_activityattr into WF_CACHE.ActivityAttrValues(waavIND);
2636: close curs_activityattr;
2637: end if;
2638:
2639: -- If it is a reference, get the item attribute and return it.

Line 2640: if (WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE = 'ITEMATTR') then

2636: close curs_activityattr;
2637: end if;
2638:
2639: -- If it is a reference, get the item attribute and return it.
2640: if (WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE = 'ITEMATTR') then
2641: return(GetItemAttrDate(itemtype, itemkey,
2642: substrb(WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE, 1, 30)));
2643:
2644: else

Line 2642: substrb(WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE, 1, 30)));

2638:
2639: -- If it is a reference, get the item attribute and return it.
2640: if (WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE = 'ITEMATTR') then
2641: return(GetItemAttrDate(itemtype, itemkey,
2642: substrb(WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE, 1, 30)));
2643:
2644: else
2645: return(WF_CACHE.ActivityAttrValues(waavIND).DATE_VALUE);
2646:

Line 2645: return(WF_CACHE.ActivityAttrValues(waavIND).DATE_VALUE);

2641: return(GetItemAttrDate(itemtype, itemkey,
2642: substrb(WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE, 1, 30)));
2643:
2644: else
2645: return(WF_CACHE.ActivityAttrValues(waavIND).DATE_VALUE);
2646:
2647: end if;
2648:
2649: exception

Line 2657: WF_CACHE.ActivityAttrValues(waavIND).PROCESS_ACTIVITY_ID := actid;

2653: CLOSE curs_activityattr;
2654: end if;
2655:
2656: if (ignore_notfound) then
2657: WF_CACHE.ActivityAttrValues(waavIND).PROCESS_ACTIVITY_ID := actid;
2658: WF_CACHE.ActivityAttrValues(waavIND).NAME := aname;
2659: WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE := 'CONSTANT';
2660: WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE := '';
2661: WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE := '';

Line 2658: WF_CACHE.ActivityAttrValues(waavIND).NAME := aname;

2654: end if;
2655:
2656: if (ignore_notfound) then
2657: WF_CACHE.ActivityAttrValues(waavIND).PROCESS_ACTIVITY_ID := actid;
2658: WF_CACHE.ActivityAttrValues(waavIND).NAME := aname;
2659: WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE := 'CONSTANT';
2660: WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE := '';
2661: WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE := '';
2662: WF_CACHE.ActivityAttrValues(waavIND).DATE_VALUE := to_date(NULL);

Line 2659: WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE := 'CONSTANT';

2655:
2656: if (ignore_notfound) then
2657: WF_CACHE.ActivityAttrValues(waavIND).PROCESS_ACTIVITY_ID := actid;
2658: WF_CACHE.ActivityAttrValues(waavIND).NAME := aname;
2659: WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE := 'CONSTANT';
2660: WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE := '';
2661: WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE := '';
2662: WF_CACHE.ActivityAttrValues(waavIND).DATE_VALUE := to_date(NULL);
2663: return(null);

Line 2660: WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE := '';

2656: if (ignore_notfound) then
2657: WF_CACHE.ActivityAttrValues(waavIND).PROCESS_ACTIVITY_ID := actid;
2658: WF_CACHE.ActivityAttrValues(waavIND).NAME := aname;
2659: WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE := 'CONSTANT';
2660: WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE := '';
2661: WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE := '';
2662: WF_CACHE.ActivityAttrValues(waavIND).DATE_VALUE := to_date(NULL);
2663: return(null);
2664:

Line 2661: WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE := '';

2657: WF_CACHE.ActivityAttrValues(waavIND).PROCESS_ACTIVITY_ID := actid;
2658: WF_CACHE.ActivityAttrValues(waavIND).NAME := aname;
2659: WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE := 'CONSTANT';
2660: WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE := '';
2661: WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE := '';
2662: WF_CACHE.ActivityAttrValues(waavIND).DATE_VALUE := to_date(NULL);
2663: return(null);
2664:
2665: else

Line 2662: WF_CACHE.ActivityAttrValues(waavIND).DATE_VALUE := to_date(NULL);

2658: WF_CACHE.ActivityAttrValues(waavIND).NAME := aname;
2659: WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE := 'CONSTANT';
2660: WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE := '';
2661: WF_CACHE.ActivityAttrValues(waavIND).NUMBER_VALUE := '';
2662: WF_CACHE.ActivityAttrValues(waavIND).DATE_VALUE := to_date(NULL);
2663: return(null);
2664:
2665: else
2666:

Line 2734: WF_CACHE.GetActivityAttrValue(actid, aname, status, waavIND);

2730: Wf_Core.Raise('WFSQL_ARGS');
2731: end if;
2732:
2733: -- First check value_type flag for possible item_attribute ref.
2734: WF_CACHE.GetActivityAttrValue(actid, aname, status, waavIND);
2735:
2736: if (status <> WF_CACHE.task_SUCCESS) then
2737: open curs_activityattr (actid, aname);
2738: fetch curs_activityattr into WF_CACHE.ActivityAttrValues(waavIND);

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

2732:
2733: -- First check value_type flag for possible item_attribute ref.
2734: WF_CACHE.GetActivityAttrValue(actid, aname, status, waavIND);
2735:
2736: if (status <> WF_CACHE.task_SUCCESS) then
2737: open curs_activityattr (actid, aname);
2738: fetch curs_activityattr into WF_CACHE.ActivityAttrValues(waavIND);
2739: close curs_activityattr;
2740: end if;

Line 2738: fetch curs_activityattr into WF_CACHE.ActivityAttrValues(waavIND);

2734: WF_CACHE.GetActivityAttrValue(actid, aname, status, waavIND);
2735:
2736: if (status <> WF_CACHE.task_SUCCESS) then
2737: open curs_activityattr (actid, aname);
2738: fetch curs_activityattr into WF_CACHE.ActivityAttrValues(waavIND);
2739: close curs_activityattr;
2740: end if;
2741:
2742: -- If it is a reference, return value of item_attr instead of

Line 2744: if (WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE = 'ITEMATTR') then

2740: end if;
2741:
2742: -- If it is a reference, return value of item_attr instead of
2743: -- contents of WAAV.
2744: if (WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE = 'ITEMATTR') then
2745: if (WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE is null) then
2746: return(null); -- Null itemattr means null value, not an error
2747:
2748: else

Line 2745: if (WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE is null) then

2741:
2742: -- If it is a reference, return value of item_attr instead of
2743: -- contents of WAAV.
2744: if (WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE = 'ITEMATTR') then
2745: if (WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE is null) then
2746: return(null); -- Null itemattr means null value, not an error
2747:
2748: else
2749: return(GetItemAttrClob(itemtype, itemkey,

Line 2750: substrb(WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE, 1, 30)));

2746: return(null); -- Null itemattr means null value, not an error
2747:
2748: else
2749: return(GetItemAttrClob(itemtype, itemkey,
2750: substrb(WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE, 1, 30)));
2751:
2752: end if;
2753: end if;
2754:

Line 2820: WF_CACHE.GetActivityAttrValue(actid, name, status, waavIND);

2816:
2817: -- First check value_type flag for possible item_attribute ref.
2818:
2819: -- First check value_type flag for possible item_attribute ref.
2820: WF_CACHE.GetActivityAttrValue(actid, name, status, waavIND);
2821:
2822: if (status <> WF_CACHE.task_SUCCESS) then
2823: open curs_activityattr (actid, GetActivityAttrEvent.name);
2824: fetch curs_activityattr into WF_CACHE.ActivityAttrValues(waavIND);

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

2818:
2819: -- First check value_type flag for possible item_attribute ref.
2820: WF_CACHE.GetActivityAttrValue(actid, name, status, waavIND);
2821:
2822: if (status <> WF_CACHE.task_SUCCESS) then
2823: open curs_activityattr (actid, GetActivityAttrEvent.name);
2824: fetch curs_activityattr into WF_CACHE.ActivityAttrValues(waavIND);
2825: close curs_activityattr;
2826: end if;

Line 2824: fetch curs_activityattr into WF_CACHE.ActivityAttrValues(waavIND);

2820: WF_CACHE.GetActivityAttrValue(actid, name, status, waavIND);
2821:
2822: if (status <> WF_CACHE.task_SUCCESS) then
2823: open curs_activityattr (actid, GetActivityAttrEvent.name);
2824: fetch curs_activityattr into WF_CACHE.ActivityAttrValues(waavIND);
2825: close curs_activityattr;
2826: end if;
2827:
2828: -- If it is a reference, replace lvalue with value of itemattr.

Line 2829: if (WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE = 'ITEMATTR') then

2825: close curs_activityattr;
2826: end if;
2827:
2828: -- If it is a reference, replace lvalue with value of itemattr.
2829: if (WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE = 'ITEMATTR') then
2830: return(GetItemAttrEvent(itemtype, itemkey,
2831: substrb(WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE, 1, 30)));
2832:
2833: else

Line 2831: substrb(WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE, 1, 30)));

2827:
2828: -- If it is a reference, replace lvalue with value of itemattr.
2829: if (WF_CACHE.ActivityAttrValues(waavIND).VALUE_TYPE = 'ITEMATTR') then
2830: return(GetItemAttrEvent(itemtype, itemkey,
2831: substrb(WF_CACHE.ActivityAttrValues(waavIND).TEXT_VALUE, 1, 30)));
2832:
2833: else
2834: -- Only itemattr-type activity event attrs are supported
2835: return NULL;

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

3061: Wf_Core.Token('ACTID', nvl(actid, 'NULL'));
3062: Wf_Core.Raise('WFSQL_ARGS');
3063: end if;
3064:
3065: WF_CACHE.GetProcessActivity(actid, status);
3066:
3067: if (status <> WF_CACHE.task_SUCCESS) then
3068:
3069: select WPA.PROCESS_ITEM_TYPE, WPA.PROCESS_NAME, WPA.PROCESS_VERSION,

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

3063: end if;
3064:
3065: WF_CACHE.GetProcessActivity(actid, status);
3066:
3067: if (status <> WF_CACHE.task_SUCCESS) then
3068:
3069: select WPA.PROCESS_ITEM_TYPE, WPA.PROCESS_NAME, WPA.PROCESS_VERSION,
3070: WPA.ACTIVITY_ITEM_TYPE, WPA.ACTIVITY_NAME, WPA.INSTANCE_ID,
3071: WPA.INSTANCE_LABEL, WPA.PERFORM_ROLE, WPA.PERFORM_ROLE_TYPE,

Line 3073: into WF_CACHE.ProcessActivities(actid)

3069: select WPA.PROCESS_ITEM_TYPE, WPA.PROCESS_NAME, WPA.PROCESS_VERSION,
3070: WPA.ACTIVITY_ITEM_TYPE, WPA.ACTIVITY_NAME, WPA.INSTANCE_ID,
3071: WPA.INSTANCE_LABEL, WPA.PERFORM_ROLE, WPA.PERFORM_ROLE_TYPE,
3072: WPA.START_END, WPA.DEFAULT_RESULT
3073: into WF_CACHE.ProcessActivities(actid)
3074: from WF_PROCESS_ACTIVITIES WPA
3075: where WPA.INSTANCE_ID = GetActivityLabel.actid;
3076:
3077: end if;

Line 3079: return(WF_CACHE.ProcessActivities(actid).PROCESS_NAME || ':' ||

3075: where WPA.INSTANCE_ID = GetActivityLabel.actid;
3076:
3077: end if;
3078:
3079: return(WF_CACHE.ProcessActivities(actid).PROCESS_NAME || ':' ||
3080: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL);
3081:
3082: exception
3083: when no_data_found then

Line 3080: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL);

3076:
3077: end if;
3078:
3079: return(WF_CACHE.ProcessActivities(actid).PROCESS_NAME || ':' ||
3080: WF_CACHE.ProcessActivities(actid).INSTANCE_LABEL);
3081:
3082: exception
3083: when no_data_found then
3084: Wf_Core.Context('Wf_Engine', 'GetActivityLabel', to_char(actid));

Line 3278: if (WF_CACHE.MetaRefreshed) then

3274: -- Use the text_value passed in as the result code for the activity.
3275: result := text_value;
3276: begin
3277: savepoint wf_savepoint;
3278: if (WF_CACHE.MetaRefreshed) then
3279: NULL;
3280:
3281: end if;
3282:

Line 3874: if (WF_CACHE.MetaRefreshed) then

3870: is
3871: l_aq_tm_processes varchar2(512);
3872: begin
3873: WF_CORE.TAG_DB_SESSION(WF_CORE.CONN_TAG_WF, Background.itemtype);
3874: if (WF_CACHE.MetaRefreshed) then
3875: null;
3876:
3877: end if;
3878:

Line 4062: if (WF_CACHE.MetaRefreshed) then

4058: Wf_Core.Raise('WFSQL_ARGS');
4059: end if;
4060:
4061: --
4062: if (WF_CACHE.MetaRefreshed) then
4063: null;
4064: end if;
4065:
4066: --Bug 9527839. RAC enabled workflows

Line 4219: if (WF_CACHE.MetaRefreshed) then

4215: is
4216: begin
4217: WF_CORE.TAG_DB_SESSION(WF_CORE.CONN_TAG_WF, StartProcess.itemtype);
4218:
4219: if (WF_CACHE.MetaRefreshed) then
4220: null;
4221: end if;
4222: --Bug 2259039
4223: Wf_Engine_Util.Start_Process_Internal(

Line 5601: if (WF_CACHE.MetaRefreshed) then

5597: Wf_Core.Token('ACTIVITY', activity);
5598: Wf_Core.Raise('WFSQL_ARGS');
5599: end if;
5600:
5601: if (WF_CACHE.MetaRefreshed) then
5602: null;
5603:
5604: end if;
5605:

Line 6240: if (WF_CACHE.MetaRefreshed) then

6236: Wf_Core.Token('NAME', activity);
6237: Wf_Core.Raise('WFENG_ACTIVITY_EXIST');
6238: end if;
6239:
6240: if (WF_CACHE.MetaRefreshed) then
6241: null;
6242:
6243: end if;
6244:

Line 6305: if (WF_CACHE.MetaRefreshed) then

6301: Wf_Core.Token('ITEMTYPE', nvl(itemtype, 'NULL'));
6302: Wf_Core.Raise('WFSQL_ARGS');
6303: end if;
6304:
6305: if (WF_CACHE.MetaRefreshed) then
6306: null;
6307:
6308: end if;
6309:

Line 6790: if (WF_CACHE.MetaRefreshed) then

6786: Wf_Core.Token('EVENT_MESSAGE.EVENT_NAME', '');
6787: Wf_Core.Raise('WFSQL_ARGS');
6788: end if;
6789:
6790: if (WF_CACHE.MetaRefreshed) then
6791: null;
6792:
6793: end if;
6794:

Line 7204: WF_CACHE.GetItemAttrValue(p_itemtype, p_itemKey, p_aname, iStatus,

7200: Wf_Core.Raise('WFSQL_ARGS');
7201: end if;
7202:
7203: if (p_itemkey = wf_engine.eng_synch) then
7204: WF_CACHE.GetItemAttrValue(p_itemtype, p_itemKey, p_aname, iStatus,
7205: wiavIND);
7206:
7207: if (iStatus <> WF_CACHE.task_SUCCESS) then
7208: return null;

Line 7207: if (iStatus <> WF_CACHE.task_SUCCESS) then

7203: if (p_itemkey = wf_engine.eng_synch) then
7204: WF_CACHE.GetItemAttrValue(p_itemtype, p_itemKey, p_aname, iStatus,
7205: wiavIND);
7206:
7207: if (iStatus <> WF_CACHE.task_SUCCESS) then
7208: return null;
7209:
7210: else
7211: if (p_addend is NOT null) then

Line 7212: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE :=

7208: return null;
7209:
7210: else
7211: if (p_addend is NOT null) then
7212: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE :=
7213: (WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE + p_addend);
7214: else
7215: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := 0;
7216: end if;

Line 7213: (WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE + p_addend);

7209:
7210: else
7211: if (p_addend is NOT null) then
7212: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE :=
7213: (WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE + p_addend);
7214: else
7215: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := 0;
7216: end if;
7217:

Line 7215: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := 0;

7211: if (p_addend is NOT null) then
7212: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE :=
7213: (WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE + p_addend);
7214: else
7215: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := 0;
7216: end if;
7217:
7218: return WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE;
7219:

Line 7218: return WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE;

7214: else
7215: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := 0;
7216: end if;
7217:
7218: return WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE;
7219:
7220: end if;
7221:
7222: else

Line 7365: if (WF_CACHE.MetaRefreshed) then

7361: Wf_Core.Token('ITEMTYPE', nvl(p_itemtype, 'NULL'));
7362: Wf_Core.Raise('WFSQL_ARGS');
7363: end if;
7364:
7365: if (WF_CACHE.MetaRefreshed) then
7366: null;
7367: end if;
7368:
7369: -- Retry all activities in ERROR for given parameters