APPS.ZPB_EXCEPTION_ALERT dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 1875: -- b5102962 WF_ITEM_ACTIVITY_STATUSES_V is non performant so

1871: IF (funcmode = 'RUN') THEN
1872:
1873: resultout :='COMPLETE:N';
1874:
1875: -- b5102962 WF_ITEM_ACTIVITY_STATUSES_V is non performant so
1876: -- it is replaced by the table WF_ITEM_ACTIVITY_STATUSES and
1877: -- ACTIVITY_STATUS_CODE is replaced by ACTIVITY_STATUS
1878: select count(*) into thisCount
1879: from WF_ITEM_ACTIVITY_STATUSES

Line 1876: -- it is replaced by the table WF_ITEM_ACTIVITY_STATUSES and

1872:
1873: resultout :='COMPLETE:N';
1874:
1875: -- b5102962 WF_ITEM_ACTIVITY_STATUSES_V is non performant so
1876: -- it is replaced by the table WF_ITEM_ACTIVITY_STATUSES and
1877: -- ACTIVITY_STATUS_CODE is replaced by ACTIVITY_STATUS
1878: select count(*) into thisCount
1879: from WF_ITEM_ACTIVITY_STATUSES
1880: where ITEM_TYPE = 'EPBCYCLE' and

Line 1879: from WF_ITEM_ACTIVITY_STATUSES

1875: -- b5102962 WF_ITEM_ACTIVITY_STATUSES_V is non performant so
1876: -- it is replaced by the table WF_ITEM_ACTIVITY_STATUSES and
1877: -- ACTIVITY_STATUS_CODE is replaced by ACTIVITY_STATUS
1878: select count(*) into thisCount
1879: from WF_ITEM_ACTIVITY_STATUSES
1880: where ITEM_TYPE = 'EPBCYCLE' and
1881: ITEM_KEY in (select ITEM_KEY from WF_ITEMS_V where PARENT_ITEM_KEY = ItemKey)
1882: and (ACTIVITY_STATUS = 'NOTIFIED' or ACTIVITY_RESULT_CODE = '#TIMEOUT');
1883:

Line 1962: -- b5102962 WF_ITEM_ACTIVITY_STATUSES_V is non performant so

1958: l_label varchar2(150);
1959: l_ctr number;
1960: l_activity_id number;
1961:
1962: -- b5102962 WF_ITEM_ACTIVITY_STATUSES_V is non performant so
1963: -- it is replaced by the table WF_ITEM_ACTIVITY_STATUSES and
1964: -- ACTIVITY_STATUS_CODE is replaced by ACTIVITY_STATUS and
1965: -- ASSIGNED_USER_DISPLAY_NAME to ASSIGNED_USER.
1966: -- Done for both cursors below.

Line 1963: -- it is replaced by the table WF_ITEM_ACTIVITY_STATUSES and

1959: l_ctr number;
1960: l_activity_id number;
1961:
1962: -- b5102962 WF_ITEM_ACTIVITY_STATUSES_V is non performant so
1963: -- it is replaced by the table WF_ITEM_ACTIVITY_STATUSES and
1964: -- ACTIVITY_STATUS_CODE is replaced by ACTIVITY_STATUS and
1965: -- ASSIGNED_USER_DISPLAY_NAME to ASSIGNED_USER.
1966: -- Done for both cursors below.
1967:

Line 1970: FROM WF_ITEM_ACTIVITY_STATUSES

1966: -- Done for both cursors below.
1967:
1968: CURSOR c_exceptionPool is
1969: SELECT ITEM_KEY, ASSIGNED_USER
1970: FROM WF_ITEM_ACTIVITY_STATUSES
1971: WHERE ITEM_TYPE = 'EPBCYCLE' and
1972: ITEM_KEY in (select ITEM_KEY from WF_ITEMS_V where PARENT_ITEM_KEY = ItemKey)
1973: and (ACTIVITY_STATUS = 'NOTIFIED' or ACTIVITY_RESULT_CODE = '#TIMEOUT');
1974: v_exChild c_exceptionPool%ROWTYPE;

Line 1995: from WF_ITEM_ACTIVITY_STATUSES_V

1991:
1992: begin
1993:
1994: select activity_id into l_activity_id
1995: from WF_ITEM_ACTIVITY_STATUSES_V
1996: WHERE ITEM_TYPE = 'EPBCYCLE'
1997: AND ITEM_KEY = childItemKey
1998: AND activity_name = 'EXPREQNTF';
1999:

Line 2042: from WF_ITEM_ACTIVITY_STATUSES_V

2038:
2039: begin
2040:
2041: select activity_id into l_activity_id
2042: from WF_ITEM_ACTIVITY_STATUSES_V
2043: WHERE ITEM_TYPE = 'EPBCYCLE'
2044: AND ITEM_KEY = childItemKey
2045: and activity_name = 'EXPAPPROVAL';
2046:

Line 2172: from WF_ITEM_ACTIVITY_STATUSES_V

2168:
2169:
2170: -- Begin REQUEST_EXPLANATIONS code
2171: select ITEM_KEY into ItemKey
2172: from WF_ITEM_ACTIVITY_STATUSES_V
2173: where item_type = 'EPBCYCLE' and NOTIFICATION_ID = NID;
2174:
2175:
2176: ACID := wf_engine.GetItemAttrNumber(Itemtype => ItemType,