APPS.POR_CANCEL_NOTIF_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 125: po_requisition_lines_all prl

121: select nvl(prh.supplier_notified_flag, 'N'), prl.contractor_status
122: into l_supplier_notified_flag, l_contractor_status
123: from
124: po_requisition_headers_all prh,
125: po_requisition_lines_all prl
126: where
127: prh.requisition_header_id = prl.requisition_header_id and
128: requisition_line_id = l_req_line_id;
129:

Line 246: po_requisition_lines_all prl,

242: prl.assignment_start_date, prh.segment1 || ' / ' || to_char(prl.line_num)
243: INTO l_job_name, l_contact_info, l_start_date, l_req_info
244: FROM
245: po_requisition_headers_all prh,
246: po_requisition_lines_all prl,
247: po_job_associations pja
248: WHERE prl.requisition_line_id = l_req_line_id AND
249: prl.job_id = pja.job_id AND
250: prh.requisition_header_id = prl.requisition_header_id;

Line 501: UPDATE po_requisition_lines_all

497: aname => 'REQ_LINE_ID');
498:
499: l_progress := 'POR_CANCEL_NOTIFICATION_PVT.post_notification_process: 02';
500:
501: UPDATE po_requisition_lines_all
502: SET supplier_notified_for_cancel ='Y'
503: WHERE requisition_line_id = l_req_line_id;
504:
505: l_cont_status := wf_engine.GetItemAttrText (itemtype => itemtype,