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_UTIL dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 233: SELECT /+ leading(wias) index(wias,WF_ITEM_ACTIVITY_STATUSES_PK) /

229: -- The join to active rows in WAIS for this item should choose
230: -- exactly one of these.
231:
232: -- bug 1663684 - Added hint to choose a different driving table
233: SELECT /*+ leading(wias) index(wias,WF_ITEM_ACTIVITY_STATUSES_PK) */
234: WPA.INSTANCE_ID
235: INTO parentid
236: FROM WF_ITEM_ACTIVITY_STATUSES WIAS,
237: WF_PROCESS_ACTIVITIES WPA

Line 236: FROM WF_ITEM_ACTIVITY_STATUSES WIAS,

232: -- bug 1663684 - Added hint to choose a different driving table
233: SELECT /*+ leading(wias) index(wias,WF_ITEM_ACTIVITY_STATUSES_PK) */
234: WPA.INSTANCE_ID
235: INTO parentid
236: FROM WF_ITEM_ACTIVITY_STATUSES WIAS,
237: WF_PROCESS_ACTIVITIES WPA
238: WHERE WPA.ACTIVITY_ITEM_TYPE =
239: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE
240: AND WPA.ACTIVITY_NAME = WF_CACHE.ProcessActivities(actid).PROCESS_NAME

Line 1584: -- Move the item activity status row from WF_ITEM_ACTIVITY_STATUSES to

1580: end Reset_Tree;
1581:
1582: --
1583: -- Move_To_History (PRIVATE)
1584: -- Move the item activity status row from WF_ITEM_ACTIVITY_STATUSES to
1585: -- WF_ITEM_ACTIVITY_STATUSES_H table.
1586: -- IN
1587: -- itemtype - A valid item type from (WF_ITEM_TYPES table).
1588: -- itemkey - A string generated from the application object's primary key.

Line 1585: -- WF_ITEM_ACTIVITY_STATUSES_H table.

1581:
1582: --
1583: -- Move_To_History (PRIVATE)
1584: -- Move the item activity status row from WF_ITEM_ACTIVITY_STATUSES to
1585: -- WF_ITEM_ACTIVITY_STATUSES_H table.
1586: -- IN
1587: -- itemtype - A valid item type from (WF_ITEM_TYPES table).
1588: -- itemkey - A string generated from the application object's primary key.
1589: -- actid - The activity instance id.

Line 1598: INSERT INTO WF_ITEM_ACTIVITY_STATUSES_H (

1594: begin
1595:
1596: -- Copy row to history table, changing status to COMPLETE/#FORCE
1597: -- if status is not already complete.
1598: INSERT INTO WF_ITEM_ACTIVITY_STATUSES_H (
1599: ITEM_TYPE,
1600: ITEM_KEY,
1601: PROCESS_ACTIVITY,
1602: ACTIVITY_STATUS,

Line 1636: FROM WF_ITEM_ACTIVITY_STATUSES

1632: ERROR_MESSAGE,
1633: ERROR_STACK,
1634: ACTION,
1635: PERFORMED_BY
1636: FROM WF_ITEM_ACTIVITY_STATUSES
1637: WHERE ITEM_TYPE = itemtype
1638: AND ITEM_KEY = itemkey
1639: AND PROCESS_ACTIVITY = actid;
1640:

Line 1644: -- INSERT INTO WF_ITEM_ACTIVITY_STATUSES_H (

1640:
1641: -- 3966635 Workflow Provisioning Project
1642: -- Insert added so as not to loose the change. This insert
1643: -- should replace the one above.
1644: -- INSERT INTO WF_ITEM_ACTIVITY_STATUSES_H (
1645: -- ITEM_TYPE,
1646: -- ITEM_KEY,
1647: -- PROCESS_ACTIVITY,
1648: -- ACTIVITY_STATUS,

Line 1684: --FROM WF_ITEM_ACTIVITY_STATUSES

1680: -- ERROR_STACK,
1681: -- ACTION,
1682: -- PERFORMED_BY,
1683: -- PROV_REQUEST_ID
1684: --FROM WF_ITEM_ACTIVITY_STATUSES
1685: --WHERE ITEM_TYPE = itemtype
1686: --AND ITEM_KEY = itemkey
1687: --AND PROCESS_ACTIVITY = actid;
1688:

Line 2323: WF_ACTIVITIES A1, WF_ITEM_ACTIVITY_STATUSES WIAS

2319: cursor children_to_kill (pid in pls_integer) is
2320: SELECT
2321: WIAS.PROCESS_ACTIVITY, WIAS.ACTIVITY_STATUS
2322: FROM WF_PROCESS_ACTIVITIES PA, WF_PROCESS_ACTIVITIES PA1,
2323: WF_ACTIVITIES A1, WF_ITEM_ACTIVITY_STATUSES WIAS
2324: WHERE PA.INSTANCE_ID = pid
2325: AND PA.ACTIVITY_ITEM_TYPE = PA1.PROCESS_ITEM_TYPE
2326: AND PA.ACTIVITY_NAME = PA1.PROCESS_NAME
2327: AND PA1.PROCESS_VERSION = A1.VERSION

Line 2435: FROM WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA1,

2431: -- Select all the active children process(es) under this parent process
2432: cursor children_be_suspended(parent in pls_integer) is
2433: SELECT
2434: WIAS.PROCESS_ACTIVITY
2435: FROM WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA1,
2436: WF_ACTIVITIES WA1, WF_PROCESS_ACTIVITIES WPA2, WF_ACTIVITIES WA2
2437: WHERE WPA1.INSTANCE_ID = processid
2438: AND WPA1.ACTIVITY_ITEM_TYPE = WA1.ITEM_TYPE
2439: AND WPA1.ACTIVITY_NAME = WA1.NAME

Line 2503: FROM WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA1,

2499: -- Select all the suspended children processes under this parent process
2500: cursor children_be_resumed(parent in pls_integer) is
2501: SELECT
2502: WIAS.PROCESS_ACTIVITY
2503: FROM WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA1,
2504: WF_PROCESS_ACTIVITIES WPA2, WF_ACTIVITIES WA
2505: WHERE WPA1.INSTANCE_ID = processid
2506: AND WPA1.ACTIVITY_ITEM_TYPE = WA.ITEM_TYPE
2507: AND WPA1.ACTIVITY_NAME = WA.NAME

Line 2875: from wf_item_activity_statuses_h ias,

2871: cursor message_attrs_cursor(itemtype varchar2, itemkey varchar2) is
2872: select ma.NAME, ma.TYPE, ma.SUBTYPE,
2873: ma.TEXT_DEFAULT, ma.NUMBER_DEFAULT, ma.DATE_DEFAULT,
2874: n.notification_id
2875: from wf_item_activity_statuses_h ias,
2876: wf_notifications n,
2877: wf_message_attributes ma
2878: where ias.item_type = itemtype
2879: and ias.item_key = itemkey