544: else
545: -- SYNCHMODE: store attributes in plsql only
546: for curs in attrcurs(itemtype) loop
547: --Getting the index for the item attribute.
548: WF_CACHE.GetItemAttribute(itemtype, curs.name, status, wiaIND);
549:
550: --Getting the index for the item attribute value
551: WF_CACHE.GetItemAttrValue(itemtype, itemkey, curs.name, status, wiavIND);
552:
547: --Getting the index for the item attribute.
548: WF_CACHE.GetItemAttribute(itemtype, curs.name, status, wiaIND);
549:
550: --Getting the index for the item attribute value
551: WF_CACHE.GetItemAttrValue(itemtype, itemkey, curs.name, status, wiavIND);
552:
553: --Loading the item attribute into cache for synch mode.
554: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemType;
555: WF_CACHE.ItemAttributes(wiaIND).NAME := curs.name;
550: --Getting the index for the item attribute value
551: WF_CACHE.GetItemAttrValue(itemtype, itemkey, curs.name, status, wiavIND);
552:
553: --Loading the item attribute into cache for synch mode.
554: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemType;
555: WF_CACHE.ItemAttributes(wiaIND).NAME := curs.name;
556: WF_CACHE.ItemAttributes(wiaIND).TYPE := curs.type;
557: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := curs.subtype;
558: WF_CACHE.ItemAttributes(wiaIND).FORMAT := curs.format;
551: WF_CACHE.GetItemAttrValue(itemtype, itemkey, curs.name, status, wiavIND);
552:
553: --Loading the item attribute into cache for synch mode.
554: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemType;
555: WF_CACHE.ItemAttributes(wiaIND).NAME := curs.name;
556: WF_CACHE.ItemAttributes(wiaIND).TYPE := curs.type;
557: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := curs.subtype;
558: WF_CACHE.ItemAttributes(wiaIND).FORMAT := curs.format;
559: WF_CACHE.ItemAttributes(wiaIND).TEXT_DEFAULT := curs.text_default;
552:
553: --Loading the item attribute into cache for synch mode.
554: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemType;
555: WF_CACHE.ItemAttributes(wiaIND).NAME := curs.name;
556: WF_CACHE.ItemAttributes(wiaIND).TYPE := curs.type;
557: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := curs.subtype;
558: WF_CACHE.ItemAttributes(wiaIND).FORMAT := curs.format;
559: WF_CACHE.ItemAttributes(wiaIND).TEXT_DEFAULT := curs.text_default;
560: WF_CACHE.ItemAttributes(wiaIND).NUMBER_DEFAULT := curs.number_default;
553: --Loading the item attribute into cache for synch mode.
554: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemType;
555: WF_CACHE.ItemAttributes(wiaIND).NAME := curs.name;
556: WF_CACHE.ItemAttributes(wiaIND).TYPE := curs.type;
557: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := curs.subtype;
558: WF_CACHE.ItemAttributes(wiaIND).FORMAT := curs.format;
559: WF_CACHE.ItemAttributes(wiaIND).TEXT_DEFAULT := curs.text_default;
560: WF_CACHE.ItemAttributes(wiaIND).NUMBER_DEFAULT := curs.number_default;
561: WF_CACHE.ItemAttributes(wiaIND).DATE_DEFAULT := curs.date_default;
554: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemType;
555: WF_CACHE.ItemAttributes(wiaIND).NAME := curs.name;
556: WF_CACHE.ItemAttributes(wiaIND).TYPE := curs.type;
557: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := curs.subtype;
558: WF_CACHE.ItemAttributes(wiaIND).FORMAT := curs.format;
559: WF_CACHE.ItemAttributes(wiaIND).TEXT_DEFAULT := curs.text_default;
560: WF_CACHE.ItemAttributes(wiaIND).NUMBER_DEFAULT := curs.number_default;
561: WF_CACHE.ItemAttributes(wiaIND).DATE_DEFAULT := curs.date_default;
562:
555: WF_CACHE.ItemAttributes(wiaIND).NAME := curs.name;
556: WF_CACHE.ItemAttributes(wiaIND).TYPE := curs.type;
557: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := curs.subtype;
558: WF_CACHE.ItemAttributes(wiaIND).FORMAT := curs.format;
559: WF_CACHE.ItemAttributes(wiaIND).TEXT_DEFAULT := curs.text_default;
560: WF_CACHE.ItemAttributes(wiaIND).NUMBER_DEFAULT := curs.number_default;
561: WF_CACHE.ItemAttributes(wiaIND).DATE_DEFAULT := curs.date_default;
562:
563: --Loading the item attribute value into cache for use by synch processes
556: WF_CACHE.ItemAttributes(wiaIND).TYPE := curs.type;
557: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := curs.subtype;
558: WF_CACHE.ItemAttributes(wiaIND).FORMAT := curs.format;
559: WF_CACHE.ItemAttributes(wiaIND).TEXT_DEFAULT := curs.text_default;
560: WF_CACHE.ItemAttributes(wiaIND).NUMBER_DEFAULT := curs.number_default;
561: WF_CACHE.ItemAttributes(wiaIND).DATE_DEFAULT := curs.date_default;
562:
563: --Loading the item attribute value into cache for use by synch processes
564: --only until we introduce the item locking feature.
557: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := curs.subtype;
558: WF_CACHE.ItemAttributes(wiaIND).FORMAT := curs.format;
559: WF_CACHE.ItemAttributes(wiaIND).TEXT_DEFAULT := curs.text_default;
560: WF_CACHE.ItemAttributes(wiaIND).NUMBER_DEFAULT := curs.number_default;
561: WF_CACHE.ItemAttributes(wiaIND).DATE_DEFAULT := curs.date_default;
562:
563: --Loading the item attribute value into cache for use by synch processes
564: --only until we introduce the item locking feature.
565: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemType;
561: WF_CACHE.ItemAttributes(wiaIND).DATE_DEFAULT := curs.date_default;
562:
563: --Loading the item attribute value into cache for use by synch processes
564: --only until we introduce the item locking feature.
565: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemType;
566: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
567: WF_CACHE.ItemAttrValues(wiavIND).NAME := curs.name;
568: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := curs.text_default;
569: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := curs.number_default;
562:
563: --Loading the item attribute value into cache for use by synch processes
564: --only until we introduce the item locking feature.
565: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemType;
566: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
567: WF_CACHE.ItemAttrValues(wiavIND).NAME := curs.name;
568: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := curs.text_default;
569: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := curs.number_default;
570: WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE := curs.date_default;
563: --Loading the item attribute value into cache for use by synch processes
564: --only until we introduce the item locking feature.
565: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemType;
566: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
567: WF_CACHE.ItemAttrValues(wiavIND).NAME := curs.name;
568: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := curs.text_default;
569: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := curs.number_default;
570: WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE := curs.date_default;
571:
564: --only until we introduce the item locking feature.
565: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemType;
566: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
567: WF_CACHE.ItemAttrValues(wiavIND).NAME := curs.name;
568: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := curs.text_default;
569: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := curs.number_default;
570: WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE := curs.date_default;
571:
572: end loop;
565: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemType;
566: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
567: WF_CACHE.ItemAttrValues(wiavIND).NAME := curs.name;
568: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := curs.text_default;
569: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := curs.number_default;
570: WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE := curs.date_default;
571:
572: end loop;
573: end if;
566: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
567: WF_CACHE.ItemAttrValues(wiavIND).NAME := curs.name;
568: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := curs.text_default;
569: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := curs.number_default;
570: WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE := curs.date_default;
571:
572: end loop;
573: end if;
574: