APPS.PO_CONTROL_CHECKS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 67

SELECT  s.po_header_id, s.po_release_id, s.po_line_id, s.line_location_id, s.shipment_num
BULK COLLECT INTO l_po_header_id, l_po_release_id, l_po_line_id, l_line_location_id, l_shipnum
FROM    po_requisition_lines_all rl, po_line_locations_all s
WHERE rl.line_location_id = s.line_location_id
AND (  (p_doctyp = 'REQUISITION' and rl.requisition_header_id = p_docid)
    OR (p_doctyp = 'PO' and s.po_header_id = p_docid)
    OR (p_doctyp = 'RELEASE' and s.po_release_id = p_docid)
    )
AND (NVL(p_lineid,0) = 0 OR s.po_line_id = p_lineid)
AND (NVL(p_shipid,0) = 0 OR s.line_location_id = p_shipid)
AND nvl(s.drop_ship_flag, 'N') = 'Y';

Line: 136

        insert into po_online_report_text(online_report_id,
                                      last_update_login,
                                      last_updated_by,
                                      last_update_date,
                                      created_by,
                                      creation_date,
                                      line_num,
                                      shipment_num,
                                      distribution_num,
                                      sequence,
                                      text_line)
                              values (p_reportid,
                                      FND_GLOBAL.LOGIN_ID,
                                      FND_GLOBAL.USER_ID,
                                      sysdate,
                                      FND_GLOBAL.USER_ID,
                                      sysdate,
                                      NULL,
                                      l_shipnum(i),
                                      NULL,
                                      1,
                                      FND_MESSAGE.GET_STRING('PO', l_message));