APPS.OE_ORDER_EXTN_IMPORT_PVT SQL Statements

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

Line: 24

SELECT header_id,
       order_source_id,
       orig_sys_document_ref,
       sold_to_org_id,
       org_id
FROM OE_HEADERS_EXT_IFACE_ALL
    WHERE PROCESS_STATUS=1
      AND DATA_SET_ID=l_data_set_id;

Line: 34

SELECT line_id,
       order_source_id,
       orig_sys_document_ref,
       orig_sys_line_ref,
       orig_sys_shipment_ref,
       sold_to_org_id,
       org_id
FROM OE_LINES_EXT_IFACE_ALL
    WHERE PROCESS_STATUS=1
      AND DATA_SET_ID=l_data_set_id;

Line: 51

    l_rel_sql 		  := 'SELECT ''ADMIN_DEFINED'' FROM DUAL';

Line: 72

      SELECT header_id INTO l_header_id
           FROM oe_order_headers_all
          WHERE order_source_id       = i.order_source_id
            AND orig_sys_document_ref = i.orig_sys_document_ref
            AND org_id = Nvl(i.org_id,l_org_id)
            AND (sold_to_org_id is NULL OR decode(l_customer_key_profile, 'Y',nvl(sold_to_org_id, FND_API.G_MISS_NUM), 1)
                = decode(l_customer_key_profile, 'Y',nvl(i.sold_to_org_id, FND_API.G_MISS_NUM), 1));

Line: 88

       UPDATE OE_HEADERS_EXT_IFACE_ALL
                 SET PROCESS_STATUS = 2, HEADER_ID= l_header_id
                 WHERE data_set_id  =  l_data_set_id
                 AND PROCESS_STATUS = 1
                 AND order_source_id       = i.order_source_id
                 AND orig_sys_document_ref = i.orig_sys_document_ref
                 AND (sold_to_org_id is NULL OR decode(l_customer_key_profile, 'Y',nvl(sold_to_org_id, FND_API.G_MISS_NUM), 1)
                     = decode(l_customer_key_profile, 'Y',nvl(i.sold_to_org_id, FND_API.G_MISS_NUM), 1));

Line: 99

      UPDATE OE_HEADERS_EXT_IFACE_ALL
                 SET PROCESS_STATUS = 2
                 WHERE data_set_id  =  l_data_set_id
                 AND header_id = i.header_id
                 AND PROCESS_STATUS = 1;

Line: 109

    SELECT COUNT(*) INTO l_header_count
     FROM OE_HEADERS_EXT_IFACE_ALL
      WHERE PROCESS_STATUS=2
        AND HEADER_ID IS NOT NULL;

Line: 170

            DELETE FROM OE_HEADERS_EXT_IFACE_ALL
                WHERE data_set_id  = l_data_set_id
                  AND PROCESS_STATUS = 2;

Line: 182

      SELECT line_id INTO l_line_id
              FROM oe_order_lines_all
             WHERE  order_source_id   = i.order_source_id
               AND orig_sys_document_ref = i.orig_sys_document_ref
	       AND orig_sys_line_ref  = i.orig_sys_line_ref
               AND NVL(orig_sys_shipment_ref,FND_API.G_MISS_CHAR) = NVL(i.orig_sys_shipment_ref,FND_API.G_MISS_CHAR)
               AND org_id = Nvl(i.org_id,l_org_id)
               AND (sold_to_org_id is NULL OR decode(l_customer_key_profile, 'Y', nvl(sold_to_org_id, FND_API.G_MISS_NUM), 1)
                   = decode(l_customer_key_profile, 'Y', nvl(i.sold_to_org_id, FND_API.G_MISS_NUM), 1));

Line: 202

       UPDATE OE_LINES_EXT_IFACE_ALL
                 SET PROCESS_STATUS = 2, LINE_ID= l_line_id
                 WHERE data_set_id  = l_data_set_id
                 AND PROCESS_STATUS = 1
                 AND order_source_id   = i.order_source_id
	         AND orig_sys_line_ref  = i.orig_sys_line_ref
                 AND NVL(orig_sys_shipment_ref,FND_API.G_MISS_CHAR) = NVL(i.orig_sys_shipment_ref,FND_API.G_MISS_CHAR)
                 AND (sold_to_org_id is NULL OR decode(l_customer_key_profile, 'Y', nvl(sold_to_org_id, FND_API.G_MISS_NUM), 1)
                     = decode(l_customer_key_profile, 'Y', nvl(i.sold_to_org_id, FND_API.G_MISS_NUM), 1));

Line: 213

      UPDATE OE_LINES_EXT_IFACE_ALL
                 SET PROCESS_STATUS = 2
                 WHERE data_set_id  =  l_data_set_id
                 AND line_id = i.line_id
                 AND PROCESS_STATUS = 1;

Line: 223

    SELECT COUNT(*) INTO l_line_count
     FROM OE_LINES_EXT_IFACE_ALL
      WHERE PROCESS_STATUS=2
        AND LINE_ID IS NOT NULL;

Line: 284

              DELETE FROM OE_LINES_EXT_IFACE_ALL
                  WHERE data_set_id  = l_data_set_id
                    AND PROCESS_STATUS = 2;