DBA Data[Home] [Help]

APPS.ENG_WORKFLOW_API_PKG dependencies on WF_ITEM_ACTIVITY_STATUS

Line 1088: FROM WF_ITEM_ACTIVITY_STATUSES

1084:
1085: /* Getting Notification Id */
1086: SELECT NOTIFICATION_ID
1087: INTO l_nid
1088: FROM WF_ITEM_ACTIVITY_STATUSES
1089: WHERE ITEM_KEY = p_itemkey
1090: AND ITEM_TYPE = p_itemtype
1091: AND NOTIFICATION_ID IS NOT NULL;
1092:

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

1483: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
1484: end if;
1485:
1486: -- Get Notifications group_id for activity
1487: Wf_Item_Activity_Status.Notification_Status(itemtype,itemkey,actid,
1488: l_group_id,l_user);
1489: l_voting_option := Wf_Engine.GetActivityAttrText(itemtype,itemkey,
1490: actid,'VOTING_OPTION');
1491: if (l_voting_option not in ('REQUIRE_ALL_VOTES', 'WAIT_FOR_ALL_VOTES',