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 4411: FROM wf_notifications wn, WF_ITEM_ACTIVITY_STATUSES ias

4407:
4408: l_lock boolean;
4409: cursor openNotifications is -- <7513983>
4410: SELECT wn.notification_id
4411: FROM wf_notifications wn, WF_ITEM_ACTIVITY_STATUSES ias
4412: WHERE ias.item_type = itemtype
4413: AND ias.item_key = itemkey
4414: AND ias.notification_id is not null
4415: AND ias.notification_id = wn.group_id

Line 4419: FROM wf_notifications wn, WF_ITEM_ACTIVITY_STATUSES_H iash

4415: AND ias.notification_id = wn.group_id
4416: AND wn.status = 'OPEN'
4417: UNION
4418: SELECT wn.notification_id
4419: FROM wf_notifications wn, WF_ITEM_ACTIVITY_STATUSES_H iash
4420: WHERE iash.item_type = itemtype
4421: AND iash.item_key = itemkey
4422: AND iash.notification_id is not null
4423: AND iash.notification_id = wn.notification_id

Line 5637: update WF_NOTIFICATIONS WN set

5633: -- status is closed and not cancelled when going through the external
5634: -- CompleteActivity interface.
5635: -- Bug2811737 CTILLEY - added update to end_date
5636: if (notid is not null) then
5637: update WF_NOTIFICATIONS WN set
5638: status = 'CLOSED',
5639: end_date = sysdate
5640: where WN.GROUP_ID = CompleteActivity.notid
5641: and WN.STATUS = 'OPEN';

Line 6400: wf_notifications ntf

6396: wf_process_activities pa,
6397: wf_activities ac,
6398: wf_activities ap,
6399: wf_items i,
6400: wf_notifications ntf
6401: where ias.item_type = p_itemtype
6402: and ias.item_key = p_itemkey
6403: and ias.activity_status = wf_engine.eng_completed
6404: and ias.process_activity = pa.instance_id