APPS.CLN_3A9_CANCELPO_PKG SQL Statements

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

Line: 40

      SELECT authorization_status
      INTO   l_authorization_status
      FROM   po_headers_all
      WHERE  po_header_id = p_document_id;

Line: 51

      SELECT authorization_status
      INTO   l_authorization_status
      FROM   po_releases_all
      WHERE  po_release_id = p_document_id;

Line: 64

   SELECT cln_generic_s.nextval INTO l_cln_event_key FROM dual;

Line: 79

      insert into cln_test(test) values('Exception ' || ':'  || l_error_code || ':' || l_error_msg);

Line: 142

      SELECT poh.segment1, por.release_num, poh.revision_num, poh.vendor_order_num
      INTO   l_po_number, l_rel_number, l_rev_number, l_supp_ord_number
      FROM   po_headers_all poh, po_releases_all por
      WHERE  poh.po_header_id = l_po_header_id
         AND poh.po_header_id = por.po_header_id(+);

Line: 148

      SELECT poh.po_header_id, poh.segment1, por.release_num, por.revision_num, poh.vendor_order_num
      INTO   l_po_header_id, l_po_number, l_rel_number, l_rev_number, l_supp_ord_number
      FROM   po_headers_all poh, po_releases_all por
      WHERE  por.po_release_id = l_po_release_id
         AND poh.po_header_id = por.po_header_id(+);

Line: 183

   SELECT VENDOR_ID, VENDOR_SITE_ID
   INTO   l_party_id, l_party_site_id
   FROM   PO_HEADERS_ALL
   WHERE  PO_HEADER_ID = l_po_header_id;

Line: 197

   SELECT cln_generic_s.nextval INTO l_cln_event_key FROM dual;

Line: 201

   SELECT cln_generic_s.nextval INTO l_xmlg_doc_id FROM dual;

Line: 262

      SELECT poh.xml_flag
      INTO   l_xml_flag
      FROM po_headers_all poh
      WHERE po_header_id= l_po_header_id;

Line: 267

       SELECT por.xml_flag
       INTO   l_xml_flag
       FROM   po_headers_all poh, po_releases_all por
       WHERE  poh.po_header_id = por.po_header_id
          AND por.po_release_id  = l_po_release_id;