APPS.PO_REQAPPROVAL_INIT1 dependencies on WF_NOTIFICATION

Line 7077: /* l_nid := wf_notification.Send(username,

7073: /* DEBUG */
7074: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
7075: END IF;
7076: IF username IS NOT NULL AND doc IS NOT NULL THEN
7077: /* l_nid := wf_notification.Send(username,
7078: itemtype,
7079: 'PLSQL_ERROR_OCCURS',
7080: null, null, null, null);
7081: wf_Notification.SetAttrText(l_nid, 'PLSQL_ERROR_DOC', doc);

Line 7081: wf_Notification.SetAttrText(l_nid, 'PLSQL_ERROR_DOC', doc);

7077: /* l_nid := wf_notification.Send(username,
7078: itemtype,
7079: 'PLSQL_ERROR_OCCURS',
7080: null, null, null, null);
7081: wf_Notification.SetAttrText(l_nid, 'PLSQL_ERROR_DOC', doc);
7082: wf_Notification.SetAttrText(l_nid, 'PLSQL_ERROR_LOC', loc);
7083: wf_Notification.SetAttrText(l_nid, 'PLSQL_ERROR_MSG', msg);
7084: */
7085: -- Get Document Id for the Errored Item.

Line 7082: wf_Notification.SetAttrText(l_nid, 'PLSQL_ERROR_LOC', loc);

7078: itemtype,
7079: 'PLSQL_ERROR_OCCURS',
7080: null, null, null, null);
7081: wf_Notification.SetAttrText(l_nid, 'PLSQL_ERROR_DOC', doc);
7082: wf_Notification.SetAttrText(l_nid, 'PLSQL_ERROR_LOC', loc);
7083: wf_Notification.SetAttrText(l_nid, 'PLSQL_ERROR_MSG', msg);
7084: */
7085: -- Get Document Id for the Errored Item.
7086: IF (document_id IS NULL) THEN

Line 7083: wf_Notification.SetAttrText(l_nid, 'PLSQL_ERROR_MSG', msg);

7079: 'PLSQL_ERROR_OCCURS',
7080: null, null, null, null);
7081: wf_Notification.SetAttrText(l_nid, 'PLSQL_ERROR_DOC', doc);
7082: wf_Notification.SetAttrText(l_nid, 'PLSQL_ERROR_LOC', loc);
7083: wf_Notification.SetAttrText(l_nid, 'PLSQL_ERROR_MSG', msg);
7084: */
7085: -- Get Document Id for the Errored Item.
7086: IF (document_id IS NULL) THEN
7087: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');

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 7578: x_supp_user_name := wf_notification.responder(l_nid);

7574: IF (l_nid IS NULL) THEN
7575: --we do not want to continue if the notification is not closed.
7576: RETURN;
7577: ELSE
7578: x_supp_user_name := wf_notification.responder(l_nid);
7579: END IF;
7580: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'SUPPLIER', avalue => x_vendor);
7581: -- commented out the usage of accptance_type (FPI)
7582: /* IF (x_accp_type is NULL) THEN

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')

Line 7718: x_supp_user_name := wf_notification.responder(l_nid);

7714: IF (l_nid IS NULL) THEN
7715: --We do not want to continue if the notification is not closed.
7716: RETURN;
7717: ELSE
7718: x_supp_user_name := wf_notification.responder(l_nid);
7719: END IF;
7720: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'SUPPLIER', avalue => x_vendor);
7721: -- commented out the usage of accptance_type (FPI)
7722: /* IF (x_accp_type is NULL) THEN