APPS.WF_ITEM dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 245: update WF_ITEM_ATTRIBUTE_VALUES

241:
242: else
243: -- Parent context is null
244: -- increase all known #CNT counter by 1
245: update WF_ITEM_ATTRIBUTE_VALUES
246: set NUMBER_VALUE = NUMBER_VALUE + 1
247: where NAME like '#CNT_%'
248: and NUMBER_VALUE is not null
249: and ITEM_TYPE = parent_itemType

Line 550: insert into WF_ITEM_ATTRIBUTE_VALUES (

546: if (itemkey <> wf_engine.eng_synch) then
547: -- NORMAL: store attributes in table
548: if(not wf_item.c_ondemand) then
549: -- only popluate when the flag is false
550: insert into WF_ITEM_ATTRIBUTE_VALUES (
551: ITEM_TYPE,
552: ITEM_KEY,
553: NAME,
554: TEXT_VALUE,

Line 770: FROM WF_ITEM_ATTRIBUTE_VALUES

766: end if;
767: else
768: SELECT TEXT_VALUE
769: bulk collect into attrNames
770: FROM WF_ITEM_ATTRIBUTE_VALUES
771: WHERE ITEM_TYPE = p_itemType
772: AND ITEM_KEY = p_itemKey
773: AND NAME like ('#LBL_%')
774: AND TEXT_VALUE is NOT null;

Line 794: FROM WF_ITEM_ATTRIBUTE_VALUES wiav

790: --in the parent which the child may not have created the corresponding
791: --#LBL_ (did not arrive) such as in the case of an AbortProcess()
792: SELECT wiav.NAME
793: bulk collect into attrNames
794: FROM WF_ITEM_ATTRIBUTE_VALUES wiav
795: WHERE wiav.ITEM_TYPE = l_parent_itemType
796: AND wiav.ITEM_KEY = l_parent_itemKey
797: and wiav.NAME like ('#CNT_%')
798: AND NOT EXISTS (select null

Line 799: from wf_item_attribute_values wiav2

795: WHERE wiav.ITEM_TYPE = l_parent_itemType
796: AND wiav.ITEM_KEY = l_parent_itemKey
797: and wiav.NAME like ('#CNT_%')
798: AND NOT EXISTS (select null
799: from wf_item_attribute_values wiav2
800: where wiav2.item_type = p_itemType
801: and wiav2.item_key = p_itemKey
802: and wiav2.name = REPLACE(wiav.name,'#CNT_','#LBL_'));
803: if (attrNames.COUNT > 0) then

Line 821: from wf_item_attribute_values wiav

817: from wf_items wi
818: where wi.parent_item_type = p_itemtype
819: and wi.parent_item_key = p_itemkey
820: and wi.parent_item_type = (select wiav.text_value
821: from wf_item_attribute_values wiav
822: where wiav.item_type = wi.item_type
823: and wiav.item_key = wi.item_key
824: and wiav.name = 'ERROR_ITEM_TYPE')
825: and wi.parent_item_key = (select wiav.text_value

Line 826: from wf_item_attribute_values wiav

822: where wiav.item_type = wi.item_type
823: and wiav.item_key = wi.item_key
824: and wiav.name = 'ERROR_ITEM_TYPE')
825: and wi.parent_item_key = (select wiav.text_value
826: from wf_item_attribute_values wiav
827: where wiav.item_type = wi.item_type
828: and wiav.item_key = wi.item_key
829: and wiav.name = 'ERROR_ITEM_KEY')
830: and exists (select null

Line 831: from wf_item_attribute_values wiav

827: where wiav.item_type = wi.item_type
828: and wiav.item_key = wi.item_key
829: and wiav.name = 'ERROR_ITEM_KEY')
830: and exists (select null
831: from wf_item_attribute_values wiav
832: where wiav.item_type = wi.item_type
833: and wiav.item_key = wi.item_key
834: and wiav.name = 'ERROR_ACTIVITY_LABEL')
835: and end_date is null)