eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_REQAPPROVAL_INIT1 dependencies on WF_NOTIFICATIONS

Line 7145: UPDATE wf_notifications

7141: itemkey IN VARCHAR2)
7142: IS
7143: pragma AUTONOMOUS_TRANSACTION;
7144: BEGIN
7145: UPDATE wf_notifications
7146: SET status = 'CLOSED'
7147: WHERE notification_id IN
7148: (SELECT ias.notification_id
7149: FROM wf_item_activity_statuses ias,

Line 7150: wf_notifications ntf

7146: SET status = 'CLOSED'
7147: WHERE notification_id IN
7148: (SELECT ias.notification_id
7149: FROM wf_item_activity_statuses ias,
7150: wf_notifications ntf
7151: WHERE ias.item_type = itemtype
7152: AND ias.item_key = itemkey
7153: AND ntf.notification_id = ias.notification_id
7154: );

Line 7544: FROM wf_notifications a,

7540: SELECT a.notification_id,
7541: a.recipient_role
7542: INTO l_nid,
7543: l_ntf_role_name
7544: FROM wf_notifications a,
7545: wf_item_activity_statuses wa
7546: WHERE itemkey =wa.item_key
7547: AND itemtype =wa.item_type
7548: AND a.message_name IN ('PO_EMAIL_PO_WITH_RESPONSE', 'PO_EMAIL_PO_PDF_WITH_RESPONSE')

Line 7562: FROM wf_notifications a,

7558: SELECT a.notification_id,
7559: a.recipient_role
7560: INTO l_nid,
7561: l_ntf_role_name
7562: FROM wf_notifications a,
7563: wf_item_activity_statuses wa
7564: WHERE itemkey =wa.item_key
7565: AND itemtype =wa.item_type
7566: AND a.message_name IN ('PO_EMAIL_PO_WITH_RESPONSE', 'PO_EMAIL_PO_PDF_WITH_RESPONSE')

Line 7684: FROM wf_notifications a,

7680: SELECT a.notification_id,
7681: a.recipient_role
7682: INTO l_nid,
7683: l_ntf_role_name
7684: FROM wf_notifications a,
7685: wf_item_activity_statuses wa
7686: WHERE itemkey =wa.item_key
7687: AND itemtype =wa.item_type
7688: AND a.message_name IN ('PO_EMAIL_PO_WITH_RESPONSE', 'PO_EMAIL_PO_PDF_WITH_RESPONSE')

Line 7702: FROM wf_notifications a,

7698: SELECT a.notification_id,
7699: a.recipient_role
7700: INTO l_nid,
7701: l_ntf_role_name
7702: FROM wf_notifications a,
7703: wf_item_activity_statuses wa
7704: WHERE itemkey =wa.item_key
7705: AND itemtype =wa.item_type
7706: AND a.message_name IN ('PO_EMAIL_PO_WITH_RESPONSE', 'PO_EMAIL_PO_PDF_WITH_RESPONSE')