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.OE_ERROR_WF dependencies on WF_ITEM_ACTIVITY_STATUS

Line 882: from WF_ITEM_ACTIVITY_STATUSES WIAS

878: status VARCHAR2(30);
879:
880: cursor activity_status (litemtype varchar2, litemkey varchar2, lactid number ) is
881: select WIAS.ACTIVITY_STATUS
882: from WF_ITEM_ACTIVITY_STATUSES WIAS
883: where WIAS.ITEM_TYPE = litemtype
884: and WIAS.ITEM_KEY = litemkey
885: and WIAS.PROCESS_ACTIVITY = lactid;
886:

Line 1360: Wf_Item_Activity_Status.Create_Status (itemtype => 'OEOL',

1356: oe_debug_pub.add('Closed delivery detail exists');
1357: END IF;
1358:
1359: BEGIN
1360: Wf_Item_Activity_Status.Create_Status (itemtype => 'OEOL',
1361: itemkey => p_item_key,
1362: actid => p_process_activity,
1363: status => wf_engine.eng_notified,
1364: result => wf_engine.eng_null,

Line 1473: FROM WF_ITEM_ACTIVITY_STATUSES IAS

1469:
1470: BEGIN
1471: SELECT 1
1472: INTO l_count
1473: FROM WF_ITEM_ACTIVITY_STATUSES IAS
1474: WHERE IAS.ITEM_TYPE = p_item_type
1475: AND IAS.ITEM_KEY = p_item_key
1476: AND IAS.PROCESS_ACTIVITY = p_activity_id
1477: AND IAS.ACTIVITY_STATUS = l_error_status

Line 1824: WF_ITEM_ACTIVITY_STATUSES IAS,

1820: CURSOR l_retry_cursor_1 IS
1821: SELECT IAS.ITEM_KEY, PA.INSTANCE_LABEL, PA.ACTIVITY_NAME, PA.PROCESS_NAME, IAS.PROCESS_ACTIVITY, I.USER_KEY, I.PARENT_ITEM_TYPE, I.PARENT_ITEM_KEY, PA.ACTIVITY_ITEM_TYPE, WAT.NUMBER_VALUE
1822: FROM WF_PROCESS_ACTIVITIES PA,
1823: WF_ITEMS I,
1824: WF_ITEM_ACTIVITY_STATUSES IAS,
1825: WF_ITEM_ATTRIBUTE_VALUES WAT,
1826: WF_ACTIVITIES WA
1827: WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
1828: AND IAS.ITEM_KEY = I.ITEM_KEY

Line 1850: WF_ITEM_ACTIVITY_STATUSES IAS,

1846: CURSOR l_retry_cursor_2 IS
1847: SELECT IAS.ITEM_KEY, PA.INSTANCE_LABEL, PA.ACTIVITY_NAME, PA.PROCESS_NAME, IAS.PROCESS_ACTIVITY, I.USER_KEY, I.PARENT_ITEM_TYPE, I.PARENT_ITEM_KEY, PA.ACTIVITY_ITEM_TYPE, WAT.NUMBER_VALUE
1848: FROM WF_PROCESS_ACTIVITIES PA,
1849: WF_ITEMS I,
1850: WF_ITEM_ACTIVITY_STATUSES IAS,
1851: WF_ITEM_ATTRIBUTE_VALUES WAT,
1852: WF_ACTIVITIES WA
1853: WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
1854: AND IAS.ITEM_KEY = I.ITEM_KEY

Line 1875: WF_ITEM_ACTIVITY_STATUSES IAS,

1871: CURSOR l_retry_cursor_3 IS
1872: SELECT IAS.ITEM_KEY, PA.INSTANCE_LABEL, PA.ACTIVITY_NAME, PA.PROCESS_NAME, IAS.PROCESS_ACTIVITY, I.USER_KEY, I.PARENT_ITEM_TYPE, I.PARENT_ITEM_KEY, PA.ACTIVITY_ITEM_TYPE, WAT.NUMBER_VALUE
1873: FROM WF_PROCESS_ACTIVITIES PA,
1874: WF_ITEMS I,
1875: WF_ITEM_ACTIVITY_STATUSES IAS,
1876: WF_ITEM_ATTRIBUTE_VALUES WAT,
1877: WF_ACTIVITIES WA
1878: WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
1879: AND IAS.ITEM_KEY = I.ITEM_KEY

Line 1902: WF_ITEM_ACTIVITY_STATUSES IAS,

1898: CURSOR l_retry_cursor_4 IS
1899: SELECT IAS.ITEM_KEY, PA.INSTANCE_LABEL, PA.ACTIVITY_NAME, PA.PROCESS_NAME, IAS.PROCESS_ACTIVITY, I.USER_KEY, I.PARENT_ITEM_TYPE, I.PARENT_ITEM_KEY, PA.ACTIVITY_ITEM_TYPE, WAT.NUMBER_VALUE
1900: FROM WF_PROCESS_ACTIVITIES PA,
1901: WF_ITEMS I,
1902: WF_ITEM_ACTIVITY_STATUSES IAS,
1903: WF_ITEM_ATTRIBUTE_VALUES WAT,
1904: WF_ACTIVITIES WA
1905: WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
1906: AND IAS.ITEM_KEY = I.ITEM_KEY

Line 1928: WF_ITEM_ACTIVITY_STATUSES IAS,

1924: CURSOR l_retry_cursor_5 IS
1925: SELECT IAS.ITEM_KEY, PA.INSTANCE_LABEL, PA.ACTIVITY_NAME, PA.PROCESS_NAME, IAS.PROCESS_ACTIVITY, I.USER_KEY, I.PARENT_ITEM_TYPE, I.PARENT_ITEM_KEY, PA.ACTIVITY_ITEM_TYPE, WAT.NUMBER_VALUE
1926: FROM WF_PROCESS_ACTIVITIES PA,
1927: WF_ITEMS I,
1928: WF_ITEM_ACTIVITY_STATUSES IAS,
1929: WF_ITEM_ATTRIBUTE_VALUES WAT,
1930: WF_ACTIVITIES WA
1931: WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
1932: AND IAS.ITEM_KEY = I.ITEM_KEY

Line 1955: WF_ITEM_ACTIVITY_STATUSES IAS,

1951: CURSOR l_retry_cursor_6 IS
1952: SELECT IAS.ITEM_KEY, PA.INSTANCE_LABEL, PA.ACTIVITY_NAME, PA.PROCESS_NAME, IAS.PROCESS_ACTIVITY, I.USER_KEY, I.PARENT_ITEM_TYPE, I.PARENT_ITEM_KEY, PA.ACTIVITY_ITEM_TYPE, WAT.NUMBER_VALUE
1953: FROM WF_PROCESS_ACTIVITIES PA,
1954: WF_ITEMS I,
1955: WF_ITEM_ACTIVITY_STATUSES IAS,
1956: WF_ITEM_ATTRIBUTE_VALUES WAT,
1957: WF_ACTIVITIES WA
1958: WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
1959: AND IAS.ITEM_KEY = I.ITEM_KEY