APPS.IBE_CANCEL_ORDER_PVT SQL Statements

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

Line: 15

    P_Last_Updated_By   IN  NUMBER,
    P_Last_Update_Date  IN  DATE,
    P_Last_Update_Login	IN  NUMBER,
    X_Return_Status     OUT NOCOPY VARCHAR2,
    X_Msg_Count         OUT NOCOPY NUMBER,
    X_Msg_Data          OUT NOCOPY VARCHAR2
    )
   IS
  l_api_version NUMBER := 1.0;

Line: 92

  SELECT org_id FROM oe_order_headers_all
  WHERE header_id = l_header_id;

Line: 181

  l_header_rec.operation       := OE_Globals.G_OPR_UPDATE;