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 dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 111: insert into WF_ITEM_ATTRIBUTE_VALUES (

107: WF_CACHE.ItemAttrValues(wiavIND).NUMBER_VALUE := number_value;
108: WF_CACHE.ItemAttrValues(wiavIND).DATE_VALUE := date_value;
109:
110: else
111: insert into WF_ITEM_ATTRIBUTE_VALUES (
112: ITEM_TYPE,
113: ITEM_KEY,
114: NAME,
115: TEXT_VALUE,

Line 218: insert into WF_ITEM_ATTRIBUTE_VALUES (

214:
215: end loop;
216: else
217: forall arrayIndex in aname.FIRST..aname.LAST
218: insert into WF_ITEM_ATTRIBUTE_VALUES (
219: ITEM_TYPE,
220: ITEM_KEY,
221: NAME,
222: TEXT_VALUE

Line 319: insert into WF_ITEM_ATTRIBUTE_VALUES (

315: end if;
316: end loop;
317: else
318: forall arrayIndex in aname.FIRST..aname.LAST
319: insert into WF_ITEM_ATTRIBUTE_VALUES (
320: ITEM_TYPE,
321: ITEM_KEY,
322: NAME,
323: NUMBER_VALUE

Line 418: insert into WF_ITEM_ATTRIBUTE_VALUES (

414: end if;
415: end loop;
416: else
417: forall arrayIndex in aname.FIRST..aname.LAST
418: insert into WF_ITEM_ATTRIBUTE_VALUES (
419: ITEM_TYPE,
420: ITEM_KEY,
421: NAME,
422: DATE_VALUE

Line 591: update WF_ITEM_ATTRIBUTE_VALUES set

587:
588: end if;
589:
590: else
591: update WF_ITEM_ATTRIBUTE_VALUES set
592: TEXT_VALUE = tvalue
593: where ITEM_TYPE = itemtype
594: and ITEM_KEY = itemkey
595: and NAME = aname;

Line 602: insert into WF_ITEM_ATTRIBUTE_VALUES (ITEM_TYPE, ITEM_KEY, NAME, TEXT_VALUE)

598: -- ondemand logic.
599: if wf_item.Attribute_ON_Demand(itemtype, itemkey) then
600: --we need to check if the item attribute is defined or not
601: --if attribute value is not defined at design time, we raise an exception
602: insert into WF_ITEM_ATTRIBUTE_VALUES (ITEM_TYPE, ITEM_KEY, NAME, TEXT_VALUE)
603: select
604: SetItemAttrText.itemtype,
605: SetItemAttrText.itemkey,
606: SetItemAttrText.aname,

Line 699: update WF_ITEM_ATTRIBUTE_VALUES set

695: return TRUE;
696: end if;
697:
698: else
699: update WF_ITEM_ATTRIBUTE_VALUES set
700: TEXT_VALUE = p_avalue
701: where ITEM_TYPE = p_itemtype
702: and ITEM_KEY = p_itemkey
703: and NAME = p_aname;

Line 712: insert into WF_ITEM_ATTRIBUTE_VALUES (ITEM_TYPE, ITEM_KEY, NAME, TEXT_VALUE)

708: --
709: --we need to check if the item attribute is defined or not
710: --if attribute value is not defined at design time, we raise an exception
711: --
712: insert into WF_ITEM_ATTRIBUTE_VALUES (ITEM_TYPE, ITEM_KEY, NAME, TEXT_VALUE)
713: select
714: SetItemAttrText2.p_itemtype,
715: SetItemAttrText2.p_itemkey,
716: SetItemAttrText2.p_aname,

Line 876: update WF_ITEM_ATTRIBUTE_VALUES set

872:
873: end if;
874:
875: else
876: update WF_ITEM_ATTRIBUTE_VALUES set
877: NUMBER_VALUE = avalue
878: where ITEM_TYPE = itemtype
879: and ITEM_KEY = itemkey
880: and NAME = aname;

Line 887: insert into WF_ITEM_ATTRIBUTE_VALUES (ITEM_TYPE, ITEM_KEY, NAME, NUMBER_VALUE)

883: --ondemand logic.
884: if wf_item.Attribute_ON_Demand(itemtype, itemkey) then
885: --we need to check if the item attribute is defined or not
886: --if attribute value is not defined, we raise an exception
887: insert into WF_ITEM_ATTRIBUTE_VALUES (ITEM_TYPE, ITEM_KEY, NAME, NUMBER_VALUE)
888: select
889: SetItemAttrNumber.itemtype,
890: SetItemAttrNumber.itemkey,
891: SetItemAttrNumber.aname,

Line 963: update WF_ITEM_ATTRIBUTE_VALUES set

959:
960: end if;
961:
962: else
963: update WF_ITEM_ATTRIBUTE_VALUES set
964: DATE_VALUE = avalue
965: where ITEM_TYPE = itemtype
966: and ITEM_KEY = itemkey
967: and NAME = aname;

Line 974: insert into WF_ITEM_ATTRIBUTE_VALUES (ITEM_TYPE, ITEM_KEY, NAME, DATE_VALUE)

970: --ondemand logic.
971: if wf_item.Attribute_ON_Demand(itemtype, itemkey) then
972: --we need to check if the item attribute is defined or not
973: --if attribute value is not defined at design time, we raise an exception
974: insert into WF_ITEM_ATTRIBUTE_VALUES (ITEM_TYPE, ITEM_KEY, NAME, DATE_VALUE)
975: select
976: SetItemAttrDate.itemtype,
977: SetItemAttrDate.itemkey,
978: SetItemAttrDate.aname,

Line 1083: update WF_ITEM_ATTRIBUTE_VALUES set

1079: wf_core.token('OPERATION', 'Wf_Engine.SetItemAttrEvent');
1080: wf_core.raise('WFENG_SYNCH_DISABLED');
1081: end if;
1082:
1083: update WF_ITEM_ATTRIBUTE_VALUES set
1084: EVENT_VALUE = SetItemAttrEvent.event
1085: where ITEM_TYPE = SetItemAttrEvent.itemtype
1086: and ITEM_KEY = SetItemAttrEvent.itemkey
1087: and NAME = SetItemAttrEvent.name;

Line 1095: insert into WF_ITEM_ATTRIBUTE_VALUES (ITEM_TYPE, ITEM_KEY, NAME, EVENT_VALUE)

1091: if wf_item.Attribute_ON_Demand(SetItemAttrEvent.itemtype, SetItemAttrEvent.itemkey) then
1092: --we need to check if the item attribute is defined or not
1093: --if attribute value is not defined at design time, we raise an exception
1094:
1095: insert into WF_ITEM_ATTRIBUTE_VALUES (ITEM_TYPE, ITEM_KEY, NAME, EVENT_VALUE)
1096: select
1097: SetItemAttrEvent.itemtype,
1098: SetItemAttrEvent.itemkey,
1099: SetItemAttrEvent.name,

Line 1189: update WF_ITEM_ATTRIBUTE_VALUES set

1185: end loop;
1186:
1187: else
1188: forall arrayIndex in aname.FIRST..aname.LAST
1189: update WF_ITEM_ATTRIBUTE_VALUES set
1190: TEXT_VALUE = avalue(arrayIndex)
1191: where ITEM_TYPE = itemtype
1192: and ITEM_KEY = itemkey
1193: and NAME = aname(arrayIndex);

Line 1200: insert into WF_ITEM_ATTRIBUTE_VALUES

1196: if (success_cnt <> aname.COUNT) then
1197: --ondemand logic
1198: if wf_item.Attribute_ON_Demand(itemtype, itemkey) then
1199: forall arrayIndex in aname.FIRST..aname.LAST
1200: insert into WF_ITEM_ATTRIBUTE_VALUES
1201: (ITEM_TYPE, ITEM_KEY, NAME, TEXT_VALUE)
1202: select itemtype, itemkey, aname(arrayIndex), avalue(arrayIndex)
1203: from WF_ITEM_ATTRIBUTES WIA
1204: where

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

1204: where
1205: WIA.ITEM_TYPE = itemtype
1206: and
1207: WIA.NAME = aname(arrayIndex)
1208: and not exists (select 1 from WF_ITEM_ATTRIBUTE_VALUES WIAV
1209: where WIAV.item_type=itemtype
1210: and WIAV.item_key=itemkey
1211: and WIAV.NAME=aname(arrayIndex));
1212:

Line 1302: update WF_ITEM_ATTRIBUTE_VALUES set

1298: end loop;
1299:
1300: else
1301: forall arrayIndex in aname.FIRST..aname.LAST
1302: update WF_ITEM_ATTRIBUTE_VALUES set
1303: NUMBER_VALUE = avalue(arrayIndex)
1304: where ITEM_TYPE = itemtype
1305: and ITEM_KEY = itemkey
1306: and NAME = aname(arrayIndex);

Line 1313: insert into WF_ITEM_ATTRIBUTE_VALUES

1309: if (success_cnt <> aname.COUNT) then
1310: --ondemand logic
1311: if wf_item.Attribute_ON_Demand(itemtype, itemkey) then
1312: forall arrayIndex in aname.FIRST..aname.LAST
1313: insert into WF_ITEM_ATTRIBUTE_VALUES
1314: (ITEM_TYPE, ITEM_KEY, NAME, NUMBER_VALUE)
1315: select itemtype, itemkey, aname(arrayIndex), avalue(arrayIndex)
1316: from WF_ITEM_ATTRIBUTES WIA
1317: where

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

1317: where
1318: WIA.ITEM_TYPE = itemtype
1319: and
1320: WIA.NAME = aname(arrayIndex)
1321: and not exists (select 1 from WF_ITEM_ATTRIBUTE_VALUES WIAV
1322: where WIAV.item_type=itemtype
1323: and WIAV.item_key=itemkey
1324: and WIAV.NAME=aname(arrayIndex));
1325:

Line 1413: update WF_ITEM_ATTRIBUTE_VALUES set

1409: end loop;
1410:
1411: else
1412: forall arrayIndex in aname.FIRST..aname.LAST
1413: update WF_ITEM_ATTRIBUTE_VALUES set
1414: DATE_VALUE = avalue(arrayIndex)
1415: where ITEM_TYPE = itemtype
1416: and ITEM_KEY = itemkey
1417: and NAME = aname(arrayIndex);

Line 1424: insert into WF_ITEM_ATTRIBUTE_VALUES

1420: if (success_cnt <> aname.COUNT) then
1421: --ondemand logic
1422: if wf_item.Attribute_ON_Demand(itemtype, itemkey) then
1423: forall arrayIndex in aname.FIRST..aname.LAST
1424: insert into WF_ITEM_ATTRIBUTE_VALUES
1425: (ITEM_TYPE, ITEM_KEY, NAME, DATE_VALUE)
1426: select itemtype, itemkey, aname(arrayIndex), avalue(arrayIndex)
1427: from WF_ITEM_ATTRIBUTES WIA
1428: where

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

1428: where
1429: WIA.ITEM_TYPE = itemtype
1430: and
1431: WIA.NAME = aname(arrayIndex)
1432: and not exists (select 1 from WF_ITEM_ATTRIBUTE_VALUES WIAV
1433: where WIAV.item_type=itemtype
1434: and WIAV.item_key=itemkey
1435: and WIAV.NAME=aname(arrayIndex));
1436:

Line 1621: from WF_ITEM_ATTRIBUTE_VALUES

1617: --data else will propagate the exception
1618: begin
1619: select TEXT_VALUE
1620: into lvalue
1621: from WF_ITEM_ATTRIBUTE_VALUES
1622: where ITEM_TYPE = itemtype
1623: and ITEM_KEY = itemkey
1624: and NAME = aname;
1625: exception

Line 1715: from WF_ITEM_ATTRIBUTE_VALUES

1711: else
1712: begin
1713: select NUMBER_VALUE
1714: into lvalue
1715: from WF_ITEM_ATTRIBUTE_VALUES
1716: where ITEM_TYPE = itemtype
1717: and ITEM_KEY = itemkey
1718: and NAME = aname;
1719: exception

Line 1806: from WF_ITEM_ATTRIBUTE_VALUES

1802: else
1803: begin
1804: select DATE_VALUE
1805: into lvalue
1806: from WF_ITEM_ATTRIBUTE_VALUES
1807: where ITEM_TYPE = itemtype
1808: and ITEM_KEY = itemkey
1809: and NAME = aname;
1810: exception

Line 2017: from WF_ITEM_ATTRIBUTE_VALUES

2013:
2014: begin
2015: select EVENT_VALUE
2016: into lvalue
2017: from WF_ITEM_ATTRIBUTE_VALUES
2018: where ITEM_TYPE = GetItemAttrEvent.itemtype
2019: and ITEM_KEY = GetItemAttrEvent.itemkey
2020: and NAME = GetItemAttrEvent.name;
2021:

Line 5021: delete from wf_item_attribute_values

5017:
5018: wf_engine.CreateProcess(copy_itemtype,new_itemkey,root_process);
5019:
5020: --delete any defaulted attributes because we will copy the existing ones.
5021: delete from wf_item_attribute_values
5022: where item_type = copy_itemtype
5023: and item_key = new_itemkey;
5024:
5025:

Line 5030: insert into wf_item_attribute_values

5026: end if;
5027:
5028: -- copy all item attributes including runtime attributes. Also, copy
5029: -- those item attributes that were added after the item was forked
5030: insert into wf_item_attribute_values
5031: (ITEM_TYPE, ITEM_KEY, NAME,
5032: TEXT_VALUE, NUMBER_VALUE, DATE_VALUE)
5033: select ITEM_TYPE, NEW_ITEMKEY, NAME,
5034: TEXT_VALUE, NUMBER_VALUE, DATE_VALUE

Line 5035: from wf_item_attribute_values

5031: (ITEM_TYPE, ITEM_KEY, NAME,
5032: TEXT_VALUE, NUMBER_VALUE, DATE_VALUE)
5033: select ITEM_TYPE, NEW_ITEMKEY, NAME,
5034: TEXT_VALUE, NUMBER_VALUE, DATE_VALUE
5035: from wf_item_attribute_values
5036: where item_type = copy_itemtype
5037: and item_key = copy_itemkey
5038: and name not like '#LBL_'
5039: and name not like '#CNT_'

Line 5047: from wf_item_attribute_values

5043: from WF_ITEM_ATTRIBUTES
5044: where ITEM_TYPE = copy_itemtype
5045: and NAME not in
5046: (select name
5047: from wf_item_attribute_values
5048: where item_type = copy_itemtype
5049: and item_key = copy_itemkey
5050: and name not like '#LBL_'
5051: and name not like '#CNT_');

Line 5146: update WF_ITEM_ATTRIBUTE_VALUES

5142: end;
5143: else
5144: -- PARENT_CONTEXT is null
5145: -- increase all known #CNT counter by 1
5146: update WF_ITEM_ATTRIBUTE_VALUES
5147: set NUMBER_VALUE = NUMBER_VALUE + 1
5148: where NAME like '#CNT_%'
5149: and NUMBER_VALUE is not null
5150: and ITEM_TYPE = l_parent_itemType

Line 7003: WF_ITEM_ATTRIBUTE_VALUES WIAV

6999: AND WPA.ACTIVITY_ITEM_TYPE = WA.ITEM_TYPE
7000: AND WPA.ACTIVITY_NAME = WA.NAME
7001: AND EXISTS
7002: ( SELECT 1 FROM WF_ACTIVITY_ATTR_VALUES WAAV,
7003: WF_ITEM_ATTRIBUTE_VALUES WIAV
7004: WHERE WAAV.PROCESS_ACTIVITY_ID = WIAS.PROCESS_ACTIVITY
7005: AND WAAV.NAME = '#BUSINESS_KEY'
7006: AND WAAV.VALUE_TYPE = 'ITEMATTR'
7007: AND WIAV.ITEM_TYPE = WIAS.ITEM_TYPE

Line 7224: update WF_ITEM_ATTRIBUTE_VALUES wiav

7220: end if;
7221:
7222: else
7223: if (p_addend is NOT null) then
7224: update WF_ITEM_ATTRIBUTE_VALUES wiav
7225: set wiav.NUMBER_VALUE = (wiav.NUMBER_VALUE+p_addend)
7226: where wiav.ITEM_TYPE = p_itemtype
7227: and wiav.ITEM_KEY = p_itemkey
7228: and wiav.NAME = p_aname

Line 7231: update WF_ITEM_ATTRIBUTE_VALUES wiav

7227: and wiav.ITEM_KEY = p_itemkey
7228: and wiav.NAME = p_aname
7229: returning wiav.NUMBER_VALUE into l_avalue;
7230: else
7231: update WF_ITEM_ATTRIBUTE_VALUES wiav
7232: set wiav.NUMBER_VALUE = 0
7233: where wiav.ITEM_TYPE = p_itemtype
7234: and wiav.ITEM_KEY = p_itemkey
7235: and wiav.NAME = p_aname