APPS.POR_CANCEL_NOTIF_PVT dependencies on PO_REQUISITION_SUPPLIERS

Line 299: update po_requisition_suppliers

295: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,g_module_prefix || l_api_name || l_progress || l_cont_status);
296: END IF;
297:
298: IF (l_cont_status = 'PENDING') THEN
299: update po_requisition_suppliers
300: set SUPPLIER_NOTIFIED_FLAG = 'N'
301: where requisition_line_id = l_req_line_id;
302: END IF;
303:

Line 361: FROM po_requisition_suppliers

357: IF (l_cont_status = 'PENDING') THEN
358:
359: SELECT max(requisition_supplier_id)
360: INTO l_requisition_supplier_id
361: FROM po_requisition_suppliers
362: WHERE
363: requisition_line_id = l_req_line_id AND
364: nvl(supplier_notified_flag, 'N') = 'N';
365:

Line 516: UPDATE po_requisition_suppliers

512: (itemtype => itemtype,
513: itemkey => itemkey,
514: aname => 'SUPPLIER_ID');
515:
516: UPDATE po_requisition_suppliers
517: SET supplier_notified_flag='Y'
518: WHERE requisition_supplier_id = l_supplier_id;
519:
520: END IF;