APPS.POS_ACK_PO dependencies on WF_NOTIFICATION

Line 101: from wf_notifications

97: relRec REL_CSR%ROWTYPE;
98:
99: CURSOR NID_CSR(p_nid in number) IS
100: select notification_id
101: from wf_notifications
102: where notification_id = p_nid
103: FOR UPDATE of notification_id NOWAIT;
104:
105: nidRec NID_CSR%ROWTYPE;

Line 121: from wf_notifications a,po_headers_all poh,

117: --dbms_output.put_line('For Releases');
118: begin
119: select a.notification_id,poh.wf_item_type,poh.wf_item_key, a.message_name
120: INTO l_nid,l_po_item_type,l_po_item_key, l_message_name
121: from wf_notifications a,po_headers_all poh,
122: wf_item_activity_statuses wa
123: where poh.po_header_id=l_po_header_id
124: and poh.wf_item_key=wa.item_key
125: and poh.wf_item_type=wa.item_type

Line 138: from wf_notifications a,po_releases_all por,

134: begin
135: --dbms_output.put_line('For Std PO');
136: select a.notification_id,por.wf_item_type,por.wf_item_key
137: INTO l_nid,l_po_item_type,l_po_item_key
138: from wf_notifications a,po_releases_all por,
139: wf_item_activity_statuses wa
140: where por.po_release_id=l_po_release_id
141: and por.wf_item_key=wa.item_key
142: and por.wf_item_type=wa.item_type

Line 277: WF_NOTIFICATION.SetAttrText(nid =>l_nid ,

273: same as the l_supplier_name. See bug 3900146 for details.
274:
275: */
276: l_progress := '3-1';
277: WF_NOTIFICATION.SetAttrText(nid =>l_nid ,
278: aname => 'RESULT',
279: avalue => l_action);
280:
281: l_progress := '3-2';

Line 282: WF_NOTIFICATION.Respond(nid =>l_nid ,

278: aname => 'RESULT',
279: avalue => l_action);
280:
281: l_progress := '3-2';
282: WF_NOTIFICATION.Respond(nid =>l_nid ,
283: respond_comment =>null,
284: responder =>l_supp_username
285: --action_source in varchar2 default null
286: );