APPS.WF_ITEM dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 221: update WF_ITEM_ATTRIBUTE_VALUES

217:
218: else
219: -- Parent context is null
220: -- increase all known #CNT counter by 1
221: update WF_ITEM_ATTRIBUTE_VALUES
222: set NUMBER_VALUE = NUMBER_VALUE + 1
223: where NAME like '#CNT_%'
224: and NUMBER_VALUE is not null
225: and ITEM_TYPE = parent_itemType

Line 527: insert into WF_ITEM_ATTRIBUTE_VALUES (

523: if (itemkey <> wf_engine.eng_synch) then
524: -- NORMAL: store attributes in table
525: if(not wf_item.c_ondemand) then
526: -- only popluate when the flag is false
527: insert into WF_ITEM_ATTRIBUTE_VALUES (
528: ITEM_TYPE,
529: ITEM_KEY,
530: NAME,
531: TEXT_VALUE,

Line 729: FROM WF_ITEM_ATTRIBUTE_VALUES

725: end if;
726: else
727: SELECT TEXT_VALUE
728: bulk collect into attrNames
729: FROM WF_ITEM_ATTRIBUTE_VALUES
730: WHERE ITEM_TYPE = p_itemType
731: AND ITEM_KEY = p_itemKey
732: AND NAME like ('#LBL_%')
733: AND TEXT_VALUE is NOT null;

Line 751: FROM WF_ITEM_ATTRIBUTE_VALUES wiav

747: --in the parent which the child may not have created the corresponding
748: --#LBL_ (did not arrive) such as in the case of an AbortProcess()
749: SELECT wiav.NAME
750: bulk collect into attrNames
751: FROM WF_ITEM_ATTRIBUTE_VALUES wiav
752: WHERE wiav.ITEM_TYPE = l_parent_itemType
753: AND wiav.ITEM_KEY = l_parent_itemKey
754: and wiav.NAME like ('#CNT_%')
755: AND NOT EXISTS (select null

Line 756: from wf_item_attribute_values wiav2

752: WHERE wiav.ITEM_TYPE = l_parent_itemType
753: AND wiav.ITEM_KEY = l_parent_itemKey
754: and wiav.NAME like ('#CNT_%')
755: AND NOT EXISTS (select null
756: from wf_item_attribute_values wiav2
757: where wiav2.item_type = p_itemType
758: and wiav2.item_key = p_itemKey
759: and wiav2.name = REPLACE(wiav.name,'#CNT_','#LBL_'));
760: if (attrNames.COUNT > 0) then