DBA Data[Home] [Help]

APPS.WF_ENGINE_BULK dependencies on WF_ITEM_ATTRIBUTES

Line 267: from WF_ITEM_ATTRIBUTES WIA

263: WIA.NAME,
264: WIA.TEXT_DEFAULT,
265: WIA.NUMBER_DEFAULT,
266: WIA.DATE_DEFAULT
267: from WF_ITEM_ATTRIBUTES WIA
268: where WIA.ITEM_TYPE = itemtype;
269:
270: exception
271: when others then

Line 420: from WF_ITEM_ATTRIBUTES WIA

416: forall arrayIndex in itemkeys.FIRST..itemkeys.LAST save exceptions
417: insert into WF_ITEM_ATTRIBUTE_VALUES
418: (ITEM_TYPE, ITEM_KEY, NAME, TEXT_VALUE)
419: select itemtype, itemkeys(arrayIndex), anames(arrayIndex), text_default
420: from WF_ITEM_ATTRIBUTES WIA
421: where
422: WIA.ITEM_TYPE = itemtype
423: and
424: WIA.NAME = anames(arrayIndex)

Line 565: from WF_ITEM_ATTRIBUTES WIA

561: forall arrayIndex in itemkeys.FIRST..itemkeys.LAST save exceptions
562: insert into WF_ITEM_ATTRIBUTE_VALUES
563: (ITEM_TYPE, ITEM_KEY, NAME, NUMBER_VALUE)
564: select itemtype, itemkeys(arrayIndex), anames(arrayIndex), number_default
565: from WF_ITEM_ATTRIBUTES WIA
566: where
567: WIA.ITEM_TYPE = itemtype
568: and
569: WIA.NAME = anames(arrayIndex)

Line 715: from WF_ITEM_ATTRIBUTES WIA

711: forall arrayIndex in itemkeys.FIRST..itemkeys.LAST save exceptions
712: insert into WF_ITEM_ATTRIBUTE_VALUES
713: (ITEM_TYPE, ITEM_KEY, NAME, DATE_VALUE)
714: select itemtype, itemkeys(arrayIndex), anames(arrayIndex), Date_default
715: from WF_ITEM_ATTRIBUTES WIA
716: where
717: WIA.ITEM_TYPE = itemtype
718: and
719: WIA.NAME = anames(arrayIndex)