APPS.PO_REQ_DOCUMENT_CANCEL_PVT SQL Statements

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

Line: 94

    SELECT type_lookup_code,
           org_id -- Bug 3362534
    INTO l_req_subtype,
         l_document_org_id
    FROM PO_REQUISITION_HEADERS_ALL
    WHERE requisition_header_id = p_req_header_id(i);

Line: 155

        po_reqs_control_sv.update_reqs_status(
            x_req_header_id       =>  p_req_header_id(i),
            x_req_line_id         =>  p_req_line_id(i),
            x_agent_id            =>  null,
            x_req_doc_type        =>  'REQUISITION',
            x_req_doc_subtype     =>  l_req_subtype,
            x_req_control_action  =>  'CANCEL REQUISITION',
            x_req_control_reason  =>  p_cancel_reason,
            x_req_action_date     =>  p_cancel_date,
            x_encumbrance_flag    =>  l_encumbrance_flag,
            x_oe_installed_flag   =>  l_oe_installed_flag,
	    x_req_control_error_rc =>  l_req_control_error_rc);