567: else
568: -- SYNCHMODE: store attributes in plsql only
569: for curs in attrcurs(itemtype) loop
570: --Getting the index for the item attribute.
571: WF_CACHE.GetItemAttribute(itemtype, curs.name, status, wiaIND);
572:
573: --Getting the index for the item attribute value
574: WF_CACHE.GetItemAttrValue(itemtype, itemkey, curs.name, status, wiavIND);
575:
570: --Getting the index for the item attribute.
571: WF_CACHE.GetItemAttribute(itemtype, curs.name, status, wiaIND);
572:
573: --Getting the index for the item attribute value
574: WF_CACHE.GetItemAttrValue(itemtype, itemkey, curs.name, status, wiavIND);
575:
576: --Loading the item attribute into cache for synch mode.
577: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemType;
578: WF_CACHE.ItemAttributes(wiaIND).NAME := curs.name;
573: --Getting the index for the item attribute value
574: WF_CACHE.GetItemAttrValue(itemtype, itemkey, curs.name, status, wiavIND);
575:
576: --Loading the item attribute into cache for synch mode.
577: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemType;
578: WF_CACHE.ItemAttributes(wiaIND).NAME := curs.name;
579: WF_CACHE.ItemAttributes(wiaIND).TYPE := curs.type;
580: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := curs.subtype;
581: WF_CACHE.ItemAttributes(wiaIND).FORMAT := curs.format;
574: WF_CACHE.GetItemAttrValue(itemtype, itemkey, curs.name, status, wiavIND);
575:
576: --Loading the item attribute into cache for synch mode.
577: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemType;
578: WF_CACHE.ItemAttributes(wiaIND).NAME := curs.name;
579: WF_CACHE.ItemAttributes(wiaIND).TYPE := curs.type;
580: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := curs.subtype;
581: WF_CACHE.ItemAttributes(wiaIND).FORMAT := curs.format;
582: WF_CACHE.ItemAttributes(wiaIND).TEXT_DEFAULT := curs.text_default;
575:
576: --Loading the item attribute into cache for synch mode.
577: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemType;
578: WF_CACHE.ItemAttributes(wiaIND).NAME := curs.name;
579: WF_CACHE.ItemAttributes(wiaIND).TYPE := curs.type;
580: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := curs.subtype;
581: WF_CACHE.ItemAttributes(wiaIND).FORMAT := curs.format;
582: WF_CACHE.ItemAttributes(wiaIND).TEXT_DEFAULT := curs.text_default;
583: WF_CACHE.ItemAttributes(wiaIND).NUMBER_DEFAULT := curs.number_default;
576: --Loading the item attribute into cache for synch mode.
577: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemType;
578: WF_CACHE.ItemAttributes(wiaIND).NAME := curs.name;
579: WF_CACHE.ItemAttributes(wiaIND).TYPE := curs.type;
580: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := curs.subtype;
581: WF_CACHE.ItemAttributes(wiaIND).FORMAT := curs.format;
582: WF_CACHE.ItemAttributes(wiaIND).TEXT_DEFAULT := curs.text_default;
583: WF_CACHE.ItemAttributes(wiaIND).NUMBER_DEFAULT := curs.number_default;
584: WF_CACHE.ItemAttributes(wiaIND).DATE_DEFAULT := curs.date_default;
577: WF_CACHE.ItemAttributes(wiaIND).ITEM_TYPE := itemType;
578: WF_CACHE.ItemAttributes(wiaIND).NAME := curs.name;
579: WF_CACHE.ItemAttributes(wiaIND).TYPE := curs.type;
580: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := curs.subtype;
581: WF_CACHE.ItemAttributes(wiaIND).FORMAT := curs.format;
582: WF_CACHE.ItemAttributes(wiaIND).TEXT_DEFAULT := curs.text_default;
583: WF_CACHE.ItemAttributes(wiaIND).NUMBER_DEFAULT := curs.number_default;
584: WF_CACHE.ItemAttributes(wiaIND).DATE_DEFAULT := curs.date_default;
585:
578: WF_CACHE.ItemAttributes(wiaIND).NAME := curs.name;
579: WF_CACHE.ItemAttributes(wiaIND).TYPE := curs.type;
580: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := curs.subtype;
581: WF_CACHE.ItemAttributes(wiaIND).FORMAT := curs.format;
582: WF_CACHE.ItemAttributes(wiaIND).TEXT_DEFAULT := curs.text_default;
583: WF_CACHE.ItemAttributes(wiaIND).NUMBER_DEFAULT := curs.number_default;
584: WF_CACHE.ItemAttributes(wiaIND).DATE_DEFAULT := curs.date_default;
585:
586: --Loading the item attribute value into cache for use by synch processes
579: WF_CACHE.ItemAttributes(wiaIND).TYPE := curs.type;
580: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := curs.subtype;
581: WF_CACHE.ItemAttributes(wiaIND).FORMAT := curs.format;
582: WF_CACHE.ItemAttributes(wiaIND).TEXT_DEFAULT := curs.text_default;
583: WF_CACHE.ItemAttributes(wiaIND).NUMBER_DEFAULT := curs.number_default;
584: WF_CACHE.ItemAttributes(wiaIND).DATE_DEFAULT := curs.date_default;
585:
586: --Loading the item attribute value into cache for use by synch processes
587: --only until we introduce the item locking feature.
580: WF_CACHE.ItemAttributes(wiaIND).SUBTYPE := curs.subtype;
581: WF_CACHE.ItemAttributes(wiaIND).FORMAT := curs.format;
582: WF_CACHE.ItemAttributes(wiaIND).TEXT_DEFAULT := curs.text_default;
583: WF_CACHE.ItemAttributes(wiaIND).NUMBER_DEFAULT := curs.number_default;
584: WF_CACHE.ItemAttributes(wiaIND).DATE_DEFAULT := curs.date_default;
585:
586: --Loading the item attribute value into cache for use by synch processes
587: --only until we introduce the item locking feature.
588: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemType;
584: WF_CACHE.ItemAttributes(wiaIND).DATE_DEFAULT := curs.date_default;
585:
586: --Loading the item attribute value into cache for use by synch processes
587: --only until we introduce the item locking feature.
588: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemType;
589: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
590: WF_CACHE.ItemAttrValues(wiavIND).NAME := curs.name;
591: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := curs.text_default;
592: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := curs.number_default;
585:
586: --Loading the item attribute value into cache for use by synch processes
587: --only until we introduce the item locking feature.
588: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemType;
589: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
590: WF_CACHE.ItemAttrValues(wiavIND).NAME := curs.name;
591: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := curs.text_default;
592: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := curs.number_default;
593: WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE := curs.date_default;
586: --Loading the item attribute value into cache for use by synch processes
587: --only until we introduce the item locking feature.
588: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemType;
589: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
590: WF_CACHE.ItemAttrValues(wiavIND).NAME := curs.name;
591: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := curs.text_default;
592: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := curs.number_default;
593: WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE := curs.date_default;
594:
587: --only until we introduce the item locking feature.
588: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemType;
589: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
590: WF_CACHE.ItemAttrValues(wiavIND).NAME := curs.name;
591: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := curs.text_default;
592: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := curs.number_default;
593: WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE := curs.date_default;
594:
595: end loop;
588: WF_CACHE.ItemAttrValues(wiavIND).ITEM_TYPE := itemType;
589: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
590: WF_CACHE.ItemAttrValues(wiavIND).NAME := curs.name;
591: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := curs.text_default;
592: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := curs.number_default;
593: WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE := curs.date_default;
594:
595: end loop;
596: end if;
589: WF_CACHE.ItemAttrValues(wiavIND).ITEM_KEY := itemKey;
590: WF_CACHE.ItemAttrValues(wiavIND).NAME := curs.name;
591: WF_CACHE.ItemAttrValues(wiavIND).TEXT_VALUE := curs.text_default;
592: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := curs.number_default;
593: WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE := curs.date_default;
594:
595: end loop;
596: end if;
597: