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

4527:
4528: --Cancel any OPEN FYI notifications
4529: for nid in openNotifications
4530: loop
4531: wf_notification.cancel(nid.notification_id,' ');
4532: end loop;
4533:
4534: --Include the information of the aborted process in the events
4535: --parameter list.

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

5892: if (notid is not null) then
5893: -- 16-DEC-03 shanjgik bug fix 2722369 check for reassignType added
5894: if (reassignType = Wf_Engine.eng_delegate) then
5895: -- delegate the notification
5896: Wf_Notification.Forward(notid, performer, ntfComments);
5897: else -- case reassignType is TRANSFER or null
5898: -- Call Wf_Notification.Transfer(notid, performer) to transfer
5899: -- ownership of the notification to the new performer.
5900: Wf_Notification.Transfer(notid, performer, ntfComments);

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

5894: if (reassignType = Wf_Engine.eng_delegate) then
5895: -- delegate the notification
5896: Wf_Notification.Forward(notid, performer, ntfComments);
5897: else -- case reassignType is TRANSFER or null
5898: -- Call Wf_Notification.Transfer(notid, performer) to transfer
5899: -- ownership of the notification to the new performer.
5900: Wf_Notification.Transfer(notid, performer, ntfComments);
5901: end if;
5902: end if;

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

5896: Wf_Notification.Forward(notid, performer, ntfComments);
5897: else -- case reassignType is TRANSFER or null
5898: -- Call Wf_Notification.Transfer(notid, performer) to transfer
5899: -- ownership of the notification to the new performer.
5900: Wf_Notification.Transfer(notid, performer, ntfComments);
5901: end if;
5902: end if;
5903: else
5904: -- Activity must be complete (all other statuses are not valid

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