APPS.WF_ENGINE dependencies on WF_NOTIFICATION

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 4580: wf_notification.cancel(nid.notification_id,' ');

4576:
4577: --Cancel any OPEN FYI notifications
4578: for nid in openNotifications
4579: loop
4580: wf_notification.cancel(nid.notification_id,' ');
4581: end loop;
4582:
4583: --Include the information of the aborted process in the events
4584: --parameter list.

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 5961: Wf_Notification.Forward(notid, performer, ntfComments);

5957: if (notid is not null) then
5958: -- 16-DEC-03 shanjgik bug fix 2722369 check for reassignType added
5959: if (reassignType = Wf_Engine.eng_delegate) then
5960: -- delegate the notification
5961: Wf_Notification.Forward(notid, performer, ntfComments);
5962: else -- case reassignType is TRANSFER or null
5963: -- Call Wf_Notification.Transfer(notid, performer) to transfer
5964: -- ownership of the notification to the new performer.
5965: Wf_Notification.Transfer(notid, performer, ntfComments);

Line 5963: -- Call Wf_Notification.Transfer(notid, performer) to transfer

5959: if (reassignType = Wf_Engine.eng_delegate) then
5960: -- delegate the notification
5961: Wf_Notification.Forward(notid, performer, ntfComments);
5962: else -- case reassignType is TRANSFER or null
5963: -- Call Wf_Notification.Transfer(notid, performer) to transfer
5964: -- ownership of the notification to the new performer.
5965: Wf_Notification.Transfer(notid, performer, ntfComments);
5966: end if;
5967: end if;

Line 5965: Wf_Notification.Transfer(notid, performer, ntfComments);

5961: Wf_Notification.Forward(notid, performer, ntfComments);
5962: else -- case reassignType is TRANSFER or null
5963: -- Call Wf_Notification.Transfer(notid, performer) to transfer
5964: -- ownership of the notification to the new performer.
5965: Wf_Notification.Transfer(notid, performer, ntfComments);
5966: end if;
5967: end if;
5968: else
5969: -- Activity must be complete (all other statuses are not valid

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