APPS.PO_REQAPPROVAL_INIT1 dependencies on WF_NOTIFICATIONS

Line 7920: update wf_notifications set status = 'CLOSED'

7916: itemkey in varchar2) is
7917: pragma AUTONOMOUS_TRANSACTION;
7918: begin
7919:
7920: update wf_notifications set status = 'CLOSED'
7921: where notification_id in (
7922: select ias.notification_id
7923: from wf_item_activity_statuses ias,
7924: wf_notifications ntf

Line 7924: wf_notifications ntf

7920: update wf_notifications set status = 'CLOSED'
7921: where notification_id in (
7922: select ias.notification_id
7923: from wf_item_activity_statuses ias,
7924: wf_notifications ntf
7925: where ias.item_type = itemtype
7926: and ias.item_key = itemkey
7927: and ntf.notification_id = ias.notification_id);
7928:

Line 8485: from wf_notifications a,

8481: --dbms_output.put_line('For std pos');
8482: begin
8483: select a.notification_id, a.recipient_role
8484: INTO l_nid, l_ntf_role_name
8485: from wf_notifications a,
8486: wf_item_activity_statuses wa
8487: where itemkey=wa.item_key
8488: and itemtype=wa.item_type
8489: and a.message_name in ('PO_EMAIL_PO_WITH_RESPONSE', 'PO_EMAIL_PO_PDF_WITH_RESPONSE')

Line 8500: from wf_notifications a,

8496: begin
8497: --dbms_output.put_line('For Releases');
8498: select a.notification_id, a.recipient_role
8499: INTO l_nid, l_ntf_role_name
8500: from wf_notifications a,
8501: wf_item_activity_statuses wa
8502: where itemkey=wa.item_key
8503: and itemtype=wa.item_type
8504: and a.message_name in ('PO_EMAIL_PO_WITH_RESPONSE', 'PO_EMAIL_PO_PDF_WITH_RESPONSE')

Line 8680: from wf_notifications a,

8676: --dbms_output.put_line('For std pos');
8677: begin
8678: select a.notification_id, a.recipient_role
8679: INTO l_nid, l_ntf_role_name
8680: from wf_notifications a,
8681: wf_item_activity_statuses wa
8682: where itemkey=wa.item_key
8683: and itemtype=wa.item_type
8684: and a.message_name in ('PO_EMAIL_PO_WITH_RESPONSE', 'PO_EMAIL_PO_PDF_WITH_RESPONSE')

Line 8695: from wf_notifications a,

8691: begin
8692: --dbms_output.put_line('For Releases');
8693: select a.notification_id, a.recipient_role
8694: INTO l_nid, l_ntf_role_name
8695: from wf_notifications a,
8696: wf_item_activity_statuses wa
8697: where itemkey=wa.item_key
8698: and itemtype=wa.item_type
8699: and a.message_name in ('PO_EMAIL_PO_WITH_RESPONSE', 'PO_EMAIL_PO_PDF_WITH_RESPONSE')