APPS.XDPCORE_ERROR SQL Statements

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

Line: 355

  SELECT error_count
    FROM xdp_error_count
   WHERE object_key = cv_fp_name
     AND object_type = XDP_UTILITIES.g_fp_object_type;

Line: 397

 select xoo.order_id, xoo.External_Order_number, NVL(xoo.external_order_version, 'N/A'), xoo.fa_display_name, xoo.wi_display_name, xoo.line_item_name, xfe.display_name
 into l_OrderID, l_OrderNumber, l_OrderVersion, l_FAName, l_WIName, l_LineName, l_FeName
 from XDP_ORU_ORDERS_V xoo, XDP_FES_VL xfe
 where fa_instance_id = l_FAInstanceID
   and xoo.FE_ID = xfe.fe_id;

Line: 439

            SELECT display_name INTO lv_fp_disp_name
            FROM xdp_proc_body_vl
            WHERE proc_name =  lv_fp_name;

Line: 601

    SELECT external_order_number, external_order_version
      INTO l_order_number, l_order_version
    FROM XDP_ORDER_HEADERS WHERE order_id = l_OrderID;

Line: 610

    SELECT line_item_name INTO l_LineName FROM xdp_order_line_items WHERE line_item_id = l_LineID;

Line: 632

      XDP_NOTIFICATIONS.Get_WI_Update_URL(l_WIInstaceID,
                                          l_OrderID,
                                          itemtype,
                                          itemKey,
                                          l_NtfURL);