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 8344: FROM WF_ITEM_ACTIVITY_STATUSES wias,

8340: SELECT ntf.NOTIFICATION_ID,
8341: ntf.RECIPIENT_ROLE,
8342: ntf.MESSAGE_NAME,
8343: ntf.message_type
8344: FROM WF_ITEM_ACTIVITY_STATUSES wias,
8345: WF_NOTIFICATIONS ntf ,
8346: WF_NOTIFICATIONS orig_ntf
8347: WHERE ntf.STATUS = 'OPEN'
8348: AND wias.NOTIFICATION_ID = ntf.group_id

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

9622: --
9623: -- VoteForResultType
9624: -- Because of bug2885157,
9625: -- copied from WF_STANDARD.VoteForResultType 115.46
9626: -- and put Wf_Item_Activity_Status.ClearCache before calling
9627: -- Wf_Item_Activity_Status.Notification_Status to get notification group id correctly
9628: --
9629: --
9630: -- Standard Voting Function

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

9623: -- VoteForResultType
9624: -- Because of bug2885157,
9625: -- copied from WF_STANDARD.VoteForResultType 115.46
9626: -- and put Wf_Item_Activity_Status.ClearCache before calling
9627: -- Wf_Item_Activity_Status.Notification_Status to get notification group id correctly
9628: --
9629: --
9630: -- Standard Voting Function
9631: -- IN

Line 9736: Wf_Item_Activity_Status.ClearCache;

9732: -- Always clear the cache first
9733: -- Bug2885157
9734: -- so it should be safe to force reading from
9735: -- the database.
9736: Wf_Item_Activity_Status.ClearCache;
9737:
9738: -- Get Notifications group_id for activity
9739: Wf_Item_Activity_Status.Notification_Status(itemtype,itemkey,actid,
9740: l_group_id,l_user);

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

9735: -- the database.
9736: Wf_Item_Activity_Status.ClearCache;
9737:
9738: -- Get Notifications group_id for activity
9739: Wf_Item_Activity_Status.Notification_Status(itemtype,itemkey,actid,
9740: l_group_id,l_user);
9741: l_voting_option := Wf_Engine.GetActivityAttrText(itemtype,itemkey,
9742: actid,'VOTING_OPTION');
9743:

Line 10204: Wf_Item_Activity_Status.ClearCache;

10200: -- Always clear the cache first
10201: -- Bug2885157
10202: -- so it should be safe to force reading from
10203: -- the database.
10204: Wf_Item_Activity_Status.ClearCache;
10205:
10206:
10207: -- Get Notifications group_id for activity
10208: Wf_Item_Activity_Status.Notification_Status(itemtype,itemkey,actid,

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

10204: Wf_Item_Activity_Status.ClearCache;
10205:
10206:
10207: -- Get Notifications group_id for activity
10208: Wf_Item_Activity_Status.Notification_Status(itemtype,itemkey,actid,
10209: l_group_id,l_user);
10210:
10211: -- Get Voting Option
10212: l_voting_option := Wf_Engine.GetActivityAttrText(itemtype,itemkey,

Line 11208: FROM WF_ITEM_ACTIVITY_STATUSES wias,

11204: SELECT ntf.NOTIFICATION_ID,
11205: ntf.RECIPIENT_ROLE,
11206: ntf.MESSAGE_NAME,
11207: ntf.message_type
11208: FROM WF_ITEM_ACTIVITY_STATUSES wias,
11209: WF_NOTIFICATIONS ntf
11210: WHERE ntf.STATUS = 'OPEN'
11211: AND wias.NOTIFICATION_ID = ntf.group_id
11212: AND wias.NOTIFICATION_ID IS NOT NULL