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_ATTRIBUTES

Line 499: from WF_ITEM_ATTRIBUTES WIA

495: begin
496: select WIA.ITEM_TYPE, WIA.NAME, WIA.TYPE, WIA.SUBTYPE, WIA.FORMAT,
497: WIA.TEXT_DEFAULT, WIA.NUMBER_DEFAULT, WIA.DATE_DEFAULT
498: into WF_CACHE.ItemAttributes(wiaIND)
499: from WF_ITEM_ATTRIBUTES WIA
500: where WIA.ITEM_TYPE = itemtype
501: and WIA.NAME = aname;
502:
503: exception

Line 608: from WF_ITEM_ATTRIBUTES WIA

604: SetItemAttrText.itemtype,
605: SetItemAttrText.itemkey,
606: SetItemAttrText.aname,
607: SetItemAttrText.avalue
608: from WF_ITEM_ATTRIBUTES WIA
609: where WIA.ITEM_TYPE = SetItemAttrText.itemtype
610: and WIA.NAME = SetItemAttrText.aname;
611:
612: if SQL%NOTFOUND then

Line 718: from WF_ITEM_ATTRIBUTES WIA

714: SetItemAttrText2.p_itemtype,
715: SetItemAttrText2.p_itemkey,
716: SetItemAttrText2.p_aname,
717: SetItemAttrText2.p_avalue
718: from WF_ITEM_ATTRIBUTES WIA
719: where WIA.ITEM_TYPE = SetItemAttrText2.p_itemtype
720: and WIA.NAME = SetItemAttrText2.p_aname;
721:
722: if SQL%NOTFOUND then

Line 778: from WF_ITEM_ATTRIBUTES WIA

774: begin
775: select WIA.ITEM_TYPE, WIA.NAME, WIA.TYPE, WIA.SUBTYPE, WIA.FORMAT,
776: WIA.TEXT_DEFAULT, WIA.NUMBER_DEFAULT, WIA.DATE_DEFAULT
777: into WF_CACHE.ItemAttributes(wiaIND)
778: from WF_ITEM_ATTRIBUTES WIA
779: where WIA.ITEM_TYPE = itemtype
780: and WIA.NAME = aname;
781:
782: exception

Line 893: from WF_ITEM_ATTRIBUTES WIA

889: SetItemAttrNumber.itemtype,
890: SetItemAttrNumber.itemkey,
891: SetItemAttrNumber.aname,
892: SetItemAttrNumber.avalue
893: from WF_ITEM_ATTRIBUTES WIA
894: where WIA.ITEM_TYPE = SetItemAttrNumber.itemtype
895: and WIA.NAME = SetItemAttrNumber.aname;
896:
897: if SQL%NOTFOUND then

Line 980: from WF_ITEM_ATTRIBUTES WIA

976: SetItemAttrDate.itemtype,
977: SetItemAttrDate.itemkey,
978: SetItemAttrDate.aname,
979: SetItemAttrDate.avalue
980: from WF_ITEM_ATTRIBUTES WIA
981: where WIA.ITEM_TYPE = SetItemAttrDate.itemtype
982: and WIA.NAME = SetItemAttrDate.aname;
983:
984: if SQL%NOTFOUND then

Line 1101: from WF_ITEM_ATTRIBUTES WIA

1097: SetItemAttrEvent.itemtype,
1098: SetItemAttrEvent.itemkey,
1099: SetItemAttrEvent.name,
1100: SetItemAttrEvent.event
1101: from WF_ITEM_ATTRIBUTES WIA
1102: where WIA.ITEM_TYPE = SetItemAttrEvent.itemtype
1103: and WIA.NAME = SetItemAttrEvent.name;
1104:
1105: if SQL%NOTFOUND then

Line 1203: from WF_ITEM_ATTRIBUTES WIA

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
1205: WIA.ITEM_TYPE = itemtype
1206: and
1207: WIA.NAME = aname(arrayIndex)

Line 1316: from WF_ITEM_ATTRIBUTES WIA

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
1318: WIA.ITEM_TYPE = itemtype
1319: and
1320: WIA.NAME = aname(arrayIndex)

Line 1427: from WF_ITEM_ATTRIBUTES WIA

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
1429: WIA.ITEM_TYPE = itemtype
1430: and
1431: WIA.NAME = aname(arrayIndex)

Line 1497: from WF_ITEM_ATTRIBUTES WIA

1493: if (status <> WF_CACHE.task_SUCCESS) then
1494: select WIA.ITEM_TYPE, WIA.NAME, WIA.TYPE, WIA.SUBTYPE, WIA.FORMAT,
1495: WIA.TEXT_DEFAULT, WIA.NUMBER_DEFAULT, WIA.DATE_DEFAULT
1496: into WF_CACHE.ItemAttributes(wiaIND)
1497: from WF_ITEM_ATTRIBUTES WIA
1498: where WIA.ITEM_TYPE = itemtype
1499: and WIA.NAME = aname;
1500:
1501: end if;

Line 1567: from WF_ITEM_ATTRIBUTES WIA

1563: begin
1564: select WIA.ITEM_TYPE, WIA.NAME, WIA.TYPE, WIA.SUBTYPE, WIA.FORMAT,
1565: WIA.TEXT_DEFAULT, WIA.NUMBER_DEFAULT, WIA.DATE_DEFAULT
1566: into WF_CACHE.ItemAttributes(wiaIND)
1567: from WF_ITEM_ATTRIBUTES WIA
1568: where WIA.ITEM_TYPE = itemtype
1569: and WIA.NAME = aname;
1570:
1571: exception

Line 1631: from WF_ITEM_ATTRIBUTES

1627: -- ondemand logic
1628: if wf_item.Attribute_On_Demand(itemtype, itemkey) then
1629: select TEXT_DEFAULT
1630: into lvalue
1631: from WF_ITEM_ATTRIBUTES
1632: where ITEM_TYPE = itemtype
1633: and NAME = aname;
1634: else
1635: raise no_data_found;

Line 1725: from WF_ITEM_ATTRIBUTES

1721: -- ondemand logic
1722: if wf_item.Attribute_On_Demand(itemtype, itemkey) then
1723: select NUMBER_DEFAULT
1724: into lvalue
1725: from WF_ITEM_ATTRIBUTES
1726: where ITEM_TYPE = itemtype
1727: and NAME = aname;
1728: else
1729: raise no_data_found;

Line 1815: from WF_ITEM_ATTRIBUTES

1811: when no_data_found then
1812: if wf_item.Attribute_On_Demand(itemtype, itemkey) then
1813: select DATE_DEFAULT
1814: into lvalue
1815: from WF_ITEM_ATTRIBUTES
1816: where ITEM_TYPE = itemtype
1817: and NAME = aname;
1818: else
1819: raise no_data_found;

Line 1936: from WF_ITEM_ATTRIBUTES WIA

1932: begin
1933: select WIA.ITEM_TYPE, WIA.NAME, WIA.TYPE, WIA.SUBTYPE, WIA.FORMAT,
1934: WIA.TEXT_DEFAULT, WIA.NUMBER_DEFAULT, WIA.DATE_DEFAULT
1935: into WF_CACHE.ItemAttributes(wiaIND)
1936: from WF_ITEM_ATTRIBUTES WIA
1937: where WIA.ITEM_TYPE = GetItemAttrClob.itemtype
1938: and WIA.NAME = GetItemAttrClob.aname;
1939:
1940: exception

Line 2040: from WF_ITEM_ATTRIBUTES WIA

2036: -- will only be inserted into the table when setItemAttrEvent is called.
2037: --
2038: if wf_item.Attribute_On_Demand(itemtype, itemkey) then
2039: select null into l_value
2040: from WF_ITEM_ATTRIBUTES WIA
2041: where WIA.ITEM_TYPE = GetItemAttrEvent.itemtype
2042: and WIA.NAME = GetItemAttrEvent.name;
2043:
2044: Wf_Event_T.Initialize(lvalue);

Line 4048: from WF_ITEM_ATTRIBUTES WIA

4044: -- All event item attrs to be initialized
4045: -- Initialization is now deferred until GetItemAttrEvent
4046: /* cursor evtcurs is
4047: select WIA.NAME
4048: from WF_ITEM_ATTRIBUTES WIA
4049: where WIA.ITEM_TYPE = CreateProcess.itemtype
4050: and WIA.TYPE = 'EVENT';*/
4051:
4052: begin

Line 5043: from WF_ITEM_ATTRIBUTES

5039: and name not like '#CNT_'
5040: union all
5041: select ITEM_TYPE, new_itemkey, NAME,
5042: TEXT_DEFAULT, NUMBER_DEFAULT, DATE_DEFAULT
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