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

Line 1916: from WF_ITEM_ACTIVITY_STATUSES WIAS

1912: -- , WIAS.DUE_DATE,
1913: -- , WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE,
1914: -- , WIAS.ERROR_STACK
1915: into x_activity_status
1916: from WF_ITEM_ACTIVITY_STATUSES WIAS
1917: , WF_PROCESS_ACTIVITIES PA
1918: , WF_ACTIVITIES A
1919: where WIAS.ITEM_TYPE = p_item_type
1920: and WIAS.ITEM_KEY = p_item_key

Line 8309: FROM WF_ITEM_ACTIVITY_STATUSES wias,

8305: SELECT ntf.NOTIFICATION_ID,
8306: ntf.RECIPIENT_ROLE,
8307: ntf.MESSAGE_NAME,
8308: ntf.message_type
8309: FROM WF_ITEM_ACTIVITY_STATUSES wias,
8310: WF_NOTIFICATIONS ntf ,
8311: WF_NOTIFICATIONS orig_ntf
8312: WHERE ntf.STATUS = 'OPEN'
8313: AND wias.NOTIFICATION_ID = ntf.group_id

Line 9550: -- and put Wf_Item_Activity_Status.ClearCache before calling

9546: --
9547: -- VoteForResultType
9548: -- Because of bug2885157,
9549: -- copied from WF_STANDARD.VoteForResultType 115.46
9550: -- and put Wf_Item_Activity_Status.ClearCache before calling
9551: -- Wf_Item_Activity_Status.Notification_Status to get notification group id correctly
9552: --
9553: --
9554: -- Standard Voting Function

Line 9551: -- Wf_Item_Activity_Status.Notification_Status to get notification group id correctly

9547: -- VoteForResultType
9548: -- Because of bug2885157,
9549: -- copied from WF_STANDARD.VoteForResultType 115.46
9550: -- and put Wf_Item_Activity_Status.ClearCache before calling
9551: -- Wf_Item_Activity_Status.Notification_Status to get notification group id correctly
9552: --
9553: --
9554: -- Standard Voting Function
9555: -- IN

Line 9660: Wf_Item_Activity_Status.ClearCache;

9656: -- Always clear the cache first
9657: -- Bug2885157
9658: -- so it should be safe to force reading from
9659: -- the database.
9660: Wf_Item_Activity_Status.ClearCache;
9661:
9662: -- Get Notifications group_id for activity
9663: Wf_Item_Activity_Status.Notification_Status(itemtype,itemkey,actid,
9664: l_group_id,l_user);

Line 9663: Wf_Item_Activity_Status.Notification_Status(itemtype,itemkey,actid,

9659: -- the database.
9660: Wf_Item_Activity_Status.ClearCache;
9661:
9662: -- Get Notifications group_id for activity
9663: Wf_Item_Activity_Status.Notification_Status(itemtype,itemkey,actid,
9664: l_group_id,l_user);
9665: l_voting_option := Wf_Engine.GetActivityAttrText(itemtype,itemkey,
9666: actid,'VOTING_OPTION');
9667:

Line 10128: Wf_Item_Activity_Status.ClearCache;

10124: -- Always clear the cache first
10125: -- Bug2885157
10126: -- so it should be safe to force reading from
10127: -- the database.
10128: Wf_Item_Activity_Status.ClearCache;
10129:
10130:
10131: -- Get Notifications group_id for activity
10132: Wf_Item_Activity_Status.Notification_Status(itemtype,itemkey,actid,

Line 10132: Wf_Item_Activity_Status.Notification_Status(itemtype,itemkey,actid,

10128: Wf_Item_Activity_Status.ClearCache;
10129:
10130:
10131: -- Get Notifications group_id for activity
10132: Wf_Item_Activity_Status.Notification_Status(itemtype,itemkey,actid,
10133: l_group_id,l_user);
10134:
10135: -- Get Voting Option
10136: l_voting_option := Wf_Engine.GetActivityAttrText(itemtype,itemkey,

Line 11132: FROM WF_ITEM_ACTIVITY_STATUSES wias,

11128: SELECT ntf.NOTIFICATION_ID,
11129: ntf.RECIPIENT_ROLE,
11130: ntf.MESSAGE_NAME,
11131: ntf.message_type
11132: FROM WF_ITEM_ACTIVITY_STATUSES wias,
11133: WF_NOTIFICATIONS ntf
11134: WHERE ntf.STATUS = 'OPEN'
11135: AND wias.NOTIFICATION_ID = ntf.group_id
11136: AND wias.NOTIFICATION_ID IS NOT NULL