DBA Data[Home] [Help]

APPS.WFJ_QUEUE dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 197: from WF_ITEM_ATTRIBUTE_VALUES

193:
194: -- Get the source event
195: select EVENT_VALUE
196: into srcValue
197: from WF_ITEM_ATTRIBUTE_VALUES
198: where ITEM_TYPE = ApplyTransformation.itemtype
199: and ITEM_KEY = ApplyTransformation.itemkey
200: and NAME = ApplyTransformation.srcName;
201:

Line 205: from WF_ITEM_ATTRIBUTE_VALUES

201:
202: -- Get the destination event
203: select ROWID
204: into lRowid
205: from WF_ITEM_ATTRIBUTE_VALUES
206: where ITEM_TYPE = ApplyTransformation.itemtype
207: and ITEM_KEY = ApplyTransformation.itemkey
208: and NAME = ApplyTransformation.dstName;
209:

Line 225: update WF_ITEM_ATTRIBUTE_VALUES

221: dstValue.ERROR_MESSAGE := srcValue.ERROR_MESSAGE;
222: dstValue.ERROR_STACK := srcValue.ERROR_STACK;
223:
224: -- Assign the source to the destination
225: update WF_ITEM_ATTRIBUTE_VALUES
226: set EVENT_VALUE = dstValue
227: where ITEM_TYPE = ApplyTransformation.itemType
228: and ITEM_KEY = ApplyTransformation.itemkey
229: and NAME = ApplyTransformation.dstName;