DBA Data[Home] [Help]

APPS.ENG_WORKFLOW_API_PKG dependencies on WF_ITEM_ACTIVITY_STATUS

Line 943: FROM WF_ITEM_ACTIVITY_STATUSES

939:
940: /* Getting Notification Id */
941: SELECT NOTIFICATION_ID
942: INTO l_nid
943: FROM WF_ITEM_ACTIVITY_STATUSES
944: WHERE ITEM_KEY = p_itemkey
945: AND ITEM_TYPE = p_itemtype
946: AND NOTIFICATION_ID IS NOT NULL;
947:

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

1333: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
1334: end if;
1335:
1336: -- Get Notifications group_id for activity
1337: Wf_Item_Activity_Status.Notification_Status(itemtype,itemkey,actid,
1338: l_group_id,l_user);
1339: l_voting_option := Wf_Engine.GetActivityAttrText(itemtype,itemkey,
1340: actid,'VOTING_OPTION');
1341: if (l_voting_option not in ('REQUIRE_ALL_VOTES', 'WAIT_FOR_ALL_VOTES',