APPS.WF_ENGINE dependencies on WF_NOTIFICATIONS

Line 1926: -- ### Needs to be integrated with document support in wf_notifications!

1922: Wf_Core.Token('ANAME', nvl(aname, 'NULL'));
1923: Wf_Core.Raise('WFSQL_ARGS');
1924: end if;
1925:
1926: -- ### Needs to be integrated with document support in wf_notifications!
1927:
1928: -- Get attribute type info
1929: WF_CACHE.GetItemAttribute(itemtype, aname, status, wiaIND);
1930:

Line 4460: FROM wf_notifications wn, WF_ITEM_ACTIVITY_STATUSES ias

4456:
4457: l_lock boolean;
4458: cursor openNotifications is -- <7513983>
4459: SELECT wn.notification_id
4460: FROM wf_notifications wn, WF_ITEM_ACTIVITY_STATUSES ias
4461: WHERE ias.item_type = itemtype
4462: AND ias.item_key = itemkey
4463: AND ias.notification_id is not null
4464: AND ias.notification_id = wn.group_id

Line 4468: FROM wf_notifications wn, WF_ITEM_ACTIVITY_STATUSES_H iash

4464: AND ias.notification_id = wn.group_id
4465: AND wn.status = 'OPEN'
4466: UNION
4467: SELECT wn.notification_id
4468: FROM wf_notifications wn, WF_ITEM_ACTIVITY_STATUSES_H iash
4469: WHERE iash.item_type = itemtype
4470: AND iash.item_key = itemkey
4471: AND iash.notification_id is not null
4472: AND iash.notification_id = wn.notification_id

Line 5693: update WF_NOTIFICATIONS WN set

5689: -- status is closed and not cancelled when going through the external
5690: -- CompleteActivity interface.
5691: -- Bug2811737 CTILLEY - added update to end_date
5692: if (notid is not null) then
5693: update WF_NOTIFICATIONS WN set
5694: status = 'CLOSED',
5695: end_date = sysdate
5696: where WN.GROUP_ID = CompleteActivity.notid
5697: and WN.STATUS = 'OPEN';

Line 6469: wf_notifications ntf

6465: wf_process_activities pa,
6466: wf_activities ac,
6467: wf_activities ap,
6468: wf_items i,
6469: wf_notifications ntf
6470: where ias.item_type = p_itemtype
6471: and ias.item_key = p_itemkey
6472: and ias.activity_status = wf_engine.eng_completed
6473: and ias.process_activity = pa.instance_id