eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_ENGINE_BULK dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 253: insert into WF_ITEM_ATTRIBUTE_VALUES (

249: --if its on demand, we are not going to do this
250: forall arrInd in itemkeys.FIRST..itemkeys.LAST save exceptions
251:
252: -- NORMAL: store attributes in table
253: insert into WF_ITEM_ATTRIBUTE_VALUES (
254: ITEM_TYPE,
255: ITEM_KEY,
256: NAME,
257: TEXT_VALUE,

Line 330: insert into WF_ITEM_ATTRIBUTE_VALUES (

326: --bulk insert the new attribute for all the itemkeys in the list
327: begin
328:
329: forall arrInd in l_itemkeys.FIRST..l_itemkeys.LAST SAVE EXCEPTIONS
330: insert into WF_ITEM_ATTRIBUTE_VALUES (
331: ITEM_TYPE,
332: ITEM_KEY,
333: NAME,
334: TEXT_VALUE

Line 417: insert into WF_ITEM_ATTRIBUTE_VALUES

413: --If itemtype is on demand, we will insert default values if not exists already
414: if wf_item.Attribute_On_Demand(itemtype, itemkeys(itemkeys.FIRST)) then
415: begin
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

Line 425: and not exists (select 1 from WF_ITEM_ATTRIBUTE_VALUES WIAV

421: where
422: WIA.ITEM_TYPE = itemtype
423: and
424: WIA.NAME = anames(arrayIndex)
425: and not exists (select 1 from WF_ITEM_ATTRIBUTE_VALUES WIAV
426: where WIAV.item_type=itemtype
427: and WIAV.item_key=itemkeys(arrayIndex)
428: and WIAV.NAME=anames(arrayIndex));
429: exception

Line 441: update WF_ITEM_ATTRIBUTE_VALUES set

437: g_FailedAttributes.DELETE;
438: -- Set the text value.
439: begin
440: forall arrInd in itemkeys.FIRST..itemkeys.LAST save exceptions
441: update WF_ITEM_ATTRIBUTE_VALUES set
442: TEXT_VALUE = avalues(arrInd)
443: where ITEM_TYPE = itemtype
444: and ITEM_KEY = itemkeys(arrInd)
445: and NAME = anames(arrInd)

Line 562: insert into WF_ITEM_ATTRIBUTE_VALUES

558: --If itemtype is on demand, we will insert default values if not exists already
559: if wf_item.Attribute_On_Demand(itemtype, itemkeys(itemkeys.FIRST)) then
560: begin
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

Line 570: and not exists (select 1 from WF_ITEM_ATTRIBUTE_VALUES WIAV

566: where
567: WIA.ITEM_TYPE = itemtype
568: and
569: WIA.NAME = anames(arrayIndex)
570: and not exists (select 1 from WF_ITEM_ATTRIBUTE_VALUES WIAV
571: where WIAV.item_type=itemtype
572: and WIAV.item_key=itemkeys(arrayIndex)
573: and WIAV.NAME=anames(arrayIndex));
574: exception

Line 587: update WF_ITEM_ATTRIBUTE_VALUES set

583:
584: -- Set the number value.
585: begin
586: forall arrInd in itemkeys.FIRST..itemkeys.LAST save exceptions
587: update WF_ITEM_ATTRIBUTE_VALUES set
588: NUMBER_VALUE = avalues(arrInd)
589: where ITEM_TYPE = itemtype
590: and ITEM_KEY = itemkeys(arrInd)
591: and NAME = anames(arrInd)

Line 712: insert into WF_ITEM_ATTRIBUTE_VALUES

708: --If itemtype is on demand, we will insert default values if not exists already
709: if wf_item.Attribute_On_Demand(itemtype, itemkeys(itemkeys.FIRST)) then
710: begin
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

Line 720: and not exists (select 1 from WF_ITEM_ATTRIBUTE_VALUES WIAV

716: where
717: WIA.ITEM_TYPE = itemtype
718: and
719: WIA.NAME = anames(arrayIndex)
720: and not exists (select 1 from WF_ITEM_ATTRIBUTE_VALUES WIAV
721: where WIAV.item_type=itemtype
722: and WIAV.item_key=itemkeys(arrayIndex)
723: and WIAV.NAME=anames(arrayIndex));
724: exception

Line 732: update WF_ITEM_ATTRIBUTE_VALUES set

728: end if;
729: -- Set the date value.
730: begin
731: forall arrInd in itemkeys.FIRST..itemkeys.LAST save exceptions
732: update WF_ITEM_ATTRIBUTE_VALUES set
733: DATE_VALUE = avalues(arrInd)
734: where ITEM_TYPE = itemtype
735: and ITEM_KEY = itemkeys(arrInd)
736: and NAME = anames(arrInd)

Line 979: insert into WF_ITEM_ATTRIBUTE_VALUES (

975: -- Create a schema attribute across the itemkeys
976: if l_itemkeys.count>0 then
977: begin
978: forall arrInd in l_itemkeys.FIRST..l_itemkeys.LAST SAVE EXCEPTIONS
979: insert into WF_ITEM_ATTRIBUTE_VALUES (
980: ITEM_TYPE,
981: ITEM_KEY,
982: NAME,
983: TEXT_VALUE

Line 1028: insert into WF_ITEM_ATTRIBUTE_VALUES (

1024: number_value=>l_itemkeys.count);
1025: end if; --Label Counter exists
1026: begin
1027: forall arrInd in l_itemkeys.FIRST..l_itemkeys.LAST SAVE EXCEPTIONS
1028: insert into WF_ITEM_ATTRIBUTE_VALUES (
1029: ITEM_TYPE,
1030: ITEM_KEY,
1031: NAME,
1032: TEXT_VALUE

Line 1058: update WF_ITEM_ATTRIBUTE_VALUES

1054: else
1055: -- Parent context is null
1056: -- increase all known #CNT counter by the number of itemkeys
1057: l_count:= l_itemkeys.count;
1058: update WF_ITEM_ATTRIBUTE_VALUES
1059: set NUMBER_VALUE = NUMBER_VALUE + l_count
1060: where NAME like '#CNT_%'
1061: and NUMBER_VALUE is not null
1062: and ITEM_TYPE = parent_itemType